Job Description
Insight Global is seeking a Data Engineer / Developer to support a global pharmaceutical client within their External Development and Manufacturing Solutions (EDMS) organization. This individual will be responsible for designing, building, and maintaining enterprise data solutions that support advanced analytics, AI/ML initiatives, and business intelligence across drug development, clinical operations, manufacturing, and supply chain functions.
The ideal candidate will have deep experience with Snowflake, ETL/ELT development, data modeling, and data warehouse architecture. This role requires a hands-on engineer who can develop scalable, governed data solutions while partnering with data scientists, business stakeholders, and technical teams to enable high-quality, AI-ready data assets.
Responsibilities:
- Design, develop, and maintain enterprise data warehouses and datamarts within the Snowflake platform.
- Build scalable dimensional data models, including star and snowflake schemas, to support reporting, analytics, and AI/ML use cases.
- Develop and optimize data views, semantic layers, and data products for business intelligence and machine learning consumption.
- Create, maintain, and monitor ETL/ELT pipelines that ingest, transform, and load data from multiple enterprise source systems.
- Implement data integration strategies including incremental loads, change data capture (CDC), and slowly changing dimensions (SCD).
- Partner with data scientists and business stakeholders to translate analytical and AI requirements into scalable data solutions.
- Support data harmonization and entity resolution efforts across multiple pharmaceutical and operational data sources.
- Establish and maintain data quality standards, validation rules, and governance practices.
- Collaborate with cloud infrastructure, security, and architecture teams to ensure data platform scalability, security, and compliance.
- Troubleshoot data issues, optimize performance, and support the ongoing enhancement of enterprise data assets.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- Bachelor's degree in Computer Science, Data Science, Information Systems, Bioinformatics, Engineering, or related field required
- 3+ years of hands-on data engineering experience with a strong focus on datamart development and ETL pipeline delivery
- 2+ years of production-level Snowflake experience in an enterprise environment
- Demonstrated experience building AI/ML-ready data pipelines and feature engineering frameworks
- Proven track record delivering data solutions that span multiple heterogeneous source systems
Nice to Have Skills & Experience
- Master's degree in Data Science, Computational Biology, or related discipline preferred
- Snowflake SnowPro Core Certification
- Snowflake SnowPro Advanced: Data Engineer
- dbt Analytics Engineering Certification
- Microsoft Certified: Azure Data Engineer Associate (DP-203)
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.