Sr Data Engineer - Greensboro, United States - Guilford County, NC

Description

Salary : $96, $122,162.00 Annually

Location : 301 West Market Street Greensboro, NC

Job Type: Full Time

Job Number: 03228

Department: Information Technology

Opening Date: 01/03/2024

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

Do you want to apply your expertise for a cause you can feel good about? Do you want to work for an organization that wants you to grow with it? Guilford County is a high-performing local government organization that maintains a culture embracing diversity, striving for equality, and inspiring individual and organizational excellence

CLICK HERE TO LEARN WHY YOU SHOULD WORK FOR GUILFORD COUNTY

GENERAL STATEMENT OF DUTIES

As part of the Data and Analytics team, the Sr Data Engineer will be an integral part of the county's data operationalization, analytics, and visualization initiatives. The Sr Data Engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate will be an experienced data wrangler who enjoys creative problem solving and growing data systems from the ground up. The Sr Data Engineer should be comfortable supporting the data needs of multiple projects, possess an in-depth understanding of data modeling, and excited by the prospect of designing the county's data architecture to support the County's strategic initiatives.

DISTIGUISHING FEATURES OF THE CLASS

The Sr Data Engineer's central role is to help overcome data-related barriers to solving business problems. This involves building and maintaining the code, processes and infrastructure to understand, access, and use data efficiently, effectively, and securely. The Sr Data Engineer's main focus will be to build and streamline data workflows to improve data operationalization and work closely with different department and IT teams to develop data models and pipelines for reporting, analysis, and visualization. The Sr Data Engineer will support our software developers, database architects, and data analysts on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products.

Examples of Duties

DUTIES AND RESPONSIBILITIES

Essential duties and responsibilities include, but are not limited to:

• Build data integrations, ETL workflows and data pipelines between systems.
• Develop and maintain data standards and documentation.
• Support the creation and maintenance of the data asset and data system inventory
• Collaborate with other department teams to improve data models that feed business intelligence and reporting tools, increasing data accessibility, and fostering data-driven decision making across the organization.
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Work closely with application development and infrastructure engineering teams to gain an understanding of different data architectures and required functionality.
• Ensure that Data and Analytic systems are engineered to address relevant security, privacy, regulatory, and auditability requirements.
• Performs related work as required.

RECRUITMENT STANDARDS

Knowledge, Skills & Abilities

• Strong working SQL knowledge and experience working with relational databases, query authoring
• (SQL) as well as working familiarity with a variety of databases
• Experience working with the Microsoft Power Platform including Logic Apps, Power BI, Power Apps, and Power Automate
• Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
• Experience supporting and working with cross-functional teams in a dynamic environment
• Knowledge of system and software quality assurance best practices and methodologies.
• Experience in building 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
• Prefer knowledge of Data Governance and best practices around data architectures.
• Prefer demonstrated experience building analytical tools and visualizations that provide actionable insights
• Knowledge of industry standards, emerging technologies, and best practices for information systems security, privacy, and regulatory compliance (e.g., HIPAA)
• Record of successful, complex project completion with minimal supervision including skills in design, requirement gathering, project planning, prioritization, coordination, multi-tasking, and problem solving?
• Experience working with REST APIs (typically as a source of data)
• Experience working with geospatial data, particularly in Esri/ArcGIS Online
• Demonstrated ability to research and pilot 'modern data stack' techniques technology such as semantic layer, orchestration, data lineage/observability.
• Opportunity for a hybrid schedule

Typical Qualifications

Minimum Qualifications

Bachelor's degree with significant coursework related to Computer Science, Data Science, Information Systems Management, Database Administration, Computer Engineering, or Information Technology and 2+ years of relevant work experience, OR

Associate degree in a field related to Computer Science, Data Science, Information Management, Database Administration, Computer Engineering, or Information Technology and 4+ of relevant work experience, OR

Graduation from high school and 6+ of relevant work experience, or an equivalent combination of education and experience.

A skills assessment or exercise may be included in the interview process.
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.

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 description with physical abilities checklist which can 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 defensible personnel decisions.

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

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, Data Science, Information Systems Management, Database Administration, Computer Engineering, or Information Technology ?

• Yes
• No
• I do not have a degree

03

Which best describes your relevant work experience? (Must be detailed in application.)

• Less than 2 years
• 2 years less than 4 years
• 4 years less than 6 years
• 6 or more years

04

Describe how your combination of education and experience provides the necessary, knowledge, skills, and competencies to perform the essential duties and tasks of this position.

05

Briefly describe a time you played a central role in overcoming a data-related barrier to solving a business problem. What was the problem, what was the solution, and what were the tools and techniques you used?

06

What are your preferred tools for documentation and collaboration in data engineering projects?

Required Question