Business Intelligence Developer

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 Developer turns data into clear, meaningful insights that help teams make smarter decisions. You’ll work with Member Services, Insurance, Travel, and corporate groups to understand their needs and create impactful dashboards and reports. This role is all about helping the organization use data with confidence—ensuring information is accurate, accessible, and truly useful.

What you will be doing:

• Design, develop, and manage ETL/ELT data pipelines using tools like Azure Data Factory and SQL Server Integration Services to integrate data from core systems and external sources.
• Develop enterprise data models (e.g., star schemas) and Power BI semantic models; write efficient DAX and Power Query (M) scripts for calculations and data transformation.
• Design interactive dashboards and paginated reports following visualization best practices, ensuring accessibility and usability for a wide range of users.
• Implement Row-Level Security (RLS), manage workspace governance, and maintain compliance with data privacy regulations.
• Work closely with product owners and subject matter experts to gather requirements, create user stories, and deliver solutions using Agile methodologies; manage tasks in Jira.
• Tune SQL queries and data models for performance, monitor data refreshes, and troubleshoot production issues to meet service-level agreements (SLAs).
• Set up deployment pipelines and version control (Git) for consistent, reliable releases across development, testing, and production environments.
• Produce technical documentation, data dictionaries, and user guides to support self-service analytics.
• Contribute to data governance and quality initiatives (standards, lineage, and definitions) in collaboration with IT and business teams.
• Stay current with Microsoft analytics tools and features, recommending enhancements that improve reliability, security, and business value.
• Other duties as assigned.

What you bring to the table:

• Bachelor’s degree in Information Technology, Information Systems, Computer Science, Data Analytics or related field, or a combination of education and experience.
• 2-5 years of experience in business intelligence development, data analytics, or business analysis.
• Strong proficiency in SQL and experience with relational databases (e.g., SQL Server, Azure SQL).
• Advanced expertise in Microsoft Power BI, including data modeling, DAX, Power Query, workspace administration, and deployment pipelines.
• Familiarity with Azure data services such as Azure Data Factory, Synapse Analytics, and Databricks (preferred).
• Solid understanding of data warehousing concepts, including dimensional modeling and slowly changing dimensions, and ETL/ELT patterns.
• Experience with scripting languages (e.g., Python or R) and integrating data via REST APIs (preferred).
• Ability to translate business requirements into technical solutions; excellent communication and collaboration skills across IT and business teams.
• Knowledge of project management tools (Jira preferred) and methodologies such as Agile, Waterfall, or hybrid approaches.
• Proficiency with Microsoft 365 applications, including Outlook, Word, Excel, PowerPoint, SharePoint, and 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.