Data Integration Engineer I

About the Department

ESSENTIAL DUTIES

• Design, develop, test, document, monitor, and maintain data integrations between County systems using APIs, database connections, scripts, and other integration tools. ·Conduct analyses of functional business processes and requirements. Collaborate with stakeholders to understand business needs and requirements. Identify opportunities to improve processes and work with teammates to implement. Develop, maintain, and present reports by data mining, collecting, integrating, modeling, analyzing, and summarizing information and trends in formats that meet user needs. Design, develop, and optimize data models to support reporting, dashboards, and advanced analytics. Create, install, and test database integrations, permissions and privileges. Utilize Power BI, Microsoft Reporting Services, or other software in a Microsoft SQL/T-SQL/M365 environment to bring together data from disparate systems to design and produce models, dashboards, and reports. Analyze, design, optimize, and automate processes and workflows using county provided platforms and tools. Support county reports, dashboards, audits, and other data systems while adhering to project deadlines and service level agreements Coordinate and manage projects, ensuring deliverables are completed on time, within scope, and aligned with organizational goals. Maintain technical documentation for integrations, automations, data models, reports, configurations, and support procedures. Provide report and system training for various county employees, departments, and organizations.
• Design, develop, test, document, monitor, and maintain data integrations between County systems using APIs, database connections, scripts, and other integration tools.
• ·Conduct analyses of functional business processes and requirements.
• Collaborate with stakeholders to understand business needs and requirements.
• Identify opportunities to improve processes and work with teammates to implement.
• Develop, maintain, and present reports by data mining, collecting, integrating, modeling, analyzing, and summarizing information and trends in formats that meet user needs.
• Design, develop, and optimize data models to support reporting, dashboards, and advanced analytics.
• Create, install, and test database integrations, permissions and privileges.
• Utilize Power BI, Microsoft Reporting Services, or other software in a Microsoft SQL/T-SQL/M365 environment to bring together data from disparate systems to design and produce models, dashboards, and reports.
• Analyze, design, optimize, and automate processes and workflows using county provided platforms and tools.
• Support county reports, dashboards, audits, and other data systems while adhering to project deadlines and service level agreements
• Coordinate and manage projects, ensuring deliverables are completed on time, within scope, and aligned with organizational goals.
• Maintain technical documentation for integrations, automations, data models, reports, configurations, and support procedures.
• Provide report and system training for various county employees, departments, and organizations.

MINIMUM QUALIFICATIONS

• Bachelor’s* degree in Computer Science, Information Systems, Data Analytics, or a related field. 2 years of experience in data integration, database design, and/or query optimization or in a related IT role. * Approved work experience beyond that required which provides equivalent knowledge, skills, and abilities may be considered and substituted for the stated education. Have and maintain a valid Driver’s License, as well as meet eligibility requires of “acceptable driving standards” as defined by the County. KNOWLEDGE, SKILLS & ABILITIES Effective communication and interpersonal skills for interacting with diverse individuals. Ability to multi-task, prioritize, and manage time effectively. Proficiency in using the Microsoft Office Suite and other software related to data management, communication, and other common business processes. Ability to follow established policies and procedures for confidentiality while adapting to evolving privacy standards and technologies. Ability to build and maintain positive relationships within a team. Basic knowledge of I.T. security practices. Extensive technical aptitude skills and ability to comprehend complex technical topics and specialized information. Ability to disseminate information to technical and non-technical individuals. Proficiency in SQL and scripting languages for data manipulation and analysis. Experience in designing, developing, and optimizing reports, dashboards, and data models. Ability to translate business needs into technical solutions.
• Bachelor’s* degree in Computer Science, Information Systems, Data Analytics, or a related field.
• 2 years of experience in data integration, database design, and/or query optimization or in a related IT role. * Approved work experience beyond that required which provides equivalent knowledge, skills, and abilities may be considered and substituted for the stated education.
• Have and maintain a valid Driver’s License, as well as meet eligibility requires of “acceptable driving standards” as defined by the County.
• Effective communication and interpersonal skills for interacting with diverse individuals.
• Ability to multi-task, prioritize, and manage time effectively.
• Proficiency in using the Microsoft Office Suite and other software related to data management, communication, and other common business processes.
• Ability to follow established policies and procedures for confidentiality while adapting to evolving privacy standards and technologies.
• Ability to build and maintain positive relationships within a team.
• Basic knowledge of I.T. security practices.
• Extensive technical aptitude skills and ability to comprehend complex technical topics and specialized information.
• Ability to disseminate information to technical and non-technical individuals.
• Proficiency in SQL and scripting languages for data manipulation and analysis.
• Experience in designing, developing, and optimizing reports, dashboards, and data models.
• Ability to translate business needs into technical solutions.

Other Qualifications

• The work environment is typically a professional office setting, involving regular use of computers, standard office equipment, and frequent interaction with both internal staff and the public in a structured, task-oriented atmosphere. Work hours may include evenings, early mornings, weekends, call-ins, and holidays. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential tasks.

Benefits

• Sarpy County offers competitive benefits to eligible* employees including: Sarpy County Insurance Benefit Guide Health Insurance Dental Insurance Life Insurance Long-term Disability Insurance Pension Plan Vacation Leave Sick Leave Flexible Spending Accounts 10 designated holidays and 2 floating holidays Employee Assistance Program *For eligiblity requirements, reference associated union contract or the Sarpy County Personnel Rules and Regulations .

Supplemental Questions