Power BI & Automation Specialist

Job Overview:

We are seeking a highly skilled, detail-oriented, and forward-thinking Power BI & Automation Specialist who is passionate about transforming data into actionable insight and automating business processes through innovative technologies. The ideal candidate will possess a blend of expertise in Power BI dashboard development, workflow automation using Power Platform, and hands-on experience in artificial intelligence solutions, including document processing and custom AI/ML model integration.

As a key member of our digital transformation team, you will bridge the gap between complex datasets and end users across departments, ensuring data consistency, visibility, and utility for both field and office teams. Your work will directly support decision-making at every level of the organization, driving efficiency, accuracy, and innovation.

Key Responsibilities:

1) Power BI Dashboard Development

·        Design, Build, and Maintain Dashboards: Leverage your in-depth knowledge of Power BI, DAX, and data modeling to create interactive, visually compelling dashboards that communicate critical business metrics. Work closely with stakeholders to understand their reporting needs and translate them into impactful data visualizations that reveal insights and trends.

·        Monitor and Improve Performance: Continuously monitor dashboard performance for responsiveness and data accuracy. Implement enhancements based on user feedback and evolving business requirements. Ensure that dashboards adapt to changing datasets and organizational goals.

·        Cross-Department Collaboration: Partner with various departments—including operations, project management, and quality assurance—to capture and analyze data requirements. Facilitate workshops and knowledge sessions to empower teams in leveraging business intelligence tools effectively.

2) Workflow Automation (Power Automate):

·        Develop Automated Flows: Create, test, and maintain Power Automate flows to streamline repetitive reporting tasks, data collection, notifications, and document management processes. Ensure flows are reliable, efficient, and deliver measurable time savings.

·        Troubleshoot and Optimize: Proactively identify and resolve errors or inefficiencies in existing flows, working with users to continuously refine and improve automation processes. Document all workflows and provide training or guidance where required.

·        Build for the Future: Analyze emerging automation needs across teams and propose new flows or solutions that enhance productivity and data quality. Stay abreast of Power Platform updates and best practices to ensure our automation stack is modern and robust.

3) AI Development & Integration:

·        AI-Powered Document Processing: Utilize AI Builder and similar low-code platforms to develop and test automated document processing solutions, extracting structured data from unstructured sources such as PDFs, emails, and images. Validate and refine AI models for accuracy and reliability in real-world scenarios.

·        Custom AI/ML Solutions: Explore, design, and implement advanced AI/ML models using Python or other relevant programming languages. Integrate these models with existing business workflows, ensuring seamless adoption without disrupting operations.

·        Identify Integration Opportunities: Work closely with leadership and functional leads to uncover opportunities where AI can deliver substantial business impact—whether in automating decision points, improving forecasting, or streamlining data validation.

4) Data Maintenance & Reporting:

·        Project and QAQC Tracking: Lead weekly updates of project and QAQC tracking sheets, integrating data from systems such as Primavera P6 and others. Ensure timely, accurate, and complete data uploads for real-time visibility into project performance.

·        Data Consistency and Usability: Establish and enforce data cleaning and transformation best practices to ensure that information used by both field and office teams is accurate, consistent, and actionable. Develop procedures for routine data validation and error checking.

·        Reporting Support: Serve as the primary resource for data extraction and reporting, quickly responding to ad hoc requests from stakeholders and ensuring compliance with governance standards for data access and sharing.

Required Skills & Qualifications:

·        Power BI Expertise: Demonstrable experience with Power BI, including DAX calculations, complex data modeling, and dashboard/report development in a business environment.

·        Power Automate Proficiency: Strong track record of designing, building, and troubleshooting Power Automate flows to support diverse business needs. Ability to optimize flows for performance and reliability.

·        AI Builder and Low-Code Platforms: Practical familiarity with AI Builder or comparable low-code tools for deploying AI-driven solutions in document processing and workflow enhancement.

·        Python and AI/ML Development: Experience developing, training, and deploying machine learning models using Python or similar languages, and integrating these with business intelligence platforms.

·        Data Management Skills: Solid grasp of data cleaning, ETL (Extract, Transform, Load) processes, and best practices in data transformation and reporting.

·        Communication and Collaboration: Excellent verbal and written communication abilities, with a collaborative mindset and a knack for translating technical concepts for non-technical audiences.

·        Independent and Team Work: Proven ability to self-manage tasks and timelines, while thriving in cross-functional team settings.

Preferred Qualifications:

·        Primavera P6 Integration: Experience connecting and synchronizing data from Primavera P6 or similar project management systems into BI/reporting platforms.

·        Project Management or Construction Workflows: Understanding of data flows and reporting needs in project management or construction domains, with a track record of supporting complex, multi-stakeholder projects.

Broader Power Platform Experience: Exposure to additional Power Platform components such as Power Apps and Dataverse, enabling full-stack automation and app development beyond BI and workflow automation.