We use cookies for the best user experience on our website, including to personalize content & offerings, to provide social media features and to analyze traffic. By clicking “Accept All Cookies” you agree to our use of cookies. You can also manage your cookies by clicking on the “Cookie Preferences” and selecting the categories you would like to accept. For more information on how we use cookies please visit our and Modify Cookie PreferencesReject All Cookies Accept All CookiesPython Senior Developer – Data Analysis, SQLIndiaJob DescriptionPython Senior Developer – Data Analysis, SQLChennai, Tamil NaduJob Summary
- Data analysis and interpretation skills
- KPI calculation and validation expertise
- Experience with dashboards and BI tools (e.g., Power BI or equivalent)
- Ability to work with large, multi-site manufacturing datasets
- Trend analysis and anomaly detection
- Experience in Agile / DevOps environments
- Support for UAT and data sign-off
- Documentation discipline for KPIs and business rules
- Experience working in global or multi-plant manufacturing environments
Role PurposeThe Business / Data Analyst is responsible for transforming manufacturing data into meaningful business insights by defining, validating, and analyzing Visual Factory KPIs, dashboards, and trends.This role ensures that data shown in Visual Factory is accurate, consistent, actionable, and trusted by manufacturing operations, quality teams, and leadership.Roles & Responsibilities1. Manufacturing KPI Definition & Ownership
- Define, document, and govern manufacturing KPIs used in Visual Factory:
- OEE (Availability, Performance, Quality)
- Downtime, scrap, yield, throughput
- Shift / line / site / enterprise-level metrics
- Own KPI definitions, formulas, thresholds, and hierarchies (KPI Trees).
- Ensure KPI standardization across plants, lines, and regions.
- Act as the single source of truth for KPI interpretation.
2. Data Analysis & Insight Generation
- Analyze manufacturing data to:
- Identify performance trends and anomalies
- Detect production losses, bottlenecks, and quality issues
- Translate raw data into actionable insights for operations and management.
- Support root cause analysis using data from Visual Factory dashboards.
- Recommend data-driven improvements to manufacturing processes.
3. Data Mapping & Validation
- Identify and document data sources (MES, historians, ERP, quality systems).
- Define business rules for data aggregation, rollups, and calculations.
- Validate data accuracy and completeness across source → API → dashboard.
- Work closely with API and QA teams to resolve data mismatches or KPI inaccuracies.
4. Dashboard & Reporting Enablement
- Define requirements for Visual Factory dashboards:
- KPI Trees
- Shift/line views
- Trend and drill-down reports
- Validate dashboard outputs against business expectations.
- Support self-service analytics and ad-hoc reporting initiatives where applicable.
- Ensure dashboards support decision-making, not just visualization.
Key Responsibilities1. Develop and maintain sql queries and scripts for efficient data retrieval.
2. Utilize data analysis techniques to interpret complex data sets and identify trends.
3. Design and implement python scripts for automation and data manipulation.
4. Collaborate within team to gather requirements and deliver high-quality solutions.
5. Participate in code reviews, troubleshoot issues, and optimize application performance.
6. Create data visualizations and reports to present findings to stakeholders.
7. Stay updated on emerging technologies and trends in sql, data analysis, and python.Skill Requirements1. Proficiency in sql for database querying and manipulation.
2. Strong knowledge of data analysis techniques and tools.
3. Experience in python programming for software development and automation.
4. Good problem-solving skills and attention to detail.
5. Ability to work effectively in a team environment and communicate technical concepts clearly.Other Requirements1.Relevant certifications in sql, data analysis, or python are a plus.Information at a GlanceWhy HCLTech?At HCLTech, you’ll supercharge your potential. You’ll find your career. And you’ll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.Copyright © 2025 HCL Technologies Limited×Cookie Consent ManagerWhen you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. Because we respect your right to privacy, you can choose not to allow some types of cookies. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer.Required CookiesThese cookies are required to use this website and can’t be turned off.Show More DetailsRequired Cookies Provider Description Enabled
SAP as service providerWe use the following session cookies, which are all required to enable the website to function:
- “route” is used for session stickiness
- “careerSiteCompanyId” is used to send the request to the correct data center
- “JSESSIONID” is placed on the visitor’s device during the session so the server can identify the visitor
- “Load balancer cookie” (actual cookie name may vary) prevents a visitor from bouncing from one instance to another
Functional CookiesThese cookies provide a better customer experience on this site, such as by remembering your login details, optimizing video performance, or providing us with information about how our site is used. You may freely choose to accept or decline these cookies at any time. Note that certain functionalities that these third-parties make available may be impacted if you do not accept these cookies.Show More DetailsFunctional Cookies Provider Description Enabled
VimeoVimeo is a video hosting, sharing, and services platform focused on the delivery of video. Opting out of Vimeo cookies will disable your ability to watch or interact with Vimeo videos.YouTubeYouTube is a video-sharing service where users can create their own profile, upload videos, watch, like, and comment on videos. Opting out of YouTube cookies will disable your ability to watch or interact with YouTube videos.Advertising CookiesThese cookies serve ads that are relevant to your interests. You may freely choose to accept or decline these cookies at any time. Note that certain functionality that these third parties make available may be impacted if you do not accept these cookies.Show More DetailsAdvertising Cookies Provider Description Enabled
Google AnalyticsGoogle Analytics is a web analytics service offered by Google that tracks and reports website traffic.Google Tag ManagerGoogle Tag Manager is a tag management system for conversion tracking, site analytics, remarketing, and more.LinkedInLinkedIn is an employment-oriented social networking service. We use the Apply with LinkedIn feature to allow you to apply for jobs using your LinkedIn profile. Opting out of LinkedIn cookies will disable your ability to use Apply with LinkedIn.
Discover more from Whitehattoolbox Jobs
Subscribe to get the latest posts sent to your email.
