Data Warehouse Lead

Uplers; United States; Remote; USD 80,000 - 120,000; Full time

Job summary

An established industry player is seeking a passionate Data Warehouse Lead to drive the design and implementation of their enterprise data warehouse. This role involves leading a team, ensuring data integrity, and collaborating with stakeholders to meet analytical needs. The ideal candidate will have extensive experience in data warehousing principles, ETL processes, and cloud solutions. Join a dynamic environment that values growth and innovation, and make a significant impact on data-driven decision-making. If you're ready for a new challenge, this opportunity offers a supportive culture and the chance to advance your career.

Benefits

Day off on the 3rd Friday of every month

Monthly Wellness Reimbursement Program

Monthly Office Commutation Reimbursement Program

Paid paternity and maternity leaves

Qualifications

• 7-8 years of experience in data warehousing, with at least 3 years in a lead role.
• Strong proficiency in SQL and experience with various database platforms.

Responsibilities

• Lead the design and maintenance of data models optimized for reporting.
• Ensure data quality and integrity throughout the warehousing process.

Skills

dBT tool

GCP

SQL

ETL

Team Handling

Data warehouse

Snowflake

Education

Bachelor's degree in Computer Science

Master's degree in Information Technology

Tools

BigQuery

Redshift

Job description

Data Warehouse Lead

Experience: 7 - 10 Years Exp
Salary : Competitive
Preferred Notice Period: Within 30 Days
Shift: 10:00AM to 7:00PM IST
Opportunity Type: Remote
Placement Type: Permanent

(*Note: This is a requirement for one of Uplers' Clients)

Must have skills required :
dBT tool, GCP, Affiliate Marketing Data, SQL, ETL, Team Handling, Data warehouse, Snowflake
Good to have skills :
BigQuery, Redshift

Forbes Advisor (One of Uplers' Clients) is Looking for:
Data Warehouse Lead 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
Job Description:
Data Warehouse Lead
Forbes Advisor is a new initiative for consumers under the Forbes Marketplace umbrella that provides journalist- and expert-written insights, news and reviews on all things personal finance, health, business, and everyday life decisions.
Forbes Marketplace is seeking a highly skilled and experienced Data Warehouse engineer to lead the design, development, implementation, and maintenance of our enterprise data warehouse. We are seeking someone with a strong background in data warehousing principles, ETL/ELT processes and database technologies. You will be responsible for guiding a team of data warehouse developers and ensuring the data warehouse is robust, scalable, performant, and meets the evolving analytical needs of the organization.

Responsibilities:
Lead the design, development and maintenance of data models optimized for reporting and analysis.
Ensure data quality, integrity, and consistency throughout the data warehousing process to enable reliable and timely ingestion of data from the source system.
Troubleshoot and resolve issues related to data pipelines and data integrity.
Work closely with business analysts and other stakeholders to understand their data needs and provide solutions.
Communicate technical concepts to non-technical audiences effectively.
Ensure the data warehouse is scalable to accommodate growing data volumes and user demands.
Ensure adherence to data governance and privacy policies and procedures.
Implement and monitor data quality metrics and processes.
Lead and mentor a team of data warehouse developers, providing technical guidance and support.
Stay up-to-date with the latest trends and technologies in data warehousing and business intelligence.
Foster a collaborative and high-performing team environment.

Qualifications:
Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
7-8 years of progressive experience in data warehousing, with at least 3 years in a lead or senior role.
Deep understanding of data warehousing concepts, principles and methodologies.
Strong proficiency in SQL and experience with various database platforms (e.g., BigQuery, Redshift, Snowflake).
Good understanding of Affiliate Marketing Data (GA4, Paid marketing channels like Google Ads, Facebook Ads, etc - the more the better).
Hands-on experience with dbt and other ETL/ELT tools and technologies.
Experience with data modeling techniques (e.g., dimensional modeling, star schema, snowflake schema).
Experience with cloud-based data warehousing solutions (e.g., AWS, Azure, GCP) - GCP is highly preferred.
Excellent problem-solving, analytical, and troubleshooting skills.
Strong communication, presentation, and interpersonal skills.
Ability to thrive in a fast-paced and dynamic environment.
Familiarity with business intelligence and reporting tools (e.g., Tableau, Power BI, Looker).
Experience with data governance and data quality frameworks is a plus.

Perks:
Day off on the 3rd Friday of every month (one long weekend each month).
Monthly Wellness Reimbursement Program to promote health well-being.
Monthly Office Commutation Reimbursement Program.
Paid paternity and maternity leaves.

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:
Forbes Advisor is a global platform dedicated to helping consumers make the best financial choices for their individual lives.

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!