Systems Analyst II - Power BI & SQL Reporting (Hybrid)

Pontoon Solutions; Oakbrook Terrace (IL); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Long-term engagement

Career growth

Job summary

Pontoon Solutions in Oakbrook Terrace, IL is seeking a skilled Business Analyst II to support operations through data analysis, reporting, and dashboard development. You will partner with stakeholders to deliver actionable insights and scalable data solutions across multiple business functions.

The ideal candidate has 5+ years in analytics, strong SQL, and extensive Power BI experience, with a focus on transforming data into strategic decisions.

Qualifications

• 5+ years of experience in Business Analysis, Data Analysis, BI, or related analytics roles.
• Strong SQL development experience and query optimization.
• Advanced experience developing and maintaining Power BI dashboards.
• Experience with data transformation, data modeling, ETL, and reporting pipelines.
• Knowledge of relational databases and data architecture concepts.
• Excellent analytical, problem-solving, and communication skills.

Responsibilities

• Gather requirements from stakeholders and translate them into reports.
• Design, develop, and maintain Power BI dashboards and reports.
• Develop and optimize SQL queries for operational and business reporting.
• Perform data transformation, modeling, and ETL development.
• Build reporting pipelines to support ongoing operations.
• Analyze datasets and provide actionable business insights.
• Ensure data accuracy and consistency across reporting platforms.
• Support reporting initiatives for infrastructure, programs, asset management, and operations.
• Collaborate with technical and business teams to implement reporting improvements.

Skills

5+ years experience

SQL development

Power BI dashboards

Data transformation

Relational databases

Analytical skills

Education

Bachelor's degree in CS/IS/Data Analytics

Tools

SQL

Power BI

Databricks

Microsoft Fabric

Oracle

Azure

Job description

Pontoon Solutions in Oakbrook Terrace, IL is seeking a skilled Business Analyst II to support operations through data analysis, reporting, and dashboard development. You will partner with stakeholders to deliver actionable insights and scalable data solutions across multiple business functions.

The ideal candidate has 5+ years in analytics, strong SQL, and extensive Power BI experience, with a focus on transforming data into strategic decisions.