Job Description Summary Department - Information Technology Job Description Job Type: Classified Job Classification: 5261 - Data Engineer II Salary Grade: 16 Pay Range Hiring Range: $75816 - $90979 Annually Pay Range: $75816 - $106163 Annually Range Explanation: 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. Pima County Information Technology is seeking a passionate Data Engineer II to help build and maintain a modern reliable data this role youll streamline ETL processes manage key datasets and work closely with teams across the department to integrate new data sources and develop analytics solutions that support business goals. This position is ideal for someone who enjoys problem-solving wants to grow their career and is motivated to turn raw data into meaningful insights that improve IT operations. If you have experience in data management analytics or IT we invite you to apply and help drive a more efficient data-driven future for Pima County. As a Data Analyst II you will: Acts as a subject matter expert on reporting tools and data analysis and provides recommendations for process improvements. Provides data analysis and reporting support for various departments. Performs data engineering tasks within one or more functional areas working independently or as part of a team. Collaborates with internal and external stakeholders to gather and validate requirements. Develops data pipelines and ETL processes. Creates and maintains a variety of reports data queries scripts workflows and automated tasks using Structured Query Language (SQL) and various database management tools. Administers analytics and database platforms. Research issues and assists in their resolution. This position is onsite with the possibility of working remote part-time or taking advantage of a 9-80 work schedule after 6 months of initial probation. In applying for this position pay particular attention to the preferred qualifications that specific in communicating how you meet those preferred qualifications. This is an in-officeposition located in Tucson AZ and cannot be remote. 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. 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. Minimum Qualifications: Bachelors 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.) OR: Associates 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.) OR: Three years of experience with Pima County in a Data Engineer I 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 three (3) years experience coding in SQL and Python. Minimum two (2) years experience with the development of automated data pipelines with tools such as Qlik Azure Data Factory or Databricks . Minimum three (3) years experience with database platforms such as Microsoft SQL Server or Snowflake. Minimum three (3) years experience developing dashboards and analytical reports using leading tools including Power BI Qlik Sense and SAP BusinessObjects. Minimum three (3) years experience with the administration and management of analytics tools such as Power BI Qlik Sense and SAP BusinessObjects covering user access data source configuration and workspace governance. 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 applicants 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 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). Some positions require a valid Arizona Class D driver license at the time of application or appointment. Failure to maintain the required licensure shall be grounds for termination. 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. Physical/Sensory Requirements : Physical and sensory abilities will be determined by position. Working Conditions: Working conditions will be determined by 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. Key Skills SR,Business Process,Active Directory,Cloud,PowerShell,Windows,Linux,SAN,Java,Troubleshoot,Procedures,SDLC,hardware,Uat,Architecture Employment Type : Full-Time Experience: years Vacancy: 1 Yearly Salary Salary: 75816 - 106163
Read Less
