Remote Power Query Jobs in Pennsylvania (NOW HIRING)

Business Intelligence Developer

Full-Time | Professional
Location: Harrisburg, PA

Turn Data Into Meaningful Business Insights

We’re looking for a skilled and analytical Business Intelligence Developer to help transform complex data into clear, actionable insights that drive smarter business decisions. In this role, you’ll partner with cross-functional teams to build powerful dashboards, optimize reporting processes, and support data-driven strategies across the organization.

If you enjoy solving problems, building scalable data solutions, and making information accessible and impactful, this could be the perfect opportunity for you.

Why You’ll Love This Role

• Collaborative and supportive team environment
• Opportunity to work on impactful, enterprise-level data initiatives
• Flexible and inclusive workplace culture
• Career growth and professional development opportunities
• Meaningful work that directly supports business performance and decision-making

Benefits & Perks

• Generous front-loaded Paid Time Off (PTO)
• Personal day plus paid holidays
• Medical, Dental, and Vision insurance
• Health Savings Account (HSA) and Flexible Spending Account (FSA) options
• 401(k) with company match and immediate vesting
• Company-paid Life Insurance and Long-Term Disability coverage
• Tuition reimbursement opportunities
• Employee discounts and additional perks
• Volunteer and employee engagement opportunities

What You’ll Be Doing

• Design, develop, and maintain ETL/ELT data pipelines using tools such as Azure Data Factory and SQL Server Integration Services
• Build enterprise data models, including star schemas and Power BI semantic models
• Create interactive dashboards, reports, and visualizations using Power BI
• Develop DAX calculations and Power Query transformations to support reporting needs
• Implement Row-Level Security (RLS) and manage workspace governance
• Collaborate with stakeholders to gather requirements and translate business needs into technical solutions
• Optimize SQL queries and data models for performance and scalability
• Monitor data refreshes and troubleshoot production issues
• Manage deployment pipelines and version control processes using Git
• Create technical documentation, data dictionaries, and user guides
• Support data governance and data quality initiatives
• Stay current with emerging analytics tools, technologies, and best practices

What You Bring to the Table

• Bachelor’s degree in Information Technology, Computer Science, Data Analytics, Information Systems, or a related field — or equivalent experience
• 2–5 years of experience in business intelligence, data analytics, or business analysis
• Strong SQL skills and experience working with relational databases such as SQL Server or Azure SQL
• Advanced experience with Microsoft Power BI, including data modeling, DAX, Power Query, and deployment pipelines
• Understanding of data warehousing concepts, ETL/ELT processes, and dimensional modeling
• Experience with Azure data services such as Azure Data Factory, Synapse Analytics, or Databricks preferred
• Familiarity with scripting languages like Python or R preferred
• Strong communication and collaboration skills with both technical and non-technical teams
• Experience working in Agile or hybrid project environments
• Proficiency with Microsoft 365 applications
• Valid driver’s license with the ability to travel within the state as needed

Work Culture

We believe in creating an environment where employees feel supported, recognized, and empowered to succeed. Our culture values collaboration, innovation, inclusivity, and community involvement, with opportunities for employee engagement, wellness initiatives, and professional growth throughout the year.

If you’re ready to use your technical expertise to make a meaningful impact through data, apply today.