Data & Analytics Lead Data Engineer
Job Summary:
Senior Data Engineer: Responsible for implementing and supporting analytic data models and data pipelines for multiple business processes on the new 3M health care company's data warehouse and big data analytics infrastructure.
Principle Responsibilities: (essential job duties and responsibilities)
- Implement data models and curated datasets on a modern data warehouse and data hub
- Interface directly with business and systems subject matter experts to understand analytic needs and determine logical data model requirements
- Implement ETL processes between data warehouses and source systems
- Work closely with data architects and senior analysts to identify common data requirements and develop shared solutions
- Support data models and data integration solutions in production
- Support and maintain data warehouse, ETL, and analytic platforms
Required Skills and Experiences:
- Data warehouse and ETL background
- Advanced SQL programming capabilities
- Background in preparing data for analysis and reporting
- Experience with analytical tools for data discovery, modeling, visualization, analysis, and reporting
- Success in a highly dynamic environment with ability to shift priorities with agility
- Ability to go from whiteboard discussion to code
- Willingness to explore and implement new ideas and technologies
- Ability to effectively communicate with technical and non-technical audiences
- Ability to work independently with minimal supervision
Minimum Qualifications:
- 6+ years experience with SQL. Snowflake strongly preferred.
- 6+ years experience in data modeling design and implementation
- 4+ years experience with Informatica IICS
- 4+ years experience working directly with subject matter experts in both business and technology domains
- 2+ years experience with BI and analytic tools. PowerBI or Tableau.
Nice-to-have:
- Experience with Machine Learning tools and processes
- Hands-on experience with Python
Education:
- Bachelor's in Computer Science, Information Systems, Engineering, science discipline, or similar