Python Senior Technical Lead - Data Analysis, SQL

HCL Technologies
HCL Technologies

Software Engineering, IT, Data Science

Posted on Jun 19, 2026
Job Description
Python Senior Technical Lead - Data Analysis, SQL
Ajax, Ontario

Job Summary

Data Analyst Job DescriptionRole SummaryThe Data Analyst will be responsible for translating raw data into actionable insights, providing data-driven recommendations to support business strategy and decision-making. This role involves collecting, cleaning, analyzing, and visualizing data to identify trends, patterns, and opportunities for process and performance improvement.Collect clean and analyze operational data and generate dashboards and reports tracking KPIs (e.g. order ingestion volumes, error rates , SLA adherence)Conduct trend analysis and performance monitoringProvide recommendations for process improvements based on data insightsCollaborate with Operational Analyst and Operation Managers for data validationKey Responsibilities and DutiesData Acquisition and Preparation:Extract, Transform, and Load (ETL) data from various primary and secondary data sources (e.g., internal databases, cloud platforms, external APIs).Clean and preprocess raw data to ensure accuracy, consistency, and completeness, including identifying and correcting errors, managing missing data, and transforming formats.Design and maintain databases (e.g., data warehouse models) and data systems to optimize data access and quality.Data Analysis and Interpretation:Apply statistical methods and data analysis techniques to perform exploratory and diagnostic analysis to uncover trends, anomalies, and relationships within complex datasets.Conduct hypothesis testing and develop models (e.g., regression analysis) to support business questions and predict outcomes.Define, track, and report on Key Performance Indicators (KPIs) and metrics across various business functions (e.g., Marketing, Sales, Operations).Reporting and Visualization:Design, develop, and maintain interactive dashboards and reports using visualization tools to present data in a clear, digestible format for both technical and non-technical audiencesCollaboration and Improvement:Collaborate with cross-functional teams (e.g., Data Engineering, Product, IT) to understand data requirements and deliver targeted, timely insights.Proactively identify and recommend process improvements, system modifications, and operational changes based on data analysis.Required Qualifications and SkillsEssential Technical Skills (Hard Skills)SQL (Structured Query Language): Advanced proficiency in writing complex queries, stored procedures, and managing relational databases.Statistical Programming: Expertise in at least one statistical programming language (Python or R) for complex data analysis, statistical modeling, and automation (e.g., using libraries like Pandas, NumPy, Scikit-learn).Data Visualization Tools: High proficiency in industry-standard tools like Tableau, Power BI, or Google Looker Studio for creating interactive dashboards.Spreadsheet Tools: Advanced knowledge of Microsoft Excel (Pivot Tables, VLOOKUPs, functions, modeling).Statistical Analysis: Strong foundation in descriptive and inferential statistics.Essential Workplace Skills (Soft Skills)Critical Thinking and Problem-Solving: The ability to approach a business problem logically, ask the right questions, and find meaningful patterns in data.Communication and Presentation: Excellent verbal and written communication skills to clearly articulate complex technical information and its business implications.Attention to Detail: Meticulous approach to data cleaning and quality assurance to

Key Responsibilities

null

Skill Requirements

null

Other Requirements

null
Information at a Glance

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

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:

Industry-benchmarked compensation

Best-in-class healthcare benefits

Personal time off

Maternity and paternity benefits

Access to skills / higher education programs/resources

Discounts on products and services via Benefit Box

Participate in CSR programs and live life with a purpose

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.