BI Analyst

JFC Staffing Companies; Harrisburg (Dauphin County); Hybrid; USD 65,000 - 75,000; Full time

Benefits offered by this job

HSA medical

Paid PTO

401k match

Volunteer time off

Remote-friendly culture

Job summary

JFC Staffing Companies is seeking a BI Analyst to join a growing analytics team in Central Pennsylvania (mostly remote, with quarterly on-site meetings). You will build dashboards and reports in Power BI, craft SQL queries, and collaborate with stakeholders to define metrics and KPIs that guide strategic decisions.

The role requires 2–5 years of BI/data analytics experience, strong SQL, and data modeling knowledge.

Qualifications

• Bachelor's degree or equivalent experience.
• 2–5 years BI/data analytics experience.
• Experience building dashboards in Power BI.
• Strong SQL skills.
• Knowledge of data modeling and ETL/ELT.
• Ability to present to senior stakeholders.
• Valid driver's license and travel locally.

Responsibilities

• Define metrics, KPIs, and reporting requirements with stakeholders.
• Build and maintain dashboards/reports in Power BI.
• Write and tune SQL queries; support data pipeline work.
• Apply data warehousing concepts and manage report security.
• Maintain data dictionaries and glossaries; promote self-service reporting.
• Handle ad hoc analysis and present findings to audiences.

Skills

Power BI

SQL

Data modeling

ETL/ELT

Data governance

Communication

Education

Bachelor's degree

Tools

DAX

Power Query

Job description

BIAnalyst

Location: Central Pennsylvania (must reside in PA) — mostly remote, with occasional on-site meetings (roughly quarterly)

Compensation: $65,000–$75,000 (up to $80K DOE)

About the Role

Join a growing analytics team helping business leaders make smarter, faster decisions. You'll build the dashboards and reports that stakeholders rely on every day, and help shape how the organization uses its data.

What You'll Do

• Work directly with business stakeholders to define metrics, KPIs, and reporting requirements
• Build and maintain dashboards and reports in Power BI, using DAX and Power Query for data modeling
• Write and tune SQL queries; support data pipeline and integration work alongside a BI developer
• Apply data warehousing concepts (e.g., star/snowflake schema) and manage report security, refresh schedules, and performance
• Maintain documentation, data dictionaries, and glossaries; support broader adoption of self‑service reporting
• Handle ad hoc analysis requests and present findings to both technical and non‑technical audiences

What You'll Bring

Required

• Bachelor's degree in a related field, or equivalent experience
• 2–5 years of experience in BI, data analytics, or business analysis
• Hands‑on experience building dashboards/reports in Power BI
• Strong SQL skills
• Working knowledge of data modeling, ETL/ELT, and data governance concepts
• Strong communication skills, including comfort presenting to senior stakeholders
• Valid driver's license and ability to travel locally

Benefits Highlights

• Medical coverage with employer HSA contribution
• Generous PTO plus paid holidays
• 401(k) with strong employer match
• Paid volunteer time off
• Flexible, collaborative culture with a mostly remote schedule

Direct W2 only EOE.