Senior Data Architect

Data Architect

Salary Range: $108,468 - $162,701 This is an exempt position. Pay rates are based on education, skill, experience level and internal equity.

Provides a key role in structuring the enterprise in terms of its processes, capabilities and technology. This incumbent aligns strategic goals and objectives with decisions regarding products and services; partners and suppliers; organization; capabilities; and key business and IT initiatives. This individual's primary responsibility is to ensure that the technological solutions support business goals, requirements, capabilities and objectives are translated into detailed system architectural designs through use of process flow diagrams, future-state operational changes and technical solutions models.

Who will I be working with? As part of the Enterprise Architecture Team, the Data Architect Role will work in collaboration with other Architecture roles to design solutions for various project types. In addition, the Data Architect role will work with both Development staff, Support staff and Business Partners to define and implement Data Standards and Governance across the enterprise.

More about the role: The Data Architect role will work to implement TOGAF (The Open Group Architecture Framework) and is expected to set data architecture principles, create models of data that enable the implementation of the intended business architecture, create diagrams showing key data entities, and create an inventory of the data needed to implement the architecture vision.

What Will I Be Doing?

• Quickly and effectively understand business issues and challenges
• Elicit business needs and builds a trusted advisor relationship with business leaders to provide coaching and guidance on system architectural and design solution options based on understanding of industry trends and customer expectations
• Serves as an integral member of the team that helps develop a consolidated business and technology roadmap to help ensure that resources, interdependencies and business priorities are effectively aligned
• Manages multiple projects and priorities simultaneously
• Participate in due diligence of new software purchases by reviewing all proposed data models contained in packaged or commercially available applications.
• Serve on data integration, business intelligence and content management
• Work with business users to identify and document the key facts and dimensions necessary to support the business requirements.
• Develop and maintain conceptual, logical and physical models, as well as metadata repository.
• Identify the appropriate data sources with the assistance of the business analysts and conduct thorough data quality assessments on source data. Prepare prototype models to support development efforts.
• Develop entity and attribute descriptions and definitions for the models. Ensure that conflicts in descriptions and definitions are resolved.
• Describing data entities and relationships, master data, metadata, data quality, data cleansing, and data governance

Essential Functions General

• Evaluate and select from existing and emerging technologies to best fit business and project needs
• Determine physical system design and assess existing technology and standards to fit within information standards and logical systems design
• Build a trusted advisor relationship with business leaders to provide coaching and guidance on system architectural and design solution options based on understanding of industry trends and customer expectations
• Serve as an integral member of the team that helps develop a consolidated business and technology roadmap to help ensure that resources, interdependencies and business priorities are effectively aligned
• Translate complex topics, concepts and business opportunities into possible system architectural and design solution options that will help Mecklenburg County take advantage of market opportunities or overcome business challenges
• Create and implement a standard set of EA work products including business capability models, logical architecture models, and physical architecture models that enable the organization to achieve the value identified with high quality; and manage multiple projects and priorities simultaneously
• Determine overall 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

Data Architecture

• Define and maintain conceptual, logical, and physical data models to support business and analytical needs
• Identify and document key data entities, attributes, and relationships required to support enterprise systems
• Assess data sources and perform data quality evaluations to ensure accuracy, completeness, and reliability
• Support data integration, business intelligence, and analytics initiatives through structured data design and modeling
• Develop and maintain standard 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, supporting regulatory compliance and responsible use of data

Minimum Qualifications

• Experience: Minimum of six years of progressively responsible programming experience
• Education: Bachelor's Degree in Information Technology or Computer Science Combination of relevant education and relevant experience accepted: Yes

Preferred Qualifications

• Data Migration Tools, Azure Data Lake Experience, Azure Data Factory Experience, Power BI, SQL Server Reporting Services, Big Data Concepts, Master Data Management.
• Data Analysis, Data Modeling, Data Integration, Data Warehousing, Database Design, Proficiency in both Oracle and SQL Server.

Knowledge, Skills and Abilities

• Knowledge of current software development technologies, trends, and methodologies
• Common and advanced software engineering design patterns
• Training techniques
• Assigned governmental functions
• Complex data relationships among multiple sources of structured and unstructured data
• Object-oriented programming and design
• Relational database programming and design
• Web-based application programming and design
• Project management
• Develop software using multiple tools, operating systems, languages, and methodologies
• Define, track, and assure responsiveness to clients' information service problems
• Establish and maintain effective working relationships
• Contributing to Team Success: Actively participates as a member of a team to move the team toward the completion of goals.
• Building Partnerships: Identifies opportunities and takes action to build strategic relationships between one's area and other areas, teams, departments, units, or organizations to help achieve business goals.
• Communication: Clearly conveys information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.
• Collaboration: Works effectively and cooperatively with others; establishes and maintains good working relationships.
• Customer Focus: Ensures that the customer perspective is a driving force behind business decisions and activities; crafts and implements service practices that meet customers' and own organization's needs.
• Decision Making: Identifies and understands issues, problems, and opportunities; compares data from different sources to draw conclusions; uses effective approaches for choosing a course of action or developing appropriate solutions; takes action that is consistent with available facts, constraints, and probable consequences.
• Technical/Professional Knowledge and Skills: Has achieved a satisfactory level of technical and professional skill or knowledge in position-related areas; keeps up with current developments and trends in areas of expertise.
• Driving for Results: Sets high goals for personal and group accomplishment; uses measurement methods to monitor progress toward goals; tenaciously works to meet or exceed goals while deriving satisfaction from that achievement and continuous improvement.
• Planning and Organizing: Establishes courses of action for self and others to ensure that work is completed efficiently.
• Managing Conflict: Deals effectively with others in an adversarial situation; uses appropriate interpersonal styles and methods to reduce tension or conflict between two or more people.

Computer Skills

• Relational database programming and design

Reasonable Accommodations Statement

To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodations may be made to help enable qualified individuals with disabilities to perform the essential functions satisfactorily.

Disclaimer Statement

This is not intended to be an all-inclusive list of job-related responsibilities, duties, skills, requirements or working conditions. Other duties may be assigned based on business need and the supervisor's request. Mecklenburg County reserves the right to revise the job description at any time. Designated positions may be required to assist in emergency and/or disaster situations.