Job description

About the Company

Ecore turns reclaimed rubber into high-performance surfaces that support people, safety, and sustainability. Its products are used in places such as playgrounds, fitness spaces, healthcare settings, courts, and even aerospace applications. The company is focused on circular innovation, diverting rubber from landfills and converting waste into durable, performance-driven solutions.

Location

715 Fountain Avenue, Lancaster, PA 17601

Job Summary

The Business Intelligence Analyst sits within the Enterprise Data team and is accountable for shaping, improving, and overseeing the company’s BI and analytics environment. The role centers on building scalable semantic models, designing reusable data structures, and keeping enterprise BI platforms efficient, secure, and dependable. The person in this role works closely with data engineering, MDM, business stakeholders, and BI Specialists to deliver governed, high-quality analytics across the organization. This position is key to strengthening BI maturity by introducing standards, automation, architecture improvements, and enterprise-grade data foundations for reporting and analysis.

Responsibilities

Design and sustain enterprise semantic models, reusable structures, and analytical visualizations that can scale across multiple business areas.
Set and uphold standards for modeling, naming conventions, metadata, and enterprise KPI definitions.
Own the Power BI semantic layer to keep outputs consistent, accurate, and performant.
Work with data engineering to align lakehouse and warehouse design with downstream reporting needs.
Build and administer BI governance practices such as version control, lifecycle management, documentation, and dataset certification.
Improve refresh logic, incremental refresh behavior, partitioning, and general dataset performance.
Create and support automated CI/CD pipelines for BI content across development, QA, and production.
Ensure BI tools and assets follow security, access, and governance requirements.
Coordinate with data engineering on ETL/ELT design and optimization.
Set up monitoring, alerting, observability, and root-cause analysis for pipelines, datasets, and dashboards.
Investigate and resolve performance issues in SQL, semantic models, and dataset settings.
Help shape the analytics roadmap through recommendations on architecture, tooling, automation, and governance.
Assess new BI technologies, AI agents, and automation options, and advise on their business impact.
Lead cross-functional design discussions for significant BI initiatives to ensure alignment with enterprise data strategy.
Translate business goals into analytical frameworks and enterprise data models.
Coach BI Specialists and business users on visualization standards, data literacy, and best practices for consuming semantic models.
Provide technical guidance on high-impact analytics work.

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or a similar field.
At least 7 years of practical experience in BI engineering or analytics architecture, ideally in the Microsoft BI ecosystem.
Advanced hands-on expertise in Power BI modeling, including DAX, Power Query (M), relationships, incremental refresh, partitions, and DirectQuery approaches.
Strong knowledge of SQL development, query tuning, indexing, and data warehouse concepts.
Experience building and managing BI pipelines, ETL/ELT workflows, and data validation processes.
Exposure to Databricks or another comparable big data platform is preferred.
Experience creating CI/CD, DevOps, or automation solutions for BI assets.
Solid understanding of data governance, access management, security roles, and BI lifecycle control.
Proven ability to lead architecture conversations, define standards, and influence enterprise data direction.
Clear communication skills with the ability to explain technical ideas to business audiences.
Strong analytical thinking, problem-solving ability, leadership qualities, and a continuous-improvement mindset.

Work Environment

This role is primarily office-based with occasional exposure to a manufacturing setting, where PPE may be required in some situations. Evening or weekend work may occasionally be needed to meet deadlines. Some travel may be required for offsite integration work or conferences. The position also requires manual dexterity and good visual ability for standard office equipment use. Remote work is possible when necessary.

Physical and Mental Demands

This is mainly a desk-based role. Reasonable accommodations may be provided under the ADA so that individuals with disabilities can perform the essential duties of the position.

What We Offer

Medical, dental, vision, and prescription coverage with competitive benefits
401(k) plan with company match
PTO accrual starting from day one
Tuition reimbursement support
Growth opportunities and internal advancement paths
Convenient access to eco-friendly public transportation within a two-minute walk

Additional Information

Applicants from all backgrounds are encouraged to apply. Ecore emphasizes reliability, effort, and a positive attitude as important qualities, alongside experience and background.

The company is an equal opportunity employer and does not discriminate on the basis of race, religion, creed, color, national origin, age, gender, sexual orientation, marital status, disability, veteran status, or any other legally protected status.

This employer participates in E-Verify. Federal law requires verification of the identity and work authorization of all new hires in the United States. After an offer is accepted, the employer may share Form I-9 information with the Social Security Administration and/or Department of Homeland Security to confirm employment eligibility. If work authorization cannot be confirmed, the employer must provide written notice and an opportunity to contact the relevant agency before taking adverse action. E-Verify cannot be used to pre-screen applicants or to re-verify existing employees, and it cannot restrict which documents are presented for Form I-9. Photo matching may be used to compare certain permanent resident and employment authorization cards with USCIS records.

Employment Details

This is a full-time position. The role is listed as remote, with the location based in Lancaster, PA.

Business Intelligence Analyst_IT