Senior Data Modeler

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.