Business Intelligence Lead (Hybrid)
Seattle, WA - United States

We are as invested in your career as you are.

As you navigate through these uncertain times, know that Pinkerton has been a stable, thriving corporation for over 170 years. As recognized leaders around the globe in the corporate risk management industry, you can rest assured that joining us now means moving to a future-looking company. We are here today, will be here tomorrow, and are a thriving community of over 2,000 risk management professionals.

This is just one of the several exciting career opportunities that are currently available.

Job Summary:

The Business Intelligence Lead is an embedded role with one of Pinkerton's major 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 developing of technical and end-user documentation. It is important for the Lead to use a conversational approach to thoroughly explain the data visualization and expected outcomes to all project stakeholders.This position will have a hybrid work schedule within the United States (in office/remote); preferably Seattle, WA or Arlington, VA.

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, Oracle, Azure, and/or other cloud databases is needed. Advanced experience with Informatica is a must. Pinkerton is an inclusive employer who seeks candidates with diverse backgrounds, experiences, and perspectives.


  • 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.

Working Conditions:

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

  • Exposure to sensitive and confidential information.
  • Regular computer usage.
  • Occasional reaching and lifting of small objects and operating office equipment.
  • Ability to adjust focus between close and distance vision.
  • Travel, as required.

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.

*Current employees include Pinkerton and all Securitas divisions.