Experience: 7.00 + years
Salary: INR 2000000-3000000 / year (based on experience)
Expected Notice Period: 15 Days
Shift: (GMT+05:30) Asia/Kolkata (IST)
Opportunity Type: Remote
Placement Type: Full Time Permanent position(Payroll and Compliance to be managed by: Canibuild Technologies India Pvt ltd)
(*Note: This is a requirement for one of Uplers client - Canibuild Technologies India Pvt ltd)
What do you need for this opportunity
Must have skills required:
Athena, Glue, Lambda, Airflow, Commercial Projects, PowerBI, AWS, JSON, MySQL, Python, Redshift, RestAPI, Tableau
Canibuild Technologies India Pvt ltd is Looking for:
The Position:
We are seeking an experienced Data Engineer to join our team of passionate professionals working on cutting-edge technology. In this role, you will be responsible for the ELT of Canibuild data using Python, Airflow, and SQL within an AWS environment. Additionally, you will create and maintain data visualizations and dashboards using PowerBI, connecting to our SQL Server and PostgreSQL Aurora database through a gateway. This position offers a unique opportunity to influence architectural decisions and contribute to the development of a data warehouse in a cloud-native environment.
Responsibilities:
Design, develop, and maintain ELT pipelines using Python, Airflow, and SQL in an AWS environment.
Create and manage a data lake and data warehouse solutions on AWS.
Develop and maintain data-driven dashboards and reporting solutions in PowerBI.
Connect PowerBI to SQL Server and PostgreSQL Aurora databases using a gateway.
Perform data profiling and source system analysis to ensure data quality and integrity.
Collaborate with business stakeholders to capture and understand data requirements.
Implement industry best practices for data engineering and visualization.
Participate in architectural decisions and contribute to the continuous improvement of data solutions.
Follow agile practices and a lean approach in project development.
Optimize SQL queries for performance and ensure efficient database operations.
Perform database tuning and optimization as needed.
Required Skills and Experience:
Expert-level proficiency in SQL (TSQL, MS SQL) with a strong focus on optimizing SQL queries for performance.
At least 7 years of experience will be preferred.
Extensive experience with Python and Airflow for ELT processes.
Proven experience in designing and developing data warehousing solutions on the AWS cloud platform.
Strong expertise in PowerBI for data visualization and dashboard creation.
Familiarity with connecting PowerBI to SQL Server and PostgreSQL Aurora databases.
Experience with REST APIs and JSON.
Agile development experience with a focus on continuous delivery and improvement.
Excellent problem-solving skills and a proactive can-do attitude.
Strong communication skills and the ability to work collaboratively in a team environment.
Curiosity and eagerness to learn and adapt to new technologies and methodologies.
Ability to perform database tuning and optimization to ensure efficient data operations
Desired Skills.
Exposure to AWS Cloud Data Services such as RedShift, Athena, Lambda, Glue, etc.
Experience With Other Reporting Tools Like Tableau.
Knowledge of data lake architectures and best practices.
Benefits:
Flexible work arrangements.
Full Time Remote Work
Opportunity to grow with a fast-scaling company.
Recognition and reward for your contributions.
Join Canibuild and be a part of a transformative journey in the construction industry.
Must Have Skills:
Python, Airflow, SQL and powerBI in a commercial way,
Should have worked in AWS environment
Engagement Type:
Payroll and Compliacne to be managed by: Canibuild Technologies India Pvt ltd
Job Type : Direct Hire with Canibuild
Location: Remote
Interview Process
HR screening
Assessment Round
R1 - tech round by Lead
How to apply for this opportunity
- Register or login on our portal & fill out the application form.
- Clear the given Video Screening (30 min) and Click on Apply to get shortlisted
- Once it's all done, your profile will be shared with the client for the Interview round.
- When selected, just meet the client and get your exciting career started!
About Uplers:
Our goal is to make hiring reliable, simple, and fast. Our role will be to help all our talents find and apply for relevant contractual onsite opportunities and progress in their career. We will support any grievances or challenges you may face during the engagement. You will also be assigned to a dedicated Talent Success Coach during the engagement.
(Note: There are many more opportunities apart from this on the portal. Depending on the assessments you clear, you can apply for them as well).
So, if you are ready for a new challenge, a great work environment, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you!