Enterprise Data Architect

Salary: $87,259.00 - $109,073.00 Annually
Location : 201 S Greene Street Greensboro, NC
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 03227
Department: Information Technology
Opening Date: 12/20/2023
Description
ABOUT THE OPPORTUNITY
Are you are looking for an opportunity to use your unique data skills and experience to provide real strategic guidance and impact? Guilford County is a high-performing local government organization looking to establish an Enterprise Data infrastructure to enable the application of data for critical decision-making. As part of the Chief Data Officer team, the Enterprise Data Architect will be asked to provide strategic guidance and leadership in addition to technical expertise in developing a new Enterprise Data management infrastructure, including developing Data Architecture roadmaps, data quality standards, analytics support processes, and data governance processes related to the Counties priorities and goals.
GENERAL STATEMENT OF DUTIES
The Enterprise Data Architect will help define, deploy, and document Enterprise Data Architecture for centralized access to clean data from disparate county data sources to enable analytics/business intelligence while maintaining appropriate data privacy procedures for protected and/or sensitive data. The Data Architect will be a central resource for Enterprise Data and metadata management.
DISTINGUISHING FEATURES OF THE CLASS
The Enterprise Data Architect is an experienced professional reporting to the Chief Data Officer, working closely with cross-functional teams from various departments to provide recommendations for optimized Data Architecture based on the data storage and retrieval needs for Guilford County and within each department. The ideal candidate will have proven experience with data warehouse design, Master Data Management (MDM) design and development, data storage, data modeling, quality assurance, ETL, and analytics/business intelligence capabilities. A key function of this position will be to advise on best practice for data management - extraction, cleansing, alignment, storage, and governance. The Enterprise Data Architect will be responsible for constantly monitoring our Enterprise Data Architecture and quickly addressing any issues.
Examples of Duties
DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include, but are not limited to:
Design, develop, and maintain the Enterprise Data management framework

• Design, build, support and maintain countywide database systems including Microsoft SQL Server.
• Define/update county-wide data documentation and storage standards.
• Analyze database implementation methods to make sure they are in line with county policies, external regulations, and adopted standards.
• Create data monitoring models for each product and work with our software and application development teams to create models ahead of new releases.
• Develop database design and architecture documentation for executive administration.
• Ensure the integrity and security of county data assets.

Analyze systems and create solutions for business requirements

• Provide insight into the changing data storage and utilization requirements for the county and offer solutions.
• Provide guidance, assistance and support for creation and maintenance of complex data sets that meet cross-functional requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build / Maintain the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and other related technologies.

Establish and cultivate a data-driven culture

• Lead design sessions in prototyping new solutions to enhance current solutions and increase user adoption of existing tools within our support and work management portfolio.
• Functions as a subject-matter-expert and participate in the resolution of system and product issues in escalation situations.
• Work with cross functional stakeholders to assist with data-related technical issues and support their data infrastructure needs.
• Other duties as assigned by the Manager / Supervisor.

RECRUITMENT STANDARDS
Knowledge, Skills, and Abilities

• Sound working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
• Ability to build processes supporting data transformation, data structures, metadata, dependency and workload management.
• Experience eliciting and translating business pain points into tangible KPI's and associated business intelligence solutions.
• Strong project management and organizational skills
• Knowledge of Data Governance and best practices around Data Architectures.
• Experience with software tools such as Visual Studio, Microsoft SQL Server Reporting Services, Integration Services and Management Studio, Microsoft PowerBI and Tableau
• Experience supporting and working with cross-functional teams in a dynamic environment

Typical Qualifications
MINIMUM QUALIFICATIONS
Bachelor's degree in Computer Science, Statistics, Information Systems or another quantitative field with 3 years of experience in a Database Administration and/or Data Architect role OR Associate Degree in Computer Science, Statistics, Information Systems or another quantitative field with 5 years of experience in a Database Administration and/or Data Architect role.
Supplemental Information
PHYSICAL DEMANDS AND WORK CONDITIONS
Must be able to physically perform the basic life operational functions of fingering, and talking.
Must be able to perform light work exerting up to 10 pounds of force occasionally and/or a negligible amount of force frequently or constantly to lift, carry, push, pull, or otherwise move objects. Must possess the visual acuity to prepare and analyze data and figures, accounting, operate a computer terminal, and do extensive reading.
May Require Driving
This position may require driving for this position whether driving a County owned or personal vehicle to conduct county business such as but not limited to attending conferences, meetings, or any other county related functions. Motor Vehicle Reports may be verified for valid driver's license and that the driving record is compatible with the county's driving criteria.
If a personal vehicle is operated for county business proper insurance is maintained as per Guilford County's vehicle use policy.
Special Note: This generic class description gives an overview of the job class, its essential job functions, and recommended job requirements. However, for each individual position assigned to this class, there is available a completed job questionnaire with a physical abilities checklist which can give further details about that one specific position. Those documents should be reviewed before initiating a selection process. They can provide additional detailed information on which to base various personnel actions and can assist management in making legal and defensible personnel.
We are excited about the opportunity of having you as a prospective new employee!
You probably already know our county is a wonderful county to live in, but did you know it is also a wonderful place to work?
Below are a few of the reasons why we love working for Guilford County.
We offer Health Insurance (UnitedHealthCare) to all benefitted employees working a minimum of 20 hours per week. The shared cost of the premium is based on scheduled/budgeted hours. If you are a full-time employee working 40 hours a week you can expect to pay less than $35 a month for medical coverage, dental coverage for $4 a month and vision coverage for $5 a month. That's less than $45 a month for medical, dental & vision coverage; that's unheard of.
Telehealth UHC Virtual Visits are available to you with no copay or out of pocket expense.
We are excited to inform you Guilford County has an Employee Wellness Center (24/7 access) with strength training equipment, cardio machines and a group exercise room with virtual or in person coaching from our Wellness Specialist!
Employee Assistance Program, 100% funded by the county. A superb benefit for you and your family absolutely free. Confidential help with personal or work-related issues.
13 paid holidays, 12 sick days, and 12 vacation days a year. That's 37 paid days a year, totaling almost 2 months of paid time off.
Employer contributes 5% into your 401(k) - no match required.
Enrollment in the State Retirement Plan by contributing 6%.
Longevity pay beginning at five years of service.
We provide a $10,000 Life and AD&D benefit to eligible employees.
Flexible spending accounts (FSA) allow you to set aside tax-free dollars for health care and dependent care.
Voluntary Life, AD&D, Short-Term and Long-Term Disability.
01
Which best describes your level of education?

• High school
• Associate's degree
• Bachelor's degree
• Master's degree or higher

02
If you have a degree, is the major field of study in Computer Science, Statistics, Information Systems or another quantitative field?

• Yes
• No
• I do not have a degree

03
Which best describes your experience in a Database Administration and/or Data Architect role?

• Less than 3 years
• 3 years less than 5 years
• 5 years less than 7 years
• 7 or more years

Required Question