Senior Data Modeler & Analyst

Kavaliro; Denver (CO); Ibrido; USD 106.000 - 123.000; Part-time

Descrizione del lavoro

Kavaliro is seeking a Senior Data Modeler & Analyst for a long-term contract (remote with travel) to design and govern enterprise data assets that drive reporting, analytics, and modernization initiatives. The role interfaces with business stakeholders, data engineers, architects, and analytics teams to translate requirements into scalable data models, STMs, and technical specs.

The ideal candidate will have 5+ years in data modeling and strong SQL skills, with hands-on experience in data

Competenze

• Bachelor's degree required or equivalent experience in a related field.
• 5+ years in data modeling, data analysis, or data warehousing.
• Experience creating Source-to-Target Mappings (STM) and complex SQL.
• Strong communication and documentation skills; able to work with cross-functional teams.

Mansioni

• Define data entities, relationships, business rules, and transformations.
• Develop and maintain STM documentation to support data integration.
• Create complex SQL queries to profile data and validate requirements.
• Design conceptual, logical, and physical data models using ERwin or similar tools.
• Collaborate with data engineers, architects, and business stakeholders on data solutions.

Conoscenze

Data modeling

SQL development

Analytical thinking

Documentation

Communication

Formazione

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, Mathematics

Strumenti

ERwin

Snowflake

Azure Data Factory (ADF)

Azure SQL Managed Instance (SQL MI)

Denodo

DBT

Databricks

Descrizione del lavoro

Title:

Senior Data Modeler & Analyst

Department:

Business Technology - Data Technology

Location:

Remote (with up to 10% travel)

Contract Length:

6 Months with Potential for Conversion to Full-Time 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

• Preferred ERwin data modeling tools.
• Snowflake.
• Azure Data Factory (ADF).
• Azure SQL Managed Instance (SQL MI).
• Denodo.
• Metadata management and data governance tools.
• Agile software development environments.
• Financial services, lending, agricultural finance, or other regulated industries.
• Preferred Certifications Snowflake Certification Microsoft Azure Data Certifications DAMA/CDMP or equivalent data management certification

Pay

Pay: $77/ Hourly

Equal Employment Opportunities

Kavaliro provides Equal Employment Opportunities to all employees and applicants. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Kavaliro is committed to the full inclusion of all qualified individuals. In keeping with our commitment, Kavaliro will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment.