Business Intelligence Lead (Remote) at Pinkerton Consulting & Investigations, Inc. in Ann Arbor, Michigan

Job Description:

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

Competencies:

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


• Must be able to see, hear, speak, and write clearly in order to communicate with employees and/or customers.


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

Apply Now