Business Intelligence Analyst

At Ecore, we transform reclaimed rubber into innovative performance surfaces that protect people and the planet. Our products power everything from playgrounds and gyms to hospitals, courts, and even rockets—helping people in motion be their strongest, healthiest selves. As a high-growth, sustainability-driven company, we’re leading the way in circular innovation by keeping rubber out of landfills and turning waste into wellness, safety, and performance. We’re excited to find individuals who are eager to be part of a team that’s driving global impact through innovation, sustainability, and purpose.

Location:

715 Fountain Avenue, Lancaster, PA 17601

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.

What You’ll Do

Enterprise Architecture \& Modeling:

• 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.

BI Platform Engineering \& Governance

• 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.

Pipelines, Data Quality \& System Optimization

• 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.

Strategic Leadership

• 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.

Collaboration, Enablement \& Mentorship

• 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.

What You Bring

• 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.
• Familiarity with Databricks or comparable big‑data platforms (preferred).
• Hands-on experience implementing CI/CD, DevOps, or automation frameworks for BI assets.
• 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.

Candidates must be legally authorized to work in the United States; sponsorship is not available for this role.

What We Offer You

• Competitive medical, dental, vision, and prescription insurance coverage
• 401k with a company match
• PTO Hours are accrued from Day 1
• Tuition reimbursement
• Opportunities for development and internal promotions
• Two minute walk to eco-friendly public transportation from rabbittransit

Sometimes the best jobs get missed because people think they don’t have what it takes. At Ecore, we know hard work, reliability, and a good attitude matter most. No matter your background, experience, or where you’ve come from, if this job sounds like something you’d be proud to do, we’re excited to meet you.

About ECore

Evolving materials for a changing worldCircularity isn’t just about reusing and recycling, it’s about empowering innovation and imagination. Together with our customers, we lead the effort in bringing new value to end-of-life materials through a 4-step circularity model. Driven by transformation and inspired by the versatility of rubber, Ecore is a rubber circularity company.