$38.06 – $60.89 Hourly
$79,158 – $126,653 Annually
This position is a Pay Band IF
Posting Details
THIS POSTING WILL BE USED FOR ON-GOING RECRUITMENT AND WILL REMAIN OPEN UNITL FILLED.
Why does the job exist?
Provide technical and development expertise to design, develop, implement, transform, and manage public health data in enterprise data warehouses.
How does it get done?
This position develops and manages data models and automation code to enable data extract, transformation and load operations between enterprise data warehouses and associated inbound and outbound feeder systems.
Responsibilities include:
Ensure that code and jobs conform to security standards and conform with access requirements of the different systems.
Work with system owners and programs to develop end-user facing and intra-system Business Intelligence (BI) services and processes.
Develop and update data models appropriate to data warehouse structures and the structures of feeder systems.
Work with other developers within DOH IT to develop and coordinate data transformation and data exchange processes.
Who are the customers?
Bureaus and Programs within NM DOH as well as other state departments hosting feeder and consumer systems.
Ideal Candidate
Direct experience with Business Intelligence processes including data dictionary maintenance, data modeling, data extract, transformation and loading processes, and query generation.
Direct experience supporting end users in Business Intelligence and data reporting processes.
Coding experience in PySpark highly desired.
Experience in Informatica ETL tools highly desired.
Minimum Qualification
Bachelor’s degree in Computer Science, Management Information Systems (MIS), Information Technology, Engineering or similar technical degree and four (4) years of experience in software programming. Substitutions Apply. See Substitution Table below.
Substitution Table
These combinations of education and experience qualify you for the position:
Education Experience Education Experience 1 High School Diploma or Equivalent AND 8 years of experience OR High School Diploma or Equivalent AND 8 years of experience 2 Associate’s degree in the field(s) specified in the minimum qualification AND 6 years of experience Associate’s degree or higher in any field AND 8 years of experience 3 Bachelor’s degree in the field(s) specified in the minimum qualification AND 4 years of experience 4 Master’s degree in the field(s) specified in the minimum qualification AND 2 years of experience 5 PhD degree in the field(s) specified in the minimum qualification AND 0 years of experience
• Education and years of experience must be related to the purpose of the position.
• If Minimum Qualification requires a specific number of “semester hours” in a field (e.g. 6 semester hours in Accounting), applicants MUST have those semester hours in order to meet the minimum qualifications. No substitutions apply for semester hours.
Employment Requirements
Must possess and maintain a valid driver’s license.
Working Conditions
Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT), extensive personal computer and phone usage. Travel statewide is required.
Supplemental Information
Benefits:
Do you know what Total Compensation is? Click here
Agency Contact Information: John Zoltai (505) 231-2557 Email
For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.
Bargaining Unit Position
This position is covered by a collective bargaining agreement and all terms/conditions of that agreement apply and must be adhered to.