Business Intelligence Analyst

AAA Central Penn • Harrisburg, PA

7d

About The Position

The Business Intelligence Analyst helps teams make smarter decisions by turning organizational data into clear, meaningful insights. You’ll work closely with departments across the organization to understand what information they need and create easy‑to‑use dashboards and reports that support better service and stronger results. You’ll also help promote good data practices and make it easier for employees to access and use the information they need.

Requirements

• Bachelor’s degree is Information Technology, Business Analytics, Computer Science or related fields, or a combination of education and expereince.
• 2-5 years of expereince in business intelligence, data analytics, or business analysis.
• Advanced proficiency in Microsoft Power BI (Desktop and Service), including DAX, Power Query (M), data modeling, and performance optimization.
• Strong SQL skills (e.g., T-SQL) and experience with relational databases; familiarity with Azure data services is a plus.
• Solid understanding of data warehousing concepts, dimensional modeling (Kimball), ETL/ELT patterns, and data governance principles.
• Experience with project management tools (Jira preferred) and methodologies such as Agile, Waterfall, or hybrid approaches.
• Ability to translate business questions into metrics and analytics solutions; strong data storytelling and visualization skills.
• Strong analytical and problem-solving abilities, including comfort with exploratory data analysis and basic statistical techniques.
• Excellent communication and stakeholder management skills; ability to work effectively across IT and business teams.
• Proficiency with Microsoft 365 applications (Outlook, Word, Excel, PowerPoint, SharePoint, Teams).
• Valid driver’s license with the ability to travel in-state.

Nice To Haves

• Familiarity with Azure data services is a plus.
• Experience in membership-based organizations is a plus.

Responsibilities

• Collaborate with business stakeholders to gather, document, and prioritize analytics requirements; define KPIs, metrics, and data models.
• Design, build, and maintain Power BI datasets, reports, and dashboards using DAX, Power Query (M), and optimized data models; manage publishing and workspace content.
• Write and optimize SQL queries and views; partner with Business Intelligence Developer to build efficient ETL/ELT pipelines using tools like Azure Data Factory.
• Apply dimensional modeling techniques (star/snowflake schemas) and data warehousing best practices for scalable, high-performance solutions.
• Configure row-level security, data refresh schedules, gateway configurations, and performance optimizations (e.g., aggregations, incremental refresh) for BI assets.
• Develop and maintain data governance artifacts, including business glossaries, data dictionaries, and documentation to ensure data quality and trust.
• Perform exploratory data analysis and statistical profiling to validate data, detect anomalies, and recommend corrective actions.
• Deliver insights through presentations and storytelling and create executive-ready visuals tailored to business audiences.
• Promote self-service analytics by creating certified datasets, reusable templates, training materials, and providing user support.
• Monitor BI product adoption and usage; gather feedback and iterate using Agile practices.
• Ensure compliance with data privacy, security, and regulatory standards; follow change control and release management processes.
• Support ad-hoc analysis, data investigations, and cross-functional initiatives as needed.
• Other duties as assigned.

Benefits

• Generous, front-loaded Paid Time Off (PTO); no need to wait until you’ve accrued PTO to take that summer vacation.
• 1 personal day.
• 8 paid company holidays including Christmas Eve and New Year’s Eve.
• Medical, Dental, and Vision benefits.
• Health Savings Account (with employer contribution) and Flexible Spending Account options.
• 401(k) with up to 6% company matching, plus you are fully vested upon your first contribution.
• Life Insurance and Long Term Disability at no out of check cost to our team.
• Earn up to 3 extra PTO days a year for time spent volunteering in the community and attending AAA Cares events.
• Tuition Reimbursement.
• Free AAA Premier Membership.
• Discounts and perks including travel, branch services, car batteries, and more!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 101-250 employees