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
PREMIUM
More languages and countries
+ Unlock 31694 hidden job offers
Languages
English Čeština Deutsch Ελληνικά Español Français +15
Countries
United States United Kingdom India Canada Australia +
See plans
Plans from $2.99 / month

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

Business Intelligence Applications Development Sr Programmer Analyst

The Applications Development Senior Programmer Analyst is an intermediate level ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's or Master's degree in Computer Science, Data Science, Information Technology, Engineering, or a related quantitative field
  • Minimum of 6-8 years of progressive professional experience in data engineering, business intelligence, or a related role
  • Proven expertise in designing, developing, and optimizing data warehouses, data lakes, and ETL processes using tools such as Apache Spark, DataBricks, AWS Glue, Azure Data Factory, or similar
  • Advanced proficiency in SQL and experience with relational and NoSQL databases (e.g., Snowflake, Redshift, PostgreSQL, MongoDB)
  • Expert-level experience with Tableau Desktop and Tableau Server, including dashboard design, data modeling, performance tuning, and administration
  • Strong understanding of data visualization best practices and principles
  • Experience with scripting languages like Python for data manipulation and automation
  • Familiarity with cloud platforms (AWS, Azure, GCP) and their data services
  • Excellent analytical, problem-solving, and communication skills with the ability to explain complex technical concepts to non-technical stakeholders
  • Ability to work independently and as part of a team in a fast-paced, agile environment
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable and efficient data pipelines and ETL processes to ingest, transform, and load data from various sources into data warehouses and data lakes
  • Work closely with business stakeholders, data analysts, and other engineers to understand data requirements and translate them into technical specifications
  • Develop, test, and deploy high-quality, interactive, and visually appealing Tableau dashboards and reports that meet business needs
  • Optimize Tableau dashboards for performance, scalability, and usability, ensuring data accuracy and consistency
  • Manage and administer Tableau Server, including user permissions, data source connections, and performance monitoring
  • Implement data governance, security, and quality best practices across all data solutions
  • Troubleshoot and resolve data-related issues, performance bottlenecks, and reporting discrepancies
  • Provide technical guidance and mentorship to junior team members, fostering a collaborative and learning-oriented environment
  • Stay up-to-date with emerging data engineering and visualization technologies and recommend their adoption where appropriate
  • Fulltime
Read More
Arrow Right

Business Intelligence Applications Development Sr Programmer Analyst

The Applications Development Senior Programmer Analyst is an intermediate level ...
Location
Location
India , Pune
Salary
Salary:
Not provided
https://www.citi.com/ Logo
Citi
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's or Master's degree in Computer Science, Data Science, Information Technology, Engineering, or a related quantitative field
  • Minimum of 6-8 years of progressive professional experience in data engineering, business intelligence, or a related role
  • Proven expertise in designing, developing, and optimizing data warehouses, data lakes, and ETL processes using tools such as Apache Spark, DataBricks, AWS Glue, Azure Data Factory, or similar
  • Advanced proficiency in SQL and experience with relational and NoSQL databases (e.g., Snowflake, Redshift, PostgreSQL, MongoDB)
  • Expert-level experience with Tableau Desktop and Tableau Server, including dashboard design, data modeling, performance tuning, and administration
  • Strong understanding of data visualization best practices and principles
  • Experience with scripting languages like Python for data manipulation and automation
  • Familiarity with cloud platforms (AWS, Azure, GCP) and their data services
  • Excellent analytical, problem-solving, and communication skills with the ability to explain complex technical concepts to non-technical stakeholders
  • Ability to work independently and as part of a team in a fast-paced, agile environment
Job Responsibility
Job Responsibility
  • Design, develop, and maintain scalable and efficient data pipelines and ETL processes to ingest, transform, and load data from various sources into data warehouses and data lakes
  • Work closely with business stakeholders, data analysts, and other engineers to understand data requirements and translate them into technical specifications
  • Develop, test, and deploy high-quality, interactive, and visually appealing Tableau dashboards and reports that meet business needs
  • Optimize Tableau dashboards for performance, scalability, and usability, ensuring data accuracy and consistency
  • Manage and administer Tableau Server, including user permissions, data source connections, and performance monitoring
  • Implement data governance, security, and quality best practices across all data solutions
  • Troubleshoot and resolve data-related issues, performance bottlenecks, and reporting discrepancies
  • Provide technical guidance and mentorship to junior team members, fostering a collaborative and learning-oriented environment
  • Stay up-to-date with emerging data engineering and visualization technologies and recommend their adoption where appropriate
  • Fulltime
Read More
Arrow Right