Insight Global's client in the BioPharma manufacturing industry is looking for an enthusiastic, fast paced data warehouse and business intelligence architect to join an exciting opportunity for a ground up implementation of data and BI platform getting data from many Sales, Financial, Planning & Factory applications and provide best in class analytics and reporting for all levels in the company. The BI Architect will report to VP of Technology 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 in various functions sales, marketing, finance, purchasing, supply chain and manufacturing to understand their data and reporting needs.
· Create a reporting and metrics catalog and work with consulting partners to build and execute a project plan to deliver the reporting needs.
· Architect a modern data platform which will be a combination of a cloud data warehouse/data lake, set of ETL tools, data quality tools and standards and an enterprise reporting tool for consumption of data.
· Lead the ETL tool implementation for building data pipelines for batch/real-time and near real time data into data lake.
· Define the standards for data modeling to support self-service reporting.
· Implement data retention and archival policies.
· Implement data security and governance standards for right access and PII data for European GDPR.
· Create a framework to measure data quality and report data quality issues in a timely fashion.
· Overtime, create a data science platform to solve ML/AI used cases in factory.
· Lead a team of data and BI engineers to develop data pipelines and reports. Ability to work with onshore and offshore contracting teams will be required.
· Document the QA/testing and devOps standards and guidelines. Implement a robust SDLC and CI/CD framework for all code and reports going into production.
· Review and monitor project teams adherence to design standards & implementation framework.
· Create a support process, SLAs, monitoring, alerting to support production break-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/ .
· B.S. degree in Computer Science, Software Engineering, Business Analytics or equivalent combination of education and experience.
· 15+ years of experience in building and maintaining large data warehouses.
· 5+ years of experience in implementing cloud data warehouses from scratch.
· Hands-on experience in cloud data platforms like Snowflake and Databricks.
· Experience using modern ETL tools like Fivetran, DBT, Matillion ETL or native Azure service like Azure Data Factory.
· Experience using native storage, compute, and data ingestion service in Azure and AWS cloud.
· Hands-on experience in implementing Power BI architecture and creating reports in Power BI.
· Expertise in writing SQL and code in Python.
· Expertise with queuing systems like Kafka, Solace.
· Experience in understanding PLC data in manufacturing facility and building data platforms and analytics on it.
· Experience in ingesting data from Microsoft Dynamics and creating embedded reporting using Power BI.
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.