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 network of industry subject matter experts.
The Senior Manager - Data Analytics will be responsible for creating complex stored procedures, views, data aggregation/manipulation through table joins/queries, database design, normalization, and de-normalization techniques.
- 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.
- 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 10 to 15 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. Practical experience in loading database tables and building Fabric-based data lakes. Experience in creating AI agents is a valuable asset.
- 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.
- Expertise in SQL server, Azure/Azure Data Bricks and Python is preferred.
- Familiarity with the Power Platform ecosystem.
- 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.
