AAA Central Penn · 9 hours ago
Business Intelligence Developer
Harrisburg, PA, US
Full-time
Onsite
Entry, Mid Level
2+ years expAAA Central Penn is dedicated to providing high-quality care and support to its members and team members. The Business Intelligence Developer will turn data into meaningful insights, working with various teams to create impactful dashboards and reports, ensuring data accuracy and accessibility.
Consumer Services
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
Qualification
Required
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
Proficiency with Microsoft 365 applications, including Outlook, Word, Excel, PowerPoint, SharePoint, and Teams
Valid driver's license with the ability to travel in-state
Preferred
Familiarity with Azure data services such as Azure Data Factory, Synapse Analytics, and Databricks
Experience with scripting languages (e.g., Python or R) and integrating data via REST APIs
Knowledge of project management tools (Jira preferred) and methodologies such as Agile, Waterfall, or hybrid approaches
Experience in membership-based organizations is a plus
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!
Company
AAA Central Penn
AAA Central Penn serves members in Adams, Cumberland, Dauphin, Huntingdon, Juniata, Lancaster, Lebanon, Mifflin, and Perry counties.
201-500 employees
Funding
Current Stage
Growth StageLeadership Team
Jodie Daubert
President & CEO
Greg Tobin
Chief Sales & Member Experience Officer
Company data provided by crunchbase