CrawlJobs Logo

Sr. Data Warehouse Developer

urmc.rochester.edu Logo

University of Rochester

Location Icon

Location:
United States of America , Albany

Category Icon
Category:
IT - Software Development

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

86482.00 - 129723.00 USD / Year
Save Job
Save Icon
Apply Position

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

Additional Information:

Job Posted:
February 21, 2026

Employment Type:
Fulltime
Work Type:
Remote work
Icon
University of Rochester - All Job Offers
Job Link Share:
Copy Link Icon
Facebook Icon Twitter Icon LinkedIn Icon

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Sr. Data Warehouse Developer

Sr. ETL Developers

We are looking for talented individuals to become part of our growing business a...
Location
Location
United States , Scottsdale; Naperville
Salary
Salary:
Not provided
thinkartha.com Logo
Artha Solutions
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Minimum 6 years of experience in IT Industry
  • At least 6 years of technical experience with databases or data warehousing
  • Experience in Oracle DB, SQL Server, Mysql, No SQL such as Mongo DB with strong skills on SQL and PL/SQL and Java
  • BS/BA in Computer Science or related discipline required
  • Candidates with Talend certifications & experience will be given a strong preference
  • Strong understanding of relational database concepts & technology – data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture
  • Experience with setup, configuration, design best practices, performance optimization, team based development approaches with a leading Talend/BI tool
  • Well organized and able to manage multiple projects in a fast paced demanding environment
  • Attention to detail and quality
  • excellent problem solving and communication skills
Read More
Arrow Right

Sr. Data Engineer

We are looking for a Sr. Data Engineer to join our growing Quality Engineering t...
Location
Location
Salary
Salary:
Not provided
dataideology.com Logo
Data Ideology
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience)
  • 5+ years of experience in data engineering, data warehousing, or data architecture
  • Expert-level experience with Snowflake, including data modeling, performance tuning, security, and migration from legacy platforms
  • Hands-on experience with Azure Data Factory (ADF) for building, orchestrating, and optimizing data pipelines
  • Strong experience with Informatica (PowerCenter and/or IICS) for ETL/ELT development, workflow management, and performance optimization
  • Deep knowledge of data modeling techniques (dimensional, tabular, and modern cloud-native patterns)
  • Proven ability to translate business requirements into scalable, high-performance data solutions
  • Experience designing and supporting end-to-end data pipelines across cloud and hybrid architectures
  • Strong proficiency in SQL and experience optimizing large-scale analytic workloads
  • Experience working within SDLC frameworks, CI/CD practices, and version control
Job Responsibility
Job Responsibility
  • Ability to collect and understand business requirements and translate those requirements into data models, integration strategies, and implementation plans
  • Lead modernization and migration initiatives to move clients from legacy systems into Snowflake, ensuring functionality, performance and data integrity
  • Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse
  • Optimize and troubleshoot ETL/ELT workflows, applying best practices for scheduling, orchestration, and performance tuning
  • Maintain documentation, architecture diagrams, and migration plans to support knowledge transfer and project tracking
What we offer
What we offer
  • PTO Policy
  • Eligibility for Health Benefits
  • Retirement Plan
  • Work from Home
  • Fulltime
Read More
Arrow Right

Sr Data Analyst

Resource Informatics Group, Inc. is actively seeking a skilled Sr Data Analyst t...
Location
Location
United States , Irving
Salary
Salary:
Not provided
rigusinc.com Logo
Resource Informatics Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree or foreign equivalent in Computer Science, Data Science, Data Analytics, Business Analytics, or a related field and six (6) years of experience in Data Analytics
  • Alternatively, a Master’s degree or foreign equivalent in Computer Science, Data Science, Data Analytics, Business Analytics, or a related field and three (3) years of experience in Data Analytics
  • Required skills include experience in SQL, Tableau, Python, data analysis, Unix scripting, AWS, Jira, Software Development Life Cycle (SDLC), Agile, and PL/SQL
  • Expertise in Machine Learning and Data Science, along with strong problem-solving capabilities and collaboration skills, is essential
Job Responsibility
Job Responsibility
  • Developing Python scripts to automate validations for data quality and quantity
  • Creating and maintaining automation scripts using Python and Linux Shell Scripting for platform maintenance activities and health checks
  • Extracting data from Salesforce Cloud and ensuring adherence to PRD specifications
  • Reconciling data between source and target tables, ensuring data consistency, accuracy, and integrity
  • Analyzing client data files and Developing procedures for preparing, transforming, and cleansing data prior to analysis
  • Generating and documenting reports using Python, SQL, Excel and Extracting data from disparate sources using technologies like Snowflake and Redshift
  • Creating scripts in Databricks to migrate the data from various sources to Data Warehouse
  • Performing data cleaning, transformation, enrichment and Utilizing data mining techniques on data for analysis
  • Design metrics and build dashboards in Tableau to track customer behavior, KPIs, and marketing effectiveness
  • create PL/SQL reports and should be moving them to AWS Redshift
  • Fulltime
