Rarefied talent in data science, data technology, and analytics

Business Intelligence Lead (Remote- United States)


Job Description

Who We Are:
Pinkerton is a global comprehensive risk and security management leader focused on delivering specialized risk advisory, investigations, protection solutions, and embedded SMEs. With over 170 years of legacy, Pinkerton has built unparallel institutional knowledge, while having sight into future risk businesses are facing. 

Pinkerton clients rely on our family of thousands of employees and connected partners across 100+ countries to support their risk management and security needs. No matter when, no matter where, we pride ourselves on being there for our clients.

With an unified sense of purpose, our global force of Pinkerton agents and support functions band together to become something more than colleagues — we are a family. With every new career opportunity, we seek candidates with diverse experiences, perspectives, and backgrounds.

To Apply- Click Here

Job Summary:
The Business Intelligence Leadis an embedded role, with one of Pinkerton's largest global tech clients.This position will be responsible for acting as the project lead on data warehouse and business intelligence initiatives, design and implementation of databases, devising test plans, and development of technical and end user documentation. This position can be based anywhere (remote) within the United States.

Essential Functions:

  1. Represent Pinkerton's core values of integrity, vigilance, and excellence.
  2. Design and implement databases for OLTP/OLAP, data warehouse, and reporting solutions using best practices.
  3. Collaborate with peers and internal customers to determine business requirements.
  4. Analyze business requirements to produce technical requirements for data models, transformations, visualization, and reporting.
  5. Redesign existing data warehouse schemas and ETL pipelines as needed to improve performance, accuracy, and the robustness of data sets.
  6. Work with data from a variety of data sources and systems.
  7. Devise test plans to validate data accuracy and coordinate with end users for acceptance testing of solutions.
  8. Develop reports, dashboards, and KPIs using the Microsoft BI Platform.
  9. Develop a variety of documentation;
    • Create entity relationship diagrams and data flow diagrams.
    • Design end user documentation for data models and pipelines.
  10. Administer end-user access to data models and reports, provide reports of user permissions, and maintain system access logs.
  11. Act as a change agent to bring about innovative ways to develop software and establish continuous improvements to the software development cycle.
  12. All other duties, as assigned.

Education, Experience, and Certifications:
Bachelor's degree in computer science, data engineering, business intelligence, or related discipline preferred and seven years of experience in business intelligence or data warehouse. Experience with Microsoft PowerBI platform, Microsoft SSIS, SSAS, Informatica, Oracle, Azure, and/or other cloud databases is needed.


  • Strong understanding of data warehouse concepts and architecture, such as star/snowflake schema, OLAP cubes, and tabular cubes.
  • Skilled in using Microsoft SQL Server, including advanced SQL queries, T-SQL, database design, and stored procedures.
  • Proficiency with DAX and M, Power Query Formula language.
  • Effective written and verbal communication skills.
  • Able to multi-task and organize workload for effective implementation.
  • Able to interact effectively at all levels and across diverse cultures.
  • Able to manage multiple projects simultaneously with competing priorities and deadlines.
  • Attentive to detail and accuracy.
  • Able to carry out responsibilities with little supervision.
  • Computer skills; Microsoft Office.

Pinkerton is an equal opportunity employer and provides equal opportunity to all applicants for all 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.

Interested in this position?
Job Location
Additional Job Details
Employment Type:
Full Time

Salary range:
$100,000 – $150,000
More Jobs at Pinkerton