Senior Data/BI Analytics
About The Position
We are seeking a highly skilled, self-driven Senior Data Analyst / BI Analytics to take full ownership of existing reporting, also will be supporting the end-to-end implementation of our enterprise Data Lakehouse initiative. This individual will play a pivotal role in data ingestion validation, warehouse/lakehouse data modeling, testing, and ongoing reporting operations. This role is ideal for someone who thrives in a small to mid-sized, fast-paced environment, wears many hats, and is passionate about solving problems, learning new technologies, and helping build modern data capabilities from the ground up. For the seventh consecutive year in 2025, our culture was recognized as one of the Top 100 Best Places to Work by the Philadelphia Business Journal. Our Mission is to be the leader of the pest industry by providing a superior customer experience. We believe a happy, engaged and empowered team is the clear reason for our high customer ratings and consistent rapid growth.
Requirements
- SQL & (Plus either Data Warehousing Space and/or BI Development)
- Expert-level SQL such as complex joins, subqueries, etc.
- Strong understanding of relational and dimensional modeling, star/snowflake schemas, and warehouse concepts.
- Strong Excel skills for ad hoc analysis.
- Experience with modern lakehouse architecture or warehousing (Fabric, Databricks, or similar)
- Understanding of data pipelines, ELT/ETL processes, and data ingestion patterns.
- Advanced BI development experience (preferably Power BI)
Nice To Haves
- Understanding of ML/AI fundamentals (no need to be a data scientist but should understand basic concepts).
- Familiarity with cloud platforms (Azure or similar)
- Experience supporting or implementing large-scale data transformations or BI modernization projects.
- Highly independent, proactive, resourceful, and driven, comfortable operating with limited supervision.
- Strong problem-solving skills; able to troubleshoot ambiguous or complex data challenges.
- Curious, eager to learn, and excited about building new capabilities.
Responsibilities
- (Immediately)Take full ownership of current reporting, including maintenance and learn the data structure of our operational systems, and data sources.
- Conduct deep data investigations to ensure data accuracy, consistency, and quality across systems.
- Serve as the primary testing and validation resource for the Data Lakehouse implementation (data ingestion, transformations, modeling, and BI consumption layers).
- Partner with technical teams and vendors to support requirements definition, acceptance testing, and post-go-live readiness.
- Develop and maintain Power BI dashboards and develop reports as needed to support other functions.
- Support advanced analytics initiatives, including ML, predictive modeling, and use of LLM-based tools within the data platform. (Prefer)
- Collaborate cross-functionally to design scalable reporting and analytics solutions.
- Improve documentation, data governance, and data literacy across the organization.
Benefits
- Full Medical, Dental, Vision, 401k Company Match, Life & Disability Benefits
- Full Paid Training
- Paid Time Off and Paid Holidays
- Weekly Pay & On-Demand Pay
- Career growth opportunities in a fast-growing, award-winning company
- Formal Leadership Development Program
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
Number of Employees
51-100 employees
