Senior Data Architect​/Modeler - Snowflake​/Data Vault

Location and Employment

Location: Preferably local to Minneapolis, MN. Occasional need to travel to clientofficesacross the US.

Employment Type: Open to W-2 Salary, W-2 Hourly, or C2C.

Compensation: $80/hr W-2 Hourly, $150,000-$165,000 Salary, or $100/hr on C2C. Compensation will be determined based on relevant experience, skills, and overall qualifications.

Requirements: Must be authorized to work legally in the US without sponsorship, now or in the future.

Concord isn't your typical consulting firm; we are an execution company with a passion for making things happen. Our mission is to help clients enhance customer experiences, optimize operations, and revolutionize their product offerings through seamless integration, optimization, and activation of technology and data.

We are purpose-built, merging the industry’s top specialty companies to amplify our Innovation Capabilities in analytics & AI, data management & engineering, UX and digital experience, and technical platform integration, automation & security engineering.

We are looking for a Senior Data Architect/Modeler to join our expanding Data Management practice. In this role, you will be responsible for the successful delivery of large-scale data modernization projects. You are expected to be a skilled, hands‑on practitioner and data modeler in delivering data modernization projects on Snowflake and/or Databricks/Fabric, specifically involving SAP data.

Emphasizing that this is a senior, client‑facing role with strong personal presence, client‑facing skills, and the ability to work with minimal supervision.

• 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.

• Over 10 years of expertise in data management, including 5+ years as a Data Architect, delivering innovative solutions and driving transformative initiatives.
• Proven track record of leading and delivering complex, large‑scale data modernization projects in Snowflake across diverse industries, and Data Vault expertise is a must.
• Comprehensive knowledge and hands‑on experience with various data architecture patterns, including data warehouse, data mesh, data vault, and data lakehouse, to address modern analytics needs.
• Experience in data analysis and profiling of source data independently to research and document data scenarios.
• Experience in analyzing legacy data warehouse implementations in HANA, identify gaps and provide…