City of McKinney · 4 hours ago
Data Architect
McKinney, TX
Contract
Onsite
Senior Level
5+ years expThe City of McKinney is a rapidly growing community dedicated to making a meaningful difference in the lives of its residents. They are seeking a Data Architect responsible for designing and managing the organization's data infrastructure to support decision-making and analytics. This senior IT role involves collaboration with cross-functional teams to ensure data integrity, security, and alignment with business objectives.
Business DevelopmentGovernmentMuseums and Historical Sites
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 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
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Software/Computer Engineering, or a related field
Five (5) years of experience in data architecture, data warehousing/modeling, cloud platform architecture, and enterprise database design
Preferred
Master's degree in Computer Science, Information Systems, Enterprise/Information Architecture, or a related field
Industry-recognized certifications such as Certified Data Management Professional (CDMP); TOGAF (The Open Group Architecture Framework) for enterprise architecture; Cloud Data Architect Certificates (Azure Solutions Architect Expert AWS Solutions Architect – Professional, or Google Professional Cloud Architect)
Four (4) years of experience with data lakehouse architectures and tools (e.g. Snowflake, Databricks)
Snowflake data integration and orchestration (Snowpipe, Streams, Tasks)
Performance optimization and query tuning in Snowflake
Data modeling and schema design tailored for Snowflake
Snowflake security features (RBAC, masking, encryption)
Four (4) years of experience implementing data mesh or distributed data architecture concepts
Advanced Experience: Eight (8) years of experience in data architecture, with a focus on cloud-based solutions or large-scale enterprise systems
Company
City of McKinney
As one of the fastest-growing cities in America, McKinney maintains a nationally-acclaimed quality of life coupled with a convenient location to the DFW area.
1001-5000 employees
H1B Sponsorship
City of McKinney has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Robin Horton
Executive Assistant - Office of the CIO
Company data provided by crunchbase