Senior Data Analyst at Pinkerton Consulting & Investigations, Inc.

Job Description

Senior Data Analyst at Pinkerton Consulting & Investigations, Inc.

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 Senior Data Analyst – Global Information Management is responsible for managing the reporting, metrics, and information management initiatives for the client’s Global Security Team. The Senior Data Analyst will create queries, sort, and assess large volumes of data utilizing SQL, Python, with advanced knowledge of data visualization tools such as Tableau, Quicksight and/or other business intelligence tools. This position will have a hybrid work schedule (in office/remote).

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. Develop processes and data pipelines to improve reporting efficiencies.

7. Collect, archive, and review data from a variety of open and proprietary sources.

8. Ensure the integrity, confidentiality, and security of all datasets.

9. Collaborate with key stakeholders to ingest volumes of data, policy, and program points.

10. All other duties, as assigned.

Education, Experience, and Certifications:

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. Pinkerton is an inclusive employer who seeks candidates with diverse backgrounds, experiences, and perspectives.

Competencies:

• Proficiency in creating ad-hoc queries.

• Demonstrated problem solving experience providing business insights and recommendations from data sets.

• Able to adapt as the external environment and organization evolves.

• Attentive to detail and accuracy.

• Able to analyze complex situations and recommend solutions.

• Effective written and verbal communication skills.

• Serve as an effective team member.

• Strong client orientation and results-driven.

• Able to work independently with little supervision.

• Serve as an effective team leader.

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

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.

Salary & Benefits Information:

Rate of pay: $120000 / year.

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. Pinkerton also adheres to all local, state, federal, and country hiring requirements.