Urgent Role - Cloud Data Analyst || Remote

Title: Cloud Data Analyst

Location: Remote

Duration: 3-6 Months

Description

100% Remote

Candidates need to take a video screen with prime vendor prior to end client submittal

Required Information for Submittals (need candidate response) -4 bullet points on candidate experience:

BI reporting exp.

ETL experience

Experience With Business Requirements Gathering.

Experience using AWS Redshift

Knockout Questions (need candidate response)

Provide an example of a past project where they used redshift to pull data from a system using an ETL process.

What reports have you had to create in a BI reporting tool for the business?

Have you worked with business users or stakeholders to identify business requirements and what reports they need?

Understanding Of Stakeholder Needs

• The candidate should mention their approach to understanding the needs and objectives of stakeholders, including business users or project managers.

Data Exploration

• They should discuss how they explore and analyze existing data sources, if available, to get a sense of the data landscape.

Required Skills

Experience pulling data from a system using Redshift and ETL process

Experience creating complex BI Reports and using BI reporting tools (Tableau/PowerBI and QuickSight)

Business requirements gathering and translating that into technical requirements (working with both the business and technical teams)

Strong knowledge in SQL

Reason for Opening

They have an old legacy system(Ultimate) they need to pull data from and create reports for stakeholders.

Business Objectives & Key Project Details

They are starting to utilize BI reporting tools. They have an old legacy system they need to pull data from into a Datawarehouse so they can create reports. They will be using AWS Redshift to do this along with ETL processes and using either Tableau or PowerBI to create the reports.

% breakdown of what they will be doing

They will be working with stakeholders (Purchasing managers) to gather business requirements and what reports they need.

Work with the technical team to translate those business requirements into what Data they need to pull

They will be using the raw data they get from the data engineers to do ETL work into their BI reporting tool to create the reports for stakeholders.

They will be creating a new ETL process on how to do that within NPW.

They will be creating reports for Purchasing, invoice, inventory data, etc.

Position Overview

As a Cloud Data Analyst you will play a pivotal role in designing, implementing, and maintaining our data analysis processes, utilizing AWS cloud services, Redshift, SQL, and QuickSight. You will collaborate closely with cross-functional teams to ensure our data-driven decisions are accurate, insightful, and support our business objectives. This role demands a proactive problem solver with a deep understanding of data analysis techniques, cloud architecture, and data visualization tools.

Key Responsibilities

Utilize your expertise in AWS services (or similar cloud platforms), Redshift, SQL, and QuickSight to design and develop robust data pipelines, ETL processes, and data models.

Collaborate with data engineers, data scientists, and business stakeholders to understand data requirements and translate them into actionable insights.

Write and optimize complex SQL queries to extract, transform, and load data from various sources into our Redshift data warehouse.

Develop interactive and visually appealing dashboards and reports using QuickSight to convey meaningful insights to business users.

Monitor and maintain the performance, availability, and security of our data infrastructure, identifying and resolving issues promptly.

Stay up to date with the latest industry trends, best practices, and emerging technologies related to cloud data analysis and visualization.

Requirements

Bachelor's degree in computer science, Information Technology, or a related field.

Proven experience in cloud data analysis, preferably using AWS services (or similar cloud platforms).

Strong proficiency in SQL and experience with database design and optimization.

Familiarity with data warehousing concepts and working knowledge of Amazon Redshift or similar data warehousing solutions.

Experience with Pick Basic systems and Rocket Universe database preferred but not required.

Proficiency in data visualization tools such as Quicksight, Tableau, or Power BI.

Excellent problem-solving skills and the ability to analyze complex data sets.

Effective communication skills, both written and verbal, to collaborate with technical and non-technical stakeholders.

Strong attention to detail and a commitment to producing high-quality work.

AWS certification(s) is a plus, but not mandatory.

Thanks & Regards,

Deepak Pandey

Talent Acquisition - North America

[email protected]