Nonexempt Designated in Connect 700 Program for Applicants with
Disabilities:
Yes The work you'll do is more than just a job. At the State of Minnesota, employees play a critical role in developing policies, providing essential services, and working to improve the well-being and quality of life for all Minnesotans. The State of Minnesota is committed to equity and inclusion, and invests in employees by providing benefits, support resources, and training and development opportunities. Job Summary The Public Employees Retirement Association (PERA) is a lifetime income, cost-sharing retirement plan for Minnesota public employees. We serve over 440,000 current and former public employees from 2,100 governmental agencies and pay monthly benefits to more than 120,000 retirees, disabled members, and survivors of deceased members. Our members are social workers, firefighters, nurses, police officers, correctional officers, snowplow drivers, attorneys, and paraprofessionals. The services they provide and the work they do make our communities better. PERA offers free employee parking in an attached parking ramp. Join our team! About the Opportunity At PERA, meaningful work meets a supportive team environment. Join a collaborative public service organization dedicated to strengthening the retirement security of Minnesota's public employees. The Business Intelligence Engineer exists to provide agency-wide support to management and business users by creating and maintaining architecture for optimal extraction, transformation and loading of data from various sources into a suitable environment for business intelligence. Duties include data warehousing, dimensional modeling, and preparation of data for downstream analysis. Researches and recommends new technologies and tools for managing and automating processes pertinent to business intelligence. This position is telework eligible and offers a hybrid work schedule, based on agency and department needs and other dependencies. Scheduled in-office workdays will be at PERA's office at 60 Empire Drive, Suite 200, St. Paul, Minnesota 55103. Candidates residing in Minnesota within 50 miles of our St Paul office may be eligible to telework up to 50%. Candidates residing in Minnesota and more than 50 miles from our office may be eligible to telework more than 50%. Candidates residing in a bordering state within 50 miles of our office may be eligible to telework up to 50%. Candidates who do not reside in Minnesota or within 50 miles of the office in a state bordering Minnesota are not eligible to be hired, unless planning to relocate within 50 miles of the office or report to the office full time. Qualifications Minimum Qualifications Three (3) years in reporting, query tools and practices, procedures in compiling, tabulating and verifying statistical data, and schema design for business intelligence and reporting needs. Infrastructure engineering data preparation and pipeline development as well as maintenance of data records. Years of experience must also demonstrate the following: Experience in creating and managing data architectures. Experience with SQL development and understanding of relational databases. Experience with Microsoft PowerBI. Experience in programming languages such as Python and Spark. Commitment to a respectful, inclusive and diverse work environment. Preferred Qualifications Bachelor's Degree in Computer Science, Management Information Systems, Data Analytics/Data Science, or Mathematics. Experience with Microsoft PowerBI semantic modeling. Experience with ETL (Extract, Transform and Load) concepts. Experience with Azure Synapse or Azure Fabric. Experience with version control systems such as Git. Experience with pension/retirement industry including defined contribution plans and defined benefit plans. Additional Requirements It is the policy of the Retirement Systems of MN that all employees submit to a background investigation prior to employment. The background check may consist of the following components: SEMA4 Records Check (applies to current and past State employees only) Criminal History Check Employment Reference Check Social Security and Address Verification Education Verification Driver's License Check •The Retirement Systems will not sponsor applicants for work visas. All applicants must be legally authorized to work in the US. Application Details How to Apply Select "Apply for Job" at the top of this page. If you have questions about applying for jobs, contact the Careers Help Desk at 651-259-3637 or email careers@state.mn.us. For additional information about the application process, go to http://www.mn.gov/careers. Contact Contact PERA Human Resources at PERAHR@mnpera.
org if:
You have questions about this position You are an individual with a disability and need to request an accommodation for a scheduled interview You wish to receive consideration as a Connect 700 Program applicant, apply online, e-mail the Job ID#, the Working Title and your valid Proof of Eligibility Certificate by the closing date to PERAHR@mnpera.org. Veterans To be considered for any Veteran's Status, you MUST indicate this on your application.
RECENTLY SEPARATED VETERANS
(RSV): Effective July 1, 2009, legislation provides that the top five RSV applicants who apply and meet the qualifications for a vacancy shall be granted an interview.
You must:
1. Meet all Minimum Qualifications identified in this posting. 2. Meet all of the RSV criteria. 3. Submit a copy of your DD-214 form by the closing date to: PERAHR@mnpera.org
CERTAIN DISABLED VETERANS
Effective August 1, 2012, legislation provides state agencies with the option to appoint certain disabled veterans on a noncompetitive basis if you: 1. Meet service requirements and have a verified service-connected disability rating of at least 30%. 2. Provide qualifying documentation verifying the disability. 3. Meet all Minimum Qualifications identified in this posting. 4. You must submit all documentation by the closing date to: PERAHR@mnpera.org About Public Employees Retire Assoc The Public Employees Retirement Association (PERA) administers and promotes sustainable retirement plans and provides services our members value. We administer three cost-sharing, multiple-employer defined benefit plans; one agent, multiple-employer plan; and a defined contribution plan. These programs are tax-qualified retirement plans under Section 401(a) of the Internal Revenue Code. PERA serves almost 500,000 current and former public employees from 2,100 governmental agencies. We pay monthly benefits to more than 135,000 retirees, members who are disabled, and survivors of deceased members. Our 185,000 active members include social workers, firefighters, snowplow drivers, nurses, jailers, attorneys, paraprofessionals, and police officers. They work in our parks, cities, counties, and schools across the state. The services they provide and the work they do make our communities better. While PERA receives some State aid, expenses such as benefits, payroll, and other administrative costs are funded by investment earnings and employer and employee contributions. Working together to improve the state we love. What do Minnesota's State employees have in common? A sense of purpose in their work Connection with their coworkers and communities Opportunities for personal and professional growth Benefits As an employee, you'll have access to one of the most affordable health insurance plans in Minnesota, along with other benefits to help you and your family be well.
Your benefits may include:
Paid vacation and sick leave 12 paid holidays each year Low-cost medical, dental, vision, and prescription drug plans Fertility care, including IVF Diabetes care Dental and orthodontic care for adults and children 6 weeks paid leave for parents of newborn or newly adopted children Pension plan that provides income when you retire (after working at least three years) Employer paid life insurance to provide support for your family in the event of death Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury Tax-free expense accounts for health, dental, and dependent care Resources that provide support and promote physical, emotional, social, and financial well-being Support to help you reach your career goals: Training, classes, and professional development Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov) Employee Assistance Program (EAP) for work/life support: A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance Common sources of stress can be addressed through the
EAP:
mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues
Daily Living/Convenience Services:
Chore services, home repair, trip planning, child/elder care Programs, resources and benefits eligibility varies based on type of employment, agency, funding availability, union/collective bargaining agreement, location, and length of service with the State of Minnesota.
EQUAL OPPORTUNITY EMPLOYERS
Minnesota state agencies are equal opportunity, affirmative action, and veteran-friendly employers. State agencies are committed to creating a workforce that reflects the diversity of the state and strongly encourages persons of color and Indigenous communities, members of the LGBTQIA2S+ community, individuals with disabilities, women, and veterans to apply. The varied experiences and perspectives of employees strengthen the work we do together and our ability to best serve Minnesotans. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, sex (including pregnancy, childbirth, and disabilities related to pregnancy or childbirth), gender identity, gender expression, marital status, familial status, age, sexual orientation, status regarding public assistance, disability, veteran status or activity in a local Human Rights Commission or any other characteristic protected by law.
APPLICANTS WITH DISABILITIES
Minnesota state agencies make reasonable accommodations to their employees and applicants with disabilities. If you have a disability and need assistance in searching or applying for jobs with the State of Minnesota, call the Careers Help Desk at 651-259-3637 or email careers@state.mn.us and let us know the support you need.
