Data Engineer

OEC; Chennai District; On-site; INR 1,800,000 - 2,600,000; Full time

Job summary

OEC is seeking a Data Engineer in Chennai to design, develop, and deploy BI solutions, data warehousing, and enterprise data integrations. You will implement access controls and data security measures while maintaining comprehensive documentation.

The role focuses on building scalable ETL pipelines across Azure and AWS, creating dashboards with Power BI or Tableau, and collaborating with business users to deliver actionable insights.

Qualifications

• 3+ years in BI, data engineering and reporting.
• Bachelor’s degree in IT/CS or related field.
• Strong SQL skills and data modelling knowledge.
• Experience with ETL/ELT, SSIS/SSAS and cloud data services.

Responsibilities

• Develops and deploys BI solutions and data warehouse across Azure and AWS.
• Designs and maintains dashboards and reports to drive business decisions.
• Builds scalable data pipelines and ETL processes using cloud services.
• Collaborates with stakeholders to evaluate business needs and data requirements.
• Performs testing and validation across cloud environments; documents results.
• Ensures data security and access controls across platforms.

Skills

Business Intelligence

Data Engineering

SQL

AWS

Azure

Power BI/Tableau

Education

Bachelor’s degree in Information Technology, Computer Science, or related discipline

Tools

AWS

Azure

Power BI

Tableau

SSIS

SSRS

SSAS

Athena

Glue

Lambda

Step Functions

CloudWatch

Job description

Job Description:

Job Title: Data Engineer

Location: Chennai
Reports To: Manager Business Intelligence

Position Overview

Develops effective business intelligence solutions for OEC by designing, developing, and deploying systems to support business intelligence, reporting, data warehousing, and integration with enterprise applications. Implements user access controls and data security measures. Assists in the evaluation of the business to support delivery of effective business intelligence and reporting solutions. Maintains documentation of processes, reports, applications, and procedures.

Key Responsibilities

1. Develops and deploys systems to support business intelligence, reporting, and data warehouse solutions using both Azure and AWS cloud platforms; implements robust user access controls and data security measures across cloud environments.
2. Owns the design, development, and maintenance of ongoing metrics, reports, analyses, and dashboards using tools like Amazon Quick Sight, Microsoft Azure BI solutions to drive key business decisions.
3. Design, build, and maintain scalable data pipelines and ETL processes using Azure and AWS services such as Azure Data Factory, AWS Glue, Amazon Redshift, and S3, ensuring efficient data extraction, transformation, and loading across cloud environments.
4. Anticipates opportunities for improvement in cross-cloud analytics solutions; outlines and identifies alternate solutions leveraging the strengths of both AWS and Azure platforms and presents to management for final approval and implementation.
5. Develops and performs system testing across Azure and AWS environments, fixes defects identified during testing; re-executes unit tests to validate results and ensure compatibility between cloud platforms.
6. Assists in coordination efforts with management and end-users to evaluate business needs and support delivery of effective business intelligence and reporting solutions that leverage the cost-optimization benefits of both Microsoft workloads on AWS and native Azure services.
7. Develops and tests database scripts, stored procedures, triggers, functions, Azure Data Factory pipelines, AWS Glue jobs, and other back-end processes to support seamless system integration across cloud environments.
8. Assists with tabular and multi-dimensional modelling in addition to the development of the Enterprise Data Warehouse using both AWS cloud data warehouse solutions.

Skills & Qualifications

Must-Have:

• At least 3 years of experience in business intelligence, data engineering and reporting required.
• A bachelor’s degree from an accredited college or university is required, with a focus in Information Technology, Computer Science, or related discipline.
• Strong proven track record of developing and testing database scripts, stored procedures, triggers, functions, SSIS Packages, AWS, Glue, Lambda, Step Function, Cloudwatch, Athena.
• Experience using BI/Analytics/Statistical tools like Power BI, Tableau, Business Objects, SSRS, SSAS, and Excel.
• Strong SQL skills, business intelligence tool expertise, AWS Cloud services, and report development skills.
• Knowledge of data modelling, data quality, ETL/SQL server, and SSAS (DAX/MDX) database queries.
• Understanding of configuration, deployment, and database servers.
• Strong writing and verbal communication skills.
• Ability to work collaboratively in a functional team environment.
• Refined analytical thinking and problem-solving skills.

Preferred:

• • Domain expertise in the company’s industry.
  • Certification in AWS or Azure services.