Senior Data Architect

Mecklenburg County•Charlotte, NC

About The Position

The Senior Data Architect is part of the Enterprise Architecture Team and works with other architecture roles to design solutions for various projects. The role partners with development staff, support staff, business partners, and business leaders to define and implement enterprise data standards and governance. It helps align strategic goals with decisions about products and services, partners and suppliers, organizational capabilities, and business and IT initiatives. The role implements TOGAF and translates business requirements and capabilities into detailed system architectural designs, process-flow diagrams, future-state operational changes, and technical solution models. The Data Architect establishes data architecture principles; creates data models that support the intended business architecture; diagrams key data entities; and inventories the data needed to realize the architecture vision. The position develops and maintains conceptual, logical, and physical data models and metadata repositories, evaluates data sources and data quality, and supports data integration, business intelligence, analytics, and content management initiatives. It also develops enterprise architecture artifacts and ensures that solutions are scalable, secure, and aligned with enterprise governance, security, and policy requirements. 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. A bachelor's degree in Information Technology or Computer Science and at least six years of progressively responsible programming experience are listed as minimum qualifications. Relevant education and experience may be combined.

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 across multiple structured and unstructured data sources.
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.
Relational database programming and design computer skills.
Ability to contribute to team success, build partnerships, communicate clearly, collaborate, and focus on customer needs.
Ability to make decisions using information from different sources, plan and organize work, drive results, and manage conflict effectively.
Ability to maintain technical and professional knowledge and keep up with current developments and trends.

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 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 new 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 and assess source-data quality; prepare prototype models to support development.
Develop entity and attribute descriptions and definitions, and resolve conflicts in model descriptions and definitions.
Describe data entities and relationships, master data, metadata, data quality, data cleansing, and data governance.
Evaluate and select existing and emerging technologies to fit business and project needs.
Determine physical system design and assess existing technology and standards against information standards and logical system design.
Translate complex topics, concepts, and business opportunities into system architecture and design options that help the County address opportunities and business challenges.
Create and implement standard enterprise architecture work products, including business capability models, logical architecture models, and physical architecture models; maintain their quality and value.
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 data models supporting business and analytical needs, and document key enterprise data entities, attributes, and relationships.
Support data integration, business intelligence, and analytics through structured data design and modeling.
Maintain consistent, high-quality enterprise architecture artifacts across initiatives.
Ensure alignment with enterprise data, security, and governance policies, including regulatory compliance and responsible data use.