Smart IT Frame LLC
Data Modeler / Data Architect (Minneapolis)
Smart IT Frame LLC, Minneapolis, Minnesota, United States, 55400
Role: Data Modeler / Data Architect
Location: Minneapolis, MN
Required Skills & Experience 15+ years of experience as a Data Modeler / Data Architect. Expert-level skills in: Logical, physical, and dimensional data modeling Entity relationship modeling (ERD) Star/Snowflake schemas Normalization/denormalization techniques Strong hands-on experience with tools such as: Erwin, ER/Studio, PowerDesigner, or equivalent Advanced SQL proficiency with ability to analyze, optimize, and validate data structures. Strong understanding of: Data warehousing concepts OLTP vs OLAP systems Master Data Management (MDM) Metadata management
Experience with modern cloud data platforms (one or more): AWS Redshift, Snowflake, Azure Synapse, Google BigQuery, Databricks Experience collaborating with ETL/Data Engineering teams (Informatica, Spark, Glue, DataStage, etc.). Proven experience working in banking/financial services, especially with regulatory and risk data systems. Strong understanding of data governance, data quality frameworks, and data lineage. Excellent communication, stakeholder engagement, and documentation skills.
Required Skills & Experience 15+ years of experience as a Data Modeler / Data Architect. Expert-level skills in: Logical, physical, and dimensional data modeling Entity relationship modeling (ERD) Star/Snowflake schemas Normalization/denormalization techniques Strong hands-on experience with tools such as: Erwin, ER/Studio, PowerDesigner, or equivalent Advanced SQL proficiency with ability to analyze, optimize, and validate data structures. Strong understanding of: Data warehousing concepts OLTP vs OLAP systems Master Data Management (MDM) Metadata management
Experience with modern cloud data platforms (one or more): AWS Redshift, Snowflake, Azure Synapse, Google BigQuery, Databricks Experience collaborating with ETL/Data Engineering teams (Informatica, Spark, Glue, DataStage, etc.). Proven experience working in banking/financial services, especially with regulatory and risk data systems. Strong understanding of data governance, data quality frameworks, and data lineage. Excellent communication, stakeholder engagement, and documentation skills.