09 Sep
|
Lenovo
|
Bengaluru
Roles and Responsibilities :
- - As a Senior Data Engineer, you will be involved in data Lakehouse development including requirements gathering, database modeling, ETL job design & development, and dashboard/report development activities.
- You will be working with the Customer Experience team to build and enhance a cloud-based warehouse of operational data to drive analytics.
- You will be responsible for developing ETL/data pipelines using Talend, SQL, and Python, and ingesting data from various external sources into large MPP data warehouses such as Azure Synapse, Hive, Snowflake, or similar platforms.
- You will frequently conduct data analysis, ingest data from various internal and external sources, write advanced SQL queries, and optimize data storage needed by business and executive operations.
- You will partner with business stakeholders to analyze operational data, investigate trends, answer ad hoc business questions, and provide data-driven recommendations that support strategic and operational decision-making.
- You will perform exploratory data analysis, validate data quality, identify anomalies, reconcile data across multiple sources, and translate business requirements into SQL-based analyses and actionable insights.
- You will develop complex SQL queries to extract, profile, reconcile, and analyze large datasets, helping stakeholders understand business performance, customer behavior, operational metrics, and data quality issues.
- You will enable daily business activities by providing the foundation for all federated querying and analysis produced by the BI and Data Science teams.
- You will collaborate closely with Product Managers, Business Analysts, BI Developers, and Data Scientists to ensure data is accurate, reliable, and optimized for reporting, advanced analytics, and machine learning initiatives.
- You will have the opportunity to work with up-to-date data stack components and continuously grow by learning new tools and technologies in a collaborative, data-driven environment.
- Job Requirements :
- - Bachelor's/Master's degree in Computer Science, Mathematics, or Science.
- Minimum 5 years of experience in ETL development and coding, including validation of complex data mappings.
- Hands-on experience with ETL Tool Talend (minimum 5 years).
- Proficient in SQL with at least 8 years of experience developing complex SQL queries for data validation, troubleshooting, and business analysis.
- Experience in Python for data processing and transformation tasks.
- Strong experience with data warehouse databases such as Azure Synapse, Hive, Snowflake, SQL Server, or Redshift.
- Experience and knowledge in ingesting data from various external sources is a must-have.
- Strong analytical and problem-solving skills with the ability to analyze large datasets and translate findings into meaningful business insights.
- Experience performing data profiling, data quality analysis, data reconciliation, and root cause analysis using SQL.
- Experience working with business stakeholders to understand analytical requirements and support data-driven decision-making.
- Excellent oral and written communication skills.
- Experience working with cloud-based data platforms.
-
📌 Senior Data Engineer (Bengaluru)
🏢 Lenovo
📍 Bengaluru