Senior Data Engineer

Impact Consulting Solutions, Inc. offers a remote, Scrum-driven environment focused on data warehousing, data modeling, and end-to-end data flows from source to BI tool. The Senior Data Engineer will join a four-analyst, four-engineer team and work with Snowflake, Azure Data Factory, and NoSQL stores. The compensation range is $128,254 to $154,456 per year.

Responsibilities

• Design and maintain data warehousing solutions using Kimball and Inmon techniques, including dimensional data stores, ODS, and slowly changing dimensions.
• Oversee data movement from source systems through targets and dimensions to the business intelligence layer.
• Craft advanced SQL queries and clearly distinguish DDL from DML in development tasks.
• Decompose data into 3NF and model relational data with attention to ACID transactions.
• Apply basic performance tuning and security considerations while accounting for CAP theorem implications.
• Utilize senior level JavaScript and work with non-relational NoSQL data stores.
• Translate technical requirements into code-based solutions and contribute to Snowflake implementations.
• Leverage Azure Data Factory for data integration and manage source control with Git/GitHub, including pipeline branches and merges.
• Experience with data modeling techniques; familiarity with slowly changing dimensions, star schemas, and data vault models is a plus.
• Collaborate effectively within a Scrum team environment.
• Demonstrate a self-starting, proactive approach to tasks and projects.

Requirements

• Proven data warehousing experience with Kimball and Inmon approaches, including DDS, ODS, and slowly changing dimensions.
• End-to-end data flow experience from source to BI tool.
• Advanced SQL skills are mandatory, with clear understanding of DDL versus DML.
• Ability to decompose data to 3NF and model relational data with ACID transactions.
• Basic performance and security knowledge; understanding of CAP theorem.
• Senior level JavaScript proficiency and experience with NoSQL data stores.
• Ability to translate technical requirements into code-driven solutions.
• Exposure to Snowflake and intermediate experience with Azure Cloud Technologies (Azure Data Factory).
• Experience with source control using Git/GitHub and managing pipelines with branching and merging.
• Data modeling experience and techniques, including slowly changing dimensions, star schemas, and data vaults.
• Comfortable working in a Scrum team environment with a team composition of four analysts and four engineers.
• Self-starter attitude with initiative and reliability.

Technologies

• SQL
• JavaScript
• Snowflake
• Azure Data Factory
• Git/GitHub
• NoSQL data stores

Work location

Remote

Salary

USD 128,254 - 154,456 per year