Senior FP&A Business Intelligence Analyst

Senior FP&A Business Intelligence Analyst

Position Summary 

The Senior FP&A Business Intelligence Analyst serves as a critical bridge between Finance, Operations, and IT by designing, developing, and maintaining data, reporting, analytics, and automation solutions that support business decision-making across the organization.

Responsibilities 

• Build and maintain enterprise datasets, semantic models, dashboards, and reporting solutions.
• Develop Power BI and Microsoft Fabric solutions, including semantic models, reporting, and self-service analytics capabilities.
• Design and maintain analytical, forecasting, and decision-support models using SQL, Python, and other modern technologies.
• Partner with business and technology teams to translate requirements into actionable data and reporting solutions.
• Ensure data quality through validation, reconciliation, and monitoring processes.
• Manage data models, reporting frameworks, and key business hierarchies.
• Automate reporting, analysis, and recurring business processes using AI and modern productivity tools.
• Continuously improve reporting standards, governance, and analytical methodologies.

Qualifications and Requirements 

• 5+ years of experience in business intelligence, analytics, reporting, or data management.
• Advanced SQL skills, including data transformation, troubleshooting, optimization, and analytical model development.
• Experience developing analytical, forecasting, or decision-support models using SQL, Python, or similar technologies.
• Strong experience with Microsoft Power BI, including semantic models, DAX, dashboards, and reporting solutions.
• Experience with Microsoft Fabric and cloud-based analytics platforms.
• Strong understanding of data modeling, governance, validation, and reporting best practices.
• Ability to independently investigate problems, validate findings, and develop effective solutions with minimal supervision.
• Excellent communication and collaboration skills across business and technical teams.
• Experience using AI and automation tools to improve efficiency while exercising sound business judgment and validating results.
• Experience with SAP or other ERP systems preferred.
• Experience with Python, Microsoft Copilot, Power Query, and workflow automation tools preferred.
• Experience working with relational databases, data modeling, data integration, and enterprise reporting environments preferred.
• Bachelor’s degree or equivalent experience in Business Intelligence, Information Systems, Computer Science, Data Analytics, Statistics, Mathematics, Finance, or a related field.

Why Work for EcoShield Pest Solutions? 

The Shield Co. Management / EcoShield Pest Solutions is one of the fastest-growing pest control companies in the country! Our mission is to create the world’s happiest family, and our purpose is to spread happiness. We do this by delivering exceptional experiences to our customers, employees, partners, and communities—treating everyone like family. 

EcoShield Pest Solutions is proud to offer competitive pay and full benefits! 

• Weekly Pay – get paid every Friday! 
• Paid sick and vacation time along with 10 company-paid holidays. 
• Comprehensive benefits package including medical, dental, and vision options. 
• 401(k) with a competitive match. 
• Access to the Employee Assistance Program (EAP). 
• Discounted pest control services for employees and their friends and family.  

Physical Demands and Working Requirements    

The physical demands and working conditions outlined here are typical requirements for an employee to effectively carry out the essential duties of this job. Reasonable accommodations may be provided to assist individuals with disabilities in performing these essential functions.   

• Requires prolonged periods of sitting at a desk or workstation  
• Frequent use of hands and fingers for typing and using a computer mouse 
• Occasionally lift and carry office materials or supplies up to 25 pounds      
• Requires clear vision for reading documents, computer screens, and other office materials      
• Work is inside a climate-controlled office with quiet to moderate noise level   

The above statements are meant to outline the general nature and scope of work performed by employees in this role. They should not be interpreted as an exhaustive list of all responsibilities, duties, and skills required for this position.   

EcoShield is an equal opportunity employer, committed to diversity and inclusion. We make employment decisions based on merit and business needs, without discrimination based on race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Americans with Disabilities Act (ADA): The Shield Co. Management, LLC is committed to providing reasonable accommodations to qualified individuals with disabilities during both the hiring process and throughout employment, in accordance with applicable laws.