Senior Business Systems Analyst: Power BI & Automation

SGS Consulting; Springfield (IL); Híbrido; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

SGS Consulting seeks a Data & Reporting Specialist to design, implement, and optimize automated reporting and data solutions within a Microsoft 365 environment. You will gather requirements, translate them into scalable Power Platform solutions, and own projects from inception to delivery.

Responsibilities include building dashboards, automating workflows, and maintaining data quality across reporting processes in a hybrid Chicago setting. Collaboration with stakeholders is essential to success.

Formación

• Bachelor's degree required or equivalent experience in a technical/business field.
• Experience translating business requirements into data-driven technical solutions (Power Platform preferred).
• Experience building automated reporting solutions and dashboards in a Microsoft 365 / Power Platform environment.

Responsabilidades

• Build and maintain automated reporting solutions using Power BI, Power Apps, Power Automate, and related tools.
• Translate business requirements into scalable data-driven solutions and workflows.
• Work with Microsoft 365 data sources, Dataverse, and Power Query M code to prepare data for reporting.
• Ensure data integrity, validation, and reliability across reporting solutions.
• Collaborate with stakeholders to define requirements and deliver impactful reporting and automation.
• Own data and reporting projects from requirements through implementation in a hybrid Chicago environment.

Conocimientos

Business Analysis

Requirements Gathering

Data Solutions

Data Reporting

Data Integrity

Data Validation

Data Transformation

Low-Code Development

Power Apps

Power Automate

Power BI

Power Query M Code

DAX

Dataverse

Microsoft 365

AI and Automation

Process Automation

Workflow Automation

Dashboard Development

Financial Reporting

Investment Reporting

Relational Databases

Data Modeling

Data Visualization

Troubleshooting

Documentation

Stakeholder Management

Analytical Skills

Independent Work

Cross-Functional Collaboration

Educación

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

Descripción del empleo

SGS Consulting seeks a Data & Reporting Specialist to design, implement, and optimize automated reporting and data solutions within a Microsoft 365 environment. You will gather requirements, translate them into scalable Power Platform solutions, and own projects from inception to delivery.

Responsibilities include building dashboards, automating workflows, and maintaining data quality across reporting processes in a hybrid Chicago setting. Collaboration with stakeholders is essential to success.