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

Job Description:

The Business Intelligence Data Analyst is an embedded role, with one of Pinkerton's major global tech clients. This position supports the reporting, metrics, and information management initiatives for the client's Global Security team and will create queries, sort, and assess large volumes of data utilizing SQL, Python, Tableau and/or other business intelligence tools. 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. Support information management initiatives for the client's Global Security Team.
3. Assess and manipulate large data sets with SQL, Tableau, Python, Excel, and other business intelligence tools.
4. Perform ad-hoc reports and analysis;
   
   
   • Run and modify SQL queries to generate list reports from data sources.
   • Generate data, identify problems within datasets, and resolve data discrepancies.
5. Create dashboards and interactive custom visualizations using business intelligence tools.
6. Collect, archive, and review data from a variety of open and proprietary sources.
7. Ensure the integrity, confidentiality and security of all datasets.
8. Collaborate with key stakeholders to ingest volumes of data, policy, and program points.
9. All other duties, as assigned.

Bachelor's degree with five years of experience in information management, information systems, MIS or a related field, or an equivalent combination of education and experience sufficient to perform the essential functions of the job, as determined by the company. Experience with SQL, Python, Excel, and Tableau, required.

Competencies:

• Proficiency in creating ad-hoc queries.
• Able to adapt as the external environment and organization evolves.
• Attentive to detail and accuracy.
• Effective written and verbal communication skills.
• Serve as an effective team member.
• Able to work independently with little supervision.
• Able to multi-task and organize workload for effective implementation.
• Effective independent judgment and decision-making ability.
• Able to interact effectively at all levels and across diverse cultures.
• Computer skills; Microsoft Office, SharePoint, SQL, Python, and Tableau.

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.

Benefit options include employer-paid life and AD&D, voluntary life and AD&D, medical, (HSA) Health Savings Account, (FSA) Flexible Savings Account, dental, vision, short-term disability, long-term disability, 401(K), paid time off (vacation, personal, sick, and holidays) and several employee assistance-related programs. This information provides a brief benefit overview. Upon the acceptance of an employment offer, the new employee will receive comprehensive plan details based on specific eligibility rules.

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.