Senior Data Warehouse Data Modeler (Azure, SQL, SSIS)

JPS Tech Solutions

Iowa

On-site

USD 120,000 - 170,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

JPS Tech Solutions Pvt Ltd seeks 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 role emphasizes standards, metadata management, and enterprise data architecture in financial services contexts.

The ideal candidate will have extensive experience with SQL, ETL technologies (preferably SSIS), and modern Microsoft Azure data platforms, supported by strong data analysis

Qualifications

  • 10+ years of experience as a Data Modeler in large, multinational 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 with strong data analysis skills.
  • 5+ years of experience 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 BI tools.
  • 2+ years of experience using PowerDesigner or related data modeling tools.
  • Knowledge of Ralph Kimball methodology and data modeling concepts (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 diagrams.
  • Create and maintain enterprise data models supporting operational and analytical data requirements.
  • Collaborate with policy teams to define and support data vision, operational frameworks, and analytics strategies.
  • Coordinate with architects, developers, DBAs, and analysts to understand project requirements.
  • Develop standards and best practices for data modeling, database design, and implementation.
  • Establish data modeling approaches to support metadata management, ODS, and ETL environments.
  • Create, validate, and test physical data models for business data, applications, structures, and metadata tables.
  • Improve database performance, scalability, and operational efficiency through data modeling.
  • Coordinate data architecture discussions across business programs and technical teams.
  • Optimize data platforms, database structures, and data applications.
  • Support data management, data transformation, reference data management, and BI initiatives.
  • Plan development approaches and implementation timelines with stakeholders.

Skills

Problem-solving
Analytical skills
Communication
Collaboration
Technical documentation
Debugging

Tools

PowerDesigner
SSIS
SQL

Job description

JPS Tech Solutions Pvt Ltd seeks 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 role emphasizes standards, metadata management, and enterprise data architecture in financial services contexts.

The ideal candidate will have extensive experience with SQL, ETL technologies (preferably SSIS), and modern Microsoft Azure data platforms, supported by strong data analysis

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Data Modeler
Data Warehouse Data Modeler

JPS Tech Solutions • Iowa

On-site
USD 120,000 - 170,000
Azure Data Architect: Cloud Data Warehouse & Modeling
Azure Data Architect: Cloud Data Warehouse & Modeling

TECHNOLOGY PARTNERS INC • St. Louis (MO)

On-site
USD 63,000 - 90,000
Senior Data Warehouse & Integration Engineer (Azure/ETL)
Senior Data Warehouse & Integration Engineer (Azure/ETL)

Goods & Services • United States

Remote
MXN 900,000 - 1,350,000
Senior Data Warehouse & ETL Engineer — SQL Server to Azure
Senior Data Warehouse & ETL Engineer — SQL Server to Azure

goodsservices • United States

Remote
USD 120,000 - 160,000
Senior Data Warehouse and Integration Engineer
Senior Data Warehouse and Integration Engineer

goodsservices • United States

Remote
USD 120,000 - 160,000
Senior Data Modeler
Senior Data Modeler

Hydrogen Group • United States

Remote
USD 96,000 - 124,000
Senior Data Modeler - Cloud Data Architecture & DWH
Senior Data Modeler - Cloud Data Architecture & DWH

Quantum Technologies LLC • New York (NY)

On-site
USD 110,000 - 150,000
Data Modeler
Data Modeler

Kavaliro • Denver (CO)

Remote
USD 103,000 - 110,000
Senior Data Architect
Senior Data Architect

TECHNOLOGY PARTNERS INC • St. Louis (MO)

On-site
USD 63,000 - 90,000
Hybrid Data Architects/Engineers
Hybrid Data Architects/Engineers

Quantum Strides LLC • Maryland

On-site
USD 90,000 - 130,000