Location: Hybrid (based in California)
Company: Community Health Group
About Us:
At Community Health Group, we are deeply committed to the health and well-being of our community, and we believe that quality data can lead to healthier lives. As an integral part of our mission to provide accessible healthcare, we are looking for an experienced Informatics Data Engineer to join our innovative team. This role will allow you to blend your expertise in data engineering, SQL, and data modeling to drive data strategies that directly impact health outcomes across our organization.
We’re not just about numbers—we’re about transforming lives through data. If you’re passionate about optimizing data pipelines, building robust infrastructures, and collaborating with a dynamic team to unlock actionable insights, we want you to be part of our vision!
Your Impact:
As an Informatics Data Engineer, you will play a critical role in designing, building, and optimizing data pipelines that support essential data and analytics initiatives within our Enterprise Data Warehouse (EDW). You’ll work hand-in-hand with cross-functional teams to enable data-driven decision-making, ensuring that our organization’s strategic goals are met. The ideal candidate will have a keen understanding of Kimball dimensional modeling and advanced SQL programming—skills you’ll use daily to craft meaningful data solutions for both technical and non-technical stakeholders.
What You’ll Do:
- Build & Optimize: Design, build, and automate high-performing data pipelines with a focus on the EDW to support diverse data science and analytics initiatives.
- Dimensional Modeling: Implement Kimball methodology for dimensional modeling, creating conformed dimensions and designing fact tables (transactional, snapshot, and fact-less).
- Collaborate for Excellence: Partner with the Informatics team to continuously enhance and optimize the EDW for future analytics.
- Mentor & Lead: Help elevate the technical capabilities of your teammates by mentoring on SQL development, ETL processes, and data modeling best practices.
- Data Preparation: Support ad hoc analytics by producing clean datasets and user-friendly tools for both technical and non-technical stakeholders.
- Process Improvement: Contribute to the culture of continuous improvement by implementing best practices, optimizing processes, and ensuring the reliability and performance of systems.
- Stay Current: Keep your skills sharp and stay ahead of the industry by participating in educational programs, reading relevant literature, and attending conferences.
What You Need:
- Education: Bachelor's degree in Computer Science, Data Engineering, or a related field.
- Experience: 5+ years of ETL experience, with a focus on building and optimizing data pipelines and data infrastructure.
- SQL Expertise: Strong proficiency in SQL programming and query optimization (preferably with SQL Server or other RDBMS).
- Dimensional Modeling: Solid experience with Kimball methodology and ETL processes to create structured and useful data solutions.
- Documentation & Testing: Experience in developing database specifications, test plans, and system documentation.
Nice-to-Haves:
- Familiarity with Snowflake, Matillion, and other modern data tools.
- Experience with Tableau, Power BI, or SQL Server Reporting Services (SSRS).
- A background in healthcare analytics or experience working with healthcare data.
- Knowledge of AI tools like ChatGPT and integrating them into existing systems.
Key Competencies for Success:
- Problem Solver: Exceptional analytical abilities and a proactive approach to problem-solving.
- Team Player: Strong interpersonal skills with the ability to communicate complex concepts clearly to both technical and non-technical teams.
- Time Management: Proven ability to manage multiple projects with competing deadlines effectively.
- Security & Compliance: Adherence to data security standards, including HIPAA compliance.
Why Join Us?
- Make an Impact: Work at the crossroads of data engineering and analytics, driving critical insights that impact organizational outcomes and community health.
- Collaboration & Innovation: Join a team that values creativity, continuous learning, and collaboration—where your contributions will shape the future of healthcare data.
- Great Benefits: Enjoy comprehensive benefits designed to support you and your family, including healthcare, wellness programs, and professional development opportunities.
- Work-Life Balance: We understand the importance of balance—flexible work schedules and opportunities for professional growth make this a great place to grow your career.
Physical Requirements:
- Must be able to lift up to 30 lbs.
- Occasional evenings and weekends may be required.
Community Health Group is committed to fostering an inclusive environment. We are an Equal Opportunity Employer, and we encourage applicants from diverse backgrounds to apply. We prohibit discrimination and harassment based on race, ethnicity, gender, age, disability, or any other protected characteristic.
