CrawlJobs Logo
University of Rochester Logo University of Rochester · IT - Software Development

Sr. Data Warehouse Developer

United States of America, Albany 86482.00 - 129723.00 USD / Year · Job Posted February 21, 2026
Apply Position
Job Link Share

Job Description

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Responsibility

  • Architects, designs, develops, implements and supports various components for the enterprise data warehouse and associated data sources
  • Provides support for reporting projects, as well as process and architectural recommendations
  • Mentors staff, demonstrates best practices, plans for business continuity and sustainability and works on projects that support Business Intelligence and Data Warehousing functions
  • Develops data integration and transformation processes across on premise and cloud data sources using tools, including Oracle Data Integrator, Boomi Atomsphere, Informatica, as determined by the environment
  • Works with the user community and reporting team to understand business data and data transformation requirements. Converts requirements to functional and technical specifications for database and integration design. Manages requests and/or components of larger projects with appropriate documentation and status reports
  • Develops data models and database designs that leverage knowledge of data warehouse modeling best practices
  • Architects data integration and transformation processes across on premise and cloud data sources. Provides leadership and serves as a subject matter expert
  • Collaborates with other team members using scrum processes or other project management disciplines. Follows best practices for change and code management. Provides supporting technical documentation that is well written, organized and maintained
  • Participates in ongoing stabilization, support and maintenance. Provides on call support as needed for business continuity and operations. Attends webinars, reads case studies and white papers, and participates in opportunities to further refine skills and stay apprised on functional area topics. Maintains current knowledge of technology, equipment, and/or systems and advises on newer technologies
  • Other duties as assigned

Requirements

  • Bachelor's degree and 5 years of relevant experience required
  • Multiple project experience with Data Warehousing ETL technologies and overall knowledge of Data Warehousing/Business Intelligence lifecycles required
  • Experience with dimensional data models required
  • Strong analytical and problem solving abilities required
  • Ability to actively participate and collaborate on a team required
  • Excellent written communication skills. Ability to translate functional business requirements into documented system requirements and designs required
  • Understanding of data warehouse and agile software development processes required
  • In depth understanding and development experience using SQL, Pl/SQL and UNIX scripting languages with SQL based databases (Oracle, DB2 or SQL Server) required
  • Proficiency in developing data transformation packages/stored procedures required

Nice to have

  • Master's degree preferred
  • Experience with integrating data warehouses with business intelligence metadata tools preferred
  • Experience with service oriented architecture and enterprise information integration preferred
  • Experience with the development of web services preferred
  • Experience with Dell Boomi Atomsphere preferred
  • Experience with Oracle Data Integrator preferred
  • EPIC - EPIC Certification upon hire preferred
University of Rochester - All Job Offers

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Suggested Tags: Frontend Developer Secretary Talent Manager Salesforce Administrator Data Analyst
Similar Jobs for

Sr. Data Warehouse Developer

8 matching positions

Sr. Developer

