Senior Data Architect

County of Mecklenburg, NC•Charlotte, NC

3d•$108,468 - $162,701

About The Position

The Senior Data Architect helps structure the enterprise across its processes, capabilities, and technology, aligning strategic goals with decisions about products and services, partners and suppliers, organizational capabilities, and business and IT initiatives. The role translates business goals, requirements, capabilities, and objectives into detailed system architectural designs, using process flow diagrams, future-state operational changes, and technical solution models. As part of the Enterprise Architecture Team, the Data Architect collaborates with other architecture roles to design solutions for various projects and works with development staff, support staff, and business partners to define and implement enterprise data standards and governance. The role implements TOGAF, establishes data architecture principles, creates data models and diagrams for key entities, and inventories the data needed to realize the architecture vision. The position evaluates technologies, develops enterprise architecture artifacts and data models, assesses data quality, and supports data integration, business intelligence, analytics, and related initiatives. It ensures that solutions are scalable, secure, consistent with enterprise governance and policy, and supportive of regulatory compliance and responsible data use. This exempt position has a stated salary range of $108,468–$162,701; pay rates are based on education, skill, experience level, and internal equity.

Requirements

At least six years of progressively responsible programming experience.
Bachelor’s degree in Information Technology or Computer Science; a combination of relevant education and relevant experience is accepted.
Knowledge of current software development technologies, trends, and methodologies.
Knowledge of common and advanced software engineering design patterns.
Knowledge of training techniques and assigned governmental functions.
Knowledge of complex data relationships among multiple sources of structured and unstructured data.
Skills in object-oriented programming and design.
Skills in relational database programming and design.
Skills in web-based application programming and design.
Project management skills.
Ability to develop software using multiple tools, operating systems, languages, and methodologies.
Ability to define, track, and ensure responsiveness to clients’ information service problems.
Ability to establish and maintain effective working relationships.
Ability to contribute to team success, build partnerships, communicate clearly, collaborate, and focus on customer needs.
Ability to make informed decisions, apply technical and professional knowledge, drive results, and plan and organize work.
Ability to manage conflict effectively.

Nice To Haves

Experience with data migration tools.
Azure Data Lake experience.
Azure Data Factory experience.
Power BI experience.
SQL Server Reporting Services experience.
Knowledge of big data concepts.
Master Data Management experience.
Experience or skills in data analysis, data modeling, data integration, data warehousing, and database design.
Proficiency in both Oracle and SQL Server.

Responsibilities

Understand business issues and challenges quickly and effectively.
Elicit business needs and build trusted-advisor relationships with business leaders, providing coaching and guidance on architectural and design options informed by industry trends and customer expectations.
Help develop a consolidated business and technology roadmap that aligns resources, interdependencies, and business priorities.
Manage multiple projects and priorities simultaneously.
Review proposed data models in packaged or commercially available applications as part of due diligence for software purchases.
Serve on data integration, business intelligence, and content management initiatives.
Work with business users to identify and document key facts and dimensions needed to support business requirements.
Develop and maintain conceptual, logical, and physical data models and a metadata repository.
Identify appropriate data sources with business analysts, assess source-data quality, and prepare prototype models to support development.
Develop entity and attribute descriptions and definitions, and resolve conflicts in descriptions and definitions.
Describe data entities and relationships, master data, metadata, data quality, data cleansing, and data governance.
Evaluate and select existing or emerging technologies to meet business and project needs.
Determine physical system designs and assess existing technology and standards against information standards and logical systems design.
Translate complex topics, concepts, and business opportunities into architectural and design options that help the County address challenges and market opportunities.
Create and implement standard enterprise architecture work products, including business capability models, logical architecture models, and physical architecture models; ensure quality and manage multiple priorities.
Determine modeling standards, guidelines, best practices, and approved modeling techniques and approaches.
Collaborate with cross-functional teams to ensure solutions are scalable, secure, and aligned with enterprise governance and policy requirements.
Work successfully with and on Agile teams.
Define and maintain conceptual, logical, and physical data models for business and analytical needs.
Identify and document key data entities, attributes, and relationships required for enterprise systems.
Assess data sources and perform data-quality evaluations for accuracy, completeness, and reliability.
Support data integration, business intelligence, and analytics initiatives through structured data design and modeling.
Maintain enterprise architecture artifacts, including business capability models, logical architectures, and physical solution designs, ensuring consistency and quality across initiatives.
Ensure solutions align with enterprise data, security, and governance policies and support regulatory compliance and responsible data use.