remote
Data Engineer - Medpace
Data Engineer
Full‑time Data Engineer responsible for designing, building, and maintaining data warehousing and BI solutions using Snowflake, SQL Server, and ETL processes to support corporate analytics and reporting.
About the role
Key Responsibilities
- Design, develop, and optimize data warehouse schemas and pipelines on Snowflake and SQL Server.
- Implement robust ETL processes to extract, transform, and load data from multiple source systems.
- Write and maintain complex ANSI SQL and T‑SQL queries for data validation, reporting, and analytics.
- Collaborate with business intelligence teams to deliver scalable dashboards and data models.
- Monitor data pipeline performance, troubleshoot issues, and ensure data quality and integrity.
Requirements
- 3+ years of hands‑on experience with Snowflake, SQL Server, and relational database design.
- Proficiency in writing ANSI SQL and T‑SQL for data manipulation and reporting.
- Strong background in ETL development and data warehousing concepts.
- Experience supporting business intelligence solutions and delivering data to analytical tools.
- Excellent problem‑solving skills and ability to work collaboratively in a fast‑paced environment.