Designs, develops, and maintains data pipelines, workflows, integrations, transformations, and data warehouses. Provides architecture guidance, troubleshoots more than 100 pipelines, supports stakeholders, creates reports, documents processes, participates in code reviews, mentors junior engineers, and translates business requirements into technical solutions while maintaining healthcare data privacy and security compliance.
TREND Health Partners is a tech-enabled payment integrity company. Our mission is to facilitate collaboration between payers and providers for mutual benefit and waste reduction, ultimately improving access to healthcare. We achieve this by aligning the common goals of payers and providers and fostering collaboration through a shared technology platform and seamless workflows.
Joining TREND Health Partners means becoming part of a dynamic, growing organization that promotes a collaborative and innovative work environment. Our comprehensive compensation package includes competitive salaries, highly valued health insurance, a 401(k) plan with employer match, paid parental leave, and more.
The Data Engineer II is responsible for designing, developing, and maintaining optimal data pipelines and workflows. They provide technical guidance on architecture design, work with stakeholders to assist with data-related technical issues, perform data integration, transformation, and cleaning, and translate business requirements into technical specifications and finished products. They collaborate with Data Engineer III’s to contribute to the overall product strategy, conduct code reviews, mentor Data Engineer I’s, and share knowledge with the team. Additionally, they develop and maintain documentation for data engineering processes, systems, and data models, and ensure compliance with healthcare data, related privacy, and security regulations.
ROLE AND RESPONSIBILITIES
- Design, develop, and maintain optimal data pipelines and workflows.
- Provide technical guidance on architecture design and collaborate with Data Engineers for
- implementation.
- Work with stakeholders to assist with data-related technical issues and support their data
- infrastructure needs.
- Perform data integration, transformation, and cleaning to create insightful and actionable data for the
- business.
- Translate business requirements into technical specifications and finished products.
- Participate in code reviews and contribute to team knowledge sharing.
- Lead the development and maintenance of documentation for data engineering processes and
- systems.
- Create ad-hoc reports requested by internal and external partners.
- Work as a team to support and troubleshoot errors for 100+ data pipelines.
- Work closely with the application development team to update data and data structures.
- Provide analysis, recommendations, and feedback to business process owners, leadership team, and
- the Information Technology department.
- Propose automated solutions to repeated development tasks.
QUALIFICATIONS
- Bachelor’s degree with major coursework in Computer Science or Business Administration/related field
- required. Equivalent work experience in a similar position may be substituted for educational
- requirements.
- Experience in data engineering or a related field.
- Strong proficiency in Python, T-SQL, SSMS, Databricks, and Azure Data Factory.
- Experience with data integration, transformation, and data warehousing.
- Strong understanding of data privacy and security regulations.
- Ability to translate business requirements into technical specifications and finished products.
- Proficiency in compiling data, creating reports, and presenting information.
- Proven experience working in a fast-paced environment supporting multiple concurrent projects.
- Strong written, verbal, and customer service skills.
PREFERRED SKILLS
- Ability to manage multiple tasks and projects simultaneously.
- Experience in mentoring junior developers or a desire to take on a mentoring role.
- Knowledge of healthcare data and related privacy and security regulations.
- Experience with cloud-based services like Azure.
- Strong problem-solving skills and attention to detail.
- Experience with healthcare data.
- Experience using agile framework.
- Experience with software development life cycle tools such as Red-Gate, Bitbucket, or JIRA.
MENTAL AND PHYSICAL DEMANDS
- This position will be exposed mainly to an indoor office environment and will be expected to work in or
- around computers and printers.
- The nature of the work is sedentary, and the employee will be sitting most of the time.
- Essential physical functions of the job include typing and the repetitive motion to utilize computer
- software and hardware continuously throughout the day.
- Essential mental functions of this position include concentrating on analytical tasks, reading
- information, and verbal/written communication to others continuously throughout the day.
RELATED DUTIES AS ASSIGNED
- This job description documents the general nature and level of work but is not intended to be a comprehensive list of activities, duties, or responsibilities required for this position. Consequently, employees may be asked to perform other duties as required.
- Employees may also be asked to complete certain compliance requirements set forth by our Business
- Partners in the performance of their jobs including but not limited to requests for background and drug screenings and disclosures of personal health information or personally identifiable information.
- Exemptions as provided under the ADA and TITLE VII of the Civil Rights Act will be observed and followed.
- Reasonable accommodations may be made to enable individuals with disabilities to perform the functions outlined above.
Similar Jobs
Consumer Web • Digital Media • Information Technology • Music • Software
Build and maintain production data pipelines and models using SQLMesh, BigQuery, and Python. Improve observability, reliability, and performance; support finance and revenue pipelines; participate in on-call rotation and own features end-to-end.
Top Skills:
AirflowBigQueryDagsterDbtPrefectPythonSQLSqlmesh
Big Data • Real Estate • Software
The Senior Data Engineer will optimize data ingestion pipelines, manage PostgreSQL databases, design ETL processes, and ensure system reliability in a remote-first, collaborative environment.
Top Skills:
AWSAws AuroraCi/CdCloudFormationPostgresRubyRuby On RailsTerraform
Artificial Intelligence • Machine Learning • Software • Analytics
The Senior Data Engineer will design and build scalable data platforms, handle automation for data operations, and ensure reliability and performance of data pipelines while collaborating with various teams.
Top Skills:
AirflowSparkAws EmrAws LambdaAws S3KafkaKinesisPythonScalaSQL
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
