170+ Years Strong. Industry Leader. Global Impact.
At Pinkerton, the mission is to protect our clients. To do this, we provide enterprise risk management services and programs specifically designed for each client. Pinkerton employees are one of our most important assets and critical to the delivery of world-class solutions. Bonded together, we share a commitment to integrity, vigilance, and excellence.

Pinkerton is an inclusive employer who seeks candidates with diverse backgrounds, experiences, and perspectives to join our team of industry subject matter experts.

The Manager - Data Analytics will help develop the data model and conduct data profiling with the objective of delivering high-quality data sets.

• Represent Pinkerton’s core values of integrity, vigilance, and excellence.
• Develop the data model and conduct data profiling with the objective of delivering high-quality data sets.
  
• Designing dashboards using any visualization platform is required.
  
• Design, develop, implement, and maintain a data warehouse to collate and integrate data from various
  sources and systems within the organization.
  
• Interact with SMEs (business) and architects to validate whether the data model is aligned with the
  technology suggested for the project.
• Define the data dictionary/ business glossary based on the model developed, if required.
  
• Recommend opportunities for reuse of data models in new environments.
  
• Managing and designing the reporting environment, including data sources, security, and meta-data.
  
• Follow best practices for standard naming conventions and coding practices to ensure consistency of
  data models.
  
• Responsible for creating complex stored procedures, views, data aggregation/manipulation through
  table joins/queries, database design, normalization, and de-normalization techniques.
  
• Analyzing and translating business needs into long-term solution data models.
  
• Provide technical documentations for knowledge transform, technical training, coaching for project
  Stakeholders..
• All other duties, as assigned..

At least 9 years of hands-on experience in data modelling, visualization, and managing large databases.                 B TECH/MCA degree preferably in IT, Computer Science from a recognized University. Advanced Power BI Skills, proficiency in creating complex DAX measures and leveraging visualizations
for compelling data storytelling.

   
                   • Should be technically strong in relational databases and able to provide design approaches.

                   • Practical experience in loading database tables and building Fabric-based data lakes.
                   • Expertise in SQL server, Azure/Azure Data Bricks and Python is preferred.

                   • Familiarity with the Power Platform ecosystem.
                   • Experience in creating AI agents is a valuable asset.
                   • Skilled in database design, data modeling, and developing impactful visualizations.
                   • Ability to work both independently and as part of a team, adapting to project needs.

Working Conditions:

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

• Regular computer usage.
• Occasional reaching and lifting of small objects and operating office equipment.
• Frequent sitting, standing, and/or walking. 
• Travel, as required.

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