Senior Data Architect
- Excelon Solutions
5 Days Ago
NA
W2, 1099
Remote
7-10 Years
Required Skills: SQL Server, T-SQL, Dimensional Modeling, Star Schema, Snowflake Schema , Azure Synapse Analytics
Job Description
Must Have:
- 7+ years of enterprise Data Architecture & Data Modeling experience
- Strong Conceptual, Logical & Physical Data Modeling
- Expert Dimensional Modeling, Star/Snowflake Schema & Data Warehouse Architecture
- Strong SQL Server & T-SQL experience
- Experience with Power BI Semantic Models or equivalent BI technologies
- Strong ETL/ELT, data integration, metadata, lineage, data quality & governance experience
- Experience with Azure Synapse Analytics / Microsoft Fabric / Azure Data Platform
- Enterprise reporting, analytics and semantic model architecture experience
- Strong architecture, documentation, communication and mentoring skills
Responsibilities:
- Design and maintain enterprise data models, domains, canonical models and modeling standards.
- Architect scalable data solutions for BI, reporting, analytics and data warehousing.
- Evaluate existing data architectures and recommend improvements.
- Define ETL/ELT and enterprise data integration patterns.
- Establish data governance, metadata management, lineage and documentation standards.
- Partner with BI, Data Platform, Enterprise Architecture, application and DBA teams.
- Mentor data/BI engineers and support analytics modernization initiatives.
