Senior 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.

POSITION SUMMARY

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 ensuring that the technological solutions in 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
• Determine overall modeling standards, guidelines, best

practices and approved modeling techniques and approaches.

• 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

•Evaluate and select from existing and emerging technologies to best fit

business and project needs.

•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

•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

• 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 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.

• Work successfully with and on Agile teams

•Develop

and maintain standard enterprise architecture artifacts, including business

capability models, logical architectures, and physical solution designs,

ensuring consistency and quality across initiatives

•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

•Ensure solutions align with enterprise data, security, and governance

policies, supporting regulatory compliance and responsible use of data

Administrative

•Participation in Candidate Interviews - participate in

interview process for new hires and in identifying skill set for new positions.

•Contributions to Business Process - Lead and engage

ongoing committees and teams.

•Professional Development - improve professional skills and

develop connections with industry peers.

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

Skills

•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

• Defining, tracking, and assuring responsiveness to clients’

information service problems.

• Establishing and maintaining effective working

relationships.

Abilities

• 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.

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.