ETL Data Engineer

Skills

· Translates business requirements into technical architecture vision and implementation plan. · Leads design reviews of data warehouse deliverables such as data models ETL/ELT processes and data quality assessments and any modified Master Data Management processes. · Partner with business and IT teams to deliver complex technology projects and integrations. · Supports new data warehouse development ensuring consistency and integration with existing business processes and data governance. · Assists in the design and build of conceptual logical and physical dimensional data models. Serves as the subject matter expert on star schema snowflake schemas and normalized and de-normalized data models. · Ensures consistent adherence to data warehouse architecture standards through governance. · Analyzes data warehouse performance statistics and recommend improvements. · Reviews evaluates and recommends supplemental data warehouse technologies and tools if needed. · Works with peers in business and IT to define scope project timeline deliverables and priorities of data warehouse deliverables. · Assess all risks and mitigation strategies communicate impacts on data warehouse environment. · Work with analysts to open track and resolve issues with vendors. · Adhere to IT policies for reporting and managing trouble tickets and change control. · Adhere to departmental security standards and best practices to ensure appropriate end-user data access control levels. · Communicate complex and technical information in a concise and articulate manner. · Manage and/or provide guidance to other members of the team. · Superior analytical investigation and problem-solving abilities

Description

A Sr Data Engineer will function as the primary data engineering resource on an assigned squad and will be a key individual in helping the squad deliver Data Products and value to our business stakeholders. This role will help the squad scale in their data engineering capacity through mentorship and guidance of other data engineering resources.

Responsibilities

• · 8+ years of experience in IT, 5+ years of proven experience with ELT/ETL data pipeline development and maintenance.
• · Extensive data management experience (5+ years) driving and managing data platforms (Database Administration, data warehouse, data modeling, tuning, optimization, and data virtualization)
• · Strong experience working with stakeholders including data, design, product, and executive teams and assisting them with data-related technical issues.
• · Experience with developing in a multi environment (Dev, Test, Prod, etc.) and DevOps procedures for code deployment/promotion.
• · Extensive data warehouse platform implementation, data architecture best practices, and support and governance experience
• · Experience and understanding of integrating disparate datasets into a centralized platform and a combined view of common data points.
• · Fluent in advanced SQL scripting and/or development
• · Track record of success in a fast-paced environment
• · Bachelor’s degree in IT, CS or related discipline or equivalent number of years of work experience

Educational Requirements

• · Experience working with and managing an MPP Data Warehouse platform,
• · Worked with Snowflake, SQL Server Data Warehouse and/or other cloud MPP platform operations,
• · Experience using Pentaho and Azure Data Factory
• · Experience working in Agile and/or DevOps teams (SCRUM)
• · Exceptional teaming skills encompassing cross-functional teams, peer relationships, informing, understanding, and appreciating differences.
• · Experience in a GxP / SOX regulated, quality function in a biopharmaceutical company or Clinical Research Organization (CRO) preferred.