Job Closed

This listing is no longer active.

University of Rochester

University of Rochester, located on the banks of the Genesee River in Rochester, New York, is a four-year private institution of higher learning that has offere

Senior Data Warehouse Developer

Location

New York

Posted

172 days ago

Salary

$86.5K - $129.7K / year

Seniority

Senior

Bachelor Degree5 yrs expEnglishETLInformaticaOracle Database

Job Description

Senior Data Warehouse Developer

University of Rochester

• 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 Atmosphere, 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. • 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.

Job Requirements

  • Bachelor's degree and 5 years of relevant experience required
  • Master's degree preferred
  • Multiple project experience with Data Warehousing ETL technologies required
  • Experience with dimensional data models required
  • 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

Related Categories

Related Job Pages

More Data Engineer Jobs

Real logo

Data Engineer

Real

A technology-powered real estate brokerage (NASDAQ: REAX)

Data Engineer172 days ago
Full TimeRemoteTeam 51-200Since 2014H1B Sponsor

• Work with the engineering team to create the data infrastructure • Maintain the data infrastructure in AWS • Work with the business users to understand their reporting requirements • Create reports and other forms of data access and visualization • Develop test infrastructure to maintain data integrity • Lead implementation of a BI system, such as Tableau • Create and maintain data-driven automation pipelines

India
Scratch Financial logo

Senior Staff Data Engineer

Scratch Financial

Scratch Financial is the world's simplest patient financing solution.

Data Engineer172 days ago
OtherRemoteTeam 11-50Since 1912H1B Sponsor

• Designs, builds, and oversees the deployment and operation of technology architecture, solutions and software to capture, manage, store, and utilize structured and unstructured data • Contributor to the overall Data Product roadmap by working closely with our business partners to understand their challenges and develop analytical tools to help drive business decisions • Develops technical tools and programming that leverage artificial intelligence, machine learning, and big-data techniques to cleanse, organize and transform data • Leverage prototyping methodologies to propose and design creative business solutions that exploit our broad toolset of technologies • Creates and establishes design standards and assurance processes for software, systems, and applications development • Reviews internal and external business and product requirements for data operations and activity and suggests changes and upgrades to systems and storage • Design, develop, and maintain CI/CD pipelines using GitHub Actions to automate deployment, testing, and monitoring of applications. • Implement and manage serverless solutions • Implement infrastructure as code (IaC) practices • Work with development teams to set up automated testing frameworks • Understands the basics of relational data modeling

New York
$150K - $185K / year
Job Closed
OtherRemoteTeam 51-200Since 2020H1B No Sponsor

• Reporting to our Director of BI & Analytics, you will join our data team as a key internal consultant and technical expert. Whether you are a seasoned architect or a rising talent in the analytics space, your primary mission is the same: to move beyond simple reporting and transform complex data into compelling data stories. • This is a high-impact role where technical rigor meets design strategy. You will serve as the bridge between our data infrastructure and our stakeholders, owning the end-to-end data lifecycle. This includes architecting scalable data models and ELT pipelines, as well as partnering directly with business lines to build polished, intuitive Tableau dashboards. • If you are a versatile professional who enjoys both writing complex Python/SQL transformation logic and crafting data stories that answer the "so what?" for leadership, we encourage you to apply. • What you'll do: Visualization & Storytelling • Tableau Design: Design and build highly interactive dashboards that guide users through a clear narrative flow. You don’t just display data; you highlight trends, anomalies, and actionable insights. • UX/UI Strategy: Apply design best practices (layout, color theory, pre-attentive attributes) to ensure dashboards are intuitive, consistent, and reduce cognitive load. • Performance Tuning: Proactively monitor and optimize both SQL queries and Tableau workbooks to ensure fast load times and a seamless user experience. • Data Engineering & Architecture • Data Modeling: Own the design and optimization of dimensional data models (Star Schemas) in BigQuery to create a clean, accessible, and performant "semantic layer" for analytics. • Pipeline Development: Design, build, and maintain scalable ELT / ETL pipelines (using SQL, Python, and orchestration tools) to transform raw data into analytics-ready datasets. • Data Quality & Governance: Establish and advocate for data integrity by implementing automated testing, validation frameworks, and consistent metric definitions. • Strategy & Consultation • Internal Consulting: Act as a trusted advisor to stakeholders. Translate vague business questions into strict technical requirements and analytical stories that get to the root of the problem. • Mentorship: Foster a culture of data literacy by mentoring business users on dashboard interpretation and training junior analysts on SQL best practices. • Documentation: Maintain clear technical documentation for data lineages, metric definitions, and pipeline logic.

New York
Job Closed
Veeva logo

AI Data Engineer

Veeva

Headquartered in Pleasanton, California, Veeva is a leading provider of cloud-based software and services for the life sciences industry. As an employer, Veeva

Data Engineer173 days ago

• Evaluation Strategy & Planning: Define and establish comprehensive evaluation strategies for new AI Agents. Prioritize the integrity and coverage of test data sets to reflect real-world usage and potential failure modes • LLM Output Integrity Assessment: Programmatically and manually evaluate the quality of LLM-generated content against predefined metrics (e.g., factual accuracy, contextual relevance, coherence, and safety standards) • Creating High-Fidelity Datasets: Design, curate, and generate diverse, high-quality test data sets, including challenging prompts and scenarios. Evaluate LLM outputs to proactively identify system biases, unsafe content, hallucinations, and critical edge cases • Automation of Evaluation Pipelines: Develop, implement, and maintain scalable automated evaluations to ensure efficient, continuous validation of agent behavior and prevent regressions with new features and model updates • Root Cause Analysis: Understand model behaviors and assist in the trace and root-cause analysis of identified defects or performance degradations • Reporting & Performance Metrics: Clearly document, track, and communicate performance metrics, validation results, and bug status to the broader development and product teams

Canada
$85K - $225K / year
Job Closed