Enterprise Data Architect

This range is provided by Insight Global. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

$/yr - $/yr

Enterprise Data Warehouse Architect and Development Lead

Remote within NC, onsite once a month in Raleigh, NC

Permanent, W-2 opportunity

This position leads the technical design, development, implementation, enhancement, and operation of the University’s centralized repository of enterprise data assets. The position is responsible for designing and maintaining an efficient and scalable enterprise data warehouse solution that enables business intelligence and analytics solutions that provide actionable data to campus. The Data Warehouse Architect partners with various stakeholders, business leaders, enterprise application developers, data analysts, and BI content developers to ensure that the data warehouse provides the foundation needed for data-driven decision-making across the University.

Hybrid remote and on-site work location options are available.

• Design, implement, and manage a data warehouse architecture as a foundation for analytics development, working with the analytics platform administrators and analytics development teams to optimize structures for ease of use, flexibility, and scalability
• Collaborate with business SMEs, data analysts, data scientists, and BI content developers to understand core business requirements and translate them into data warehouse design technical specifications
• Design and lead development of the data warehouse architecture, including data models, data marts, ETL processes, data lake, integrations and pipelines, etc. The architecture should be scalable to meet new needs as they arise and components should be reusable, with a focus on single source of truth (SSOT) outcomes
• Create and maintain thorough documentation of the warehouse and data mart architecture with conceptual/physical models and ERDs
• Optimize data models and warehouse architecture for performance and scalability, working in close collaboration with peers in EAS, including database administrators and enterprise system developers and administrators
• Maintain a thorough knowledge of toolsets and technologies that are available for data warehousing and processing, and work with management to create a technology roadmap and strategy to best meet the University’s future needs

• Lead and manage the software development lifecycle related to the data warehouse and create standard operating procedures
• Guide and review the development work of data engineers to confirm quality of deliverables, alignment with warehouse design principles, and completion of technical documentation
• Work with OIT and business leadership to develop and maintain a coherent data strategy related to the warehouse, ensuring the team’s alignment with strategic initiatives and priorities
• Ensure compliance with data management processes in collaboration with data governance teams
• Promote positive customer relationships to ensure customer satisfaction
• Establish a positive and proactive relationship by demonstrating ownership and knowledge of customer business processes and issues
• Maintain a deep understanding of software development project management methodologies and tools and a thorough understanding of project expectations and procedures, particularly within an agile framework
• As the most senior technical member of a team, this position provides technical and functional guidance and support to other members of the team and provides functional and/or technical decision-making with broad and institution-wide impacts that affect assigned systems, students, faculty and staff

• Lead or participate in cross-domain teams within and outside of EAS consisting of various technical analysts and developers for integrated data sources to understand and properly assimilate the data via ETL processes into data warehouse models. Work with these teams to understand the structure and meaning of source data, assimilating it into…