Data Modeler

Kavaliro; Denver (CO); Remote; USD 103,000 - 110,000; Full time

Job summary

Kavaliro is seeking a Senior Data Modeler for a long-term contract with potential conversion. The role designs, documents, and analyzes enterprise data assets to support reporting, analytics, and modernization initiatives.

You will act as a liaison between business stakeholders, data engineers, architects, and analytics teams to translate requirements into scalable models and STMs. Ideal candidates will craft data solutions using Snowflake, Azure data technologies, and data warehousing/ETL/ELT

Qualifications

• Bachelor's degree or equivalent with experience in data modeling, analytics, and data warehousing.

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 to support data integration, reporting, and analytics initiatives.
• Create complex SQL queries to profile data, validate requirements, troubleshoot issues, and support data quality efforts.
• Design and maintain conceptual, logical, and physical data models using ERwin or similar enterprise data modeling tools.
• Partner with data product owners, business stakeholders, data engineers, architects, and project teams to ensure data solutions align with business needs and enterprise standards.
• Support the design and implementation of data solutions utilizing Snowflake, Azure Data Factory (ADF), Azure SQL Managed Instance (SQL MI), Denodo, or similar enterprise technologies such as DBT and Databricks.
• Maintain data documentation, metadata, and modeling artifacts to ensure traceability, compliance, and knowledge sharing across the organization.
• Participate in solution reviews, project planning, testing, and release activities.
• Support ongoing data modernization initiatives by evaluating current-state processes and recommending scalable future-state solutions.
• Identify opportunities to improve data quality, consistency, accessibility, and operational efficiency through effective data design.

Skills

Data modeling

Advanced SQL

STM

Snowflake

Azure Data Factory

Azure SQL Managed Instance

Denodo

DBT

Databricks

ETL/ELT

Data warehousing

Education

Bachelor's degree

Tools

ERwin

Snowflake

Azure Data Factory

Denodo

DBT

Databricks

Azure SQL Managed Instance

Job description

Department: Business Technology - Data Technology

Location: Remote (with up to 10% travel)

Contract Length: 6 Months with Potential for Conversion to Full-Time

Pay Rate: $75-$80/hr.

Travel: Up to 10%

Top Things Needed

• We're seeking a hands-on data professional who can bridge business and technology teams while supporting enterprise-scale data initiatives. The successful candidate will have deep expertise in data modeling, advanced SQL, source-to-target mapping, and modern cloud data platforms. Experience working with complex or unstructured data within Snowflake and Azure environments is highly valued.
• Please submit candidates with relevant experience in enterprise data modeling, advanced SQL, Snowflake, Source-to-Target Mapping (STM), Azure data technologies, and data warehousing/ETL/ELT environments.
• Remote position
• Travel up to 10%
• Opportunity to convert to a full-time employee following the initial contract period
• Please submit candidates with relevant experience in enterprise data modeling, advanced SQL, Snowflake, Source-to-Target Mapping (STM), Azure data technologies, and data warehousing/ETL/ELT environments.

Position Summary

Our client is seeking a Senior Data Modeler for an exciting long-term contract (with possibilities to convert). The Senior Data Modeler & Analyst is responsible for designing, documenting, and analyzing enterprise data assets that support reporting, analytics, and data modernization initiatives. This individual serves as a liaison between business stakeholders, data engineers, architects, and analytics teams to translate business requirements into scalable data models, source-to-target mappings (STMs), and technical specifications.

The role supports the delivery of trusted, well-governed data solutions through data analysis, profiling, and modeling activities across multiple data platforms. The ideal candidate will exercise independent judgment in evaluating data structures, identifying data quality concerns, and recommending solutions that align with business objectives and enterprise architecture standards.

DUTIES

• 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 to support data integration, reporting, and analytics initiatives.
• Create complex SQL queries to profile data, validate requirements, troubleshoot issues, and support data quality efforts.
• Design and maintain conceptual, logical, and physical data models using ERwin or similar enterprise data modeling tools.
• Partner with data product owners, business stakeholders, data engineers, architects, and project teams to ensure data solutions align with business needs and enterprise standards.
• Support the design and implementation of data solutions utilizing Snowflake, Azure Data Factory (ADF), Azure SQL Managed Instance (SQL MI), Denodo, or similar enterprise technologies such as DBT and Databricks.
• Maintain data documentation, metadata, and modeling artifacts to ensure traceability, compliance, and knowledge sharing across the organization.
• Participate in solution reviews, project planning, testing, and release activities.
• Support ongoing data modernization initiatives by evaluating current-state processes and recommending scalable future-state solutions.
• Identify opportunities to improve data quality, consistency, accessibility, and operational efficiency through effective data design.

REQUIREMENTS

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics, or a related field preferred - equivalent combination of education and relevant experience may be considered.
• 5+ years of experience in data modeling, data analysis, business analysis, data warehousing, or related disciplines.
• Experience developing conceptual, logical, and physical data models.
• Experience creating and maintaining Source-to-Target Mapping (STM) documentation.
• Experience writing and optimizing complex SQL queries.
• Experience working with enterprise data platforms and data integration solutions.
• Advanced SQL development and troubleshooting.
• Enterprise data modeling principles, methodologies, and best practices.
• Relational databases, dimensional modeling, normalization, and data warehousing concepts.
• Data integration, ETL/ELT processes, and data lifecycle management.
• Source-to-target mapping and data lineage concepts.
• Strong analytical and critical-thinking skills with attention to detail.
• Ability to translate complex business requirements into technical specifications.
• Strong communication and documentation skills.
• Ability to work independently and collaboratively across business and technical teams.

Preferred

• Snowflake.
• Azure SQL Managed Instance (SQL MI).
• Metadata management hard data.
• Financial services, lending, agricultural finance or other regulated industries.

Preferred Certifications

• Snowflake Certification
• DAMA/CDMP certification