Database Administrator/Analyst

3 weeks ago

Helena, United States State of Montana Full time

Description:

The Montana Public Employee Retirement Administration (MPERA) agency is committed to providing secure and sustainable retirement benefits to nearly 60,000 members and retirees.The agency administers nine defined benefit retirement plans and is dedicated to customer service, member education, and operational efficiency.

As a member of the agency’s Information Systems Bureau, this position will support the business bureaus through analysis and maintenance of MPERA’s data sources. The ideal candidate will have experience in analyzing and assessing data, identifying integrity issues and anomalies and can make recommendations for and implantation of remediation actions.Candidate will work with programmers, engineers, and management heads to identify data and process improvement opportunities, propose system modifications, and devise data governance strategies.The ideal candidate will have experience programming in Microsoft SQL Server. In addition, duties will includeanswering customer questions and troubleshooting customer issues.

If you feel you have the qualities to be successful in this position, please apply by submitting your resume and cover letter . In your resume , include three professional references . In your cover letter, discuss how you apply your knowledge and experience to effectively troubleshoot application issues.

This position requires the successful completion of a criminal background check.

An initial candidate review will take place on June 3rd, 2024.

What are we looking for?

Education and Experience: 

A Bachelor’s degree in Computer Science, or closely related field; AND 5 years’ experience as a database analyst Alternate combinations of education and experience will be considered on a case-by-case basis.

Competencies:

Conducting analysis of data integrity Theory and practices of database design and development Designing a normalized database schema and proficient use of reports, views, stored procedures, triggers, and user defined types; MS-SQL Server SQL and Transact-SQL Strong mathematical skills to help collect, measure, organize and analyze data Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation. Experience in handling reporting packages like Business Objects, programming (JavaScript, XML, or ETL frameworks), databases Proficiency in statistics and statistical packages like Excel, SPSS, SAS to be used for data set analyzing Problem-solving skills Accuracy and attention to detail Adept at queries, writing reports, and making presentations Team-working skills Verbal and Written communication skills Proven working experience in data analysis Analyze and interpret complex datasets to derive actionable insights. Implement robust processes for validating and cleansing data. Collaborate with data users to identify and rectify errors and discrepancies. Monitor and maintain data quality standards.Implement processes for data validation and error detection. Proactively identify opportunities for improving data quality processes. Implement measures to prevent data quality issues and enhance overall data integrity. Collaborate with developers to optimize database queries. Develop and generate reports for business stakeholders Document database structures, processes, and best practices Effectively communicate with diverse levels of management and stakeholders Troubleshoot issues in complex database(s) supporting a multiple tiered software application Identify problems, emerging issues, and trends, and establish strategies to address them Manage workload and time Deliver professional customer service Explain technical issues to non-technical people Adapt to shifting business requirements

Only online applications are accepted.By applying online, you are able to receive updates and monitor the status of your application.

Employment with the beautiful State of Montana offers more than just a paycheck:

Ø Look to see the additional benefits

Ø Public Service Loan Forgiveness (PSLF) – Employment with the State of Montana may qualify you to receive student loan forgiveness under the PSLF.Lookto learn more and see if you may qualify

