Lang Company (Now Marco Technologies) · 1 day ago
SENIOR POWER BI DEVELOPER
Lang Company (Now Marco Technologies) is seeking a Senior Power BI Developer responsible for creating and deploying intuitive dashboards that measure key performance indicators and organizational performance metrics. The role involves collaborating with various stakeholders to interpret reporting requirements, developing dashboards, and ensuring data accuracy and performance optimization.
Consulting
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
Qualification
Required
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
Preferred
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