Read More
Arrow Right

Sr Data Engineer

Resource Informatics Group, Inc. is actively seeking a skilled Senior Data Engin...
Location
Location
United States , Irving
Salary
Salary:
Not provided
rigusinc.com Logo
Resource Informatics Group
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s or Master’s degree in Computer Science, Engineering, or related fields
  • Strong expertise in data engineering and cloud-based solutions
  • 6+ years of experience in data engineering, architecture, and implementation of large-scale data solutions
  • Proficiency in designing and implementing data models, data structures, and algorithms
  • Advanced knowledge of SQL and NoSQL databases
  • Demonstrated expertise in optimizing data pipelines and improving data reliability, efficiency, and quality
  • Excellent problem-solving capabilities with a keen attention to detail
  • Strong communication and collaboration skills, with the ability to work effectively across diverse teams
  • Relevant certifications in cloud technologies (Azure, AWS, or GCP) advantageous
  • Master’s in Data Science or Computer Science or foreign equivalent, plus 6+ years of experience, OR Bachelor’s in Computer Science, Information Technology, or Electronics and Communication Engineering or foreign equivalent
Job Responsibility
Job Responsibility
  • Develop and execute ETL processes for data extraction, transformation, and loading into warehouses and data lakes
  • Architect data warehousing solutions using Azure Synapse Analytics for efficient querying and reporting
  • Optimize query performance, data processing speed, and resource utilization within Azure environments
  • Construct seamless data pipelines across Azure services utilizing Azure Data Factory, Databricks, and SQL Server Integration Services
  • Collaborate with stakeholders, including data scientists and analysts, to understand data requirements and deliver effective solutions
  • Manage large data volumes leveraging the Hadoop ecosystem for diverse source collection and loading
  • Design, maintain, and optimize data processing jobs using Hadoop MapReduce, Spark, and Hive, with coding in Java or Python for custom applications
  • Monitor job and cluster performance using tools like Ambari and custom monitoring scripts, scaling and maintaining Hadoop clusters and Azure data services
  • Ensure adherence to data security measures and governance standards
  • Integrate cross-cloud data with AWS and GCP services
  • Fulltime
Read More
Arrow Right

Sr. Data Engineer

We are looking for a skilled Sr. Data Engineer to join our team in Oklahoma City...
Location
Location
United States , Oklahoma City
Salary
Salary:
Not provided
https://www.roberthalf.com Logo
Robert Half
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Proven experience with Snowflake data warehousing and schema design
  • proficiency in ETL tools such as Matillion or similar platforms
  • strong knowledge of Python and PowerShell for data automation
  • experience working with Microsoft SQL Server and related technologies
  • familiarity with cloud technologies, particularly AWS
  • understanding of data visualization and analytics tools
  • background in working with big data technologies such as Apache Kafka, Hadoop, Spark, or Pig
  • ability to design and implement APIs for data integration and management.
Job Responsibility
Job Responsibility
  • Design, implement, and maintain Snowflake data warehousing solutions to support business needs
  • assist in the migration of in-house data to Snowflake, ensuring a seamless transition
  • develop data pipelines and workflows using tools such as Matillion or equivalent ETL solutions
  • collaborate with teams to optimize and manage the existing data warehouse built on Microsoft SQL Server
  • utilize Python and PowerShell to automate data processes and enhance system efficiency
  • partner with the implementation team to shadow and learn best practices for Snowflake deployment
  • ensure data integrity, scalability, and security across all data engineering processes
  • provide insights into data visualization and analytics to support decision-making
  • work with cloud technologies, including AWS, to enhance data storage and accessibility
  • implement and manage APIs to enable seamless data integration and sharing.
What we offer
What we offer
  • Medical, vision, dental, and life and disability insurance
  • eligibility to enroll in 401(k) plan
  • access to competitive compensation and free online training.
  • Fulltime
Read More
Arrow Right

Sr. Technical Developer

Location
Location
United States , Scottsdale
Salary
Salary:
Not provided
thinkartha.com Logo
Artha Solutions
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Three years of experience working in the position offered or in any position/title providing experience with Java, .Net, SAS and Tableau
  • Qualifying experience must include experience with Java, .Net, SAS and Tableau
  • Position requires travel/relocation to various unanticipated client locations throughout the U.S. with expenses paid by the employer
Job Responsibility
Job Responsibility
  • Work on various BI Projects for clients and perform several activities such as business requirements analysis, development of reports, storyboards, ETL, unit testing, User training, Integration/ user testing and deployment activities
  • Conduct code reviews and enhancements for optimal performance and quality assurance
  • Responsible for development issues tracking, resolution and daily project status reporting
  • Facilitated effective communication between business and technical team
  • Design EDW analytics and reporting data model
  • Implement business intelligence solution architecture and overall project strategy
  • Automate the production and distribution of reports from EHR data across over 100 clinics
  • Develop simple and complex reports using BI Office report designer, SSAS and SSRS
  • Create departmental dashboards, reports and publications using BI Office
  • Design Analysis Services cubes and reporting data model
