Power BI Consultant focused on designing and developing reports and dashboards. Collaborating with clients to transform data sets for business insights.
About the role
- Power BI Developer at Public Consulting Group enhancing data-driven solutions for partners in health, education, and human services. Collaborating to maintain and create BI infrastructures during projects and operations.
Responsibilities
- Support internal and external projects by developing solutions using Power BI, Power Platform, and Excel.
- Create, maintain, and enhance Power BI dashboards and Power Platform applications in both test and production environments.
- Perform data analysis using Excel, including advanced formulas, pivot tables, and data visualization techniques.
- Troubleshoot issues, manage production changes following lifecycle and risk guidelines, and act as a subject matter expert for assigned systems.
- Gather business and analytical requirements with a focus on data-driven decision-making.
- Design and develop dashboards and reports using Power BI.
- Clean, transform, and model data using Power BI and DAX to create calculated columns, measures, and relationships.
- Develop and optimize SQL queries, views, stored procedures, and user-defined functions to support reporting and analytics.
- Document processes and standards for creating and maintaining Power BI reports and Excel-based analysis tools.
- Conduct unit testing and support QA efforts to ensure accuracy and quality of Power BI and Excel solutions.
- Lead special projects, delegate tasks, and deliverables meet business needs and timelines.
- Stay current with Power BI updates, Microsoft Fabric, and industry trends to continuously improve BI capabilities.
Requirements
- Bachelor’s degree in a related field (e.g., Data Analytics, Information Systems, Computer Science) or equivalent experience (6+ years) in a technical or analytical role.
- 2+ years of hands-on experience with Microsoft Power BI, including building dashboards, data modeling, and visualization.
- 3+ years of experience working as a data analyst, with proven ability to interpret data, identify trends, and deliver actionable insights using tools like Excel and Power BI.
- Proficient in Power BI Desktop and Power BI Service, including report creation, publishing, and workspace management.
- Solid understanding of DAX (Data Analysis Expressions) and Power Query (M language) for data modeling and transformation.
- Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, and data visualization techniques.
- Experience with data modeling, ETL (Extract, Transform, Load) processes, and performance tuning to optimize report efficiency and accuracy.
- Ability to design and manage relationships, hierarchies, and metadata in Power BI datasets.
- Proficiency in SQL and working with relational databases (e.g., SQL Server, Azure SQL, Synapse).
Benefits
- medical and dental care benefits
- 401k
- PTO
- parental leave
- bereavement leave
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
(Senior) BI Consultant leading and implementing advanced BI projects for diverse clients in Switzerland. Focusing on Microsoft technologies and cloud solutions with teamwork and problem - solving.
Business Intelligence Developer designing and implementing BI solutions for energy management provider in Bulgaria. Collaborating with stakeholders to shape architecture and support project lifecycles.
Business Intelligence Analyst at adjoe GmbH utilizing SQL and Python, improving APAC ad tech operations and collaboration across teams.
Business Intelligence Analyst designing dashboards and actionable insights for stakeholders in mobile games. Collaborating with teams to enhance data - driven decision - making.
Junior Teamlead BI Consultant leading Data & Cloud projects for HICO Group AG in Switzerland. Responsible for project implementation and collaboration with international teams.
Business Intelligence Analyst at Jam City designing dashboards and delivering analyses. Collaborating with game stakeholders to interpret data and improve decision - making.
Data Analyst role focusing on business intelligence at C&A. Responsible for data analysis and supporting decision - making processes.
Business Intelligence Developer designing and maintaining BI solutions using Power BI for energy control solutions. Collaborating with stakeholders to ensure data needs and project objectives are met.
Power BI Consultant responsible for creating dashboards and contributing to CRM Analytics with a hybrid work model at Kryptos Technologies in France.