Business Intelligence Analyst

Benda Infotech; Chicago (IL); On-site; USD 80,000 - 110,000; Full time

Job summary

Benda Infotech is seeking a Business Intelligence Analyst to design, develop, and implement Power BI reports and analytics solutions for leadership across the organization.

You will collaborate with business and technical teams, gathering data, applying DAX and SQL, and delivering meaningful insights to guide strategic decisions within the analytics lifecycle.

Qualifications

• Bachelor’s degree in analytics, information systems, math, stats, finance or related field.
• Experience with BI/data warehouse tools and Power BI Paginated Reports.
• Experience with the Snowflake platform and analytics lifecycle.
• Knowledge of Power BI data querying and modeling (relationships, measures).

Responsibilities

• Develop Power BI dashboards for unit leaders delivering timely data, KPIs and insights.
• Collaborate with business units to gather and transform relevant datasets.
• Communicate with business and technical teams to solve data problems.
• Use DAX, M, SQL to expand reporting capabilities and optimize analytics.
• Perform ad-hoc analyses to support strategic initiatives.
• Maintain data and reporting documentation.
• Serve as Power BI SME and provide user support enterprise-wide.
• Complete monthly regulatory training and adhere to policies.

Skills

Power BI

SQL

Python/R

Data visualization

Analytical skills

Excel

Communication

Project management

Education

Bachelor's Degree in Analytics

Tools

Snowflake

Paginated Reports

Data warehousing tools

Power BI Service

Job description

Full Job Description

Summary

The Business Intelligence Analyst will leverage their business and technical knowledge to design, develop, and implement reports and analytics solutions in Power BI. Will work with business and technical teams to understand business strategy and objectives, gather information, and ensure business needs are being met throughout the analytics lifecycle. This role is a unique opportunity to deliver valuable content, insights and analysis for business unit leadership across the Bank. The Business Intelligence Analyst will develop and provide significant business insights to help business leaders make better decisions. With a good eye for business, you'll partner with internal stakeholders and help execute our strategic objectives.

Responsibilities

• Develop Power BI dashboards for Business Unit Leaders across the organization that deliver timely and accurate data, performance indicators, and insights.
• Build relationships and collaborate with Business Unit Leaders and internal clients to understand, gather, clean, and transform relevant datasets required to meet reporting and analytical objectives.
• Effectively communicate and interact with business and technical personnel to solve complex data problems.
• Utilize Power BI, DAX, M, and SQL to expand and optimize the Bank’s portfolio of enterprise reporting and analytics. Improve the bank’s capabilities and processes by researching, presenting, and implementing new Power BI product features.
• Perform quantitative and qualitative ad-hoc analysis to support strategic initiatives. This analysis may include analyzing trends and synthesizing multiple datasets to uncover valuable insights.
• Build and maintain clear and relevant data and reporting documentation as needed.
• Independently handle complex issues with minimal supervision, while escalating and communicating significant issues appropriately.
• Ability to serve as a Power BI application subject matter expert and provide assistance, troubleshooting and support for users across the enterprise.
• Understand, communicate, and instill the Company’s mission, vision, and values (Pillars of Success).
• Complete monthly training in a timely manner to ensure knowledge of bank regulatory requirements, policies, and procedures.
• Working at the worksite during regular business hours and/or assigned hours.
• Other specified duties as assigned

Skills

• Strong attention to detail and ability to complete work accurately.
• Ability to organize work.
• Basic skills with SQL, Python and/or R for gathering data and automating processes and analytics.
• Demonstrated skill with DAX, M to gather, transform and visualize data to uncover emerging trends and important patterns in the business.
• Strong analytical and research skills.
• Skilled in Microsoft Excel and PowerPoint.
• Able to prioritize and manage competing projects.
• Strong written and verbal communication skills, required.

Proficient in Microsoft Office suite of products.

Education & Experience

• Bachelor’s Degree in Analytics, Information Systems, Mathematics, Statistics, Business, Finance, Accounting, or related field, required.
• Working knowledge of BI/data warehouse tools and functionality.
• Experience with Power BI Paginated Reports.
• Passion for analysis and design; candidate needs to synthesize datasets to develop and deliver data visualizations that can clearly illuminate key insights for end users.
• Experience with the complete analytics implementation lifecycle. Gathering and transforming data, building reports and dashboards, troubleshooting, data validation, and ensuring solution meets business needs.
• Experience with the Snowflake platform.
• Knowledge of Power BI data querying and modeling (relationships, calculated columns, measures).

Compensation & Benefits

Full‑time associates are eligible for our benefits package:

• Medical
• Dental
• Vision
• 401(k) plan
• Company paid life insurance
• Short and Long-term disability insurance

Company paid vacation, paid leave and holidays

This position will remain open until a qualified applicant is hired.