Data Architect

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. Joi

n 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 s

ustain 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. Essential Functions/Knowledge, Skills, & Abilities 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.

• 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 guidance to support system maintenance and upgrades.
• Collaborates and communicate with stakeholders with various technical skill levels.
• Leads cross-functional teams in data stewardship and literacy.
• Assesses and recommend tools, technologies, and platforms to support data architecture needs.
• Maintains awareness of new technologies and advances in the profession; reading professional literature; attending workshops and training sessions as appropriate.
• Produces detailed, consistent, error-free work based on defined parameters.
• Adheres to assigned work schedule and department attendance policies and procedures.
• Travels to meetings, trainings, and City events as necessary.
• Complies with all written City policies and procedures.

• Perform other duties as assigned or directed.

• Ability to embrace and embody the City’s core values of Respect, Integrity, Service, and Excellence (R.I.S.E.).
• Ability to communicate effectively with peers, supervisors, subordinates, and people to whom service is provided.
• Ability to produce desired work outcomes, including quality, quantity, and timeliness.
• Ability to plan and organize work, time, and resources, and if applicable, that of subordinates.
• Ability to forge strong professional relationships with internal staff, in an outgoing and friendly way