Insight Global's client in the BioPharma Manufacturing industry is looking for an enthusiastic, fast paced data engineer for a ground up implementation of data and BI platform getting data from many Sales, Financial, Planning, Manufacturing and Factory applications to provide best in class analytics and reporting for all levels in a pharma manufacturing company. This position will report to a Principal Architect and will lead the end-to-end solution of building a cloud data warehouse platform, implementing ETL tools to pull data from source systems, model the data in data warehouse, understanding the business analytics requirement across multiple business functions and delivering the best-in-class enterprise reporting.
Responsibilities:
* Work with multiple business partners and cross functional IT teams in various functions sales, marketing, finance, purchasing, supply chain and manufacturing to understand their data and reporting needs.
* Use Azure DevOps to create data stories and demonstrate weekly progress.
* Create design documents and data modeling.
* Build data pipelines from the source system to snowflake using Fivetran, DBT cloud, python, PySpark and airflow.
* Work with offshore consultants explain design and create development tasks for them as well as review their work for completeness and quality
* Create Power BI reports.
* Test data pipeline code and reports with IT and Business users
* Setup DevOps framework using DBT and DevOps repos/GitHub.
* Build a DevOps framework in Azure to promote code from lower environment to higher environment.
* Troubleshoot production issues and provide code fixes.
* Mentor junior engineers.
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/ .
* Bachelor's degree in Computer Science, Software Engineering, Business Analytics or equivalent combination of education and experience
* 5-7 years of experience in data engineering and business intelligence.
* 5+ years of experience in building data pipelines into Azure Data Lake and Snowflake using ETL tools like Fivetran, DBT and Airflow.
* 3-5 years of writing code in python to create data pipelines between source system and target data lake.
* Experience in managing onsite and offshore consultants for timely and quality delivery.
* Strong, hands-on experience in cloud data platforms like Snowflake.
* Hands-on experience with batch and real-time data ingestion with snowflake and ADLS using variety of data sets.
* Strong understanding of data warehouse concepts and hands-on experience in data modeling using Kimball or Data Vault methodology.
* Experience in building Power BI reports and/or setting up the user administration in Power BI.
* Experience in understanding PLC data in manufacturing facility and building data platforms and analytics on it.
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.