Enterprise Data Architect (10011835)
Job description
GENERAL STATEMENT OF DUTIES
DISTINGUISHING FEATURES OF THE CLASS
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
-
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 working with the Microsoft Power Platform including Logic Apps, Power BI, Power Apps, and Power Automate
-
Experience supporting and working with cross-functional teams in a dynamic environment
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.
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.
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.