Data Architect

About This Role

This role involves building an enterprise data warehouse initially on-premises with SQL Server, transitioning to a hybrid cloud architecture. The Data Architect will lead the overall data strategy, coordinate data team efforts, ensure robust data governance, and guide teams to deliver scalable data solutions.

Responsibilities

• Develop and implement an enterprise data architecture strategy, ensuring alignment with business objectives
• Design, build, and maintain PowerBI semantic models, datamarts, and data integration processes using Cloud & SQL Server on-prem solutions
• Collaborate with stakeholders to gather and document data requirements, ensuring the architecture meets current and future business needs
• Work with the Data Governance team to design and implement data governance and data quality best practices for the EDW to ensure the integrity and reliability of data
• Design and help develop complex ETL processes to support ETL/ELT from various data sources
• Create and maintain technical documentation including data models, data flow diagrams, and data integration specifications
• Provide guidance and support to development teams on data-related projects and initiatives
• Monitor and optimize the performance of the data architecture, identifying and resolving issues as needed
• Stay informed of industry best practices and emerging technologies in data architecture, quality, and analytics
• Provide guidance to leadership and stakeholders on data-related tools and processes

Requirements

• 5+ years of experience in data architecture with a strong focus on building enterprise data warehouses and data integration
• Expert experience in SQL Server on-prem
• Experience designing PowerBI semantic models for multi-report support
• Strong understanding of data modeling, data governance, and data quality best practices
• Strong organizational skills and attention to detail
• Ability to work independently and as part of a team in a fast-paced environment
• Proven ability to manage multiple projects and priorities simultaneously

Qualifications

• Bachelor’s Degree in Computer/Data Science, Information Systems, or a related field, or equivalent work experience
• 5+ years of experience in data architecture, with a strong focus on building enterprise data warehouses and data integration

Nice to Have

• 7+ years of experience in data architecture with a strong focus on building enterprise data warehouses and data integration
• Experience designing columnar and graph databases
• Experience with Microsoft’s Power Platform
• Experience with Epic's EHR analytics infrastructure including Clarity and Caboodle databases
• Experience in the healthcare industry and familiarity with healthcare data
• Experience with additional data integration and visualization tools
• Experience with cloud-based data warehousing solutions
• Experience with agile project management methodologies
• Certification in Microsoft Fabric or Azure
• Advanced proficiency in SQL, Python, complex queries, and stored procedures
• Expert knowledge of programming languages such as Python and R
• Proficient in Microsoft Fabric or Azure

Skills

* Required skills