This position is eligible for telework on a hybrid basis, the employee must reside in Helena and be able to come into the office on a routine basis.

  • Database Administrator/Analyst

    3 weeks ago

    Helena, United States State of Montana Full time

    The Montana Public Employee Retirement Administration (MPERA) agency is committed to providing secure and sustainable retirement benefits to nearly 60,000 members and retirees. The agency administers nine defined benefit retirement plans and is dedic Database Administrator, Database, Analyst, Administrator, Customer Service, Technology, Application

  • Healthcare Business Analyst

    2 months ago

    Helena, United States Creospan Inc. Full time

    Job Description: Healthcare Business AnalystRole Overview:As a Healthcare Business Analyst, you will be responsible for analyzing and improving processes within the healthcare industry to enhance operational efficiency and patient outcomes. You will collaborate with stakeholders to gather requirements, analyze data, and translate business needs into...

  • Healthcare Business Analyst

    2 weeks ago

    Helena, United States Creospan Inc. Full time

    Job Description: Healthcare Business AnalystRole Overview:As a Healthcare Business Analyst, you will be responsible for analyzing and improving processes within the healthcare industry to enhance operational efficiency and patient outcomes. You will collaborate with stakeholders to gather requirements, analyze data, and translate business needs into...

  • Information Protection Analyst

    2 weeks ago

    Helena, United States State of Montana Full time

    Job Overview: This position resides in the of .The Information Protection Analyst assists in helping to ensure that the appropriate operational information protection posture is maintained for each of the department’s information systems. The incumbent performs a variety of duties assigned by management. Duties include implementing Information...

  • Information Protection Analyst

    9 hours ago

    Helena, United States State of Montana Full time

    Job Overview: This position resides in the of .The Information Protection Analyst assists in helping to ensure that the appropriate operational information protection posture is maintained for each of the department’s information systems. The incumbent performs a variety of duties assigned by management. Duties include implementing Information...

  • Financial Data Analyst

    20 hours ago

    Helena, United States State of Montana Full time

    Financial Data Analyst-(24141622) Why should you keep reading and consider working here? We know you have other work options, but we ask you to consider working with us at the State of Montana Department of Administration (DOA).Our foundation of success is having effective working relationships, built on mutual trust and respect.We will challenge you to...

  • GIS Programmer/Analyst

    3 weeks ago

    Helena, United States State of Montana Full time

    /THE OUTSIDE IS IN US ALL./ Please remember to attach the required documents listed in this announcement: Resume Cover Letter Applications missing the requested documents will be considered incomplete and may not progress further in the process.Documents not requested will not be considered in the recruitment process. The State Application is not a...

  • GIS Programmer/Analyst

    20 hours ago

    Helena, United States State of Montana Full time

    /THE OUTSIDE IS IN US ALL./ Please remember to attach the required documents listed in this announcement: Resume Cover Letter Applications missing the requested documents will be considered incomplete and may not progress further in the process.Documents not requested will not be considered in the recruitment process. The State Application is not a...

  • GIS Programmer/Analyst

    4 weeks ago

    Helena, United States State of Montana Full time

    GIS Programmer/Analyst-(24141257) Please remember to attach the required documents listed in this announcement: Resume Cover Letter Applications missing the requested documents will be considered incomplete and may not progress further in the process. Documents not requested will not be considered in the recruitment process. The State Application is...

  • GIS Programmer/Analyst

    9 hours ago

    Helena, United States State of Montana Full time

    GIS Programmer/Analyst-(24141257) Please remember to attach the required documents listed in this announcement: Resume Cover Letter Applications missing the requested documents will be considered incomplete and may not progress further in the process. Documents not requested will not be considered in the recruitment process. The State Application is...

  • Administrative Assistant 2

    1 week ago

    Helena, United States State of Montana Full time

    Job Overview: The Administrative Assistant is instrumental in performing various administrative, office and legal support activities for Appellate Defender offices, which handle criminal and civil cases on appeal to the Montana Supreme Court. This position’s responsibilities include ensuring the effective operations of AppellateDefender offices by...

  • Health Services Data Analyst

    2 weeks ago

    Helena, United States State of Montana Full time

    HEALTH SERVICES DATA ANALYST RESEARCH ANALYTICS AND PLANNING BUREAU HELENA, MT MISSION/ //- /Montana Department of Corrections is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in the community the Montana Department of Corrections is the place for you! JOB OVERVIEW - Research,...

  • Health Services Data Analyst

    12 hours ago

    Helena, United States State of Montana Full time

    HEALTH SERVICES DATA ANALYST RESEARCH ANALYTICS AND PLANNING BUREAU HELENA, MT MISSION/ //- /Montana Department of Corrections is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in the community the Montana Department of Corrections is the place for you! JOB OVERVIEW - Research,...

  • Health Services Data Analyst

    2 weeks ago

    Helena, United States State of Montana Full time

    HEALTH SERVICES DATA ANALYST RESEARCH ANALYTICS AND PLANNING BUREAU HELENA, MT MISSION - Montana Department of Corrections is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in the community the Montana Department of Corrections is the place for you! JOB OVERVIEW - Research,...

  • Health Services Data Analyst

    2 weeks ago

    Helena, United States State of Montana Full time

    Health Services Data Analyst-(24141361) HEALTH SERVICES DATA ANALYST RESEARCH ANALYTICS AND PLANNING BUREAU HELENA, MT MISSION Montana Department of Corrections is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in the community the Montana Department of Corrections is...

  • Health Services Data Analyst

    20 hours ago

    Helena, United States State of Montana Full time

    Health Services Data Analyst-(24141361) HEALTH SERVICES DATA ANALYST RESEARCH ANALYTICS AND PLANNING BUREAU HELENA, MT MISSION Montana Department of Corrections is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in the community the Montana Department of Corrections is...

  • Financial Systems Analyst

    3 weeks ago

    Helena, United States State of Montana Full time

    Financial Systems Analyst-(24141472) Why should you keep reading and consider working here? We know you have other work options, but we ask you to consider working with us at the State of Montana Department of Administration (DOA).Our foundation of success is having effective working relationships, built on mutual trust and respect.We will challenge you...

  • Financial Systems Analyst

    9 hours ago

    Helena, United States State of Montana Full time

    Financial Systems Analyst-(24141472) Why should you keep reading and consider working here? We know you have other work options, but we ask you to consider working with us at the State of Montana Department of Administration (DOA).Our foundation of success is having effective working relationships, built on mutual trust and respect.We will challenge you...

  • IT Systems Administrator 2

    9 hours ago

    Helena, United States State of Montana Full time

    Job Overview: This position resides in the of . Duties include analyze and design customized technology systems to meet departmental needs, budgetary requirements, and user ability. The incumbent is responsible for the evaluation and recommendation for technical development of information systems and has primary responsibility for project management,...

  • Health Services Data Analyst

    6 days ago

    Helena, United States State of Montana Full time

    Description: HEALTH SERVICES DATAANALYST RESEARCH ANALYTICS AND PLANNING BUREAU HELENA, MT MISSION - Montana Department of Corrections is creating a safer Montana through Accountability, Rehabilitation and Empowerment. If you want to work making positive changes in the community the Montana Department of Corrections is the place for you! JOB OVERVIEW -...