The Data Architect leads the strategic design, implementation, and governance of enterprise data systems. This role integrates responsibilities across data architecture, master data management (MDM), metadata management, and analytics to ensure scalable, secure, and high-quality data environments.
Requirements
- Dimensional modeling, metadata management, and data warehousing principles.
- ETL development using Azure Data Factory, Synapse, SSIS.
- Advanced Power BI skills including DAX and dashboard/report development.
- Familiarity with data lake, lakehouse, and metadata-driven design.
- Experience with platforms such as SAP, Oracle, Google Cloud, NetSuite.
- Moderate to advanced SQL/NoSQL proficiency.
- Deep understanding of MDM, metadata, reference data, and data quality initiatives.
Responsibilities
- Design and implement scalable, secure, and high-performance data architectures supporting analytics and reporting.
- Architect and manage the Enterprise Data Warehouse (EDW), including data lineage, dimensional modeling (e.g., Kimball), and metadata management.
- Develop and maintain data pipelines using Azure Data Factory, Synapse, SSIS, and other modern tools.
- Integrate external and internal data sources to support advanced analytics and decision-making.
- Lead the design and development of Power BI dashboards and reports.
- Design and implement secure data access infrastructure aligned with privacy regulations (e.g., GDPR, HIPAA).
- Monitor and enforce data quality rules and compliance metrics.
Other
- Define and lead the enterprise-wide strategy for Master Data Management and Data Architecture.
- Develop and operate governance models balancing structure, agility, and business needs.
- Align data architecture with enterprise goals such as operational efficiency, regulatory compliance, and customer-facing analytics.
- Establish and enforce data governance frameworks, metadata management practices, and architectural standards.
- Strong leadership and mentoring capabilities.
