Data Architect - Data Vault

About us

Concord isn't your typical consulting firm; we're an execution-focused company passionate about delivering results. Our mission is to help clients enhance customer experiences, optimize operations, and revolutionize product offerings through seamless integration, optimization, and activation of technology and data.

We are looking for a Data Architect with Data Vault experience to join our expanding Data Architecture practice. In this role, you will be responsible for the successful delivery of data management projects, and contribute to practice growth by providing technical. You are expected to be a skilled, hands-on practitioner in delivering data modernization projects.

What you ll be doing

• Applies industry leading Data Vault 2.0 data modeling principles, standards, guidelines and concepts in a Snowflake environment.
• Produces conceptual, logical, and physical data models that meet business requirements.
• Create dimensional models geared towards self-service business consumption.
• Works closely with data owners, stewards, and SMEs to understand business data and reporting requirements and terminology.
• Works closely with technical resources to understand architecture principles, data domains, and underlying data sources.
• Captures data mapping and transformation rules needed to move data from existing sources to future targets.
• Uses data profiling and/or additional research to understand source data to mitigate data quality concerns.
• Oversees implementation of data pipelines to migrate data as needed and validate/document success.

What experience would we like to see?

• 5 years of expertise in data management, including 3 years as a Data Architect, delivering innovative solutions and driving transformative initiatives.
• Proven track record of delivering data products using a Data Vault 2.0 methodology in a Snowflake architecture.
• Experience in developing detailed data models and ERDs including conceptual, logical and physical data models enabling robust data structuring and optimization using Data Vault 2.0 techniques.
• Skilled in leveraging industry-standard tools such as ER/Studio and Vaultspeed for designing scalable data models.
• Expertise in SQL and Python, with proven capabilities in data ingestion, querying, extraction, and transformation.
• Hands-on experience with Snowflake tasks, streams and stored procedures that are used to architect and implement high-performance solutions.
• Solid understanding of modern data and integration patterns, including APIs, event-driven architectures, streaming, and ELT/ETL workflows.
• Ability to problem-solve in dynamic, evolving environments and provide consultative insights during high-pressure conversations.
• Strong communication skills, both verbal and written, with the ability to engage technical and business-oriented audiences effectively.
• Competence in prioritizing and managing multiple competing responsibilities while ensuring high-quality outcomes.

What we offer

• Comprehensive health, dental, and vision insurance.
• Employer contributions to Health Savings Accounts (HSA).
• Flexible Spending Accounts (FSA).
• Lifestyle Spending Account (LSA).
• Short- and long-term disability coverage, fully paid by the employer.
• Life and AD&D insurance with optional additional coverage.
• Paid Time Off (PTO) and paid holidays.
• Employee Assistance Program (EAP) for personal and professional support.
• Opportunities for advancement and career growth.
• Team-building events and company-sponsored activities.

Additional information

• Employment type: Long-term full-time role.
• Location: Open to remote in the US. Prefer candidates located in Minneapolis or Kansas City. Occasionally visiting the offices at Minneapolis, Kansas City or clients' locations might be required.
• Requirements: must be authorized to work legally in the US without sponsorship, now or in the future.

Consideration will be given to qualified candidates with varying levels of experience, with compensation commensurate with experience.

***

More than just a consulting firm, Concord is an execution company helping clients enhance customer experience, optimize operations, and differentiate product offerings. From digital transformation and legacy modernization to domain-driven design, we deliver real solutions for the problems our clients face. Join one of the fastest growing consulting firms in the Midwest!

Our core capabilities work together to help companies untangle their toughest business and technology challenges: Business Strategy & Alignment, Digital & User Experience, Cloud Applications & Integration, Data Solutions & Analytics, Quality Engineering, and Information Security.

***

Powered by JazzHR

7kYb518ydQ