Database Analyst Associate

Work for Indiana
Grow your career with the State of Indiana! With more than 50 executive branch agencies, the State of Indiana is a diverse workforce offering employees stimulating and challenging projects across a broad scope of career opportunities. As a State of Indiana employee, you impact the well-being of Indiana's communities every day.
At the State of Indiana, we don't just talk about diversity and inclusion - Our goal is to create a welcoming, accessible, and equitable workplace, with a workforce that is representative of the State of Indiana population. As a proud equal opportunity employer, reasonable accommodations may be available to enable individuals with disabilities to complete the application and interview process, as well as perform the essential functions of a role.
Next Level benefits at the State of Indiana are here! Be sure to review our expanded benefit package offerings below.
About the Indiana Department of Education (IDOE):
The Indiana Department of Education provides innovative support to Indiana schools, teachers, students, and parents. We proactively work with educators, policymakers, business leaders, and community-based organizations to build student success. Our strategic priorities include:

• Delivering quality, purposeful educational opportunities for each student
• Elevating and supporting Indiana's educators
• Increasing partnerships and delivering aligned, effective, and efficient support

Salary:
This position traditionally starts at an annual salary of $49,114. Salary for this position may be commensurate with education and job experience.
Role Overview:
The Database Analyst Associate will use best practices and technologies to provide readily available data for staff and for external data requesters. You will collaborate with departments to identify data needs, create reports, and manage databases. You will improve data quality, data standardization, and data integration across systems.
The ideal candidate will have experience working with SQL Server (SSRS, SSIS) and T-SQL query writing skills, experience with PowerBI is a plus or similar BI platform, as well as experience with issues surrounding large datasets. In addition, the candidate will have the ability to display data in a user-friendly way.
A Day in the Life:
The essential functions of this role are as follows:

• Assists in the design, implementation, and maintenance of logical and physical databases;
• Works with team to determine aggregation, partitioning, and indexing strategies for physical data;
• Administers end-user access and security at the database level;
• Ensures that data is appropriately protected via database backup and related strategies;
• Assists in the load process of database software and application of fixes;
• Assists with the evaluation and selection of infrastructure components;
• Provides operational support for the database ensuring data integrity, database availability, and performance;
• Creates and maintains general utility programs;
• Provides technical assistance to application programmers as needed;
• Monitors system performance in selected areas and implements necessary changes to improve performance when possible;
• Studies hardware/software proposals to determine the impact on existing configurations;
• Provides technical assistance to, and written guidelines for, operations personnel as needed;
• Researches new techniques and technical developments to be utilized by operations to enhance systems performance.

The job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee. Other duties, responsibilities, and activities may change or be assigned at any time.
What You'll Need for Success:
The ideal candidate in this role should minimally have either:

• a Bachelor's Degree with 3+ years of experience, or
• an Associate's Degree with 5+ years of experience, or
• at least 7+ years of experience applying the below, outlined knowledge, skills, and abilities in a similar role.
• Related certifications and coursework may be considered for education or experience.

Skills sets:

• Working knowledge of relational database design techniques;
• Working knowledge of a variety of computer languages;
• Working knowledge of computer hardware/software capabilities and configurations;
• Working knowledge in software and utilities related to supported Data Base Management Systems (DBMS) such as Reorg, Backup, Recovery, Load, Unload;
• Ability to apply theories, principles, and methodologies to existing and new computer hardware/software;
• Ability to write database computer programs, macros, subroutines, and utilities in a variety of languages;
• Effectively communicate, both orally and in writing;
• Ability to apply advanced logic;
• Ability to participate in multiple hardware/software projects and priorities;
• Ability to read and understand complicated technical manuals on programming and systems analysis.

Supervisory Responsibilities/Direct Reports:
This role may be utilized in a supervisory capacity based on agency needs.
Benefits of Employment with the State of Indiana:
The State of Indiana offers a comprehensive benefits package for full-time employees which includes:

• Three (3) medical plan options (including RX coverage) as well as vision and dental plans
• Wellness Rewards Program: Complete wellness activities to earn gift card rewards
• Health savings account, which includes bi-weekly state contribution
• Flexible work scheduling options, including the potential for hybrid remote work for employees whose work may be performed outside state facilities
• Deferred compensation 457B account (similar to 401k plan) with employer match
• Two (2) fully-funded pension plan options
• A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to:
  • 150 hours of paid new parent leave
  • Up to 15 hours of paid community service leave
  • Combined 180 hours of paid vacation, personal, and sick leave time off
  • 12 paid holidays, 14 on election years
• Education Reimbursement Program
• Group life insurance
• Referral Bonus program
• Employee assistance program that allows for covered behavioral health visits
• Qualified employer for the Public Service Loan Forgiveness Program
• Free Parking for most positions
• Free LinkedIn Learning access

Equal Employment Opportunity:
The State of Indiana is an Equal Opportunity Employer and is committed to recruit, select, develop, and promote employees based on individual ability and job performance. Our policy is to provide equal employment opportunity to all people in all aspects of employer-employee relations without discrimination because of race, color, creed, religion, sex, national origin, ancestry, age, sexual orientation, gender identity, physical or mental disability, or veteran status. We will comply with the spirit as well as the letter of all applicable state and federal laws.
If you are a qualified individual with a disability and require reasonable accommodation in completing this application, you can request assistance by contacting the Indiana State Personnel Department at [email protected].
The State of Indiana has established a culture that welcomes equity, inclusion, and opportunity for all employees and applicants. We encourage you to apply if you feel you have the transferrable skills to be successful in this position and we look forward to reviewing your application.
Current Employee? Click here to apply.