Power BI Analyst

• South Bend
• On-site

Power BI Analyst
This is located in South Bend IN 46601
The ideal candidate is a strong analytical thinker with hands-on experience in Power BI SQL data modeling and reporting automation. This person should be comfortable working with both technical and non-technical stakeholders and translating complex data into clear actionable business insights.
Key Responsibilities
Business Intelligence & Reporting
Design develop and maintain enterprise dashboards reports and analytical tools using business intelligence platforms preferably Power BI
Partner with business leaders and internal teams to gather document and translate reporting requirements into scalable BI solutions
Build reporting solutions that support users at multiple levels from individual contributors to executive leadership
Translate complex data findings into executive-level insights recommendations and decision-support materials
Present analytics outcomes directly to leadership and business stakeholders

Data Modeling Governance & Standards
Own the design and ongoing evolution of enterprise BI data models semantic layers and KPI definitions
Define and maintain BI standards naming conventions performance optimization practices and governance controls
Support consistent KPI definitions and reporting logic across departments
Serve as a steward of sensitive business data ensuring proper handling storage and distribution of confidential internal and external datasets

Data Warehousing & Data Quality
Partner with IT teams on data warehouse architecture optimization and ongoing enhancement
Acquire data from internal and external sources and support the integration of that data into enterprise reporting environments
Monitor data quality and integrity working with stakeholders to identify and resolve discrepancies
Perform data profiling to validate business requirements test assumptions and identify data or process gaps

AI Automation & Advanced Analytics
Leverage embedded AI and machine learning capabilities within BI tools to support predictive insights anomaly detection automated alerts and natural language query functionality
Use Generative AI tools to accelerate SQL query development scripting documentation and analytics workflows
Evaluate and recommend new BI tools features and analytics capabilities that improve reporting efficiency and business outcomes

Enablement & Continuous Improvement
Serve as a subject-matter expert for Power BI SQL analytics best practices and reporting standards
Lead training initiatives to improve analytics maturity across business teams
Share best practices and insights that promote a culture of continuous improvement
Participate in special projects and support additional data or reporting initiatives as needed

Required Qualifications
Experience
2 years of experience delivering business intelligence solutions using the Microsoft BI stack
2 years of experience writing maintaining and debugging SQL queries
Experience designing dashboards reports KPIs and data models for business users
Education
Bachelors degree in Data Science Business Mathematics Information Systems or a related field preferred
Equivalent professional experience may be considered

Technical Skills
Proficiency with business intelligence and visualization tools preferably Power BI
Strong SQL skills including querying troubleshooting and data validation
Experience working with large-scale public private or proprietary datasets
Ability to analyze data sources and business requirements to build accurate enterprise data models and KPIs
Experience using Generative AI tools to support SQL development scripting and technical documentation
Cloud architecture or cloud administration experience is a plus

Business & Communication Skills
Ability to explain complex technical information clearly to non-technical audiences
Strong written and verbal communication skills
Comfortable collaborating with executive leaders business teams IT and external stakeholders
Self-directed problem-solver with strong planning organization and prioritization skills
Ability to work independently and deliver high-quality results under tight deadlines
Professional collaborative and service-oriented approach

Work Environment
Standard office environment
Role may require extended periods of sitting and working at a computer
Uses standard business technology including computer equipment office phone and mobile device

What Success Looks Like
Business leaders have timely accurate and trusted reporting to support decision-making
Dashboards and reports are automated easy to use and aligned with enterprise KPI definitions
Data quality issues are identified addressed and reduced over time
BI standards and governance practices are clearly defined and consistently followed
Users across the organization become more confident and capable in using data to make decisions

Ideal Profile
Analytical detail-oriented and business-minded
Strong Power BI and SQL practitioner with a passion for clean accurate reporting
Comfortable working with executives as well as operational teams
Able to turn ambiguous reporting needs into clear dashboards and insights
Curious about emerging BI AI and automation capabilities
Focused on continuous improvement and practical business impact
Boolean strings
Power BI / SQL core search
(Business Intelligence Analyst OR BI Analyst OR Power BI Analyst OR Reporting Analyst OR Data Analyst) AND (Power BI OR PowerBI) AND SQL AND (data model OR data modeling OR semantic layer OR DAX OR KPI OR KPIs)
Microsoft BI stack search
(Business Intelligence OR BI OR Reporting OR Analytics) AND (Power BI OR SSRS OR SSIS OR SSAS OR Microsoft BI OR Microsoft Business Intelligence) AND SQL AND (dashboard OR dashboards OR reports OR reporting)
Executive reporting / KPI focused
(BI Analyst OR Business Intelligence Analyst OR Analytics Analyst OR Reporting Analyst) AND (executive reporting OR executive dashboard OR leadership reporting OR KPI dashboard OR KPI reporting) AND (Power BI OR Tableau) AND SQL
Data warehouse / semantic layer focused
(Power BI OR PowerBI) AND SQL AND (data warehouse OR data warehousing OR semantic model OR semantic layer OR enterprise data model OR star schema OR dimensional modeling) AND (dashboard OR reporting OR analytics)
Data quality / profiling angle
(BI Analyst OR Data Analyst OR Business Intelligence Analyst) AND (Power BI OR PowerBI) AND SQL AND (data quality OR data profiling OR data integrity OR data governance)
AI/GenAI plus search
(Business Intelligence Analyst OR BI Analyst OR Power BI Analyst OR Data Analyst) AND (Power BI OR PowerBI) AND SQL AND (Generative AI OR GenAI OR Copilot OR machine learning OR predictive analytics OR anomaly detection)
Broader candidate pool
(Data Analyst OR BI Developer OR Business Intelligence Developer OR Reporting Analyst OR Analytics Consultant) AND (Power BI OR PowerBI) AND SQL AND (dashboard OR reporting OR KPI OR data model)
LinkedIn Recruiter search string
(Business Intelligence Analyst OR BI Analyst OR Power BI Analyst OR BI Developer OR Reporting Analyst OR Data Analyst OR Analytics Analyst) AND (Power BI OR PowerBI) AND SQL AND (dashboard OR dashboards OR reporting OR data model OR DAX OR KPI OR semantic model OR data warehouse)
Relevant job titles
Business Intelligence Analyst

BI Analyst

Power BI Analyst

Power BI Developer

Business Intelligence Developer

BI Developer

Reporting Analyst

Data Analyst

Analytics Analyst

Data Visualization Analyst

Business Data Analyst

Business Reporting Analyst

Enterprise Reporting Analyst

Dashboard Developer

SQL Reporting Analyst

BI Consultant

Analytics Consultant

Data Warehouse Analyst

Decision Support Analyst

Management Reporting Analyst

KPI Analyst
Keywords to search for
Power BI

PowerBI

SQL

DAX

Power Query

M Query

Microsoft BI Stack

SSRS

SSIS

SSAS

Azure SQL

SQL Server

Data warehouse

Data warehousing

Data modeling

Semantic layer

Semantic model

Enterprise data model

Dimensional modeling

Star schema

KPI definitions

KPI reporting

Executive dashboards

Executive reporting

Leadership reporting

Dashboard development

Automated reporting

Data visualization

Data profiling

Data quality

Data integrity

Data governance

Data stewardship

Predictive analytics

Anomaly detection

Natural language query

Copilot

Generative AI

GenAI

Python scripting

Business requirements

Requirements gathering

Stakeholder management

Non-technical stakeholders

Training users

Analytics maturity