Business Intelligence Analyst - Harrisburg, PA

Job Title

This position is based in Harrisburg, Pennsylvania. To be considered for this role, candidates should reside in Pennsylvania and be able to work on-site up to 25% of the time.

AAA Central Penn is so much more than Roadside Assistance! Behind the scenes, our talented teams are driving innovation every day. Join our IT team and help turn data into unforgettable "Aha!" moments that make a real impact.

Make Data Make Sense

Numbers are just the beginning. In this role, you will turn data into insights, build tools teams can trust, and help leaders see the full story behind the numbers—all while making a real impact across the organization.

How You'll Make an Impact

• Turn complex data into clear, meaningful insights that support smarter business decisions
• Help leaders and teams understand performance through easy-to-use dashboards and executive-ready visuals
• Build trust in data by improving quality, consistency, and documentation
• Empower employees with self-service analytics, certified datasets, templates, training materials, and ongoing support
• Promote strong data habits and make information more accessible across the organization

What You'll Do

• Partner with business teams to understand their analytics needs, gather requirements, and help define KPIs, metrics, and data models
• Build, enhance, and maintain Power BI datasets, reports, and dashboards using DAX, Power Query (M), and well-designed data models
• Manage Power BI publishing and workspace content to keep dashboards organized and easy to access
• Write and improve SQL queries and views to support reporting and insights
• Collaborate with the Business Intelligence Developer to support reliable ETL/ELT pipelines using tools like Azure Data Factory
• Apply data warehousing best practices, including star and snowflake schemas, to create scalable, high-performing solutions
• Configure row-level security, data refresh schedules, gateways, and performance improvements such as aggregations and incremental refresh
• Create and maintain data governance resources, including business glossaries, data dictionaries, and documentation
• Explore and validate data to identify trends, spot issues, and recommend solutions
• Monitor BI usage and adoption, gather feedback, and continuously improve solutions using Agile practices
• Support ad-hoc analysis, data investigations, and cross-functional initiatives
• Ensure compliance with data privacy, security, and regulatory requirements

What You Bring to the Table:

• Bachelor's degree is Information Technology, Business Analytics, Computer Science or related fields, or a combination of education and experience.
• 2-5 years of experience 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.
• Experience in membership-based organizations is a plus.

About AAA of Central Pennsylvania

For over 100 years the name AAA has been synonymous with exceptional service. Whether it be roadside assistance, travel, financial products, or insurance nationally we have over 60 million members who appreciate the value and peace of mind that our services provide. Come join our team and be a part of the AAA legacy!

Work Culture

Here at AAA Central Penn, we value our sense of community which is evident in the events planned throughout the year. We value diversity and create an environment where everyone can be their true selves and every voice matters.

AAA Cares: AAA Central Penn has a proud tradition of supporting local non-profit organizations that have a positive community impact. In fact, commitment to the community is one of our core values that guide our efforts to meet the needs of members and the communities we serve. AAA Cares promotes volunteerism and rewards team members with volunteer activity. The initiative is team member-driven, team-spirited, and solidly supported by AAA Central Penn leadership.

Employee Engagement Activities: We love what we do and we're proud of our team. We recognize birthdays and employee anniversaries. We also have quarterly and annual recognition events, contests and trivia, an annual company-wide event, and many other opportunities to share our appreciation. Not only is this company-wide, but individual departments and offices as well. We also have opportunities to be involved with various committees that focus on topics like employee safety, wellness, and engagement.