Medica is seeking an experienced Sr. Data Engineer with a background in extraction, transformation, and loading (ETL) of data from a variety of sources. These robust and scalable solutions that will support Medica's claims and financial platforms. This role is ideal for an innovative and highly technical thinker who thrives in a mission-driven, healthcare-focused organization and is passionate about ensuring efficiency, scalability, financial integrity and compliance. The ideal candidate is a technical generalist with strong system design expertise and a proven ability to bridge strategy and execution across diverse technologies. Design, build, implement, and maintain data storage structures and processing pipelines for the extraction, transformation, and loading (ETL) of data from a variety of sources. Develop robust and scalable solutions that transform data into a useful format for analysis, enhance data flow, and enable efficient, cost-effective consumption and analysis of data. Write complex SQL queries to support analytics needs. Evaluate and recommend tools and technologies for data infrastructure and processing, including modern cloud platforms such as Snowflake, Azure, AWS, and data integration tools like Apache Airflow, dbt, Informatica Intelligent Data Management Cloud (IDMC), and distributed processing frameworks such as Apache Spark. Performs other duties as assigned. In addition to engineering responsibilities, the Data Generalist component of this role includes: Performing exploratory data analysis and generating actionable insights Creating dashboards and visualizations using tools like Power BI, Tableau, or Excel Collaborating with cross-functional teams to align data efforts with business goals