PURPOSE AND SCOPE:

Responsible for the building solutions for enterprise data warehouse, data lake and cloud analytical platform solutions. Working closely with other FMC teams, business and IT colleagues. This Sr.engineer is responsible for analysis, design, development, and on-going support for assigned programs and projects. Partner with other team members in the architecture and design for enterprise warehousing, cloud data platform and data management initiatives to deliver solutions.

Sr. Data Engineer focus:

• In- Depth knowledge of data warehousing, Hadoop, data lakes, data analytics, data management, data governance and/or BI. 
• In- Depth understanding of cloud analytics/Data service offering, Cloud architecture and economics.
• Has industry and business process knowledge, operations knowledge.
• Improve existing methods, techniques and / or processes across job areas.

PRINCIPAL DUTIES AND RESPONSIBILITIES:

• Responsible for the design, implementation, maintenance, and support of data stores used for reporting and analytics (data lake, data warehouse systems and related data marts).
• Coordinates with peers from other clinical and IT groups to ensure successful design, planning and completion of programs and projects.
• Understands business requirements and priorities to shape the scope and requirements of the Data Warehouse solution. 
• Performs data analysis and data provisioning against source systems
• Designs the processes to acquire and integrate disparate data from multiple sources
• Assists in the data architecture design to be used for Business intelligence and Analytical purposes. 
• Documents technical specifications for the design of data integration and data architecture.
• Develops the ETL, database and system code to acquire, integrate and load data to our data lake, data warehouse systems and related data marts
• Performs unit testing to assure quality repeatable, quality processes with accurate data results.
• Supports Quality Assurance engineers in the data quality testing of systems built.
• Installs processes for auditing target data stores and ensuring data quality
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Informatica, Python, SQL and AWS ‘big data’ technologies.
• Performs other related duties as assigned.

PHYSICAL DEMANDS AND WORKING CONDITIONS:

• The physical demands and work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• Little to no travel is expected for this position.

EDUCATION AND REQUIRED CREDENTIALS:

• Bachelor's Degree; Advanced Degree preferred (in Computer/Health Information Systems, concentration in IT) or an equivalent combination of education and experience

EXPERIENCE AND SKILLS:

• Bachelor‘s Degree and 5-8 years of experience/Master‘s Degree and 3 years of experience (in Information Systems, including software design/development in: Oracle, SQL, Informatica Power Center, and/or AWS data services, or an equivalent combination of education and experience
• Experience leading technology project teams. 
• Exp. working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases – On-prem ( Oracle, SQL Server) & Cloud(Snowflake & Redshift)
• Experience building and optimizing on prem ETL pipelines through Informatica, Python through optimal architectures and data sets.
• Good Knowledge on AWS services – EC2, Lambda, EMR, S3, RDS, Glue, Redshift, Kinesis, lake formation, Cloud watch, elastic search, Athena.
• Must be familiar with analysis and design methodologies for full system development life cycles.
• Must be competent with relational and dimensional database designs and concepts.
• Must have strong problem-solving skills.