Data Engineer I - Information Technology

Pima County; Tucson (AZ); On-site; USD 65,000 - 92,000; Full time

Job summary

Pima County Information Technology is seeking a Data Engineer I to design, develop, and support database systems and reporting solutions in an in-office role based in Tucson, AZ. The incumbent will collaborate across teams to deliver critical reporting using BI tools and DBMS administration.

The role emphasizes database design, security, documentation, and creating reports with Power BI, Qlik Sense, or similar tools. Visa sponsorship is not offered.

Qualifications

• Associate's degree in computer science, MIS, or related field plus 4 years software/dev experience including DB systems.
• Or two years in Data Analyst II at Pima County.
• Education/experience must be documented in application.

Responsibilities

• Participate in development of database requirements and design specs.
• Implement database changes based on app development/enhancements.
• Monitor DBMS security and assist in DB server administration.
• Write and maintain database documentation.
• Develop ad hoc reports using industry-standard tools.

Skills

DBMS

SQL

Reporting

Education

Associate's degree in CS/IS

Tools

Power BI

Qlik Sense

Business Objects

Git

Jira

Microsoft SQL Server

MySQL

Snowflake

Job description

Job Classification: 5969 - Data Engineer I

Salary Grade: 14

Pay Range

Hiring Range: $65,457 - $78,540 Annually

Pay Range: $65,457 - $91,644 Annually

• Hiring Range is an estimate of where you can receive an offer. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, education, licenses, training, and internal equity.
• Pay Range is the entire compensation range for the position.

Job Description Summary

Department - Information Technology

Job Description

Job Type: Classified

Job Classification: 5969 - Data Engineer I

Salary Grade: 14

Pay Range

Hiring Range: $65,457 - $78,540 Annually

Pay Range: $65,457 - $91,644 Annually

• Hiring Range is an estimate of where you can receive an offer. The actual salary offer will carefully consider a wide range of factors, including your skills, qualifications, experience, education, licenses, training, and internal equity.
• Pay Range is the entire compensation range for the position.

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 candidate has varying degrees of experience and 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 using Business Intelligence Tools.

In This Role You Will

• Participate in the development of database requirements and design specifications;
• Implement database changes based on application development or enhancements;
• Utilize database management systems (DBMS) software, application software, and other software related to DBMS administration;
• Monitor DBMS security using appropriate protocols;
• Work with system administration of database servers to assist in function optimally with the DBMS;
• Write and maintain database documentation appropriate to area of assignment;
• Develop custom or ad hoc reports using industry-standard tools.
• Services complex customer segment application systems and databases of either the Pima County Information Technology (IT) Department, central Finance & Risk Management Department, within an Elected Official's IT team, or other department/work unit approved by the County Administrator.
• Be responsible for other duties as assigned in support of the overall goals and functions of both the Human Resources Department and Pima County

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 improvement and help make a difference in your community by supporting the mission of Pima County government.

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.

Essential Functions

• 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

Associate'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 INCLUDING 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

• Minimum one (1) year experience planning and creating new applications to completion and working on data layer/business logic/UI.
• Minimum one (1) year experience 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 Objects.

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. Additional assessments/testing may be required as part of the selection process.

Supplemental Information

Licenses and Certificates: 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. Failure to obtain and maintain the 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 candidate’s 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).

Special Notice Items: The County requires pre-employment background checks. Successful candidates will receive a post-offer, pre-employment background screening to include verification of work history, education, and criminal conviction history. A prior criminal conviction will not automatically disqualify a candidate from employment with the County. Pima County determines whether a position is eligible for visa sponsorship at the time of recruitment. Eligibility is based on the requirements of the position and applicable laws and regulations. Not all positions with Pima County are eligible for visa sponsorship. The Information Technology is unable to provide visa sponsorship for this position.

Physical/Sensory Requirements: Physical and sensory abilities will be determined by position. Action Activity - reaching; Motion Activity - simple grasping; Hearing Activity - none; Speaking Activity - in person and on a phone; Vision - may be required to operate a motor vehicle.

Working Conditions: Working conditions will be determined by the position.

EEO Information

Pima County Government is an Equal Employment Opportunity employer. We are committed to an inclusive and diverse workforce and will not discriminate in employment opportunities or practices on the basis of race, color, religion, national origin, age, disability, gender, sexual orientation, kinship, political interest, or any other characteristic protected by law.