Get 10x More Interviews Without Applying Manually | OptimHire

OptimHire
OptimHire Job Auto-Applier
★★★★★
Install
We're excited to introduce the all new OptimHire Mobile App
Trusted by 50,000+ job seekers
Looking to Hire?
Urgently hiring

Data Engineer

Refer and Earn up to $200 USD

Refer & Earn

Get 10x More Interviews
Without Applying Manually

OptimHire’s Job Auto-Applier that will automatically apply to jobs at 300,000+ Companies.

★ ★ ★ ★ ★
Trusted by 50,000+ job seekers

Description

Role Overview

 We are seeking a highly skilled Data Engineer / BI Engineer with experience in designing ETL/ELT pipelines, managing databases, and developing dashboards using Power BI. The ideal candidate will be responsible for handling end-to-end data workflows, from data extraction and transformation to visualization and insights generation. This role provides an opportunity to be a part of a growing modern Data & AI Engineering team working to build an industry-transforming product.

 Key Responsibilities

Design, develop, and maintain ETL/ELT pipelines using Python, Airflow, and SQL to manage and optimize data lake and data warehouse solutions in an AWS environment.

Extract and integrate data from third-party APIs and optimize queries to improve performance and ensure efficient database operations.

Develop and maintain dynamic dashboards and reports in Power BI for management consumption as per stakeholder requirements.

Perform data profiling and source system analysis to ensure data quality and integrity. Independently validate and assess the accuracy of data outputs before delivery, ensuring results align with business expectations.

Proactively evaluate different technical approaches and suggest alternatives to ensure optimal outcomes within the broader system and business context.

Implement best practices in data engineering, architecture, and analysis for the continuous improvement of data solutions.

Requirements

4+ years of experience in data engineering, ETL/ELT pipeline development, and data warehouse management solutions on AWS. Strong expertise in SQL (T-SQL, MS SQL) with a focus on query optimization and database performance tuning.

Proficiency in Python (including data-specific libraries such as Pandas, NumPy, etc.) and Airflow for ETL/ELT processes. Experience extracting and managing data from third-party APIs (REST, JSON).

Strong expertise in Power BI for data visualization, dashboard creation, and insight generation through data analysis.

Demonstrated ability to think critically and evaluate multiple technical solutions in the broader context of system architecture and business goals while proactively identifying problems and implementing alternative solutions

Strong communication skills and familiarity with agile methodologies with a continuous improvement mindset.

Preferred Qualifications

Exposure to AWS cloud data services such as RedShift, Athena, Lambda, Glue, etc.

Experience with additional BI tools like Tableau/QlikSense.

Knowledge of data lake architectures and best practices.

Experience with AI-driven data analytics, or integrating AI models with BI solutions.

Benefits

Opportunity to gain hands-on experience working with a talented team of data and AI professionals on AI technologies and modern data engineering practices.

Competitive salary, benefits, and opportunities for growth.

A collaborative, fast-paced, and innovative culture that values initiative, ownership, and smart solutions.

Flexible remote work opportunity



Shift Time: 3:30am to 12:30pm


Position

ML/AI Engineers

Data Analysts

Data Scientist

Data Engineer

Must have skills

Python - 3 years

SQL - 3 years

ETL(Extract, Transform, Load) - 4 years

Apache Airflow - 2 years

AWS - 3 years

Nice to have skills

Power BI - 3 years

Pandas - 2 years

Data Visualization - 2 years

Redshift - 1 years

AWS Lambda - 1 years

AWS Athena - 1 years

Tableau - 1 years

Qliksense - 1 years

Access to 10M Jobs Get the OptimHire App

Your Dream Job is
Just a Tap Away

Search smarter, apply faster, and track application on the go with the OptimHire App.

AI Powered Job Search

AI Powered
Job Search

Access to 10M Jobs

Access to
10M Jobs

Auto-Apply to Job

Auto-Apply
to Job

AI Powered Custom Resumes

AI Powered
Custom Resumes

Trusted by 50,000+ job seekers
OptimHire App Preview