Senior Data Engineer - Analytics
Essential Functions
Collaborate with other internal teams to design data pipelines to ingest information from various systems to our BigQuery or Redshift data warehouse.
Take ownership of the codebase, identifying gaps, areas for improvement, refactoring where needed, and keeping the design fresh and modern.
Actively code to unblock technical and communication challenges as necessary to ensure teams meet product roadmaps and close those gaps.
Participate in architecture review decisions, designs, and documentation that will govern the direction of the team, the codebase, and multiple products over a several month timeframe.
Communicate effectively with stakeholders (upper management, engineering manager, product manager, and peers) regarding the product you are responsible for.
Provide feedback and participate in pair programming exercises.
Success in this role
Team delivers reliable, scalable, high performing customer facing analytic services within analytic SLAs.
Consistently delivers committed business initiatives and coordinates with other stakeholders to roll out products with analytic insights.
Business teams and Customers are empowered with AI assisted insights without dependency on engineering.
Consistently deliver high quality code that is easily maintained and scaled.
Your work is reliable and your team members and stakeholders fully trust you to execute your responsibilities with minimal oversight.
Contribute to the team culture where innovation, autonomy, and accountability thrive.
Minimum Requirements
- Ability to approach complex, ambiguous data challenges systematically.
- Experience owning data integrity, ensuring that data is reliable, timely, and traceable from source to consumption.
- Experience creating and maintaining Extract, Transform, and Load (ETL) Pipelines and using modern ETL tools such as Python, SQL, Airflow, DBT, S3, Airbyte, Confluent.
- Experience creating and maintaining analytic semantic layers and business intelligence dashboard such as Looker, PowerBI, Tableau, etc.
- Experience owning data integrity, ensuring that data is reliable, timely, and traceable from source to consumption.
- Proficiency in leveraging AI agents and other AI tools to significantly enhance developer productivity.
- Experience working with database and data warehouse technologies such as Postgres, Bigquery, and Redshift.
- Experience with cloud services such as AWS, Azure, GCP.
- Experience in developing large scale data models and complex data pipelines.
Preferred Skills
- Experience in working with large slow changing dimension data models.
- Experience in the US healthcare system, in particular with data systems and EHRs such as Epic, Cerner or Athenahealth.
Education & Experience
- BS Degree or equivalent work experience.
- Five years experience developing data platforms using Python, SQL.
- Supervision: N/A
Certifications
- N/A
Language Skills
- Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures or governmental regulations.
- Ability to write reports, business correspondence and procedure manuals.
- Ability to effectively present information and respond to questions from a variety of both internal and external sources.
Physical Capabilities
- Sit.
- Use hands to finger, handle, or feel.
- Reach with hands and arms.
- Talk or hear.
- Stand and walk.
- Lift and/or move up to 10 pounds.