Power Platform Specialist

Company logo
Lerch Bates Inc.
Global technical consultancy for building systems—vertical transportation, logistics, enclosures, forensics, façade access
Develop and maintain Power Platform solutions for BI, automation, SharePoint, and data integration.
14 days ago ago
Intermediate (4-7 years), Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
Englewood, CO
Office Full-Time
Company Size
382 Employees
Service Specialisms
Elevator Consulting
Vertical Transportation
Building Systems Design
Project Management
Safety Audits
Construction Services
Design
Sector Specialisms
Vertical Transportation
Building Logistics
Building Enclosures
Facade Access
Forensics
Elevators
Pedestrian Circulation
Testing
Role
What you would be doing
power bi
power automate
sharepoint
data analysis
dashboard development
system monitoring
  • Design, develop, and maintain BI solutions using Power BI to provide real-time reporting, dashboards, and visualizations.
  • Develop and maintain automation workflows using Power Automate to streamline and optimize business processes.
  • Support end users by providing training and ongoing technical assistance for Power BI, Power Apps, Power Automate, and SharePoint tools.
  • Maintain and optimize existing Power BI dashboards and reports, ensuring data accuracy and consistency.
  • Stay current with industry trends and emerging technologies related to Power BI, Power Apps, Power Automate, and SharePoint to recommend enhancements.
  • Integrate and customize SharePoint solutions to support business collaboration, document management, and process automation.
  • Perform data analysis, cleansing, and transformation from various sources to ensure data quality and reliability.
  • Work closely with our external partners’ data engineers, database administrators, and IT teams to ensure data integrity, performance, and security.
  • Continuously monitor BI system performance, identifying and addressing potential issues or bottlenecks.
  • Collaborate with business stakeholders to gather and understand business requirements , translating them into technical specifications and scalable solutions.
What you bring
bachelor's
sql
power bi
power automate
dynamics crm
2+ years
  • Bachelor’s Degree in Computer Science, Information Systems, Data Analytics, or a related field.
  • Strong analytical and problem-solving skills with the ability to work independently or as part of a team.
  • Experience in ETL processes, data integration, and data transformation.
  • JavaScript for Dynamics customization preferred
  • Strong communication skills, both written and verbal, with the ability to translate complex technical concepts for non-technical stakeholders.
  • Proficient in SQL preferred
  • Knowledge of RPA (Robotic Process Automation) or AI tools integrated with the Power Platform preferred.
  • Microsoft certifications in Power BI, Power Platform, or SharePoint are highly desirable.
  • FSA and HSA
  • Dynamics Sales CRM experience preferred
  • Extensive experience with Power Automate to design and implement automated workflows.
  • 2+ years of experience in Power Platform development.
  • Exceptional company culture
  • Knowledge of SharePoint, i ncluding integration with Power Platform tools.
Benefits
  • Tuition Reimbursement
  • An entire internal department dedicated to your learning and career development!
  • Birthday Bonus
  • Employee Stock Ownership program!
  • 401(k) with up to 6% employer match!
  • Paid Parental Leave
  • Medical, Dental, and Vision Insurance
  • Competitive Compensation
  • Generous PTO
  • Incentive compensation bonus
  • Charitable paid time off
Training + Development
Information not given or found
Interview process
Information not given or found
Visa Sponsorship
Information not given or found
Security clearance
  • employment contingent on successful pre‑employment background check and drug test, including marijuana screening; offer rescinded if candidate fails.
Company
Overview
1947
Year Founded
Established in 1947 as a pioneering elevator consulting firm.
1980s
Decade of Expansion
Began strategic growth through acquisitions, expanding expertise and services.
2015 & 2020
Years of Expansion
Enhanced capabilities through key acquisitions, broadening service offerings.
World's Fastest
Elevator Engineering
Known for developing some of the world's fastest elevator systems.
  • Pioneered elevator consulting in the U.S. from humble beginnings.
  • Transitioned from a single office in Chicago to a global consultancy.
  • Engineered iconic skyscrapers including Burj Khalifa and Taipei 101.
  • Extended expertise into logistics, structures, façade access, and more.
  • Provides comprehensive services from design to maintenance.
  • Serves a wide range of industries and sectors.
  • Cultivates a unique employee-owned culture fostering accountability.
  • Innovates with cutting-edge technologies and methodologies.
Culture + Values
  • Provide clients with solutions that consider not only initial cost and operating cost, but also environmental and sustainable impacts.
  • Expertise in aligning all objectives to drive the right solution for clients.
  • Continuous examination of business practices to determine where we can improve ‘walking the walk.’
Environment + Sustainability
  • Assists clients in achieving Net Zero targets by integrating solutions such as regenerated-power VT, efficient design, minimized heat/electrical load, and reduced embodied carbon.
  • Advises on lifecycle carbon impacts—for example, in-truss modernizations vs full replacements—to reduce embodied carbon.
  • Operates as part of a broader ESG initiative, continuously reviewing internal business practices for sustainability.
Inclusion & Diversity
Big Kablio Logo
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio