Back

Data Engineer

Industry Other
Category Other
Location Kathmandu, Nepal
Expiry date Aug 13, 2025 (2 days left)

Job Description

About Omnicom Media Group Nepal

Our mission is to provide exceptional technology services to OMG agencies.

Established in 2013, OmnicomMediaGroup Nepal is a software company in Nepal and a subsidiary of OmnicomMediaGroup Australia - ranked top in media agencies in Australia. We are a team of around 280+ professionals who are involved in design, development, testing and maintenance of software projects developed in latest technologies. Besides that, our people are also involved in Programmatic projects which involves conversion of business.

Our core competency is Software development in the latest stack of technologies, Business Intelligence, Programmatic and Delivering Finance Function tasks. We strive to go “above and beyond” through our culture of continuous development and improvement and has embedded those into our company values.

We, at Omnicom Media Group Nepal, a subsidiary of OmnicomMediaGroup Australia are looking to hire for the position of Data Engineer.

About this role/ Role Overview

The Data Engineer will collaborate closely with Project Managers, Business Analysts, Quality Assurance, and the Management Team throughout all phases of the Software Development Life Cycle (SDLC), ensuring the timely delivery of high-quality, scalable, and reliable data solutions.

The Data Engineer is responsible for ensuring the reliability, performance, and security of data infrastructure across the organization. This role involves building and maintaining scalable data pipelines, integrating data from diverse sources including APIs, and ensuring efficient data flow across systems. The role also covers writing optimized SQL queries and procedures, writing ETL (Extract-Transform-Load) packages and monitoring the growth of the data pipelines, database changes review & growth setting.

Key Responsibilities

Technical Expertise (65%)

Work through the early stages of software lifecycle & help team design databases that are optimized for performance, reliability, and scalability.
Collaborate with database administrators to monitor database growth, optimize storage, and manage schema changes effectively.
Develop, test, and deploy database code. This involves writing stored procedures, triggers, and functions, as well as creating and maintaining database scripts, and performing data migrations.
Understand the data structure and meaning in both the source and the target BI systems.
Create and maintain database documentation, including data dictionaries, entity-relationship diagrams, and other technical documentation.
Design, build, and manage end-to-end data pipelines for batch and streaming data across cloud and on-premises systems using Glue and other associated technologies.
Develop robust ETL/ELT workflows using orchestration tools like Apache Airflow, or dbt.
Build and maintain automated data ingestion from external marketing/advertising APIs such as: Facebook Ads, Google Ads, Google Analytics, YouTube, TikTok Ads, DV360, LinkedIn Ads, etc.
Handle API authentication (OAuth2, API Keys), pagination, rate-limits, and retries to ensure reliable ingestion.
Work with third-party ETL tools (e.g., Airbyte, Sabermetrics) to streamline data sourcing.
Develop data models and transformations to cleanse, enrich, and structure data for business use.
Create modular, reusable pipeline components that are easy to maintain and monitor.
Create robust monitoring, logging, and alerting systems to ensure pipeline reliability and data freshness.
Proactively debug pipeline issues, performance bottlenecks, or upstream API failures.

Product Quality Assurance (15%)

Maintain data integrity in all databases. Working closely with project and team leads to design effective and efficient database structure.
Regularly monitor resource uses by different applications and notify concerned teams when there is need to upgrade or add resources.
Optimize data access for analytics and BI tools using Starburst and SQL engines over Iceberg tables.
Build aggregated, query-optimized data models for reporting
Collaborate with analysts to ensure datasets are analytics-ready and well-documented.

Team Management (10%)

Assist developers in writing complex queries
Verify the queries created by developer meets performance, security requirement
Document pipelines, data dictionaries, and transformation logic clearly for cross-functional usage.

Stakeholder Management (10%)

Provide regular and effective progress updates to and work closely with Project Managers to ensure the management of database involved in any project.
Work closely with data analysts and product teams to define requirements and data SLAs.

Any other additional tasks or responsibilities as required by the business.

Required Experience & Qualifications / Critical elements of success

Bachelor’s in computer science or equivalent education and experience.
At least 3+ years of experience in database development and management or as a data engineer
Sound knowledge of RDBMS concepts, database architecture and SQL/T-SQL.
Experience working in Cloud Platforms such as AWS, Azure, or GCP (S3, Redshift, Glue, Data Factory, Big Query, etc.) is advantageous
Strong knowledge in Python and SQL
Experienced in designing and building and debugging ETL pipelines using Apache Airflow and other related technologies
Experience in data ETL pipelines using technologies like Airflow, Pandas, MSSQL Server
Strong problem-solving skill, analytical thinking, and attention to detail are crucial
Strong communication and collaboration skills

Why you'll love us

Through our people philosophy, we believe that happy people with a great work/life balance are able to bring the #WOW factor to work and they're more fun to share an office with. Join us and surround yourself with like-minded, high achieving individuals and unbeatable career development opportunities.

To know more about us, please visit the link at https://www.omnicommediagroup.com.np/

Our working hours are generally from 7 am till 4 pm, Monday till Friday.