Senior Data Warehouse Analyst

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

Job summary

An innovative firm is seeking a Senior Data Warehouse Analyst to enhance their enterprise data warehouse. This role involves translating business requirements into technical specifications, collaborating with developers, and ensuring data quality. The ideal candidate will have a strong background in SQL, data warehousing principles, and experience with cloud platforms. Join a dynamic team where your analytical skills will help shape data-driven decisions and drive business success. This position offers a chance to work with cutting-edge technologies in a supportive environment that values your contributions and encourages professional growth.

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

• 6-8 years of data experience with 3-5 years as a Data Warehouse Analyst.
• Strong proficiency in SQL and experience querying large datasets.
• Solid understanding of data warehousing concepts and methodologies.

Responsibilities

• Collaborate with stakeholders to understand data and reporting requirements.
• Translate business needs into functional and technical specifications.
• Assist in performance tuning efforts for SQL queries and data retrieval.

Skills

dBT tool

DBT

GCP

Data Warehousing

SQL

Analytical Skills

Snowflake

Amazon Redshift

Education

Bachelor's degree in Computer Science

Bachelor's degree in Information Systems

Bachelor's degree in Business Analytics

Tools

Tableau

Power BI

Looker

Job description

Senior Data Warehouse Analyst

Experience: 6 - 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, DBT, GCP, Data Warehousing, SQL, Analytical Skills, Snowflake, Amazon Redshift
Good to have skills :
Affiliate Marketing

Forbes Advisor (One of Uplers' Clients) is Looking for:
Senior Data Warehouse Analyst 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
Senior Data Warehouse Analyst
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 Senior Data Warehouse Analyst to play a critical role in the development, maintenance, and optimization of our enterprise data warehouse. As a Senior Analyst, you will be responsible for understanding business requirements, translating them into technical specifications, and working closely with data warehouse engineers to ensure the data warehouse effectively supports our reporting and analytical needs. You will also be involved in data quality initiatives, performance analysis, and providing insights to stakeholders.

Responsibilities:
Collaborate with business users, analysts, and other stakeholders to understand their data and reporting requirements.
Translate business needs into clear and concise functional and technical specifications for data warehouse development.
Analyze source system data to understand its structure, quality and potential for integration into the data warehouse.
Work closely with developers to contribute to the design and implementation of logical and physical data models.
Closely integrate with Quality Analysts to identify and troubleshoot data quality issues within the data warehouse.
Assist in performance tuning efforts for SQL queries and data retrieval processes for business stakeholders.
Participate in data quality initiatives, including defining data quality rules and monitoring data accuracy.
Adhere to data governance/security policies and procedures.
Assist in the creation and maintenance of data dictionaries and documentation.
Effectively communicate technical concepts to both technical and non-technical audiences.
Collaborate with data engineers, BI developers, and other team members to deliver data solutions.
Stay up-to-date with the latest trends and technologies in data warehousing and business intelligence.

Qualifications:
Bachelor's degree in Computer Science, Information Systems, Business Analytics, or a related field.
6-8 years of data experience with 3-5 years of experience as a Data Warehouse Analyst or a similar role.
Strong proficiency in SQL and experience querying large datasets across various database platforms (e.g., GCP, Snowflake, Redshift).
Solid understanding of data warehousing concepts, principles, and methodologies (e.g., dimensional modeling, star schema).
Good understanding on Affiliate Marketing Data (GA4, Paid marketing channels like Google Ads, Facebook Ads, etc - the more the better).
Experience working with ETL/ELT processes and tools.
Basic DBT understanding.
Hands-on experience with at least one major business intelligence and data visualization tool (e.g., Tableau, Power BI, Looker).
Excellent analytical, problem-solving, and data interpretation skills.
Strong communication (written and verbal) and presentation skills.
Ability to work independently and as part of a collaborative team.
Detail-oriented with a strong focus on data accuracy and quality.
Experience with cloud-based data warehousing platforms (e.g., AWS, GCP).

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!