BI Analyst — Power BI Dashboards & Data Insights (Remote)

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

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.