Senior Business Systems Analyst: Power BI & Automation

SGS Consulting

Alton (IL)

Hybrid

USD 85,000 - 120,000

Full time

4 days ago

Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

SGS Consulting is seeking a data and reporting-focused professional to build and optimize automated reporting solutions using Microsoft Power Platform within a hybrid environment in downtown Chicago.

You will translate complex business requirements into scalable technical solutions, work hands-on with Power BI, Power Apps, Power Automate, Power Query, and Dataverse, and collaborate with stakeholders to drive process automation and data integrity.

Qualifications

Bachelor's degree or equivalent in a technical/business field.
Experience delivering data-driven reporting solutions using Power Platform.
Strong data analytics, data governance awareness, and problem-solving skills.

Responsibilities

Build, maintain, and enhance automated reporting solutions.
Translate business requirements into technical data-driven solutions.
Work with Microsoft 365 technologies and Power Platform.
Ensure data integrity, accuracy, and reliability across reporting solutions.
Take ownership of projects from requirements through implementation.
Collaborate with stakeholders to define requirements and priorities.
Develop Power BI reports, dashboards, and Power Apps solutions.
Apply DAX, Power Query, and M code for data transformation and calculations.

Skills

Business Systems Analysis

Business Systems Development

Data Analysis and Data Solutions

Data Reporting

Data Integrity

Data Validation

Data Transformation

Business Requirements Gathering

Requirements Analysis

Microsoft Power Apps

Microsoft Power Automate

Microsoft Power BI

Power Query

M Code

DAX

Microsoft Dataverse

Microsoft 365

Low-Code Development

Low-Code Business Solutions

Workflow Automation

Process Automation

Reporting Automation

Dashboard Development

Financial Reporting

Investment Reporting

Finance Concepts

Investment Concepts

Database Schemas

Relational Data Structures

Relational Databases

Business Process Improvement

Technical Solution Development

AI and Automation Opportunities

Data Quality Management

Data Governance Awareness

Application Development

Report Development

Data Sourcing

Data Modeling

Data Visualization

Troubleshooting

Technical Documentation

Stakeholder Management

Problem Solving

Analytical Skills

Microsoft Office

Independent Work

Cross-Functional Collaboration

Education

Bachelor's degree in Computer Science, Information Technology, Business Systems, Engineering, Finance, or a related technical/business field

Finance-background candidate may be considered if they have relevant work experience with technical skills

Tools