Data Warehouse Developer
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Data Warehouse Developer engaging business stakeholders to implement robust BI and analytics capabilities. Developing, testing, and documenting data solutions with Epic Clarity and Caboodle data models.
Responsibilities:
- Responsible for delivering enterprise-level data solutions that empower business partners to provide affordable, high-quality patient care and services.
- Engages with business owners and stakeholders across all organizational levels to design and implement robust BI and analytics capabilities.
- Develops, tests, and documents business intelligence and analytics solutions primarily leveraging Epic Clarity and Caboodle data models.
- Collaborates with the BI Architect on the creation of custom Caboodle data models and on the design, development, and maintenance of BI solutions derived from other organizational systems.
- Performs responsibilities independently and demonstrates sound judgment, initiative, and minimal need for supervisory direction.
- Design, develop, and implement robust Caboodle ETL pipelines, contributing to the continued growth, standardization, and scalability of the Caboodle Data Warehouse.
- Conduct data discovery and source-system analysis to understand data structures, assess data quality, evaluate upstream workflows, and inform optimal ETL and dimensional modeling approaches.
- Collaborate with BI architects, developers, analysts, and operational stakeholders to design, validate, and publish high-quality ETL processes.
- Administer and help support the Microsoft data warehouse toolset (including SSIS, SSMS, and SQL Server).
Requirements:
- Bachelor's degree in Computer Science, Management Information Systems, Engineering or equivalent work experience
- Minimum five years of paid work experience as a Developer using SQL Server SSIS or equivalent ETL tool.
- Minimum 2 years of experience with developing ETL for Epic Caboodle Data Warehouse
- Minimum five years of experience with T-SQL or ANSI SQL coding and tuning
- Minimum three years working in relational databases.
- Experience with utilizing star schema data stores as the basis for ETL targets
- Thorough understanding of the relational database model and experience in designing, modeling, developing and supporting data warehouses.
- Experience working with diverse data sources.
- Knowledge of SQL query optimization and performance tuning.
- Experience in entity relationship data modeling and data modeling tools.
- Knowledge of star and snow-flake schemas.
Benefits:
- medical
- dental
- vision
- pharmacy
- discretionary annual bonuses and merit increases
- Flexible Spending Accounts
- 403(b) savings matches
- paid time off
- career advancement opportunities
- resources to support employee and family well-being
Similar Jobs
Principal Data Engineer
Data Engineer leading teams to innovate technology in federal government. Working on scalable data pipelines using modern tech in an agile environment.
Staff Data Engineer
Staff Data Engineer at Zeta Global leading the design and implementation of a unified semantic data layer. Focused on integrating diverse data sources for enhanced AI and analytics capabilities.
Senior Data Engineer
Senior Data Engineer at Sightline Payments, overseeing data engineering and cloud-based solutions. Collaborating across teams to prepare and deliver complex data sets for improving customer-centric omnichannel experience.
Data Engineer
Júnior Data Engineer supporting SQL Server Data Warehouse, developing ETL routines and data models. Collaborating with Product, Engineering, and Analytics teams in a growing environment.
AVP, Data Engineering
AVP of Data Engineering owning Ensemble’s enterprise data platform strategy. Leading cloud-native data platform design on Azure and Databricks for scalable analytics and AI capabilities.
Data Engineer
Data Engineer developing and maintaining data pipelines and transformation models for analytics at Industrial Electric Manufacturing. Collaborating with stakeholders and ensuring data quality across business decisions.
Senior Data Engineering Manager
Senior Manager of Data Engineering leading a team that manages data at ReUp Education. Empowering adult learners and institutions by developing data solutions and pipelines.
Director, Data Engineering, ML – AI
Director of Data Engineering leading ML and AI initiatives for Measurabl. Responsible for data platform strategy and sustainability analytics in commercial real estate.
Data Engineer
Data Engineer responsible for building foundational infrastructure for AI deployments and product launches. Collaborating with top researchers and engineers in cutting-edge AI systems.
Data Engineer
Data Engineer at OrderlyMeds connecting multiple systems to BigQuery for strategic insights. Collaborating with a cross-functional team to enhance data utility and drive business decisions.
Data Engineer/Software Engineer
Data Engineer/Software Engineer responsible for implementing data-driven solutions and managing data pipelines. Join ALTEN Technology USA to work on challenging engineering projects.
Data Engineering Manager
Engineering leader managing Data Engineering team at Northrop Grumman. Overseeing data systems and leading a collaborative team to ensure engineering excellence.
Data Engineer
Senior Data Engineer serving in Prima's engineering team, building scalable data products and maintaining pipelines for optimal growth. Engaging in innovative solutions to transform motor insurance experience.
Senior Data Engineer
Senior Data Engineer leading design discussions and driving technical vision for healthcare data solutions. Collaborating cross-functionally to ensure high standards and timely project delivery.
Senior Analytics Data Engineer
Full Stack Engineer developing scalable applications for the largest real-world healthcare datasets provider. Collaborating with an international team under technical leadership for critical platform enhancements.
Director – Data Engineering
Director leading and scaling data engineering function for a Weekday's client. Building efficient data platforms powering analytics and business intelligence across the organization.
Data Engineer
Data Engineer building and maintaining data pipelines for marketing and analytics at an EdTech app with 70 million users. Collaborating with analysts and business teams for data quality and reporting.
Data Engineer
Data Engineer responsible for managing data infrastructure at Bemobi with innovative solutions for data access and analysis. Join the Data Platform team to enhance data lifecycle processes.
Senior Lead Software Engineer, Data Platform
Senior Software Engineer building scalable data and analytics platforms at Coupa. Focusing on advanced data ingestion and processing in a multi-cloud environment.
Workday/Fabric Data Engineer
Workday/Fabric Data Engineer supporting USNH's business intelligence initiatives by designing and maintaining data solutions. Collaborating with teams for effective reporting and analytics.