The Senior Data Engineer will design, build, and deliver highly visible and innovative reporting solutions. This role will model and ELT (Extract/Load/Transform) data into a cloud repository (Snowflake) for report consumption.
This position works with domain experts to architect, design and build data models and semantic layers based on business rules.
Essential Activities:
Migrate data and tools (modernize) from on premise to Cloud technologies
Design and create data models/semantic layers
Design, develop, automate, monitor and maintain ELT/ETL applications using preferred tools and techniques
Performance tune ELT/ETL to manage high volume batch data transfer to and from internal and external system locations
Recommend solutions and lead team through the process
Interact with cross-functional teams, project managers and agile teams to estimate development efforts and ensure complete delivery of solutions and accurate requirement fulfillment
Influence the business and leadership on processes and procedures that will drive value within the business and across the technical landscape
Communicate effectively and efficiently both written and verbally
Requirements:
Bachelor's Degree (BA/BS/BFA) or Equivalent
7-10 years related work experience
Experience with AWS technologies with, preferably, Snowflake, Teradata, Sql Server, DB2 as the backend
Extensive experience with delivery using ETL/ELT tools and techniques (i.e., Informatica, DataStage, SSIS, Talen, Airflow, Fivetran etc)
Expert understanding of data warehouse and master data management approaches, ELT industry standards and best practices
Experience building Data Vault and/or Star Schema models
Experience with BI reporting tools a plus such as Tableau, Cognos, Microstrategy or Looker
Possess strong communication skills and the ability to work with technical teams and business teams