What we offer
What we offer
  • Expenses paid for travel/relocation to various unanticipated client locations throughout the U.S.
Read More
Arrow Right
New

Sr Engineer - Data Engineering

Zelis is modernizing the healthcare financial experience in the United States (U...
Location
Location
India , Hyderabad
Salary
Salary:
Not provided
zelis.com Logo
Zelis
Expiration Date
March 31, 2026
Flip Icon
Requirements
Requirements
  • 2+ years working with a cloud-based ETL tool (DBT preferred)
  • 5+ years Microsoft ETL experience with SSIS
  • 5+ Years data engineering experience to include data analysis
  • 3+ years programming SQL objects (procedures, triggers, views, functions) in SQL Server
  • 3+ years of experience optimizing SQL queries
  • Advanced understanding of T-SQL, indexes, stored procedures, triggers, functions, views, etc.
  • 3+ Years designing and implementing dimensional Data Warehouse
  • Working Knowledge of Azure/AWS Architecture, Data Lake
  • 2+ Years of experience using source control software, such as, Git and Azure DevOps, etc.
  • 2+ years of experience working with a reporting software, such as, SSRS, Power BI, etc.
Job Responsibility
Job Responsibility
  • Design, develop and implement scalable batch/real time data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse and Data Lake
  • Design and implement data model changes that align with warehouse dimensional modeling standards
  • Responsible for maintenance and support of all database environments, design and develop data pipelines, workflow, ETL solutions on both on-prem and cloud-based environments
  • Design and develop SQL stored procedures, functions, views, and triggers
  • Design, code, test, document and troubleshoot deliverables
  • Collaborate with others to test and resolve issues with deliverables
  • Maintain awareness of and ensure adherence to Zelis standards regarding privacy
  • Create and maintain design documents, source to target mappings, unit test cases, data seeding
  • Ability to perform data analysis and data quality tests and create audit for the ETLs
  • Perform continuous integration and deployment using Azure DevOps and Git.
What we offer
What we offer
  • Hybrid work flexibility
  • Comprehensive healthcare benefits
  • Financial wellness programs
  • Cultural celebrations
  • Collaborative work culture
  • Leadership development
  • Global exposure.
  • Fulltime
Read More
Arrow Right

Sr. Database Developer

The database developer is responsible for the design and development of database...
Location
Location
United States , San Diego
Salary
Salary:
58.00 - 62.00 USD / Hour
gomillenniumsoft.com Logo
MillenniumSoft Inc
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Experience with data modeling tools such as ER/Studio or ERWin
  • Experience using version control systems (e.g., TFS, Git)
  • Familiar with Agile software development process
  • 8+ years of experience working with Microsoft SQL Server with emphasis on database code, ETL and Reporting Services development
  • Database design skills including normalization and data warehouse design
  • Strong hands-on T-SQL development skills including stored procedure, function, and trigger creation
  • Excellent query optimization and performance tuning skills
  • Extensive experience developing SSRS reports
  • Strong SSIS skills
  • Detailed analytical skills
Job Responsibility
Job Responsibility
  • Understand and apply database design and development principles for both transactional and dimensional schemas to support application requirements
  • Design, plan, and develop programs to optimally extract, transform, and load data from data sources to the target systems
  • Design, develop and maintain SQL Server Reporting Services reports
  • Maintain source code for database and ETL projects
  • Ensure that projects build successfully in a continuous integration environment
  • Diagnose and resolve database performance issues
  • Follow and improve development processes including but not limited to conducting peer/code reviews, complying with organizational standards, ensuring code maintainability, following build processes, implementing unit tests, and following other industry standard best practices
  • Analyzing requirements in order to create software designs
  • Estimation and timely completion of tasks
  • Documenting developed modules
  • Fulltime
Read More
Arrow Right
Jobs by Category
Art and Entertainment Jobs Banking Jobs Call Center Jobs Construction Jobs Consulting Jobs Customer Service Jobs Education Jobs Energy Jobs Finance Jobs Gastronomy Jobs Health and Beauty Jobs Hospitality and Tourism Jobs Human Resources Jobs Insurance Jobs IT - Administration Jobs IT - Software Development Jobs Legal Jobs Logistics Jobs Manufacturing Jobs Marketing, Digital Marketing, SEO, SEM Jobs Media Jobs Nursing Jobs Office Administration Jobs Pharmacy Jobs Physical Work Jobs Public Relations Jobs Public Sector Jobs Purchasing Jobs Quality Control Jobs Real Estate Jobs Research and Development Jobs Sales Jobs
Job Positions Jobs by Country
United States Jobs United Kingdom Jobs India Jobs Canada Jobs Australia Jobs Germany Jobs Ireland Jobs Poland Jobs
Company
Blog About Us Contact
Follow Us
Facebook
X (Twitter)
LinkedIn
Instagram
CrawlJobs Group
ITFlashcards AllDevBlogs
© 2026 CrawlJobs Ltd. All Rights Reserved
Terms & Conditions Privacy Policy