IMRF is looking to solve the problem of providing data analytics support to its business community by designing programs, reports, dashboards, and data extractions.
Requirements
- 3 years of intermediate SQL
- Proficiency in MSOffice Suite – such as Excel (formulas, calculations, charts, graphs, pivot tables, etc.), Visio, and PowerPoint skills
- Experience with Business Intelligence (BI) tools including Power BI and Power Automate
- Familiarity with scripting and automation
- Familiarity with various programming languages, such as Python
- Knowledge of project management tools, project methodology, technique and practices
Responsibilities
- Identify important data which includes the entire process of collecting, linking, cleaning, enriching, transforming, and augmenting internal information while being sensitive to security and privacy
- Generate and collect relevant data from sources contained in the IMRF line of business application, public website and secure websites
- Use data analytical expertise and business knowledge to extract insights from data and enrich data collected by IMRF
- Responsible for creating, maintaining, analyzing and updating reports and data tables
- Work with data to create advanced charts, tables, graphs and automation, including data refresh schedules and delivery methods
- Detect flaws in data records and lead correction processes
- Work with the Information Technology Department to specify and maintain data warehouses
Other
- Effective communication skills (both oral and written), including effective personal and interpersonal skills
- Must have the ability to work within a team environment and build relationships internal and external
- Must have the ability of leading through influence and driving new capabilities and new ways of thinking into the organization
- Bachelors’ Degree in relevant field (Information Science, Computer Science, Actuarial Science, Statistics, Finance or Mathematics)
- Flexibility to work extended days (over 7 hours per day) and extended workweeks (over 5 days per week)
