What are the responsibilities and job description for the Senior Power BI Developer position at Marco Technologies?
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.
Essential Functions
The pay range listed for this position is based on candidate's skill level, experience, relevant licenses, and educational background. For detailed information about our benefits, please visit our careers page at www.marconet.com/careers.
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.
Essential Functions
- Dashboard and Report Development
- 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.
- Data Modeling and Integration
- 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.
- Collaboration with Stakeholders
- 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.
- ETL and Data Preparation
- 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.
- Performance Optimization
- 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.
- Governance and Security
- 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.
- Training and Best Practices
- 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.
- Troubleshooting and Support
- Resolve issues related to data refresh, connectivity and performance in Power BI reports.
- Offer ongoing support and maintenance for existing dashboards and reports.
- Innovation and Continuous Improvement
- 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.
- 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.
- 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
- 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.
The pay range listed for this position is based on candidate's skill level, experience, relevant licenses, and educational background. For detailed information about our benefits, please visit our careers page at www.marconet.com/careers.
Salary : $84,321 - $134,914