HCLTech is a global technology company, home to more than 227,000 people across 60 countries, delivering industry-leading capabilities centered around AI, digital, engineering, cloud and software, 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 & Services, Semiconductor, Telecom and Media, Retail and CPG, Mobility and Public Services. Consolidated revenues as of 12 months ending March 2026 totaled $14.7B
Overview of the Role
As an Analytics Engineer at HCLTech, you will play a pivotal role in shaping the organization’s business intelligence (BI) capabilities. Your contributions will drive data-driven decision-making by designing robust data models, developing scalable data pipelines, and ensuring high-quality, accessible data for analytics and reporting. This role is critical to advancing HCLTech’s strategic objectives by enabling actionable insights, maintaining data integrity, and optimizing the performance of BI solutions.
Detailed Responsibilities
- Design and develop data models tailored for analytics and reporting, ensuring scalability and accuracy.
- Construct, review, and optimize SQL scripts and queries to support business intelligence initiatives.
- Develop and support Extract, Transform, Load (ETL) processes and data pipelines, facilitating seamless data integration from multiple sources.
- Map and transform source data to semantic and reporting layers, enabling effective and intuitive data consumption across the business.
- Collaborate with business and technical stakeholders to troubleshoot and resolve data quality, data integrity, and performance issues.
- Prepare and deliver comprehensive documentation, including mapping documents, validation reports, data quality notes, and semantic-layer handover packs.
- Ensure clear data lineage and maintain up-to-date documentation to support transparency and compliance.
- Contribute to the continuous improvement of BI development standards, best practices, and methodologies.
Skill Requirements
- Proficiency in SQL and experience with at least one major RDBMS (Oracle, MSSQL, MySQL, PostgreSQL, Teradata, Hive).
- Strong understanding of data modeling concepts, including ER modeling and Kimball/data warehousing methodologies.
- Experience designing and implementing semantic layers for BI/reporting tools.
- Hands-on experience with cloud-based data platforms such as Amazon Redshift, Snowflake, or Google BigQuery.
- Familiarity with ETL concepts and tools for building and maintaining data pipelines.
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or a related field.
- Demonstrated ability to deliver high-quality data models, SQL scripts, and documentation with minimal defects.
- Excellent analytical, problem-solving, and communication skills.
Other Requirements (Optional)
- Experience with programming languages such as Python or R for data manipulation and analysis.
- Prior exposure to data quality frameworks and data governance practices.
- Certifications in data engineering, cloud platforms, or business intelligence tools.
- Experience working in agile, cross-functional teams within a global enterprise environment.