Data Engineer II - Information Technology

Pima County•Tucson, AZ

4d•Onsite

About The Position

The Pima County Information Technology Department is seeking a motivated and detail-oriented Data Engineer II to support data analysis, reporting, and business intelligence initiatives. The ideal candidate has experience with data analytics, report development, and database systems, along with a passion for transforming data into actionable insights. This position works closely with cross-functional teams and stakeholders to design, develop, and support reporting solutions, databases, and analytical tools that improve decision-making across County departments. Strong technical, analytical, and communication skills are essential. In this role, you will: Serve as a subject matter expert for reporting tools, data analysis, and process improvement initiatives. Develop, maintain, and support reports, dashboards, and data solutions using industry-standard tools. Analyze business requirements and collaborate with stakeholders to deliver effective reporting and data-driven solutions. Participate in database design, development, and administration activities. Create and maintain technical documentation related to reporting and data analysis. Perform data engineering and analytical tasks independently or as part of a team. This is an excellent opportunity for a problem solver who enjoys working with data, developing innovative solutions, and making a meaningful impact in the community through public service. This is an in-office position located in Tucson, AZ, and cannot be remote. The Information Technology Department is unable to provide visa sponsorship for this position.

Requirements

Bachelor's degree from an accredited college, university, or technical trade school with a major in computer science, computer engineering, management information systems (MIS), or a closely-related field as determined by the department head at the time of recruitment, AND four years of work experience in software development and maintenance, AND two years of work experience in the development and maintenance of database systems. (Experience requirements may be achieved concurrently.) (Relevant experience and/or education from an accredited college or university may be substituted.)
Associate's degree from an accredited college, university, or technical trade school AND six years of work experience in information technology software development and maintenance, AND two years of work experience in the development and maintenance of database systems. (Experience requirements may be achieved concurrently.) (Relevant experience and/or education from an accredited college or university may be substituted.)
Three years of experience with Pima County in a Data Engineer I position or closely-related classification as determined by the department head.
Valid driver license is required at time of application.
Valid AZ driver license is required at time of appointment.
The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review to determine applicant’s suitability to operate county vehicles in accordance with Pima County administrative procedures.
Pre-employment background checks.
Post-offer, pre-employment background screening to include verification of work history, education, and criminal conviction history.
Post-job offer physical and/or drug screen.

Nice To Haves

Minimum two (2) years experience coding in SQL, C#, Java, or Python.
Minimum two (2) experience planning and creating new applications to completion and working on data layer/business logic/UI.
Minimum two (2) experience using Git for version control and Jira for issue tracking and project management.
Minimum two (2) experience with database platforms such as Microsoft SQL Server, MySQL, or Snowflake.
Minimum two (2) experience developing dashboards and analytical reports using leading tools, including Power BI, Qlik Sense, Tableau, Domo, Workday, and SAP BusinessObjects.

Responsibilities

Serve as a subject matter expert for reporting tools, data analysis, and process improvement initiatives.
Develop, maintain, and support reports, dashboards, and data solutions using industry-standard tools.
Analyze business requirements and collaborate with stakeholders to deliver effective reporting and data-driven solutions.
Participate in database design, development, and administration activities.
Create and maintain technical documentation related to reporting and data analysis.
Perform data engineering and analytical tasks independently or as part of a team.
Plans, develops and maintains relational databases over a variety of database platforms.
Participates in the development of database requirements and design specifications.
Models database systems, transforms database models and entities into database objects, implements database changes based on application development or enhancements.
Installs database management systems (DBMS) software, application software and other software related to DBMS administration.
Monitors and administers DBMS security using appropriate protocols.
Conducts system administration of database servers to function optimally with the DBMS.
Writes and maintains database documentation appropriate to area of assignment.
Monitors storage, archiving, backup and recovery procedures to ensure functionality and operability, as well as conducting capacity planning.
Develops custom or ad hoc reports using industry standard tools.
Responsible for other duties as assigned in support of the overall goals and functions of both the Human Resources Department and Pima County.