Data Architect

Posting number: 252600275

Department: Information Technology

Job classification: Data Architect

Posting type: Open

Categories: IT and Computers

Summary

WORKING FOR THE CITY OF MCKINNEY
Working for the City of McKinney is more than a job.  It is an opportunity to make a meaningful difference in the lives of others.  It is also an opportunity to have a hand in the development of one of the fastest growing communities in the nation.  Proudly recognized on the Top Workplaces USA list by USA TODAY, our team is dedicated to making McKinney one of the best places to work, live, and raise a family. That’s why we exist. Join us and start making a difference today.

OUR CORE VALUES
City of McKinney employees work hard and at a very fast pace.   However, we also look after and support one another.  All of us are guided by four employee-inspired values – Respect, Integrity, Service, and Excellence (RISE).  We are also supported by servant-based leaders who foster and support a healthy, family-oriented culture.  All new employees are expected to embrace and live by our core values and commit to helping us sustain our exceptional work environment as a high-performance organization (HPO).

SUMMARY OF POSITION
The Data Architect is a senior IT professional responsible for designing, developing, and managing the organization’s data infrastructure to ensure efficient, secure, and scalable data storage, processing, and retrieval. This role involves creating data models, defining data architecture frameworks, and aligning data systems with business objectives to support decision-making, analytics, and compliance. The Data Architect collaborates with cross-functional teams, including data engineers, analysts, and business stakeholders, to translate business requirements into technical solutions, ensuring data integrity, accessibility, and security. This position will be essential in contributing to business innovation and operational efficiency.

Examples of duties

GENERAL EXPECTATIONS FOR ALL EMPLOYEES 
In order for us to continue to achieve our primary function of making McKinney a better place to live, work, and raise a family, we hold these expectations for all employees. 

• Learn and demonstrate an understanding of how team, department, and City goals are interconnected.
• Contribute to a positive work culture.
• Maintain regular and reliable attendance.
• Ability to assess his/her work performance or the work performance of the team.
• Contribute to the development of others and/or the working unit or overall organization.
• Ability and willingness to work as part of a team, to demonstrate team skills, and to perform a fair share of team responsibilities.
• Ability to continuously learn and develop through a mix of internal and external training opportunities, and if applicable, encourage subordinates to do the same.

ESSENTIAL DUTIES AND RESPONSIBILITIES 

• Develops and maintains conceptual, logical, and physical data models to support business needs, ensuring scalability and performance.
• Creates and implements database solutions, data warehouses, and data lakes to store, retrieve, and manage City information.
• Ensures data quality and consistency for reliable decision-making.
• Optimizes data structures to improve reporting and dashboard performance.
• Designs and executes data migration strategies, ETL (Extract, Transform, Load) processes, and integration workflows to ensure seamless data flow across systems.
• Establishes data lineage, cataloging, and data stewardship practices.
• Produces architecture artifacts such as target state diagrams, data flow maps, data contracts, and decision records.
• Leads enterprise-wide data strategy initiatives, including governance, lifecycle management, and innovation alignment.
• Architects scalable platforms that support advanced analytics, machine learning, and AI-driven decision-making.
• Drives cross-departmental data integration to unify disparate sources and enable a single source of truth.
• Mentors junior data professionals and provide architectural guidance on modeling, security, and performance optimization.
• Evaluates and introduces emerging technologies (e.g., data mesh, real-time streaming) to enhance agility and scalability.
• Establishes and enforce data governance policies, ensuring data accuracy, security, and compliance with industry regulations (e.g., PCI-DSS, HIPAA, CJIS).
• Monitors and optimize database performance, troubleshoot issues, and implement improvements to enhance efficiency and reliability.
• Provides technical gu