I&T Systems Architect

Department: Innovation and Technology DepartmentSalary: $108,851.00 - $156,473.59 Commensurate with Experience

SUMMARY

Working Title: I&T Data Architect
Salary Range to Hire: $108,851 - $119,800 Commensurate with Experience

The City of Charlotte Innovation & Technology Services Department is seeking a strategic and technically proficient Data Architect to lead the design, governance, and optimization of enterprise data architecture for the organization. The Data Architect will play a pivotal role in enabling data-driven decision-making, supporting digital transformation, and ensuring compliance with regulatory requirements.

This role requires a forward-thinking professional capable of aligning data architecture initiatives with citywide business goals across public safety, public works, finance, transportation, permitting, and more. This role will work to reduce reputational risk and to improve trust in City data by strengthening quality, consistency, documentation, and accountability.

Major Duties and Responsibilities:

·         Strengthen the City’s ability to deliver reliable reporting, analytics, artificial intelligence, and digital services by ensuring data are accessible, trusted, governed, secure, reusable, and aligned to business needs.

·         Develop and maintain enterprise data architecture standards, models, and documentation.

·         Map data flows across major City systems, applications, databases, integrations, and reporting tools.

·         Architect integrations between legacy systems, cloud platforms, and SaaS solutions such as Workday (ERP/HRIS), GIS (e.g., Esri), permitting systems, case management, Work and Asset Management (WAM), and public safety tools.

·         Support Cyber Security in the identification and validation of where restricted data are stored, how they move, who owns them, and how they are used

·         Partner with departments, application teams, cybersecurity, infrastructure, and analytics teams to improve data management practices.

·         Support I&T partners in assessing new technology initiatives for data architecture, integration, reporting, security, and long-term sustainability impacts.

·         Recommend improvements to reduce duplicate data, manual data movement, inconsistent reporting, and unmanaged integrations.

·         Support data governance efforts, including data definitions, stewardship, quality standards, retention, and access controls as well as document source systems, data lineage, integration patterns, metadata, and data dependencies.

·         Advise leadership on data risks, opportunities, and investment priorities.

• Embody a can-do attitude and a penchant for collaborative problem solving with data

 

Knowledge, Skills & Abilities

·         Understanding principles around enterprise data architecture, data modeling, data integration, and data governance.

·         Demonstrated ability to apply experience with relational databases, data warehouses, data lakes, APIs, ETL/ELT processes, and cloud data platforms such as AWS, Snowflake, or similar technologies to support secure, reliable, and scalable enterprise data architecture.

·         Enterprise architecture concepts and how data architecture supports business applications and technology planning.

·         Data security, privacy, records retention, access control, and regulatory compliance (e.g., CJIS, HIPAA, FERPA, NIST).

·         Knowledge of metadata management, data lineage, master data management, and data quality practices and ability to establish enterprise visibility into where data resides, how it moves, and how it is used.

·         Business intelligence, analytics, reporting tools, and common public-sector data needs (e.g. CRM, MDM, addressing, asset management).

·         Knowledge of modern integration patterns, including APIs, file transfers, middleware, and event-based data movement.

·         Analyzing complex systems to understand data sources, dependencies, duplication, and integration needs and creating data models, data flow diagrams, architecture documentation, and technical standards.

·         Translating business needs into practical data architecture recommendations.

·         Evaluating technology solutions for data storage, integration, reporting, security, and governance impacts.

·         Ability to identify long-term impacts of technology and data decisions and identifying data risks and recommending practical improvements.

·         Ability to develop standards that balance governance, usability, security, and operational practicality.

·         Ability to work across organizational boundaries and build consensus around shared data practices while communicating technical data concepts clearly to technical and non-technical audiences.

·         Ability to explain risks, tradeoffs, and recommendations in a way that supports executive decision-making and organizing complex information into clear documentation, roadmaps, and decision materials.

 

Required Qualifications

·         Experience designing, documenting, or supporting data architecture, data models, databases, data integrations, or enterprise reporting environments.

·         Experience working with relational databases, data warehouses, APIs, ETL/ELT processes, and business intelligence platforms.

·         Experience analyzing how data moves between systems, applications, reports, and business processes.

·         Experience developing or applying data standards, governance practices, data quality rules, or documentation.

·         Experience working with technical teams, business users, vendors, and leadership to translate business needs into data solutions.

·         Experience creating technical documentation such as data flow diagrams, source-to-target mappings, system inventories, or architecture recommendations.

 

Preferred Qualifications

·         Experience in a large public-sector, utility, transportation, public safety, finance, or similarly complex enterprise environment.

·         Experience supporting enterprise architecture, technology governance, application modernization, or major system implementation projects.

·         Experience with cloud data platforms (e.g. AWS), data lakes, SQL Server, or similar tools.

·         Experience with metadata management, master data management, data lineage, data catalogs, or data stewardship programs.

·         Experience reviewing vendor systems or SaaS solutions for data storage, integration, reporting, security, and long-term support impacts.

·         Experience supporting open data, geospatial data, artificial intelligence, advanced analytics, or digital service initiatives.

·         Experience helping establish a new data governance, data architecture, or enterprise data management function.

 

Minimum Education and Experience

Bachelor's Level Degree and five (5) years of related experience in data architecture, database administration, data engineering, business intelligence, systems integration, enterprise architecture, or data governance;

OR

Master's Level Degree and three (3) years of related experience in data architecture, data engineering, enterprise data management, analytics, information systems, computer science, public administration, or a closely related field;

OR

An equivalent combination of education and relevant experience that provides the knowledge, skills, and abilities necessary to successfully perform the essential job duties.

 

BENEFITS

The City of Charlotte provides a comprehensive benefits package to eligible employees.

Click here to learn more about the City of Charlotte’s benefits.

The City of Charlotte is a drug and alcohol-free workplace.