Data Engineer (Onsite)

We are seeking a Senior Data Engineer to work in a direct hire role with our client in Walnut Grove, CA. The position is onsite. We cannot consider 3rd party candidates for this role.

GENERAL SUMMARY:

The Data Engineer designs, builds, and maintains scalable data infrastructure and pipelines that power our data products, reports, and analytics tools. This role plays a critical part in ensuring high-quality, reliable data flows throughout the organization, supporting both internal operations and external product features. Key responsibilities include improving data quality, implementing automated testing, and collaborating cross-functionally to deliver trusted data to end users.

ESSENTIAL JOB DUTIES:

• Design, build, and maintain robust ETL/ELT pipelines across multiple data sources and systems.


• Ensure data quality and consistency through validation frameworks, automated testing, and monitoring.


• Collaborate with clinical & operational process owners, data developers and other internal stakeholders to validate data requirements and implement efficient data solutions.


• Create and maintain well-documented, version-controlled data transformations and data models.


• Support the delivery of high-performance datasets for reporting, dashboards, machine learning models, and operational workflows.


• Optimize data storage and processing by designing scalable and cost-effective data architectures.


• Implement and enforce best practices in data governance, security, and access control.


• Collaborate with Business Intelligence and IT teams to manage data platform tooling (e.g., Power BI, SQL Server, Snowflake, Redshift, BigQuery, etc.).


• Conduct root cause analysis and debugging for data issues and partner with stakeholders to resolve anomalies.


• Participate in sprint planning, backlog grooming, and technical design sessions as a data engineering subject matter expert.

QUALIFICATIONS:

• Strong experience with modern ETL/ELT frameworks and orchestration tools (e.g., dbt, SQLMesh).


• Direct Experience working with Electronic Medical Records systems (EMRs) and with implementing ETL in a Healthcare setting is strongly preferred.


• Robust Proficiency in SQL and one or more general-purpose programming languages (Python preferred).


• Hands-on experience with relational and columnar databases (e.g., PostgreSQL, Snowflake, Redshift, SQL Server).


• Experience with cloud-based data platforms (AWS, Google Cloud Platform, or Azure).


• Familiarity with CI/CD pipelines, containerization (e.g., Docker), and infrastructure-as-code.


• Demonstrated ability to write testable, maintainable, and well-documented data code.


• Experience working in an Agile or product-driven environment.


• Excellent communication skills and ability to collaborate across teams and domains.


• Understanding of data warehousing concepts, dimensional modeling, and data product lifecycle.

COMPENTENCIES:

• Data Architecture - Able to design scalable, maintainable data pipelines that meet evolving business needs.


• Data Quality & Reliability - Focused on testing, validation, and uptime of data products.


• Cross-Team Collaboration - Works closely with analytics, product, and engineering teams to translate requirements into performant data systems.


• Documentation & Process Discipline - Maintains clear and reusable documentation of pipelines, schemas, and transformations.


• Initiative & Problem-Solving - Proactively identifies opportunities for improvement and resolves issues efficiently.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.