Business Intelligence Analyst at AAA Oregon-Idaho

Harrisburg, Pennsylvania, United States -

Full Time

Start Date

Immediate

Expiry Date

12 Jun, 26

Salary

0.0

Posted On

14 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, DAX, Power Query (M), SQL, Dimensional Modeling, Data Warehousing, ETL/ELT, Azure Data Factory, Data Governance, Exploratory Data Analysis, Data Storytelling, Agile, Stakeholder Management, Jira, Statistical Profiling, Row-Level Security

Industry

Consumer Services

Description

At AAA Central Penn, we exist for our members and will judge everything we do by how well it serves their needs. We also strive to provide the same high-quality care and support to our team members. Whether it is through our recognition programs, engagement opportunities, or working as a team to help better our community, we love what we do and want our team members to have FUN at work. We work hard to serve our members, but we also work hard to make sure our team members are taken care of and have an inclusive, open, and flexible work culture. Team Member Focused 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! Why you will love your job: 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. What you will be doing: * 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. 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 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. * 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.

Responsibilities

The Business Intelligence Analyst will collaborate with stakeholders to define requirements, design, build, and maintain Power BI dashboards and reports using DAX and Power Query. Responsibilities also include writing optimized SQL queries, applying dimensional modeling, ensuring data governance, and promoting self-service analytics across the organization.