Data Analyst 1

Typical Day in the Role

• Purpose of the Team: The purpose of this team is \_\_\_\_The team is responsible for supporting supply chain operations by ensuring accurate data collection, maintenance, and availability of required deliverables prior to project launches. \_\_\_\_\_\_\_.
• Key projects: This role will contribute to \_\_\_\_This role will contribute to building and maintaining bill of materials (BOM) for supply chain, ensuring data accuracy, and developing/maintaining Power BI dashboards to support operational insights\_\_\_\_\_\_\_.

Summary:
The main function of a Data Analyst is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.
Job Responsibilities:

• Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
• Design, implement, automate and maintain large scale enterprise data ETL processes
• Modify existing databases and database management systems and/or direct programmers and analysts to make changes
• Test programs or databases, correct errors and make necessary modifications

Skills:

• Experience with database technologies
• Knowledge of the ETL process
• Knowledge of at least one scripting language
• Strong written and oral communication skills
• Strong troubleshooting and problem solving skills
• Demonstrated history of success
• Desire to be working with data and helping businesses make better data driven decisions

Education/Experience:

• Bachelor's degree in a technical field such as computer science, computer engineering or related field required
• 0-2 years applicable experience required

Explain a typical day in the role.:
Support data quality initiatives by building Power BI dashboards that surface key metrics, trends, and data issues. Analyze datasets to identify inconsistencies and partner with stakeholders to drive resolution and improve data accuracy.
What is the ideal background of a candidate for this role?:

• Strong background in data analysis, data validation and data quality assurance
• Knowledge and experience with advanced functions in Microsoft Excel (V-lookups, H-lookups, VBA, Macros and Pivot Tables).
• Experience developing Business Analytics solutions using SQL, Excel, DAX and PowerBI.
• Experience using Azure DevOps
• Ability to effectively engage with Business and Engineering stakeholders to gather/define requirements and establish metrics for Business Analytics.

What are unique selling points that would get candidates interested in your role over another?:
This role provides the opportunity to Work in a large Cloud Hardware Product Master Data Management Team supporting processes, data, and project governance.
High impact on product and teams
Candidate Requirements

• Best vs. Average: The ideal resume would contain \_\_\_\_\_\_\_\_

○ Strong experience with Power BI, SQL, and Excel
○ Proven ability to analyze messy or inconsistent datasets and improve data accuracy
○ Ability to support data analysis and reporting in an operations environment
○ Strong stakeholder communication as a plus
How will contractor performance be measured?:
Performance will be assessed by data quality and PBI maintenance and creation
Top 3 Must-Have HARD Skills & years of experience for each:
Experience with Power BI, strong analytical skills (SQL/Excel), ability to work with messy datasets