Data Integration Specialist (10012021 & 10012022)

Salary: $87,259.00 - $109,073.00 Annually
Location : 201 West Market Street Greensboro, NC
Job Type: Full Time
Remote Employment: Flexible/Hybrid
Job Number: 03231
Department: Information Technology
Opening Date: 12/22/2023
GUILFORD COUNTY GOVERNMENT
Empower Successful People to thrive in a Strong Community supported by Quality Government
Transparency & Communication | Equity & Inclusion | Accountability
Service & Outcomes Excellence | Our People Matter
Description
GENERAL STATEMENT OF DUTIES
This position is crucial for integrating and managing data across various departments within the County government. It plays a key role in supporting public services, policy-making, and community engagement through effective Data Integration and management.Data Integration Specialist responsibilities also include ensuring compliance with government regulations and policies, particularly in data sharing and public transparency.
DISTINGUISHING FEATURES OF THE CLASS
The Data Integration (DI) Specialist's role is to plan, coordinate, and administer all activities related to the integration of data across various sources into an organized and unified view. This individual is also responsible for the monitoring of data flow between databases, servers and Cloud services to identify and implement the most suitable Data Integration architecture for the organization's needs. Proven communication skills, problem-solving skills, and knowledge of integration best practices and Knowledge of applicable data privacy practices and laws are critical to successful performance in this role.
Examples of Duties
DUTIES AND RESPONSIBILITIES
Essential duties and responsibilities include, but are not limited to:
Strategy & Planning

• Execute and manage the strategic integration of new data and data stores into existing systems and infrastructure throughout the enterprise, including introduction of Cloud services as applicable.
• Ensure that integration projects meet business requirements and goals, fulfill end-user requirements, and identify and resolve systems issues.
• Ensure that integration planning and practices are aligned with strategic business goals and the company's overall strategic vision.
• Develop standards and processes to support and facilitate integration projects and initiatives.
• Revise Data Integration architectures when required to be compatible with changing business needs and client standards so that all legal, compliance, and operational requirements, such as data sovereignty, regulatory security and privacy policies, and service level agreements (SLA), are accounted for.
• Maintain high standards of data quality through the introduction and enforcement of information handling processes and organization of the Data Integration processes.
• Collaborate with BI specialists to establish overarching strategies and service-oriented architecture.

Development & Deployment

• Conduct research on emerging Data Integration products, languages, and standards in support of procurement, development, security, and integration efforts in relation to the Cloud, BI, and big data management.
• Manage the selection, deployment, and maintenance of any Data Integration tools, be they Data Integration as-a-service (DIaaS) or Data Integration On-premise, deemed appropriate for the organization.
• Collaborate with analysts, data stewards, developers, and system owners in the testing of newly incorporated databases and integration measures.
• Liaise with developers as well as engineers to address issues in data patterns and architecture.
• Build relationships with development and infrastructure engineering teams to gain an understanding of different data architectures and required functionality.

Operational Management

• Work diligently to enhance or improve business processes via integration, or, as necessary, minimize the impact of integration on those processes.
• Where applicable, investigate and qualify potential integration solutions in the Cloud, On-Premise, or in a Hybrid arrangement to better allocate resources.
• Review data quality, addressing any issues through the creation of new processes or adjustment of the Data Integration architecture.

RECRUITMENT STANDARDS
Knowledge, Skills, and Abilities

• General technology experience.
• Data integration experience (Azure Data Factory, Databricks, Azure Synapse Analytics, SQL Server

Integration Services, Informatica, etc).

• SQL Server, Hadoop or Spark solution delivery experience.
• Programming experience (T-SQL, Python).
• Data Visualization experience (Power BI, Tableau, QlikView, etc.) preferred.
• Leveraging Cloud-based architectures (Azure).
• Must possess exceptional analytical and troubleshooting abilities.
• Proven experience in overseeing the linking of cross-functional databases between disparate business units and systems.
• Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
• Good project management skills and/or substantial exposure to project-based work structures, project lifecycle models, etc.
• Strong knowledge of system and software quality assurance best practices and methodologies.

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.
Guilford County is committed to providing Equal Employment Opportunity (EEO) to employees and applicants for employment regardless of color, religion, sex, national origin, age, disability, genetic information, sexual orientation or political affiliation. The County is committed to complying with all applicable federal, state and local laws that pertain to employment, and to providing a work environment that is free from discrimination of any kind. If you need an auxiliary aide, make the request forty-eight (48) hours in advance of the time the accommodation is needed by calling 336-641-3324.
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 years of experience in a Database Administration and/or Data Architect role?

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

Required Question