Please find the requirement below, if you find yourself comfortable with the requirement please reply with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number 302-721-5176
Job Title: Cloud Data Analyst
Job Location: 100% Remote
Duration: 3-6+ Months
Work Authorization: Citizen, Green Card only
Interview Process: Video
must have excellent comms
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.
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.
- They should discuss how they explore and analyze existing data sources, if available, to get a sense of the data landscape.
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.
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.
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.
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.
Thank you and Kind wishes
Talent Acquisition -North America
Note- In my absence please reach to Mr. Prince at email@example.com #