Senior Data Modeler

Hydrogen Group; United States; Remote; USD 96,000 - 124,000; Full time

Job summary

Hydrogen Group is seeking a Senior Data Modeler & Analyst for a remote role (10% travel). This 6‑month contract may convert, paying $70–$90 per hour.

You will design, document, and analyze complex data structures, create STM documentation, and translate business requirements into scalable data models and technical specs. The position collaborates with data engineers, architects, and analytics teams across Snowflake, ADF, SQL MI, Denodo, DBT, and Databricks to deliver well-governed data

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field preferred.
• 5+ years of experience in data modeling, data analysis, business analysis, data warehousing, or a related discipline.
• Experience developing conceptual, logical, and physical data models.
• Experience creating and maintaining Source-to-Target Mapping (STM) documentation.
• Strong experience writing, optimizing, and troubleshooting complex SQL queries.
• Experience with enterprise data platforms, relational databases, and data integration solutions.

Responsibilities

• Analyze business requirements, source systems, and data structures to define data entities, relationships, business rules, and transformation requirements.
• Develop and maintain Source-to-Target Mapping (STM) documentation for data integration, reporting, and analytics initiatives.
• Write and optimize complex SQL queries to profile data, validate requirements, troubleshoot issues, and support data quality initiatives.
• Design and maintain conceptual, logical, and physical data models using ERwin or similar enterprise modeling tools.
• Collaborate with business stakeholders, data product owners, engineers, architects, and project teams to align data solutions with business objectives and enterprise standards.
• Support data solution development across Snowflake, Azure Data Factory (ADF), Azure SQL Managed Instance (SQL MI), Denodo, and similar technologies, including DBT and Databricks.
• Maintain data documentation, metadata, and modeling artifacts to support data lineage, governance, compliance, and knowledge sharing.
• Participate in solution reviews, project planning, testing, and release activities.
• Evaluate existing data processes and recommend scalable solutions to support ongoing modernization initiatives.
• Identify opportunities to improve data quality, consistency, accessibility, and operational efficiency.

Skills

Advanced SQL development

Data modeling

Data warehousing

ETL/ELT

Data governance

Education

Bachelor's degree in a related field

Tools

ERwin

Snowflake

Azure Data Factory

Azure SQL MI

Denodo

DBT/Databricks

Job description

Senior Data Modeler & Analyst
Remote (with 10% travel required)
Duration: initial 6 month contract (potential for conversion)
Pay: $70-90/hr
We are seeking a Senior Data Modeler & Analyst to support enterprise data management, analytics, reporting, and data modernization initiatives. This individual will be responsible for designing, documenting, and analyzing complex data structures while translating business requirements into scalable data models, source-to-target mappings (STMs), and technical specifications.
The role will work closely with business stakeholders, data engineers, architects, and analytics teams to deliver reliable, well-governed data solutions across multiple platforms. The ideal candidate has strong expertise in data modeling, advanced SQL, data integration, and modern cloud data technologies.

Key Responsibilities

• Analyze business requirements, source systems, and data structures to define data entities, relationships, business rules, and transformation requirements.
• Develop and maintain Source-to-Target Mapping (STM) documentation for data integration, reporting, and analytics initiatives.
• Write and optimize complex SQL queries to profile data, validate requirements, troubleshoot issues, and support data quality initiatives.
• Design and maintain conceptual, logical, and physical data models using ERwin or similar enterprise modeling tools.
• Collaborate with business stakeholders, data product owners, engineers, architects, and project teams to align data solutions with business objectives and enterprise standards.
• Support data solution development across Snowflake, Azure Data Factory (ADF), Azure SQL Managed Instance (SQL MI), Denodo, and similar technologies, including DBT and Databricks.
• Maintain data documentation, metadata, and modeling artifacts to support data lineage, governance, compliance, and knowledge sharing.
• Participate in solution reviews, project planning, testing, and release activities.
• Evaluate existing data processes and recommend scalable solutions to support ongoing modernization initiatives.
• Identify opportunities to improve data quality, consistency, accessibility, and operational efficiency.

Required Qualifications

Education

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field preferred.
• Equivalent education and relevant professional experience may be considered.

Experience

• 5+ years of experience in data modeling, data analysis, business analysis, data warehousing, or a related discipline.
• Experience developing conceptual, logical, and physical data models.
• Experience creating and maintaining Source-to-Target Mapping (STM) documentation.
• Strong experience writing, optimizing, and troubleshooting complex SQL queries.
• Experience with enterprise data platforms, relational databases, and data integration solutions.

Technical Skills

• Advanced SQL development and troubleshooting.
• Enterprise data modeling methodologies and best practices.
• Relational databases, dimensional modeling, normalization, and data warehousing.
• Data integration, ETL/ELT processes, and data lifecycle management.
• Source-to-target mapping and data lineage.
• Ability to translate complex business requirements into technical specifications.
• Strong analytical, critical-thinking, and problem-solving skills.
• Excellent communication and technical documentation skills.
• Ability to work independently and collaborate across business and technical teams.

Preferred Qualifications

• Experience with ERwin or similar data modeling tools.
• Snowflake.
• Azure Data Factory (ADF).
• Azure SQL Managed Instance (SQL MI).
• Denodo.
• DBT or Databricks.
• Metadata management and data governance tools.
• Experience working in Agile environments.
• Background in financial services, lending, agricultural finance, or other regulated industries.

Preferred Certifications

• Snowflake Certification.
• Microsoft Azure Data Certifications.
• DAMA/CDMP or equivalent data management certification.

...