Data Engineer III

About Our Company
At Altais, we're looking for bold and curious clinicians and innovators who share our passion for enabling better health care experiences and revolutionizing the healthcare system for physicians, advanced care providers, patients, and the clinical community. At Altais, we're building breakthrough clinical support tools, technology, and services to let doctors do what they do best: care for people. We invite you to join our growing passionate team as we change the game for the future of healthcare and enable the experience that people need and deserve. Altais family of companies include Brown & Toland Physicians, Family Care Specialists and Altais Medical Groups.

About Your Team

Are you looking to work with a high performing, fast growing and dynamic IT team? Altais and our subsidiaries, form one of the most recognized medical groups in California. We are 4,000+ physicians, working in over 40 cities in California, caring for more than 500,000 patients. If working in a mission driven organization supporting highly competent, hard-working, thoughtful clinicians who value good ideas and are passionate about reshaping healthcare excites you, then we are thrilled to welcome you to your new career.

About Your Work

The Data Engineer works closely with Healthcare Analytics staff to develop system-based solutions and reports that help support clinical, financial and operational business processes and objectives. The incumbent demonstrates high level data warehouse understanding and is responsible for the creation and support of ETL, data marts, databases, reports and complex SQL. The Data Engineer will work with customers, employees and vendors to design and develop data warehouse structures that support reporting and analytical needs.

You will focus on:

• Design, develop, and maintain robust data pipelines to support healthcare analytics initiatives.
• Collaborate with cross-functional teams to understand data requirements and ensure data availability for analysis.
• Implement data integration solutions for diverse healthcare data sources, ensuring data accuracy and reliability.
• Optimize and tune existing data infrastructure to improve performance and efficiency.
• Work closely with data scientists and analysts to translate business requirements into actionable data engineering tasks.
• Ensure compliance with healthcare data privacy and security regulations in all data processing activities.
• Troubleshoot data-related issues and provide timely resolutions to maintain data integrity.
• Explore and adopt emerging technologies to enhance data engineering capabilities and stay current with industry best practices.
• Create and maintain documentation for data engineering processes, pipelines, and workflows.
• Participate in the evaluation and selection of data management tools and technologies.

The Skills, Experience & Education You Bring

• Solid understanding of database structures including the creation and support of complex views, stored procedures, and/or packages.
• High level of proficiency working with various data integration and visualization tools to include but not limited to, MS Excel, MS Access, MS SQL Server (SSIS), Talend, T-SQL, Power BI, MS Visual Studio.
• Skilled in reading and writing moderate to complex SQL commands and accurately assessing results (preferable 3+ years).
• Ability to analyze complex data structures with minimal direction.
• Automate data imports and extracts to key vendors and business partners.
• Strong aptitude for quickly troubleshooting and identifying the cause of questionable results within extracts and reports.
• Ability to efficiently research, design and build solutions to technical data challenges.
• Must be able to excel in a fast-moving team environment with a proven ability to take ownership over projects and complete them in a timely manner.
• High comfort level working on multiple simultaneous assignments and dealing with assignment prioritization changes.
• Excellent employee, client, and vendor relations a must.
• Strong facilitation, critical thinking, problem solving, decision making and analytical skills.
• Excellent verbal, written communication, and presentation skills.
• Self-starter who holds themself accountable for completing assignments timely and accurately.

Experience & Education:

• Bachelor's or higher degree in Computer Science, Information Technology, or a related field.
• 5 years + proven experience in data engineering with a focus on healthcare data.
• Proficiency in programming languages such as SQL, Python, or Java for data processing tasks.
• Strong understanding of database systems, both relational and NoSQL, and experience with data modeling.
• Expertise in ETL (Extract, Transform, Load) processes and tools (SSIS and Talend)
• Familiarity with healthcare data standards, such as HL7, FHIR, and experience working with electronic health records (EHR) data.
• Knowledge of data warehousing concepts and technologies.
• Excellent problem-solving skills and attention to detail.
• Effective communication skills to collaborate with interdisciplinary teams.
• Understanding of healthcare analytics and a commitment to maintaining the highest data quality standards.

You Share Our Mission & Values:

• You are passionate about improving the healthcare experience and want to be part of the Altais mission.
• You are bold and curious- willing to take risks, try new things and be creative.
• You take pride in your work and are accountable for the quality of everything you do, holding yourself and others to a high standard.
• You are compassionate and are known as someone who demonstrates emotional intelligence, considers others when making decisions and always tries to do the right thing.
• You co-create, knowing that we can be better as a team than individuals. You work well with others, collaborating and valuing diversity of thought and perspective.
• You build trust with your colleagues and customers by demonstrating that you are someone who values honesty and transparency.

Altais values the contribution each Team Member brings to our organization. Final determination of a successful candidate's starting pay will vary based on several factors, including, but not limited to education and experience within the job or the industry. The pay scale listed for this position is generally for candidates that meet the specified qualifications and requirements listed on this job description. Additional pay may be determined for those candidates that exceed these specified qualifications and requirements. We provide a competitive compensation package that recognizes your experience, credentials, and education alongside a robust benefits program to meet your needs.

The anticipated pay range for this role is listed in our salary posting for transparency but may vary based on factors including the candidate's qualifications, skills, experience, and geographic location. This base pay range is specific to California and can vary based on Bay Area, Metro LA, and Greater California regions which may not be applicable to other locations.

Altais and its subsidiaries and affiliates are committed to protecting the privacy and security of the personal information you provide to us. Please refer to our 'CPRA Privacy Notice for California Employees and Applicants' to learn how we collect and process your personal information when you apply for a role with us.

Physical Requirements: Office Environment - roles involving part to full time schedule in Office Environment. Based in our physical offices and work from home office/deskwork - Activity level: Sedentary, frequency most of workday.

External hires must pass a background check/drug screen. Qualified applicants with arrest records and/or conviction records will be considered for employment in a manner consistent with Federal, State and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran status or disability status and any other classification protected by Federal, State and local laws.