Element6's client is looking for a Data Architect to join their team in Madison, WI.
Responsibilities:
Demonstrate competence, experience, knowledge, understanding, and advocacy of data management concepts, data warehousing, data integration, BI, and analytics.
Partner with internal business units to define information requirements and translate them into appropriate data solutions
Collaborate with IT and business partners to lead data discovery, profiling, analysis, and quality assessments to obtain clear information requirements.
Develop and validate source-to-target mappings and transformation logic required to support business needs. Understand the importance of capturing data lineage.
Mentor other DAE's while helping them to create solid data solutions.
Provide technical leadership, mentoring and awareness to IT and business team members.
Preferred Experience:
Database: SQL Server, Azure SQL Database, Azure Data Lake, Azure Synapse
Data Query tools: SQL, T-SQL, Azure Data Studio
Data Modeling: ER/Studio Data Architect, 3NF and dimensional modeling
Data Warehousing concepts: Inmon, Kimball, Data Lake, Data Lakehouse
Data Management and Quality: data mapping, data profiling, data catalog, relational data modeling, master data management, data governance
Data Formats: csv, pipe-delimited, JSON, XML, Parquet
Data Integration concepts and strategies: EII, ETL, EL-T, SOA, and EAI
Business Intelligence tools: Alteryx, Microsoft tools (SQL Server Management Studio, SSRS, SSAS, SSIS, Power Pivot, Power Query, PowerBI)
General experience, leadership, and delivery in the cloud space