Junior BI Operations Engineer

Overview

The Junior BI Operations Engineer will assist in monitoring, maintaining, and reporting for 24x7 Enterprise BI operations and schedules. Working under the guidance of senior team members, the role supports incident and problem management, daily ETL pipelines, enterprise reporting data, data warehousing, automated ETL operations, Python scripting, and AI-driven workflows.

What you'll do

• Assist in daily 24x7 monitoring and operational reporting for ETL/ELT data pipelines and BI systems.
• Serve as 1st-level (L1) support for business users and applications by investigating, triaging, and resolving basic system alerts or job failures.
• Help prepare and maintain job scheduling modules.
• Document and update runbooks with runtime statistics and operational steps.
• Participate in KT sessions with Data Engineering and Development teams for seamless handovers to the Ops environment.
• Support automation of routine operational checks using Python and Shell scripting.
• Apply version control best practices via GitHub.
• Leverage modern AI and LLM tools to assist in log analysis, query optimization, bug fixing, and process documentation.
• Bridge technical issues with non-technical business users through clear verbal and written communication.

What you'll need

• 1 to 3 years of relevant experience in BI, Data Operations, L1/L2 Support, or Data Engineering.
• Foundational to working knowledge of SQL, PL/SQL, and relational database concepts.
• Basic understanding of data warehousing concepts, including dimensional modeling, staging, and star schema.
• Hands-on experience or working knowledge of Python and Unix/Linux Shell scripting for automation tasks.
• Familiarity with GitHub or Git workflows for code repository management and version tracking.
• Basic knowledge or practical exposure to AI & Large Language Model (LLM) tools, such as using LLM assistants for code debugging, prompt-assisted scripting, or log pattern detection.
• Exposure to or working knowledge of cloud data platforms like Snowflake DB.
• Exposure to ETL tools, such as Pentaho Data Integration, Talend, or Informatica.
• Exposure to job schedulers, such as Airflow, Control-M, or Autosys.
• Strong analytical and troubleshooting skills with a willingness to learn root-cause analysis and bug fixing.
• Willingness to work in shifts within a 24x7 operational rotation.
• Bachelor’s or Master’s Degree in Computer Science, Information Systems, Data Analytics, or a related technical field, or equivalent practical industry experience.

Nice to have

• Hands-on experience with Pentaho Data Integration (PDI) scheduling.
• Basic understanding of CI/CD concepts applied to data pipelines.
• Familiarity with ticketing tools like Jira, ServiceNow, or similar ITSM platforms.

Details

• Location: Chennai, India.
• The role operates on a shift system as part of a global 24x7 BI Operations team.