Business Intelligence Engineer - Information...

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

• Designated in Connect 700 Program for Applicants with Disabilities (https://mn.gov/mmb/careers/diverse-workforce/people-with-disabilities/connect700/) : 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.

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 (https://mn.gov/mmb-stat/policies/1422-telework.pdf) 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.