Data Modeler
Core
Design, develop, and maintain scalable conceptual, logical, and physical data models to support enterprise data warehouses, data marts, analytics, and reporting solutions.
Role type
Senior hands-on Data Modeler
Builds
Scalable data models for data warehouses, data marts, and semantic layers
Domain
Financial services / Data Warehousing
Deliverable
production ML models
Required skills
Dimensional modeling, Relational database design, ER modeling, Snowflake, SQL, Data modeling tools (ERwin/ER/Studio), AWS cloud platforms, ETL/ELT methodologies, Metadata management, Data lineage, Data governance, SDLC/Agile, JIRA
Preferred skills
Financial services industry experience, DBT, Airflow, Python, Big Data technologies (Hadoop/Spark), Semantic data models
Technologies
Snowflake, AWS, ERwin, ER/Studio, JIRA, DBT, Airflow, Hadoop, Spark
Responsibilities
Design and optimize dimensional and relational data models; Translate business requirements into data entities and structures; Collaborate with data engineers and BI teams on data integration; Review existing models for quality and performance; Define data modeling standards and documentation; Support data governance and lineage initiatives; Troubleshoot data-related issues.
Seniority
Senior, hands-on IC
