BI Analyst

Technology Council of Central Pennsylvania; Northern (KY); Hybrid; USD 65,000 - 75,000; Full time

Benefits offered by this job

Medical coverage with employer HSA

401(k) with strong employer match

Flexible, collaborative culture with a

mostly remote schedule

Job summary

Technology Council of Central Pennsylvania is seeking a BI/Analytics professional to join our growing analytics team. You will build dashboards and reports that stakeholders rely on daily and help shape how the organization uses its data.

You will work directly with business leaders to define metrics, create Power BI dashboards using DAX and Power Query, write SQL queries, and support data pipelines, data warehousing concepts, and self-service reporting.

Qualifications

• Bachelor's degree or equivalent experience.
• 2–5 years in BI, data analytics, or business analysis.
• Working knowledge of data modeling, ETL/ELT, and data governance.
• Strong communication skills and ability to present to senior stakeholders.
• Valid driver's license and ability to travel locally.

Responsibilities

• Define metrics, KPIs, and reporting requirements with stakeholders.
• Build and maintain dashboards and reports in Power BI using DAX/Power Query.
• Write and tune SQL queries; support data pipelines and integrations with a BI developer.
• Apply data warehousing concepts (star/snowflake) and manage report security, refresh schedules, and performance.
• Maintain documentation, data dictionaries, and glossaries; support self-service reporting adoption.
• Handle ad hoc analysis requests and present findings to technical and non-technical audiences.

Skills

BI analytics

Data modeling

ETL/ELT

Data governance

Stakeholder communication

Education

Bachelor's degree or equivalent

Tools

Power BI

DAX

Power Query

SQL

Job description

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
• 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
• 401(k) with strong employer match
• Flexible, collaborative culture with a mostly remote schedule

Additional Info

Job Type : Full-Time