Senior Power BI Developer

Marco Technologies•Saint Cloud, MN

46d•$84,321 - $134,914

About The Position

The Senior Power BI Developer is responsible for creating and deploying intuitive, high-impact dashboards that measure key performance indicators (KPIs) and organizational performance metrics. These dashboards will be used by a wide range of functional teams to streamline processes and improve decision-making capabilities. The Senior Power BI Developer will work in coordination with data analysts, business analysts and internal system stakeholders to interpret reporting requirements as outlined in business requirements documents. They will collaborate with other BI developers to integrate the appropriate data sources and models, ultimately developing the necessary dashboards. Additionally, they will oversee quality assurance testing, evaluate dashboard performance and assess Power BI capacity impacts.

Requirements

Associate's or Bachelor's degree in Computer Science/IT.
5 years' experience as a Power BI dashboard developer with at least 2 years of experience supporting complex dashboards in a production environment.
Hands-on experience with SQL Server Reporting Services (SSRS) and Integration Services (SSIS).
Expertise in SQL, including writing complex queries, stored procedures, performance tuning and handling large datasets in dashboards and data modeling. Proficient in DAX and Power BI.
Ability to deploy and validate Power BI solutions, ensuring adherence to proper Change and Release Management processes.
Proven capability to thrive in a fast-paced, dynamic environment with competing priorities and tight deadlines.
Strong problem-solving skills, with the ability to identify and resolve issues promptly.
Excellent organizational skills with strong time and task management abilities.
Committed to maintaining high standards for documentation, development, code layout, and technology usage, while mentoring team members to uphold these standards.
Self-motivated, with the ability to work independently and without close supervision.
Ability to work collaboratively as part of a fast-paced, client-oriented team.

Nice To Haves

Experience working within an IT, preferably within an MSP or VAR business
Power BI Admin experience
Familiarity with E-Automate, ConnectWise & Salesforce application reporting
Experience with Sales or Marketing Analytics or Data science related work
Experience with Microsoft Fabric
Exposure to MDM - Microsoft MDS

Responsibilities

Design, develop and implement interactive, user-friendly Power BI dashboards and reports.
Convert complex business requirements into effective visual representations using advanced Power BI features and custom visuals.
Ensure data accuracy and consistency throughout all reports.
Create and maintain robust data models in Power BI Desktop, including relationships, calculated columns and DAX measures.
Integrate data from various sources such as relational databases, data warehouses, APIs and flat files into Power BI.
Optimize data models to enhance performance, especially for large datasets.
Collaborate with business stakeholders, including data analysts, business analysts, and decision-makers, to gather and understand reporting requirements.
Partner with IT, Data Warehouse and other teams to ensure seamless data flow and system integration.
Effectively communicate complex technical concepts to non-technical stakeholders.
Design and execute ETL processes using Power Query and other tools to clean, transform and load data into Power BI.
Ensure high data quality and consistency throughout the ETL process.
Monitor and enhance the performance of Power BI reports and dashboards, ensuring fast load times and efficient query execution.
Work with DBAs and other technical teams to optimize database objects (views, tables) and SQL queries.
Maintain compliance with data governance and security protocols, including row-level security and access control.
Implement data validation and quality checks to ensure data integrity.
Provide training and mentorship on Power BI best practices, including design, performance optimization and report customization.
Stay updated on new Power BI features and incorporate them into projects where appropriate.
Resolve issues related to data refresh, connectivity and performance in Power BI reports.
Offer ongoing support and maintenance for existing dashboards and reports.
Continuously seek opportunities to improve reporting processes, visualizations and data models.
Explore advanced analytics features such as machine learning, AI-driven insights and automation in Power BI.
Attend required company and departmental meetings.