10822 Power BI Specialist
About the role
The Power BI Specialist will serve as the platform subject matter expert, delivering insightful and value-driven analytics to multiple departments including Sales, Forecasting, Supply Chain, and Finance.
Responsibilities
- Understand/Develop business requirements, specifications, and design data models and transform processes to convert data into insights published through reports, dashboards, BI applications, and other delivery platforms.
- Validate data, metrics, KPI against authoritative systems and stakeholder 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.
Qualifications
- BS or MS in information systems, data analytics, statistics, computer science, related business field or proven work-related experience.
- Demonstrated 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, 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: CPG Sales, Accounting, Finance, Supply Chain, Planning/Forecasting.
Benefits
Barcel USA LLC is an equal opportunity employer with a policy that provides equal employment opportunity for applicants and employees regardless of race, color, religion, disability, gender, age, national origin, sexual orientation, gender identity, marital status, pregnancy, veteran status, or any other classification protected by law. This policy applies to all aspects of employment, including recruitment, hiring, promotion, compensation, reassignment, layoff, discharge, education, training, and all other working conditions. We believe diversity drives innovation and success. We proudly welcome applications from individuals with disabilities, veterans, and women, and are committed to creating an environment where everyone can thrive.