Data Engineer

A growing biopharma company is seeking a Data Engineer to join their data team in Waltham, MA (hybrid basis). The team includes developers, analysts, and engineers, and this role reports directly to the Senior Director of Data Engineering.

Day-to-Day Responsibilities:

• Build and optimize Azure Fabric-based pipelines using Data Factory, OneLake, Lakehouse, and Pipelines.
• Develop robust T-SQL, Power Query, and PySpark transformations for commercial datasets.
• Integrate third-party sources such as IQVIA, Veeva CRM, and HCP/HCO master data.
• Build and maintain data pipelines to support commercial data workflows.
• Work closely with commercial teams to understand data requirements and ensure accurate delivery.
• Support the migration of legacy systems to a data lake environment, with a target completion by the end of the year.
• Contribute to technical strategy and execution within an Agile framework.
• Collaborate with cross-functional teams including data engineers, developers, and business stakeholders.

Compensation: $70/hour to $75/hour. Exact compensation may vary based on several factors, including skills, experience, and education.

Benefit packages for this role will start on the 31st 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.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, 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 Human Resources Request Form.

Skills and Requirements:

• 5-8 years as a Data Engineer
• 2-3 years of experience working with commercial data within the pharmaceutical industry
• Proven hands-on with Microsoft Fabric, Azure Data Factory, Lakehouse, Blob Storage, Synapse, Power BI, and ADLS Gen2
• Experience SQL, Power Query (M), PySpark
• Proficiency in Python for data engineering tasks.
• Expertise in data warehousing, data lake architectures, and data modeling techniques
• Strong experience with ETL/ELT processes and tools
• Familiarity with IQVIA datasets, Veeva CRM, and pharma sales/engagement models

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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 the recruiting process, please send a request to HR@insightglobal.com.