10822 Power BI Specialist

Barcel USA is looking for a Power BI Specialist to join our growing technology team. The candidate must have professional experience converting data from a multitude of sources into meaningful measures and key performance indicators into interactive, intuitive dashboards, and reports. This position will serve as the Power BI platform subject matter expert. Must be proactive to find opportunities regarding delivering informative and value driven insights with proficiency in statistics and mathematics. This position requires a high level of analytical expertise. The PBI Specialist is responsible for building, administering, and maintaining Power BI workspaces, reports, dashboards, and applications (25%), validating datasets (25%), collaborate with functional and technical teams to implement and improve data analytics to advance informed decision-making (30%), document data models, pipelines, processes, functionality, reports, dashboards, and solutions (15%), and training for Power BI on both dashboards, reports, and technical how-to(s) (5%). Responsibilities

• Understand/develop business requirements, specifications, and design data models and transform processes to convert data into informative and accurate insights published through reports, dashboards, BI Applications, and other embedded delivery platforms with required functionality for multiple departments including but not limited to Sales, Forecasting, Supply Chain & Finance.
• Validate data, metrics, KPI against authoritative systems and stake holder expectations.
• Present and explain to users how to utilize reports, dashboards, applications and how the output is derived via data sources, transformations, logic, and filters.
• Identify KPIs, measures, and calculations that drive business and monitor them both for data delivery and notify functional team to act.
• Develop source & validation queries utilizing advanced to Intermediate SQL syntax.
• Develop well designed reports with clean intuitive interfaces.
• Promote and evolve the focus of BI analytics.
• Document data and processes including but not limited to algorithms, parameters, models, metrics, meta data, and transformations.
• Connecting and troubleshooting data sources, importing data, and transforming data for Business intelligence.
• Improving existing datasets & models, constructing new datasets/models that are easy to understand in order to promote the reusage of the data and facilitate the self-service analytics.
• Data & root cause analysis across a number of domains (sales/supply chain/accounting)/ at multiple dimensions and hierarchy levels.
• Maintain Security via Workspaces, managed dataset permissions, sensitivity labeling, data source/privacy settings and dynamic RLS.
• Develop tabular and multidimensional models that are compatible with data warehouse standards.
• Administer workspaces & user access to PBI applications/reports/models and build permissions

• Any other duties as assigned.

• Understand/develop business requirements, specifications, and design data models and transform processes to convert data into informative and accurate insights published through reports, dashboards, BI Applications, and other embedded delivery platforms with required functionality for multiple departments including but not limited to Sales, Forecasting, Supply Chain & Finance.
• Validate data, metrics, KPI against authoritative systems and stake holder expectations.
• Present and explain to users how to utilize reports, dashboards, applications and how the output is derived via data sources, transformations, logic, and filters.
• Identify KPIs, measures, and calculations that drive business and monitor them both for data delivery and notify functional team to act.
• Develop source & validation queries utilizing Advances to Intermediate SQL syntax.
• Develop well designed reports with clean intuitive interfaces.
• Promote and evolve the focus of BI analytics.
• Document data and processes including but not limited to algorithms, parameters, models, metrics, meta data, and transformations.
• Connecting and troubleshooting data sources, importing data, and transforming data for Business intelligence.
• Improving existing datasets & models, constructing new datasets/models that are easy to understand in order to promote the reusage of the data and facilitate the self-service analytics.
• Data & root cause analysis across a number of domains (sales/supply chain/accounting)/ at multiple dimensions and hierarchy levels.
• Maintain Security via Workspaces, managed dataset permissions, sensitivity labeling, data source/privacy settings and dynamic RLS.
• Develop tabular and multidimensional models that are compatible with data warehouse standards.
• Administer workspaces & user access to PBI applications/reports/models and build permissions
• Any other duties as assigned.

Do you have experience in XML?, Do you have a Bachelor’s degree?, BS or MS in information systems, data analytics, statistics, computer science, related business field or proven work-related experience. Required:

• Demonstratable Work Experience with Power BI Report Development (Certification: PL-300 / DA-100 desired).
• 2+ years of experience working with and delivering interactive reporting and analysis solutions utilizing the Microsoft & Azure BI stack.
• Excellent verbal, written, organizational, and professional presentation skills in group settings to convey complex concepts and technical materials to business function team members.
• Advanced knowledge of DAX particularly utilizing group calculations, field parameters, and row context understanding.
• Strong knowledge of business intelligence, data modeling, visualizations, data warehousing, ETL/ELT, data integration, information security practices, and presentation concepts
• Strong to advanced technical knowledge of SQL (TSQL/MySQL/Databricks-SQL), Power Query-M/DAX, File format data extraction) extraction JSON, XML .
• Knowledge and utilization of Power Automate, Dataverse, & Writeback Capabilities with Power Apps.
• API REST/SOAP, Databricks, CSS, PBI SSRS, ADF/SSIS, ETL,.
• Work experience and domain knowledge in a data driven business setting which may be one of the following: but not isolated to (CPG Sales, Accounting, Finance, Supply Chain, Planning/Forecasting).