19 Nov
|
Bristol-Myers Squibb
|
Hyderabad
19 Nov
Bristol-Myers Squibb
Hyderabad
Job highlights
- Bachelor s degree in engineering,Computer Science,Data Science,Economics,Statistics,or a related quantitative field
- Metric Development Reporting: Develop robust semantic models,DAX measures,and optimized datasets (including RLS / OLS security where required) to ensure dashboards are performant,governed,and scalable across the organization.
- Qualifications Experience
Job Summary Role Description: Capital Projects Data Analyst
Function: Capital Projects Data Analyst
Location: Hyderabad, India
Reporting To: Cost Estimating Lead - Global Project Services
Purpose of the Role
This role is responsible for transforming historical capital project cost data-organized by Work Breakdown Structure (WBS)-into actionable insights using AI data mining techniques and advanced analytics. The primary objective is to support network facility planning and estimating by delivering dynamic cost metrics (e. g. , cost per square foot, installation factors vs equipment cost, indirect percentages) tailored to user requirements. The role will also require support for future initiatives as necessary within the Technical Services group.
In addition, the role strengthens the Capital Governance process - which provides structure, oversight, and accountability in how Global Technical Services evaluates, approves, funds, and monitors capital investments - by supplying the performance data, analytics, and Key Performance Indicators that enable Stage Gate reviews, annual CapEx portfolio planning, and executive visibility into project cost, scope, and schedule performance.
Key Responsibilities
- Data Mining Structuring: Source and organize historical capital project cost data segmented by WBS.
- Data Mining Structuring: Clean, normalize, and structure data for analysis using AI tools.
- Data Mining Structuring: Ensure data is enriched with relevant metadata (e. g. , facility type, room classification, benchmark category).
- Data Mining Structuring: Design and maintain scalable data pipelines using SQL and modern data platforms (e. g. , Microsoft Fabric, Databricks, Snowflake, Azure Data Lake) to consolidate multi-source project data into a unified, query-ready repository.
- Data Mining Structuring: Centralize scattered and legacy project cost data from disparate files and systems into a governed, single source of truth (e. g. , unified SharePoint/data platform repository), eliminating manual tracking.
- AI-Driven Analysis: Apply machine learning and natural language processing (NLP) to extract patterns, trends, and anomalies from cost data.
- AI-Driven Analysis:
Develop models to benchmark costs across facility types (e. g. , API, fill-finish, QC labs) and scope categories.
- AI-Driven Analysis: Leverage AI-powered assistants and agents (e. g. , Microsoft Copilot, Azure OpenAI, Anthropic Claude, retrieval-augmented generation) to accelerate document intelligence, automate extraction of cost data from unstructured sources (e. g. , PDFs, contracts, change orders), and improve estimating productivity.
- AI-Driven Analysis: Apply predictive and forecasting techniques to improve the accuracy of cost projections and support variance and root-cause analysis for significant deviations.
- Metric Development Reporting: Generate cost metrics such as cost per square foot, cost per unit, and other KPIs based on user queries.
- Metric Development Reporting: Build interactive dashboards and visual tools for internal stakeholders using Power BI.
- Metric Development Reporting: Develop robust semantic models, DAX measures, and optimized datasets (including RLS/OLS security where required) to ensure dashboards are performant, governed, and scalable across the organization.
- Metric Development Reporting: Develop and manage performance data, analytics, and KPIs related to capital portfolio and CapEx performance (cost, schedule, quality), supporting Stage Gate governance reviews, capital projection cycles, and executive reporting.
- User Interaction Customization: Collaborate with other Global Technical Services team members to understand data needs.
- User Interaction Customization: Translate ad hoc user requests into tailored cost analyses and reports using AI tools.
- User Interaction Customization: Enable self-service capabilities for project teams to access cost benchmarks and trends.
- User Interaction Customization: Lead requirements gathering and stakeholder engagement across time zones, translating business questions from Cost Estimating, Capital Governance, Finance, and Site Engineering stakeholders into clear analytical deliverables communicated in a concise, actionable manner.
- Tool System Integration: Integrate AI tools with existing project management and cost estimating platforms.
- Tool System Integration: Automate data ingestion and metric updates to ensure real-time relevance.
- Tool System Integration: Automate recurring data capture, refresh, and reporting workflows using the Microsoft Power Platform (Power Automate, Power Apps) and scripting (Python/SQL), reducing manual effort and turnaround time.
- Tool System Integration: Support integration of workflows, approvals, and documentation into capital project lifecycle platforms, maintaining data quality so information can be leveraged for reporting and decision-making.
- Data Governance Quality: Apply data governance practices - data quality checks, documentation, access control, and stewardship - to ensure the accuracy, integrity, and compliance of capital project data assets.
- Data Governance Quality: Support knowledge management by helping capture benchmarks, lessons learned, and best practices in a central repository so they can be reused to improve future project outcomes.
- Data Governance Quality: Handle confidential, strategic, and sensitive capital investment information with discretion and in compliance with organizational policies on data integrity and applicable regulatory requirements.
- Support for Other Initiatives: The role will also require supporting future initiatives as necessary within the Global Technical Services group.
- Support for Other Initiatives: Stay current with industry trends and emerging technologies in AI, analytics, and digital operations; identify and implement innovative solutions and continuous-improvement opportunities in analytics and reporting workflows.
Qualifications Experience
- Bachelor s degree in engineering, Computer Science, Data Science, Economics, Statistics, or a related quantitative field; master s degree preferred.
- 5-10+ years of experience in data analytics, business intelligence, or data engineering roles, preferably supporting capital projects, engineering, construction, infrastructure, or cost management functions; pharmaceutical or other regulated-industry experience is a plus.
- Expert-level proficiency in Power BI - including semantic/data modeling, DAX optimization, Power Query, RLS/OLS security, and deployment pipelines - with a portfolio of enterprise-grade dashboards delivered to senior stakeholders.
- Solid hands-on skills in the Microsoft ecosystem: Microsoft Fabric, Power Platform (Power Automate, Power Apps, Copilot Studio)
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 Cost Intelligence & AI Analytics Professional (Hyderabad)
🏢 Bristol-Myers Squibb
📍 Hyderabad