Job Description Summary

Job Description

The Pima County Information Technology Department is seeking a self-motivated thorough disciplined and perceptive individual for the role of Data Engineer I. The ideal entry level candidate will provide independent technical and analytical support on specific application system activities involving the design development construction and ongoing support of systems processes or methods to deliver critical reporting solutions. Services complex customer segment application systems and databases of either the Pima County Information Technology (IT) Department central Finance and Risk Management Department within an Elected Officials IT team or other department/work unit approved by the County Administrator. This role requires close collaboration with other project teams so strong interpersonal skills are essential. We offer an opportunity to apply and expand your skills work in a supportive team environment and advance your career. Bring your energy enthusiasm professionalism and drive for continuous improvementand help make a difference in your community by supporting the mission of Pima County government.

Duties include:

• Participates in the development of database requirements and design specifications;

• Implements database changes based on application development or enhancements;

• Utilizes database management systems (DBMS) software application software and other software related to DBMS administration;

• Monitors DBMS security using appropriate protocols;

• Works with system administration of database servers to assist in function optimally with the DBMS;

• Writes and maintains database documentation appropriate to area of assignment;

• 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.

In applying for this position pay particular attention to the description that follows and to the preferred qualifications at the end of this posting addressing each qualification in your application.

This position is on site with the possibility of part-time telecommuting after 6 months of initial probation.

This is an in-office positionlocatedin Tucson AZ and cannot be remote. TheInformation Technology Department is unable to provide visa sponsorship for this position.

Essential Functions:

As defined under the Americans with Disabilities Act this classification may include any of the following tasks knowledge skills and other characteristics. This list is ILLUSTRATIVE ONLY and is not a comprehensive listing of all functions and tasks performed by incumbents of this class. Work assignments may vary depending on the departments need and will be communicated to the applicant or incumbent by the supervisor.

• Supports the maintenance and basic operation of relational databases across assigned platforms;

• Assists in gathering database requirements and contributing to design specifications;

• Creates simple database objects based on established models and performs routine data updates or changes;

• Assists with installing or upgrading database-related software under supervision;

• Monitors database security following established procedures and escalates issues as needed;

• Performs routine system administration tasks on database servers to support performance and reliability;

• Drafts and updates technical documentation with guidance from senior engineers;

• Monitors storage utilization and participates in backup archiving and recovery activities as directed;

• Generates basic custom or ad hoc reports using standard reporting tools.

Minimum Qualifications:

Associates 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 U four years of work experience in software development and maintenance U one year 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.)

OR:

Two years of experience with Pima County in a Data Analyst II position or closely related classification as determined by the department head.

Qualifying education and experience must be clearly documented in the Education and Work Experience sections of the application. Do not substitute a resume for your application or write see resume on your application.

Preferred Qualifications: (Be specific in describing your experience in your application. Ensure the descriptions provided illustrate your competencies specifically addressing the required and preferred qualifications.):

• Minimum one (1) year experience with planning and creating new applications to completion and working on data layer/business logic/UI.

• Minimum one (1) year experience with using Git for version control and Jira for issue tracking and project management.

• Minimum one (1) year experience working with deployment pipelines.

• Minimum one (1) year experience with database platforms such as Microsoft SQL Server MySQL or Snowflake.

• Minimum one (1) year experience with reporting and analytics tools such as Power BI Qlik Sense or Business Object.

Selection Procedure:

Pima County Human Resources Department reserves the right to admit to the selection process only those candidates that meet the minimum qualifications. All applications will be assessed based on an evaluation of the listed education and experience. Candidates meeting the minimum qualifications may be further evaluated/scored against any advertised Preferred Qualifications. The hiring authority will interview and select the successful candidate from a referral list provided by Human Resources.Additionalassessments/testing may beas part of the selection process.

Supplemental Information:

Licenses and Certificates:Valid driver license isat time of application.ValidAZdriver license isat time of appointment. The successful applicant will be subject to a 39-month DOT Motor Vehicle Record review todetermineapplicants suitability tooperatecounty vehiclesin accordance withPima County administrative procedures. Failure to obtain andmaintainthe required licenses and certifications shall be grounds for termination. Any offer of employment resulting from this recruitment is contingent upon Fleet Services review and approval of the candidates driving record. Some positions may require appropriate licenses or certifications at the time of appointment or within a specified timeframe e.g. Microsoft Certified Technology Specialist (MCTS).