Data Warehouse Engineer
- Collaborate with our Business Intelligence team to understand business reporting requirements and define denormalized schema for the warehouse
- Collaborate with our DBA team on capacity planning and deploying infrastructure resources
- Build and maintain ETL solutions that centralize data from disparate sources into a centralized data warehouse
- Collaborate with DBA, Security and Infrastructure teams to establish secure connections between data tiers
- Build and maintain ETL solutions that denormalize OLTP source data into reportable OLAP data
- Collaborate with stakeholders to RCA and remediate data and reporting defects and inconsistencies
- Establish monitoring and alerting solutions to support the data warehouse and related ETL jobs
- 3+ years of experience building and maintaining an enterprise data warehouse - defining data requirements, schema and building ETL solutions
- 3+ years of experience using ETL tools (e.g. SSIS, ADF) to move data between databases/servers/environments
- 3+ years of experience denormalizing OLTP data for a data warehouse - may include T-SQL views, stored procedures, functions and ad hoc scripts
- Experience optimizing T-SQL read and write performance in a large multi-terabyte data warehouse
- Experience with SQL Server and Azure SQL Database
- Experience using Microsoft Fabric or Azure Synapse Analytics
- Familiar with message services (e.g. MSMQ, RabbitMQ, Azure Service Bus)
- Familiar with source control, change control and security best practices
- Familiar with healthcare industry data or EHR systems (e.g. EDI formats, common EHR data elements, live EHR integrations)
Recommended Jobs
Business Development Manager
Cherokee Federal, a division of Cherokee Nation Businesses, is seeking a Business Development Manager to join our dedicated team. This role is pivotal in supporting our mission of providing top-tier c…
Sr. Consultant
Cargill is seeking a highly skilled and experienced Sr. Consultant to join our Professional Services team. This role is pivotal in driving strategic initiatives and fostering partnerships that aim to …
Senior Manager Client Consulting, VCA
Job Description Visa Consulting and Analytics (VCA) drives tangible, impactful and financial results for Visa’s network clients, including both financial services and merchants. Drawing on our expe…
Sales Associate (Part-Time) - Atlanta
OBJECTIVE/MISSION ~ As an Ambassador of the Maison, he/she achieves and exceeds sales targets as directed by management and proactively develops his/her client portfolio. He/she ensures a unique c…
Entry Level Sales - Immediate Hire
At Zenvoro, we specialize in direct marketing and customer engagement, helping our clients build meaningful connections with their customer base. Our Sales Representatives work face-to-face with cons…
Practice Manager - Urgent Care @ Vinings Health Park
How would you like to work in a place where your contributions and ideas are valued? A place where you can serve with compassion, pursue excellence and honor every voice? At Wellstar, our mission is s…
RN - NICU, PRN, Nights
Overview: At Piedmont Eastside’s NICU we take pride in making a positive impact in the lives of our tiniest patients and their families! Our level 3 NICU hosts 18 beds with low nurse to patient ratio…
LPN/Scrub Tech - Labor and Delivery Phoebe Sumter PRN
Job Summary Provide professional nursing care under supervision for assigned patients in assigned areas including medical/surgical units, obstetrical units, critical care units, emergency center, …
Director, Model Risk Management
Overview: Job Purpose With approximately 5 million contracts cleared every day across multiple asset classes, ICE Clear Europe (ICEU) is one of the world’s most diverse and leading clearing houses…
SAP Digital Hub- Digital Solution Advisor Specialist, Finance
We help the world run better At SAP, we keep it simple: you bring your best to us, and we'll bring out the best in you. We're builders touching over 20 industries and 80% of global commerce, and w…