Senior Data Engineer - Data Modeling
Core
Design, build, and support scalable data warehouse solutions, pipelines, and models to meet business objectives.
Role type
Senior IC data engineer (data modeling)
Builds
Data warehouse solutions, pipelines, transformations, and data service infrastructure
Domain
Financial services / Data Engineering
Deliverable
production ML models
Required skills
Data warehousing, Data modeling, SQL, Source-to-target mapping, DDL, SCD types, Big data, Data architecture, Database management, Data pipelines, Business intelligence
Preferred skills
Data governance, Metadata management, Data migrations, Legacy rationalization
Technologies
Oracle, Hadoop, Phoenix, Alation, SQL
Responsibilities
Partner with a Lead to design, build, and support scalable data solutions; Develop, support, and implement data solutions for multiple applications; Analyze data requirements and develop data preparation processes; Design and build data warehouse solutions, including pipelines, models, transformations, and data service infrastructure; Support data governance practices, including data quality, lineage, and compliance; Create and maintain source-to-target mappings, DDL documentation, and SCD models; Collaborate with engineers, business systems analysts, quality engineering, and reporting teams to deliver aligned solutions; Support data migration, transformation, modernization, and legacy rationalization efforts; Troubleshoot data issues and conduct root cause analysis.
