Business Intelligence Developer

AAA Central Penn•Harrisburg, PA

About The Position

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.

Requirements

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.
Solid understanding of data warehousing concepts, including dimensional modeling and slowly changing dimensions, and ETL/ELT patterns.
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.

Nice To Haves

Familiarity with Azure data services such as Azure Data Factory, Synapse Analytics, and Databricks (preferred).
Experience with scripting languages (e.g., Python or R) and integrating data via REST APIs (preferred).
Experience in membership-based organizations is a plus.

Responsibilities

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.

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!