Barclays Services Corp. seeks Sr. Developer, AVP in Whippany, NJ (multiple posit...
Location
Location
United States , Whippany
Salary
Salary:
189592.00 - 195000.00 USD / Year
barclays.co.uk Logo
Barclays
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Design, develop and maintain Oracle database applications using SQL, PL/SQL, advance features like In memory, Container and Pluggable databases, and other database programming languages
  • Research and analyze Enterprise Voluminous Data and perform efficient data management using Artificial Intelligence and Machine Learning techniques and Algorithms
  • Implement and maintain tight access control using security features like Virtual Private database (VPD), Redaction, etc.
  • Design, maintain and publish data models for Star (Dimensional) and Snowflake (Normalized) using tools like ERwin, TOAD or ER Studio
  • Design and implement efficient database programs through bulk data handling using PL/SQL Tables, Nested Tables, and Arrays in Oracle, Databricks, Snowflake, and Cloud Data Warehouses
  • Manage and process high data volumes, including Petabytes and Exabytes, to meet on premises and cloud onboarding requirements
  • Optimize database performance using various partitioning methods, materialized views, inline views, and temporary tables
  • Conduct performance tuning by query optimization, tuning memory, and tuning disk usage with tools such as Explain Plan, RTSM, AWR, Hang Analyzer, ASH, and ADDM reports
  • Facilitate Scrum sessions with clients, customers, vendors, SMEs, and other stakeholders for reporting and multiple functional and business requirements
  • Automate tasks using Python, Shell scripts, Perl scripts, and PL/SQL
Job Responsibility
Job Responsibility
  • Design, develop and maintain Oracle database applications using SQL, PL/SQL, advance features like In memory, Container and Pluggable databases, and other database programming languages
  • Research and analyze Enterprise Voluminous Data and perform efficient data management using Artificial Intelligence and Machine Learning techniques and Algorithms
  • Implement and maintain tight access control using security features like Virtual Private database (VPD), Redaction, etc.
  • Design, maintain and publish data models for Star (Dimensional) and Snowflake (Normalized) using tools like ERwin, TOAD or ER Studio
  • Design and implement efficient database programs through bulk data handling using PL/SQL Tables, Nested Tables, and Arrays in Oracle, Databricks, Snowflake, and Cloud Data Warehouses
  • Manage and process high data volumes, including Petabytes and Exabytes, to meet on premises and cloud onboarding requirements
  • Optimize database performance using various partitioning methods, materialized views, inline views, and temporary tables
  • Conduct performance tuning by query optimization, tuning memory, and tuning disk usage with tools such as Explain Plan, RTSM, AWR, Hang Analyzer, ASH, and ADDM reports
  • Facilitate Scrum sessions with clients, customers, vendors, SMEs, and other stakeholders for reporting and multiple functional and business requirements
  • Automate tasks using Python, Shell scripts, Perl scripts, and PL/SQL
What we offer
What we offer
  • medical, dental and vision coverage
  • 401(k)
  • life insurance
  • other paid leave for qualifying circumstances
  • incentive award
  • Competitive holiday allowance
  • Private medical care
  • Pension contribution
  • Fulltime
Read More
Arrow Right

Sr. Data Engineer

The Senior Data Engineer supports enterprise data unification and analytics init...
Location
Location
United States , Deerfield
Salary
Salary:
Not provided
tier4group.com Logo
Tier4 Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience designing, developing, and supporting data pipelines (ETL/ELT) that integrate data from multiple systems
  • Strong SQL skills, including writing and optimizing complex queries, joins, and stored procedures in Microsoft SQL Server or comparable relational databases
  • Hands-on experience with Azure Synapse Analytics, Azure Data Factory, or similar cloud-based data warehousing and integration platforms
  • Experience working with large datasets in cloud or hybrid data environments
  • Working knowledge of data modeling concepts, including fact and dimension tables and schema design for analytics and reporting
  • Experience supporting business intelligence tools, particularly Microsoft Power BI, including datasets and dataflows
  • Ability to use scripting or programming languages such as SQL, Python, or PySpark for data transformation and automation
  • Approximately 3–5 years of professional experience in data engineering, analytics engineering, or a related role
  • Approximately 1–3 years of experience in data modeling or database design for analytics use cases
  • Undergraduate degree or equivalent experience in Computer Science, Information Systems, or a related field
Job Responsibility
Job Responsibility
  • Design, build, and maintain automated ETL/ELT data pipelines that ingest and transform data from Microsoft Dynamics 365 and legacy systems into an Azure Synapse data lake and enterprise data warehouse
  • Monitor, optimize, and support data pipeline performance to ensure reliable, timely data refreshes and efficient resource utilization
  • Implement data quality checks, validation rules, and cleansing processes to ensure data accuracy, consistency, and readiness for enterprise-wide analysis
  • Support data unification efforts by integrating data from multiple business units and systems without altering source system integrity
  • Contribute to the design and evolution of enterprise data models, including dimensional and star schemas, to support standardized reporting and unified business definitions
  • Define and maintain master data structures and relationships that enable analysis across both ERP and non-ERP data sources
  • Prepare curated and optimized datasets for business intelligence and analytics use cases, including Power BI dashboards and self-service reporting
  • Write and optimize SQL queries and develop new pipeline components to support reporting, analytics, and ad hoc data needs
  • Collaborate with business analysts, business intelligence developers, ERP specialists, and other stakeholders to translate reporting and analytics requirements into technical solutions
  • Apply data engineering and analytics best practices, including version control, documentation, code review, and performance tuning
  • Fulltime
Read More
Arrow Right

Sr. Data Engineer

Join Amgen’s Mission of Serving Patients. At Amgen, if you feel like you’re part...
Location
Location
United States , Thousand Oaks
Salary
Salary:
138325.00 - 172744.00 USD / Year
amgen.com Logo
Amgen
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Master’s degree (or foreign equivalent) in Computer Science, Computer Engineering, Clinical Informatics or related field and 2 years of experience in the job offered or in a Data Engineer – related occupation. The position requires 2 years of experience in the following: Manage and tune Hadoop, MapReduce, or Spark SQL
  • Build ETL pipelines to transfer data
  • Optimize database for usage
  • Manage data stewardship and governance
  • Configure cloud services to orchestrate, monitor, and run end-to-end data warehousing solutions
  • and Model data for translation, linking, and consumption from source to data warehouse.
Job Responsibility
Job Responsibility
  • Responsible for managing and optimizing the company's data infrastructure and architecture for Clinical Data Hub, including cloud-based distributed compute and storage
  • Design and implement data pipelines, develop data models, perform data integration, and ensure data quality and governance
  • Contributes to the effective storage, processing, and utilization of large-scale data sets
  • Work with Product Owner, Product Management, Agile Team, and Data Architects to plan and deliver prioritized Clinical Data Hub backlog items and optimize the technical environment
  • Ensure data requirements for applications, data scientists, and cross-functional use cases are met, and ensure high performance and reliability of the system
  • Provide insights and actionable solutions for business clients.
What we offer
What we offer
  • stock
  • retirement
  • medical
  • life and disability insurance
  • eligibility for an annual bonus
  • health and welfare plans
  • financial plans
  • work/life balance
  • career development opportunities
  • Retirement and Savings Plan
  • Fulltime
Read More
Arrow Right

Sr Data Engineer

The mission of Roku's Data Engineering team is to develop a world-class big data...
Location
Location
India , Bengaluru
Salary
Salary:
Not provided
roku.com Logo
Roku
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Extensive SQL Skills
  • Proficiency in at least one scripting language, Python is required
  • Experience in big data technologies like HDFS, YARN, Map-Reduce, Hive, Kafka, Spark, Airflow, Presto, etc.
  • Proficiency in data modeling, including designing, implementing, and optimizing conceptual, logical, and physical data models to support scalable and efficient data architectures.
  • Experience with AWS, GCP, Looker is a plus
  • Collaborate with cross-functional teams such as developers, analysts, and operations to execute deliverables
  • 8+ years professional experience as a data Engineer
  • BS in Computer Science
  • MS in Computer Science preferred
  • AI Literacy / AI growth mindset
Job Responsibility
Job Responsibility
  • Build highly scalable, available, fault-tolerant distributed data processing systems (batch and streaming systems) processing over 10s of terabytes of data ingested every day and petabyte-sized data warehouse
  • Build quality data solutions and refine existing diverse datasets to simplified data models encouraging self-service
  • Build data pipelines that optimise on data quality and are resilient to poor quality data sources
  • Own the data mapping, business logic, transformations and data quality
  • Low level systems debugging, performance measurement & optimization on large production clusters
  • Participate in architecture discussions, influence product roadmap, and take ownership and responsibility over new projects
  • Maintain and support existing platforms and evolve to newer technology stacks and architectures
What we offer
What we offer
  • global access to mental health and financial wellness support and resources
  • Local benefits include statutory and voluntary benefits which may include healthcare (medical, dental, and vision), life, accident, disability, commuter, and retirement options (401(k)/pension)
  • vacation and other personal time off
  • Fulltime
Read More
Arrow Right

Sr Engineer, Data - Finance Domain

This role is essential for designing and developing data architectures across on...
Location
Location
United States , Frisco; Bellevue
Salary
Salary:
105100.00 - 189600.00 USD / Year
https://www.t-mobile.com Logo
T-Mobile
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree plus 5 years of related work experience OR Advanced degree with 3 years of related experience
  • Acceptable areas of study include Computer Engineering, Computer Science, a related subject area
  • 4-7 years Developing cloud solutions using data series
  • experience with cloud platforms (Amazon Web Services, Azure, or Google Cloud)
  • 4-7 years Hands-on development using and migrating data to cloud platforms
  • Proven track record in SQL, NoSQL, and/or relational database design and development
  • 4-7 years Advanced knowledge and experience in building sophisticated data pipelines with Python, Experience in languages such as SQL, DAX Python, Java, Scala, and/or Go
  • Hands-on experience building, operating, and solving production data pipelines in cloud, hybrid, or data lakehouse environments
  • Experience developing scalable data models, transformation logic, and curated datasets using SQL, Python, Databricks, or comparable data engineering technologies
  • Experience implementing data quality, reconciliation, monitoring, or validation controls for business-critical data pipelines
Job Responsibility
Job Responsibility
  • Develop data engineering solutions that enable data pipelines, visualization, analytical tools and AI platforms to support business requirements
  • Design and develop data architectures across on-premise, cloud, and hybrid platforms to ensure scalable data infrastructure
  • Build and maintain ingestion pipelines from Finance source systems, including ERP platforms, relational databases, flat files, cloud data warehouses, and API-based feeds, into governed cloud data lake environments
  • Develop and maintain transformation logic and reusable data models using SQL, Python, Databricks, dbt, and related data engineering tools
  • Perform data wrangling, exploration, and discovery of heterogeneous data to generate new business insights
  • Support migration of legacy ETL, batch, and database-driven Finance processes into modern stack
  • Implement data quality checks, validation rules, monitoring, and reconciliation processes to improve accuracy, completeness, lineage, and timeliness of published data
  • Contribute to SOX-sensitive and audit-aware data engineering practices, including peer review, version control, change traceability, testing, and reproducible data processing where applicable
  • Partner with data architects, product managers, Finance domain teams, and engineering peers to translate business requirements into reliable pipeline and data model designs
  • Contribute to team knowledge sharing and drive the advancement of new data engineering capabilities
What we offer
What we offer
  • competitive base salary and compensation package
  • annual stock grant
  • employee stock purchase plan
  • 401(k)
  • access to free, year-round money coaches
  • medical, dental and vision insurance
  • flexible spending account
  • paid time off
  • up to 12 paid holidays
  • paid parental and family leave
  • Fulltime
Read More
Arrow Right
New

Sr. Salesforce Developer - Sales & Marketing Cloud

We are looking for an experienced Salesforce Developer with a minimum of 6 years...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 6 years’ Salesforce development experience
  • Strong hands-on experience with Sales Cloud
  • Experience working with Marketing Cloud or Salesforce environments integrated with Marketing Cloud
  • Proven experience building Salesforce reports and dashboards for sales or account management teams
  • Experience integrating Salesforce with external systems, ideally including a data warehouse, ETL platform, middleware, or API-based integration
  • Strong understanding of Salesforce data models, security model, sharing rules, profiles, permission sets, and role hierarchy
  • Experience with Salesforce declarative tools such as Flow, Process Builder, validation rules, custom objects, and custom fields
  • Strong Apex, SOQL, SOSL, and Lightning Web Components experience
  • Experience with data migration, data mapping, and data validation
  • Ability to gather requirements from business users and translate them into technical Salesforce solutions
Job Responsibility
Job Responsibility
  • Develop, configure, and enhance Salesforce solutions across Sales Cloud and related Salesforce capabilities
  • Support the integration of actuals data from the company’s data warehouse into Salesforce
  • Work with business stakeholders, particularly Account Managers, to understand reporting needs and translate them into Salesforce reporting solutions
  • Build and maintain custom Salesforce reports and dashboards for Account Managers
  • Ensure data from the warehouse is accurately mapped, transformed, and available within Salesforce for reporting and account management use cases
  • Create custom objects, fields, validation rules, flows, Apex classes, triggers, and Lightning components where required
  • Support data quality, data governance, and reconciliation between Salesforce and source systems
  • Collaborate with data, analytics, marketing, and sales teams to ensure Salesforce supports commercial reporting requirements
  • Assist in troubleshooting integration, reporting, and data visibility issues
  • Document technical designs, configuration changes, data mappings, and reporting logic
Read More
Arrow Right

Sr Engineer, Data

This role is essential for designing and developing data architectures across on...
Location
Location
United States , Bothell
Salary
Salary:
105100.00 - 189600.00 USD / Year
https://www.t-mobile.com Logo
T-Mobile
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree plus 5 years of related work experience OR Advanced degree with 3 years of related experience (Required)
  • Acceptable areas of study include Computer Engineering, Computer Science, a related subject area (Required)
  • 4-7 years Developing cloud solutions using data series
  • experience with cloud platforms (Amazon Web Services, Azure, or Google Cloud) (Required)
  • 4-7 years Hands-on development using and migrating data to cloud platforms (Required)
  • 4-7 years Experience in SQL, NoSQL, and/or relational database design and development (Required)
  • 4-7 years Advanced knowledge and experience in building complex data pipelines with Python, Experience in languages such as SQL, DAX Python, Java, Scala, and/or Go (Required)
  • Cloud Computing (Required)
  • Collaboration (Required)
  • Data Analysis (Required)
Job Responsibility
Job Responsibility
  • Develop data engineering solutions that enable data pipelines, visualization, and analytical tools to support business requirements
  • Design and develop data architectures across on-premise, cloud, and hybrid platforms to ensure scalable data infrastructure
  • Architect, build, and maintain reliable data pipelines that ingest, transform, and deliver data from diverse customer and business data sources into enterprise data lake, warehouse, and analytics platforms
  • Design reusable data models and standardized schemas, including Customer 360 and customer behavioral data structures, to support consistent metric definitions and trusted downstream use by analytics, marketing, and AI/ML teams
  • Perform data wrangling, exploration, and discovery of heterogeneous data to generate new business insights
  • Embed data quality practices into pipeline development, including automated checks for completeness, accuracy, timeliness, and governance alignment
  • Build and curate self-service data products, metadata, and documentation that improve data discoverability and enable approved users to access trusted datasets efficiently
  • Partner with analytics, marketing, AI/ML, and business stakeholders to understand data needs, define data contracts, and support scalable customer data use cases
  • Contribute to team knowledge sharing and drive the advancement of new data engineering capabilities
  • Mentor team members to build and enhance their data engineering skillsets and professional growth
What we offer
What we offer
  • Medical, dental and vision insurance
  • flexible spending account
  • 401(k)
  • employee stock grants
  • employee stock purchase plan
  • paid time off
  • up to 12 paid holidays
  • paid parental and family leave
  • family building benefits
  • back-up care
  • Fulltime
Read More
Arrow Right

Sr. Python Developer

We are seeking an experienced Backend Developer / Data Engineer to join our team...
Location
Location
India , Mohali
Salary
Salary:
Not provided
Harmonydi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Write clean, efficient, reusable, and testable code following best practices
  • Implement and maintain backend APIs using FastAPI or Django
  • Ensure application performance, scalability, and security
  • Debug and resolve issues reported by QA or end‑users
  • Conduct code reviews and maintain documentation
  • Build ETL/ELT pipelines and data workflows
  • Work with SQL and NoSQL databases
  • Experience working with AWS and GCP cloud platforms
  • Docker container-based development
  • CI/CD pipeline implementation
Job Responsibility
Job Responsibility
  • Developing and maintaining a robust, scalable, and secure software platform for our customers
  • Work closely with product managers, designers, and other developers to deliver high‑quality software and reliable data solutions
Read More
Arrow Right