Experienced Data Warehouse Engineer and Developer – Design, Develop, and Implement Scalable Data Warehousing Solutions for Business Intelligence and Data Analytics

Introduction to Forbes Advisor

Forbes Advisor is a pioneering initiative under the Forbes Marketplace umbrella, dedicated to providing consumers with expert-written insights, news, and reviews on personal finance, health, business, and everyday life decisions. Our mission is to empower individuals with the knowledge and research they need to make informed decisions, allowing them to focus on what matters most. As a dynamic and growing company, we offer the excitement of a startup with the stability and benefits of a seasoned organization.

Job Overview

We are seeking an experienced Data Warehouse Engineer and Developer to join our team, responsible for designing, developing, and implementing scalable data warehousing solutions that drive business intelligence and data analytics. This hybrid role offers the flexibility to balance your time between our remote office and home, providing an ideal work-life balance. As a key member of our team, you will play a crucial role in driving success through your strong and diverse skillset in relevant areas.

Key Responsibilities

As a Data Warehouse Engineer and Developer, your primary responsibilities will include:

• Developing and designing DW solutions that adhere to industry standards, practices, and procedures, as well as attributes of business intelligence tools and systems.
• Collaborating as a team member on multiple projects, ensuring seamless execution and delivery.
• Creating data load jobs, scripts, and sequences, reviewing and validating data loaded into the data warehouse for accuracy.
• Prototyping solutions, preparing test scripts, and conducting tests and data replication, extraction, loading, cleansing, and data modeling for data warehouses.
• Implementing best practices in data warehouses and advising users on conflicts and inappropriate data usage.
• Understanding and implementing data warehouse development in multi-platform environments.
• Understanding data mining in a data warehouse environment, including data design, database architecture, metadata, and repository creation.
• Maintaining knowledge of software tools, languages, scripts, and shells that effectively support the data warehouse environment in different operating system environments.

Essential Qualifications

To be successful in this role, you should possess:

• Independently design and implement data warehousing solutions, ETL, BI, and database.
• Good knowledge of DBT.
• A degree in BE, B.Tech, or MCA.
• Strong experience in data warehousing, ETL, BI exposure, and database.
• Experience in data analytics, with a minimum of 2 years.
• Experience in ETL, with a minimum of 3-5 years (DBT is an advantage, or Informatica, DataStage, Azure, etc.).
• Basic understanding of physical and logical data models.
• Basic knowledge of SQL and shell scripting.

Preferred Qualifications

While not essential, the following skills and qualifications are desirable:

• Strong verbal and written communication skills.
• Team collaboration and time management skills.
• Experience working in a fast-paced, dynamic environment.

Skills and Competencies

To excel in this role, you should possess:

• Strong technical skills in data warehousing, ETL, BI, and database.
• Excellent problem-solving and analytical skills.
• Ability to work independently and as part of a team.
• Strong attention to detail and ability to deliver high-quality results.
• Excellent communication and interpersonal skills.

Career Growth Opportunities and Learning Benefits

At Forbes Advisor, we are committed to the growth and development of our employees. As a Data Warehouse Engineer and Developer, you will have access to:

• Ongoing training and development opportunities to enhance your skills and knowledge.
• Mentorship and guidance from experienced professionals in the field.
• Opportunities to work on diverse projects and collaborate with cross-functional teams.
• A dynamic and supportive work environment that encourages innovation and creativity.

Work Environment and Company Culture

Our company culture is built on the values of excellence, collaboration, and innovation. We offer a flexible and remote work environment that allows you to balance your work and personal life. Our team is friendly, supportive, and passionate about what we do, and we are committed to making a positive impact on the lives of our consumers.

Compensation, Perks, and Benefits

We offer a competitive salary and a range of perks and benefits, including:

• A day off on the 3rd Friday of every month (one long weekend each month).
• A monthly wellness reimbursement program to promote health and well-being.
• Paid paternity and maternity leaves.
• Opportunities for professional growth and development.

Conclusion

If you are a motivated and experienced Data Warehouse Engineer and Developer looking for a new challenge, we encourage you to apply for this exciting opportunity. Even if you don't feel you are a perfect match, we would still love to hear from you. Our team is friendly, and we are committed to finding the right person for this role. Don't miss out on this opportunity to join a dynamic and growing company and take your career to the next level.

Apply now and become a part of our team!