Senior Data Architect — Enterprise Data & Analytics

City of McKinney; McKinney (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

The City of McKinney seeks a seasoned Data Architect to design and govern the organization’s data infrastructure, ensuring secure, scalable storage, processing, and retrieval to support analytics and compliance. You will collaborate with data engineers, analysts, and stakeholders to translate requirements into robust systems.

Responsibilities include building data models, data warehouses/lakes, defining architecture frameworks, and guiding governance and lifecycle management.

Qualifications

• Experience designing conceptual, logical, and physical data models.
• Ability to create data warehouses and data lakes for storage and analytics.
• Experience ensuring data quality and governance across platforms.
• Strong knowledge of data migration, ETL/ELT processes, and data lineage.

Responsibilities

• Develops and maintains data models to support business needs, ensuring scalability.
• Creates database solutions, data warehouses, and data lakes.
• Ensures data quality for reliable decision-making.
• Optimizes data structures for reporting performance.
• Designs ETL/ELT workflows and data migrations across systems.
• Establishes data lineage, cataloging, and governance practices.
• Delivers architecture artifacts and leads enterprise data strategy initiatives.
• Architects platforms for advanced analytics and AI-driven decisions.
• Leads cross-functional data integration and team mentorship.
• Evaluates new technologies to enhance agility and scalability.

Skills

Relational databases

NoSQL databases

Data modeling

Cloud platforms

ETL/ELT tooling

Data governance

Architectural leadership

Programming/scripting

Data observability

Containerization/Kubernetes

Education

Bachelor’s degree in CS/IS/Engineering

Master’s degree (preferred)

Tools

Erwin

ER/Studio

Snowflake

Azure/AWS/GCP

SQL Server

Oracle

PostgreSQL

MongoDB

Synapse

Redshift

Apache Airflow

Mulesoft

Terraform

Pulumi

Kubernetes

Docker

Job description

The City of McKinney seeks a seasoned Data Architect to design and govern the organization’s data infrastructure, ensuring secure, scalable storage, processing, and retrieval to support analytics and compliance. You will collaborate with data engineers, analysts, and stakeholders to translate requirements into robust systems.

Responsibilities include building data models, data warehouses/lakes, defining architecture frameworks, and guiding governance and lifecycle management.