Database Administrator/Analyst

1 month 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

    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...

  • Criminal Justice Systems Analyst

    2 weeks ago

    Helena, United States State of Montana Full time

    Criminal Justice Systems Analyst-(24141761) Division Overview: The   (MBCC) mission  is to proactively contribute to public safety, crime prevention, victim assistance through planning, policy development and coordination of the justice system in partnership with citizens, government, and communities. Job Overview : The  Criminal Justice Systems...

  • IT Systems Analyst

    2 weeks ago

    Helena, United States State of Montana Full time

    Job Overview: Reporting to the FMB Chief, this position provides functional and technical support of the TLMS 2.0 System. In this position the TLMS Analyst provides security administration, data and systems design, data modeling, data management, application development, and client support for TLMS 2.0. This data system requires ongoing development,...

  • Cost Analyst

    2 weeks ago

    Helena, Montana, United States State of Montana Full time

    Cost Analyst Join Our Team as a Cost Analyst and Make a Difference in Environmental Protection. The Petroleum Tank Release Compensation Board (PTRCB) is seeking a dedicated and experienced Cost Analysis Specialist to play a crucial role in overseeing program compliance and ensuring the efficient operation of the Petroleum Tank Release Cleanup Fund. If you...

  • IT Systems Analyst

    3 weeks ago

    Helena, United States State of Montana Full time

    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. Our foundation of success is having effective working relationships, built on mutual trust and respect. We will challenge you to be the best you can be and will work hard...

  • Research Analyst, Legislative

    2 weeks ago

    Helena, United States State of Montana Full time

    Research Analyst, Legislative-(24141823) Job Overview Our nonpartisan research analysts perform public policy research and analysis, draft legislation, and staff committees for the Montana Legislature. Analysts are hired as generalists but are expected to develop expertise in an assigned policy area. Job Duties Session duties include drafting legislation...

  • Financial Data Analyst

    1 month 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...

  • Information Protection Analyst

    1 month 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...

  • IT Systems Analyst

    4 weeks ago

    Helena, United States State of Montana Full time

    IT Systems Analyst-(24141722) 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.Our foundation of success is having effective working relationships, built on mutual trust and respect.We will challenge you to be the best...

  • IT Systems Analyst

    2 weeks ago

    Helena, Montana, United States State of Montana Full time

    IT Systems Analyst 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.Our foundation of success is having effective working relationships, built on mutual trust and respect.We will challenge you to be the best you can...

  • GIS Programmer/Analyst

    1 month 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...

  • Energy Engineering Analyst

    4 weeks ago

    Helena, United States State of Montana Full time

    Energy Engineering Analyst-(24141692) Are you looking for a career where you can make a difference for Montana’s energy system and its vital role supporting our communities and economy? Consider being part of the Montana Energy Office’s team of interdisciplinary professionals who are working to advance innovative solutions for some of Montana’s biggest...

  • Traffic Control Analyst

    3 weeks ago

    Helena, United States State of Montana Full time

    Traffic Control Analyst (Business Analyst)-(24141735) Division Overview: Motor Vehicle Division’s (MVD)  mission is to identify and promote efficient, cost-effective programs that benefit the interests, safety, and well-being of Montana citizens. This occurs through licensing, registering, and regulating the motoring activities of the public. MVD is a...

  • GIS Programmer/Analyst

    1 month 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...

  • Health Services Data Analyst

    1 month 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,...

  • IT Systems Analyst

    4 weeks ago

    Helena, United States State of Montana Full time

    IT Systems Analyst -(24141691) The Montana Public Employee Retirement Administration (MPERA) is committed to providing secure and sustainable retirement benefits to nearly 60,000 members and retirees. The agency administers eight retirement plans and is dedicated to customer service, member education, and operational efficiency.  Why should you keep...

  • Health Services Data Analyst

    1 month 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

    1 month 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 Analyst

    4 weeks ago

    Helena, United States State of Montana Full time

    The Montana Public Employee Retirement Administration (MPERA) is committed to providing secure and sustainable retirement benefits to nearly 60,000 members and retirees. The agency administers eight retirement plans and is dedicated to customer service, member education, and operational efficiency. Why should you keep reading and consider working here? We...

  • IT Systems Administrator 2

    1 month 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,...