Business Intelligence Analyst -… at AAA Central… · Harrisburg

BUSINESS INTELLIGENCE ANALYST - HARRISBURG, PA Full Time · Location: Harrisburg, PA, US Love finding the story behind the data? At AAA Central Penn, we're more than Roadside Assistance. We're a team of innovators, problem-solvers, and data-driven professionals working together to improve the member and employee experience. In this role, you'll turn data into actionable insights, build reporting tools that teams trust, and help leaders make informed decisions that drive our business forward. This position is based in Harrisburg, Pennsylvania. Competitive compensation commensurate with experience. How You'll Make an Impact • Turn data into clear, meaningful insights that help drive business decisions. • Create dashboards and reports that make it easy for leaders to understand performance. • Improve data quality, consistency, and documentation to build confidence in reporting. • Help employees access and use data through self-service tools, training, and support. • Promote a strong data-driven culture by making information more accessible across the organization. What You'll Do Analyze & Report Data • Partner with business teams to understand reporting and analytics needs. • Define key metrics, KPIs, and reporting requirements. • Explore and validate data to identify trends, opportunities, and potential issues. • Perform ad hoc reporting and data analysis to support business initiatives. Build Dashboards & Reporting Solutions • Develop and maintain Power BI reports, dashboards, and datasets. • Use DAX, Power Query (M), and data modeling to create reliable reporting solutions. • Create clear, user-friendly visualizations that help teams make informed decisions. • Manage Power BI workspaces and publishing to ensure reports are organized and accessible. Support Data Infrastructure • Write and optimize SQL queries and database views. • Partner with the Business Intelligence Developer to support ETL/ELT processes and data integration. • Apply data warehouse best practices, including star and snowflake schema design. • Configure security, data refresh schedules, gateways, and reporting performance enhancements. Improve Data Governance & Adoption • Create and maintain data dictionaries, business glossaries, and documentation. • Monitor dashboard usage and gather feedback to improve reporting solutions. • Support user training and encourage adoption of self-service analytics tools. • Follow data privacy, security, and compliance requirements. What You'll Bring Required Qualifications • Bachelor's degree in Information Technology, Business Analytics, Computer Science, or a related field, or an equivalent combination of education and experience. • 2-5 years of experience in business intelligence, data analytics, business analysis, or a related role. • Experience building reports and dashboards using Microsoft Power BI. • Strong SQL skills and experience working with relational databases. • Understanding of data modeling, data warehousing, ETL/ELT processes, and data governance principles. • Strong analytical, problem-solving, and critical-thinking skills. • Ability to translate business needs into reporting and analytics solutions. • Excellent communication skills and the ability to work with both technical and non-technical teams. • Proficiency with Microsoft 365 applications, including Excel, Outlook, Word, PowerPoint, Teams, and SharePoint. • Valid driver's license with the ability to travel within Pennsylvania. Preferred Qualifications • Experience with Azure data services. • Experience using project management tools such as Jira. • Familiarity with Agile, Waterfall, or hybrid project methodologies. • Experience working in a membership-based organization. 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.