Remote Senior Data Engineer role focused on data warehousing, data modeling, and end-to-end data flows within a Scrum team.

Design and maintain data warehouse solutions, applying Kimball and Inmon techniques including DDS, ODS, and slowly changing dimensions.
Oversee data flows from source systems through targets and dimensions to BI consumption layers.
Demonstrate advanced SQL proficiency and manage distinctions between DDL and DML.
Decompose data toward 3NF and model relational data structures while supporting ACID transactions.
Apply basic performance tuning and security considerations, with awareness of CAP theorem implications.
Utilize senior level JavaScript skills in data engineering tasks.
Work with non-relational and NoSQL data stores as part of data ecosystem.
Translate technical requirements into concrete data solutions through code.
Engage with Snowflake for data warehousing activities and leverage Azure Data Factory for data pipelines.
Practice source control using Git and GitHub, managing pipelines with branches and merges.
Leverage data modeling techniques including star schemas and data vault; experience with slowly changing dimensions is valued.
Operate effectively in a Scrum environment with a team of about 4 analysts and 4 engineers.
Demonstrate self starting behavior and initiative in task ownership.

Proven data warehousing experience.
Expertise in Kimball and Inmon methodologies such as DDS, ODS, and slowly changing dimensions.
End-to-end data flow experience from source to BI tool.
Advanced SQL skills are mandatory; familiarity with DDL vs DML.
Ability to decompose data to 3NF and model relational data effectively.
ACID transaction knowledge and basic performance and security awareness.
Understanding of CAP theorem concepts.
Senior level JavaScript proficiency.
Experience with non-relational/NoSQL data stores.
Capacity to translate requirements into code-based solutions.
Exposure to Snowflake platform.
Intermediate experience with Azure cloud technologies, notably Azure Data Factory.
Source control experience using Git and GitHub.
Experience designing and managing pipelines with branching and merging workflows.
Data modeling experience is a plus; familiarity with data modeling techniques.
Knowledge of slowly changing dimensions, star schemas, and data vault architectures.
Comfortable working in a Scrum team environment.
Self-starter with proactive mindset.

Senior Data Engineer

Job Description