State of New Mexico
IT Database Administrator - Supervisor
State of New Mexico, Santa Fe, New Mexico, us, 87503
$38.44 - $61.50 Hourly
$79,950 - $127,920 Annually
This position is a Pay Band IF
Posting Details
This job posting may be used to fill multiple vacancies.
The New Mexico Health Care Authority (HCA) is a state agency that provides comprehensive, accessible, and high-quality health care services to New Mexico residents. The agency is responsible for managing key services such as Medicaid, SNAP, TANF, and LIHEAP, ensuring uninterrupted support and care for New Mexicans.
Our Vision
Every New Mexican has access to affordable health care coverage through a coordinated and seamless health care system.Our Mission
We ensure that New Mexicans attain their highest level of health by providing whole-person, cost-effective, accessible, and high-quality health care and safety-net services.Our Goals
Leverage purchasing power and partnerships to create innovative policies and models of comprehensive health care coverage that improve the health and well-being of New Mexicans and the workforce.Achieve health equity by addressing poverty, discrimination, and lack of resources, building a New Mexico where everyone thrives.Implement innovative technology and data-driven decision-making to provide unparalleled, convenient access to services and information.Build the best team in state government by supporting employees' continuous growth and wellness.Why does the job exist?
The IT Database Administrator - Supervisor will:
Supervise and Manage the Health Care Authority Information Technology Division (ITD) data team in the development and maintenance of the data warehouse (DW) reporting and business intelligence (BI) solutions for business management department wide.How does it get done?
The IT Database Administrator - Supervisor is responsible for:
Managing, coordinating, and participating in the maintenance and improvement of the existing data warehouse (DW) reporting and business intelligence (BI) solutions, and in identifying and implementing new BI and reporting solutions;Project management, requirement gathering, business analysis, solution architecture and development on all tiers of a BI solution.Who are the customers?
This position will collaborate with the serve internal and external business and technology stakeholders at all levels.Ideal Candidate
The ideal candidate has:
Experience with T-SQL, database modeling, Integration Services, Reporting Services, Analysis Services, PL/SQL Developer, and query optimization;Experience with Microsoft SQL Server and/or Oracle Server;Experience with Export, Transform and Load (ETL) as well as Business Intelligence(BI) tools such as Power BI, IBM Cognos Suite, Tableau, and SSRS is required.
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 data analysis, design, storage and security. 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 experience4 Master's degree in the field(s) specified in the minimum qualification
AND
2 years of experience5 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 LicenseWorking Conditions
Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage. Some sitting, standing, bending and reaching may be required.
Supplemental Information
Benefits:
Do you know what Total Compensation is? Click here
Agency Contact Information: Alex Rodriguez, (505) 538-5184. Email
For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.
Bargaining Unit Position
This position is not covered by a collective bargaining agreement.
$79,950 - $127,920 Annually
This position is a Pay Band IF
Posting Details
This job posting may be used to fill multiple vacancies.
The New Mexico Health Care Authority (HCA) is a state agency that provides comprehensive, accessible, and high-quality health care services to New Mexico residents. The agency is responsible for managing key services such as Medicaid, SNAP, TANF, and LIHEAP, ensuring uninterrupted support and care for New Mexicans.
Our Vision
Every New Mexican has access to affordable health care coverage through a coordinated and seamless health care system.Our Mission
We ensure that New Mexicans attain their highest level of health by providing whole-person, cost-effective, accessible, and high-quality health care and safety-net services.Our Goals
Leverage purchasing power and partnerships to create innovative policies and models of comprehensive health care coverage that improve the health and well-being of New Mexicans and the workforce.Achieve health equity by addressing poverty, discrimination, and lack of resources, building a New Mexico where everyone thrives.Implement innovative technology and data-driven decision-making to provide unparalleled, convenient access to services and information.Build the best team in state government by supporting employees' continuous growth and wellness.Why does the job exist?
The IT Database Administrator - Supervisor will:
Supervise and Manage the Health Care Authority Information Technology Division (ITD) data team in the development and maintenance of the data warehouse (DW) reporting and business intelligence (BI) solutions for business management department wide.How does it get done?
The IT Database Administrator - Supervisor is responsible for:
Managing, coordinating, and participating in the maintenance and improvement of the existing data warehouse (DW) reporting and business intelligence (BI) solutions, and in identifying and implementing new BI and reporting solutions;Project management, requirement gathering, business analysis, solution architecture and development on all tiers of a BI solution.Who are the customers?
This position will collaborate with the serve internal and external business and technology stakeholders at all levels.Ideal Candidate
The ideal candidate has:
Experience with T-SQL, database modeling, Integration Services, Reporting Services, Analysis Services, PL/SQL Developer, and query optimization;Experience with Microsoft SQL Server and/or Oracle Server;Experience with Export, Transform and Load (ETL) as well as Business Intelligence(BI) tools such as Power BI, IBM Cognos Suite, Tableau, and SSRS is required.
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 data analysis, design, storage and security. 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 experience4 Master's degree in the field(s) specified in the minimum qualification
AND
2 years of experience5 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 LicenseWorking Conditions
Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage. Some sitting, standing, bending and reaching may be required.
Supplemental Information
Benefits:
Do you know what Total Compensation is? Click here
Agency Contact Information: Alex Rodriguez, (505) 538-5184. Email
For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.
Bargaining Unit Position
This position is not covered by a collective bargaining agreement.