You are viewing a preview of this job. Log in or register to view more details about this job.

Business Intelligence Developer

AAA Central Penn
Email

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.