Business Intelligence Analyst

Overview

170+ Years Strong. Industry Leader. Global Impact. At Pinkerton, the mission is to protect our clients. To do this, we provide enterprise risk management services and programs specifically designed for each client. Pinkerton employees are one of our most important assets and critical to the delivery of world-class solutions. Bonded together, we share a commitment to integrity, vigilance, and excellence.

Pinkerton is an inclusive employer who seeks candidates with diverse backgrounds, experiences, and perspectives to join our team of industry subject matter experts.

The Business Intelligence Analyst is responsible to Gather, analyze, and interpret business data to generate actionable insights.

Responsibilities

• Represent Pinkerton’s core values of integrity, vigilance, and excellence.
• Gather, analyze, and interpret business data to generate actionable insights.
• Design, develop, and maintain BI dashboards and reports using tools like Power BI.
• Collaborate with cross-functional teams to understand business needs and translate them into analytical requirements.
• Build and optimize data models, ensuring data accuracy, quality, and consistency across sources.
• Develop DAX/SQL queries for complex calculations, automation, and performance optimization.
• Identify trends, patterns, and anomalies to support strategic and operational decision- making.
• Ensure BI solutions follow governance, security (including RLS), and documentation standards.
• Support stakeholders through ad-hoc analysis, storytelling with data, and continuous improvement of BI solutions. Recommend opportunities for reuse of data models in new environments.
• Responsible for creating complex stored procedures, views, data aggregation through table joins/queries.
• Analyzing and translating business needs into visualizations solution.
• Provide technical documentations for knowledge transform, technical training, coaching for project stakeholders.
• All other duties, as assigned.

Qualifications

At least 4-5 years of hands-on experience in data modelling, visualization, and managing databases. B TECH/MCA degree preferably in Information Technology, Computer Science from a recognized university.

• Advanced Power BI Skills, proficiency in creating complex DAX measures and leveraging visualizations for compelling data storytelling.
• Practical experience in loading database tables and building Fabric-based data lakes.
• Expertise with the Power Platform ecosystem.
• Ability to work both independently and as part of a team, adapting to project needs.

Working Conditions:

With or without reasonable accommodation, requires the physical and mental capacity to effectively perform all essential functions;

• Regular computer usage.
• Occasional reaching and lifting of small objects and operating office equipment.
• Frequent sitting, standing, and/or walking.
• Travel, as required.

Pinkerton is an equal opportunity employer to all applicants and positions without regard to race/ethnicity, color, national origin, ancestry, sex/gender, gender identity/expression, sexual orientation, marital/prenatal status, pregnancy/childbirth or related conditions, religion, creed, age, disability, genetic information, veteran status, or any protected status by local, state, federal or country-specific law.