Be an early applicantLess than 25 applicants

Company

Concord · 9 hours ago

Data Architect - Minneapolis or Kansas City

United States

Full-time

Remote

Senior Level, Lead/Staff

10+ years exp

Maximize your interview chances

Software

Work & Life Balance

No H1B

U.S. Citizen Only

Insider Connection @Concord

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Create and maintain Entity Relationship Diagrams (ERDs) using tools such as Erwin, SQL DBM, and Lucid.

Deliver silver and gold layer data models to refine raw data into clean, structured, and aggregated layers for analysis and reporting.

Develop conceptual data models that provide high-level representations of the data warehouse structure.

Translate business requirements into detailed logical data models, defining entities, relationships, and attributes.

Design physical data models, specifying how data will be stored in databases (tables, columns, indexes, constraints).

Establish and enforce data modeling standards, best practices, and procedures for enterprise-level data models.

Create source-to-target data mapping documents to define data flow and transformation rules between systems and models.

Conduct data analysis and data mining to uncover insights, patterns, and trends in large datasets.

Utilize SQL to query databases, optimize queries, and support data extraction and transformation processes.

Manage and leverage metadata management and data modeling tools, including Erwin, ER Studio, and SQL DBM.

Collaborate with teams working on data warehouses, data lakes, lake houses, and enterprise cloud platforms such as Databricks and Snowflake.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ModelingData ArchitectureSQLDatabricksSnowflakeErwinSQL DBMLucidER StudioData LakesData AnalysisData MiningCloud Data PlatformsIT Consulting

Required

10+ years in data-related roles.

5+ years as a Data Architect.

Proven experience in data modeling, data architecture, and data lakehouse design.

Proficiency with data modeling tools (e.g., Erwin, SQL DBM, Lucid, ER Studio).

Strong SQL skills for data querying, extraction, and transformation.

Must have working experience with cloud data platforms (i.e., Databricks, Azure, Snowflake).

Ability to translate complex business requirements into structured data models.

Excellent communication skills and attention to detail.

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

Preferred

Experience in IT consulting is a plus.

Company

Concord

Concord is a technology consultancy blending style with substance to create flawless customer experiences backed by powerful analytics and underwritten by strong data foundations.

Founded in 1999

Hopkins, Minnesota, USA

1,001-5,000 employees