Business Intelligence Analyst_IT

ECORE•Lancaster, PA

31d

About The Position

We are seeking a highly skilled Business Intelligence Analyst to join our Enterprise Data team and help elevate our organization’s analytics capabilities. In this role, you will design scalable BI architecture, build trusted semantic models, and ensure our reporting ecosystem is accurate, efficient, and enterprise‑ready. If you’re passionate about modern BI engineering, love building reusable data assets, and enjoy partnering across the business to deliver meaningful insights—this is the role where you can make a major impact.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
7+ years of experience in BI engineering or analytics architecture (Microsoft BI ecosystem preferred).
Expert-level Power BI experience: DAX, Power Query (M), modeling, incremental refresh, partitions, DirectQuery.
Strong SQL development and query optimization skills.
Experience building and managing BI pipelines and ETL/ELT workflows.
Strong understanding of data governance, security roles, and BI lifecycle management.
Excellent communication skills, including the ability to explain technical topics to non‑technical audiences.
A proactive, solution‑oriented mindset with strong analytical and leadership skills.

Nice To Haves

Familiarity with Databricks or comparable big‑data platforms (preferred).
Hands-on experience implementing CI/CD, DevOps, or automation frameworks for BI assets.

Responsibilities

Design and maintain enterprise semantic models and reusable data structures for scalable analytics.
Define and uphold standards for modeling, naming conventions, metadata, and KPIs.
Serve as the owner of the Power BI semantic layer, ensuring consistency and accuracy.
Collaborate closely with data engineering to align lakehouse/warehouse design with BI needs.
Lead BI governance, including version control, lifecycle management, documentation, and dataset certification.
Optimize dataset refresh strategies, incremental refresh, partitioning, and overall performance.
Build and maintain automated CI/CD pipelines across development, QA, and production.
Ensure BI systems follow security, access control, and enterprise data governance policies.
Partner with data engineering to design and optimize ETL/ELT processes.
Implement monitoring, alerting, observability, and root‑cause analysis for BI pipelines and dashboards.
Drive performance tuning across SQL, semantic models, and dataset configurations.
Contribute to the Enterprise Data analytics roadmap, including architecture, automation, and tooling recommendations.
Evaluate emerging BI technologies, AI capabilities, and automation solutions.
Lead design reviews for high‑impact BI initiatives and ensure alignment with enterprise strategy.
Work with business leaders to translate strategic goals into data models and analytic frameworks.
Mentor BI Specialists and business users on visualization best practices, data literacy, and semantic model usage.
Provide technical guidance on major analytics projects across the organization.