Data Warehouse Data Modeler

JPS Tech Solutions Pvt Ltd; Iowa; On-site; USD 120,000 - 160,000; Full time

Job summary

JPS Tech Solutions Pvt Ltd is seeking an experienced Senior Data Warehouse Data Modeler to design, develop, and optimize enterprise data models and data warehouse solutions across traditional and cloud platforms.

The ideal candidate will have 10+ years in financial services data warehousing, strong SQL, ETL (SSIS), and metadata management, with hands-on Azure data platform experience. Excellent collaboration and documentation skills are required.

Qualifications

• 10+ years of experience as a Data Modeler in large multinational environments.
• 10+ years of hands-on SQL, at least one programming language, ETL technologies (SSIS preferred), and database platforms.
• 10+ years in data modeling and metadata management.
• 10+ years designing and building large-scale financial services data warehouses with strong data analysis.
• 5+ years with modern data platforms including Microsoft Azure.
• 5+ years in data management, data warehousing, data transformation, metadata management, reference data management, and BI tools.
• 2+ years using PowerDesigner or related data modeling tools.
• Solid knowledge of Ralph Kimball methodology (3NF, Star/Snowflake).
• Strong problem-solving, debugging, and analytical skills.
• Excellent communication, collaboration, and technical documentation skills.

Responsibilities

• Design and develop conceptual, logical, and physical data models and related documentation.
• Create and maintain enterprise data models supporting operational and analytical needs.
• Collaborate with policy teams to define enterprise data vision and analytics strategies.
• Work with architects, developers, DBAs, and analysts to capture requirements and capabilities.
• Develop standards/best practices for data modeling and database design.
• Establish data modeling approaches for metadata management, ODS, and ETL environments.
• Create, validate, and test physical data models for business data and metadata tables.
• Apply data modeling to improve performance, scalability, and efficiency.
• Coordinate data architecture discussions across programs and technical teams.
• Optimize data platforms and database structures.
• Support data management, transformation, reference data management, and BI initiatives.
• Collaborate with stakeholders to plan development approaches and timelines.

Skills

SQL

Data modeling

Metadata management

ETL development

Analytical skills

Communication

Problem solving

Tools

PowerDesigner

SSIS

Microsoft Azure

Job description

Job Summary

We are seeking an experienced Senior Data Warehouse Data Modeler to design, develop, and optimize enterprise data models and data warehouse solutions. The role involves creating conceptual, logical, and physical data models, establishing data modeling standards, and supporting enterprise data architecture across traditional and cloud platforms. The ideal candidate will have extensive experience in financial services data warehousing, SQL, ETL technologies, metadata management, and modern Microsoft Azure data platforms.

Key Responsibilities

• Design and develop conceptual, logical, and physical data models, including data flow diagrams and related documentation.
• Create and maintain enterprise data models supporting operational and analytical data requirements.
• Collaborate with policy teams to define and support enterprise data vision, operational frameworks, and analytical strategies.
• Work with system architects, software developers, database administrators, and design analysts to understand project requirements and technical capabilities.
• Develop standards and best practices for data modeling, database design, and implementation.
• Establish data modeling approaches to support metadata management, operational data stores, and ETL environments.
• Create, validate, and test physical data models for business data, applications, database structures, and metadata tables.
• Apply data modeling principles to improve database performance, scalability, and operational efficiency.
• Coordinate and facilitate data architecture and solution discussions across business programs and technical teams.
• Optimize existing and new data platforms, database structures, and data applications.
• Support data management, data transformation, reference data management, and business intelligence initiatives.
• Collaborate with internal and external stakeholders to plan development approaches and implementation timelines.

Required Qualifications

• 10+ years of experience working as a Data Modeler in large, multinational business environments.
• 10+ years of hands-on experience with SQL, at least one programming language, ETL technologies (preferably SSIS), and database platforms.
• 10+ years of hands-on experience in data modeling and metadata management.
• 10+ years of experience designing and building large-scale financial services data warehouses, supported by strong data analysis skills.
• 5+ years of experience working with modern data platforms, including Microsoft Azure offerings.
• 5+ years of hands-on experience in data management, data warehousing, data transformation, metadata management, reference data management, and business intelligence tools.
• 2+ years of experience using PowerDesigner or a related data modeling tool.
• Comprehensive knowledge of Ralph Kimball methodology and data modeling concepts, including logical and physical modeling, Third Normal Form (3NF), Star Schema, and Snowflake Schema.
• Strong problem-solving, debugging, and analytical skills.
• Excellent communication, collaboration, and technical documentation skills.

Technical Skills

• Data Modeling: Conceptual, logical, and physical data modeling, 3NF, Star Schema, Snowflake Schema.
• Data Warehousing: Enterprise data warehouses, financial services data warehouses, operational data stores.
• Data Management: Metadata management, reference data management, data transformation.
• Database & Programming: SQL, relational databases, programming languages.
• ETL: ETL development and integration, preferably Microsoft SSIS.
• Cloud Platforms: Microsoft Azure and modern cloud data platforms.
• Data Modeling Tools: PowerDesigner or equivalent data modeling tools.
• Methodologies: Ralph Kimball dimensional modeling methodology.