Sorry, this job is no longer available.(Loading More Opportunities)
Data Analyst - Power BI
About Advance Auto Parts
Advance Auto Parts, Inc. is a leading automotive aftermarket parts provider that serves both professional installer and do-it-yourself customers. As of October 5, 2019, Advance operated 5,000 stores and 152 Worldpac branches in the United States, Canada, Puerto Rico and the U.S. Virgin Islands. The Company also serves 1,260 independently owned Carquest branded stores across these locations in addition to Mexico, the Bahamas, Turks and Caicos and British Virgin Islands. The Advance Global Capability Center (GCC) in Hyderabad, India, opened in 2019. It is a key enabler and hub of innovation for the company, a place where talented Team Members provide support to our North American-based teams across a variety of functions to deliver on our Mission: Passion for Customers Passion for Yes!
The Resource should have 4+ years experience in MS-Power BI, should have good experience inExcel/Advanced Excel and SQL .
Essential Job Functions:
MS-Power BI Stack Development (Power Query, Power Pivot and Power View), Excel/Advance excel
Design and develop Power BI reports
Modelling & DAX using PowerBI
PBI Report performance tuning
Power BI service/cloud
Power BI Admin
Ability to build Power BI Reports/ Dashboards and Reports by connecting to varied data sources
Estimate technical requirements and breaks down work to user stories and tasks.
Design and work on proof of concepts that can be demonstrated to the customer.
Become customers trusted technical advisor and subject-matter expert.
Establish best practices and guide team.
Excellent skill in writing Complex DAX Queries.
Should have experience in Excel and Advanced excel.
Workday and Power BI Integration would be an added advantage.
Migration from other BI tools into Power BI would be an added advantage.
Should work as an Individual contributor
Experience in working with power bi gateways
Ability to Perform Data Cleansing and Data Profiling.
Ability to optimize report performance.
Experience in implementing Row Level Security.
Ability to organize and lead meetings with business and operational data owners
Work closely with business stakeholder, data analyst and data engineering team to perform data transformation.
Understand the business requirements/ questions to be answered
Design and align on mock-ups
Define visuals and key KPI's that enables speed to insight
Work with Data engineering team closely to perform data extraction and data transformation processes to create the data set required for the dashboard
Develop the mock-up design in Power BI and load the dashboard with real data
Implement feedback from business users and create final version of the PB reports
Scale, maintain and improve existing solutions
Implement feedback from business users and further enhance the PB reports
Prepare holistic documentations (process and technical) to enable proper knowledge transfer of both process and solution to the production team
Professional in This Role Get To
Keep management updated:Develop and Administer Power BI Projects with Building reporting models
Impact the bottom line:Work on Development of visual reports, dashboards and KPI scorecards using Power BI Desktop and Connecting to data sources, importing data, and transforming data for Business Intelligence
Strengthen relationships:Establish and maintain communication with end-users and /or team members; understand their needs, resolve issues, and meet expectations as agreed
Take the lead:Understand the business requirements and develop data models accordingly and Develop unit tests and provides code coverage to accurately test business logic and functionality with good experience in Project Documentation.
experience_range : 5-8 years
skills : PowerBI / SQL / Tableau / Zoho Reports / Google charts / QlikV