Data Vault

Concord USA•Open to multiple locations in the US, MN

1d•Hybrid

About The Position

We are looking for a Senior Data Architect/Modeler to support a large-scale data modernization engagement with a leading national health and benefits organization. In this role, you will be responsible for the successful delivery of data modernization projects within a complex, enterprise-scale environment, with Snowflake as the primary platform. This is a senior, client-facing consulting position requiring a skilled, hands-on practitioner with deep experience in data modeling and modern data architecture. You will be expected to work directly with client stakeholders, lead technical workstreams, and deliver with minimal supervision.

Requirements

10+ years in data management, including 5+ years as a Data Architect delivering large-scale modernization projects.
Proven experience leading complex Snowflake modernization engagements across diverse industries; Data Vault expertise highly preferred.
Experience analyzing legacy data warehouse implementations (SAP HANA) and translating gaps into future-state Snowflake data models.
Expert-level knowledge of SAP data including ECC, S/4 HANA, APO, and IBP.
Functional data architecture experience across Finance, Supply Chain, Quality, and Manufacturing domains.
Hands-on expertise across data architecture patterns: data warehouse, data mesh, data vault, and data lakehouse.
Proficient in developing conceptual, logical, and physical data models and ERDs for both operational and analytical stores.
Advanced SQL and Python skills for data ingestion, querying, extraction, and transformation
Experience with Snowflake and Databricks; solid understanding of ELT/ETL, APIs, event-driven, and streaming patterns.
Experienced with modeling tools: SQL DBM, Lucidchart, ER/Studio.
Skilled in generating source-to-target mapping documents to support pipeline implementation.
Experience implementing data governance frameworks and deploying data catalog solutions.
Ability to translate complex, ambiguous business requirements into scalable data models.
Strong client-facing communication skills with both technical and business audiences.
Able to lead and mentor a team of data modelers and mapping analysts.
Comfortable managing multiple priorities in fast-moving, consulting environments.
Collaborative cross-functional partner to Data Analysts, BI, and Data Engineering teams.
Must be authorized to work legally in the US without sponsorship, now or in the future.

Responsibilities

Serve as a data architect and data modeling lead on client projects, driving the successful execution of comprehensive data management strategies.
Develop and lead data architecture strategies and roadmaps to align with client business objectives and deliver measurable outcomes.
Design conceptual, logical and physical data models adhering to industry standards and to serve business requirements.
Create dimensional models geared towards enterprise reporting and 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.
Develop and enforce robust data standards, policies, best practices, and procedures to uphold data quality, integrity, and security.
Lead the assessment, selection, and adoption of cutting-edge data management technologies to build scalable and efficient end-to-end solutions tailored to client needs.
Design and implement high-performance solutions leveraging cloud platforms such as Snowflake and Databricks, ensuring scalability and efficiency.
Define and execute comprehensive data governance strategies, ensuring security, compliance, and data discoverability across the organization.
Provide technical leadership, guidance, and mentorship to team members, fostering professional growth and enhancing team capabilities.

Benefits

Health, Dental, and Vision Insurance: Comprehensive coverage to support your overall well-being.
Employer Contributions to Health Savings Accounts (HSA): For employees enrolled in High Deductible Health Plans, Concord contributes toward your HSA.
Flexible Spending Accounts (FSA): Options for healthcare and dependent care expenses, plus a Lifestyle Spending Account (LSA) for wellness and personal development.
Disability Insurance: Short-term (up to 12 weeks) and long-term coverage, fully paid by the employer.
Life and AD&D Insurance: Employer-provided coverage of with options for additional voluntary coverage.
Employee Assistance Program (EAP): Support for legal, financial, and personal challenges.
401(k) Retirement Savings: 1% employer match.
Career Growth Opportunities: Pathways for advancement and skill development.
Team Engagement Activities: Regular team-building events and company-sponsored activities to foster collaboration and connection.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume