Enterprise Data Architect

Consumer Cellular - Scottsdale, AZ

Full-time - Mid Level

Scottsdale, AZ

Professional, Scientific, and Technical Services

About the position

The Enterprise Data Architect will lead the design, implementation, and optimization of the organization's Enterprise Data Warehouse (EDW) solutions. This role is crucial for ensuring that data architecture effectively supports strategic objectives and enables advanced data analytics. The architect will collaborate with cross-functional teams to build a scalable data architecture that drives business insights and data-driven decision-making.

Responsibilities

• Lead the architecture and design of the Enterprise Data Warehouse (EDW) to support data storage, processing, and analytical needs.
• Develop and implement data warehouse models, including dimensional modeling, star schemas, and snowflake schemas.
• Optimize data warehouse performance and scalability to handle large volumes of data and complex queries.
• Design and manage ETL (Extract, Transform, Load) processes for seamless data integration from various source systems into the EDW.
• Oversee data ingestion, transformation, and loading processes to ensure data accuracy, consistency, and timeliness.
• Implement data governance frameworks and best practices to maintain data quality, integrity, and security within the EDW.
• Develop and enforce data standards, policies, and procedures for compliance with regulatory requirements.
• Work closely with business stakeholders, IT teams, and data analysts to understand data requirements and translate them into effective data warehouse solutions.
• Provide expert guidance on data warehouse architecture and integration strategies to support business intelligence and analytics initiatives.
• Continuously assess and enhance the EDW architecture to incorporate emerging technologies and improve performance.
• Create and maintain comprehensive documentation for data warehouse architecture, data models, ETL processes, and data governance policies.
• Provide regular updates and reports on the status and performance of the EDW to senior management and other key stakeholders.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field; Master's degree preferred.
• 5-8 years of experience as a Data Architect with a strong focus on Enterprise Data Warehousing (EDW) design and implementation.
• Extensive experience with data warehouse technologies and tools, such as Microsoft SQL Server, Oracle, Snowflake, Amazon Redshift, Google BigQuery.
• Proficiency in ETL tools and techniques, with hands-on experience in designing and optimizing ETL workflows.
• Strong understanding of data modeling, data integration, and data quality best practices.
• Excellent problem-solving skills and the ability to develop innovative solutions for complex data challenges.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with both technical and non-technical stakeholders.