Job
Description
Senior Data Engineer (SQL, Python & AWS) Experience: 9-15 years Salary : INR 35,00,000-45,00,000 / year Preferred Notice Period : Within 30 Days Shift : 5:30AM to 2:30PM IST Opportunity Type: Remote Placement Type: Permanent (*Note: This is a requirement for one of Uplers' Clients) Must have skills required : Airflow, ETL pipelines, PostgreSQL Aurora database, PowerBI, AWS, Python, RestAPI, SQL Good to have skills : Athena, Data Lake Architecture, Glue, Lambda, JSON, Redshift, Tableau Leading Proptech Company (One of Uplers' Clients) is Looking for: Data Engineer (WFH) who is passionate about their work, eager to learn and grow, and who is committed to delivering exceptional results. If you are a team player, with a positive attitude and a desire to make a difference, then we want to hear from you. Role Overview Description 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 our Company 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 role requires strong critical thinking, the ability to assess data and outcomes, and proactive problem-solving skills. 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. ¢ Extract and integrate data from third-party APIs to populate the data lake. ¢ 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. ¢ Critically assess the outcomes of your work to ensure they align with expectations before marking tasks as complete. ¢ Optimize SQL queries for performance and ensure efficient database operations. ¢ Perform database tuning and optimisation as needed. ¢ Proactively identify and present alternative solutions to achieve desired outcomes. ¢ Take ownership of end-to-end data-related demands from data extraction (whether from internal databases or third-party apps) to understanding the data, engaging with relevant people when needed, and delivering meaningful solutions. Required Skills and Experience: ¢ At least 9+ years of experience will be preferred. Strong critical thinking skills to assess outcomes, evaluate results, and suggest better alternatives where appropriate. ¢ Expert-level proficiency in SQL (TSQL, MS SQL) with a strong focus on optimizing queries for performance. ¢ Extensive experience with Python (including data-specific libraries) and Airflow for ELT processes. ¢ Proven ability to extract and manage data from third-party APIs. ¢ 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. ¢ Proactive mindset able to suggest alternative approaches to achieve goals efficiently. ¢ Excellent problem-solving skills and a proactive can-do attitude. ¢ Strong communication skills and the ability to work collaboratively in a team environment. ¢ Ability to independently assess data, outcomes, and potential gaps to ensure results align with business goals. ¢ 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. How to apply for this opportunity: Easy 3-Step Process: 1. Click On Apply! And Register or log in on our portal 2. Upload updated Resume & Complete the Screening Form 3. Increase your chances to get shortlisted & meet the client for the Interview! About Our Client: We are a cloud-based residential sales platform designed to bridge the communication gap between clients, sales teams, and construction teams. Our goal is to ensure seamless collaboration, resulting in buildable and well-aligned residential projects. As builders with a strong tech foundation, we bring deep industry expertise to every solution we create. About Uplers: Our goal is to make hiring and getting hired reliable, simple, and fast. Our role will be to help all our talents find and apply for relevant product and engineering job opportunities and progress in their career. (Note: There are many more opportunities apart from this on the portal.) 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!
