Senior Data Modeler & Analyst – Remote (Contract)

Hydrogen Group; United States; Remoto; USD 96.000 - 124.000; Tempo pieno

Descrizione del lavoro

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

Competenze

• 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.

Mansioni

• 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.

Conoscenze

Advanced SQL development

Data modeling

Data warehousing

ETL/ELT

Data governance

Formazione

Bachelor's degree in a related field

Strumenti

ERwin

Snowflake

Azure Data Factory

Azure SQL MI

Denodo

DBT/Databricks

Descrizione del lavoro

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