Grow with us. Lead with us.

At Pioneer, you'll work directly with executive teams, solving complex problems and shaping strategies that reset what's possible. Sometimes the work is headline-worthy. Sometimes it's foundational. But every project earns trust - and earns us the right to take on more. You'll get the kind of access, challenge, and growth found at big firms - while helping build a company that's scaling fast and guided by what we value.

If you're looking for meaning, momentum, and a seat at the table, you're in the right place.

As a Principal Consultant on our Data & Analytics team you will join a dynamic team in a fast-paced environment, dedicated to helping clients solve complex issues and achieve exceptional results. With a breadth of experience across the data analytics ecosystem, this role will focus primarily on partnering closely with client stakeholders to support Power App Development.

You will drive the design and implementation of low-code solutions, working closely with stakeholders to translate requirements into function Canvas and Model-Driven apps. The apps will automate processes, and ensure seamless data integration across the Microsoft ecosystem.  

Responsibilities:  

• Client Stakeholder Engagement: Work closely with our clients to support business initiatives, scoping new work, leading technical teams, developing proposals and SOWs
• Application Development: Design, develop, and deploy custom Canvas and Model-Driven apps tailored to business needs. 

• Workflow Automation: Build and optimize automated business processes using Power Automate and Logic Apps. 

• Data Management: Utilize Microsoft Dataverse, SharePoint, and SQL Server for data modeling and secure storage. 

• Integration: Create custom connectors and integrate apps with third-party APIs or other Microsoft services like Dynamics 365 and Teams. 

• Visualization: Develop interactive Power BI dashboards to provide data-driven insights. 

• Governance & Maintenance: Troubleshooting issues, ensuring app security, and maintaining documentation for end-users. 

• Requirements & Analysis: Partner with business and technical stakeholders to elicit, document, and refine requirements; facilitate workshops; and prioritize features and enhancements aligned to business objectives. 

• 5 years professional experience focusing on Power Apps and Power Automate
• 10 years consulting experience  
• Proven ability to lead technical teams through complex initiatives
• Strong executive presence and client-facing skills
• Experience developing proposals and SOWs
• Bachelor's degree in computer science, Data Analytics, or a related field (or equivalent professional experience). 
• Advanced Power App development experience (Canvas Apps, Model-Driven Apps, Custom Pages) with a strong portfolio of applications
• Power Automate expertise, including complex workflows, approvals, RPA integrations, and API-driven automation
• Energy & Infrastructure Industry expertise is a plus 

The estimated salary range for this role is $123,000 - $185,000 annually. This is based on a wide array of factors unique to each candidate, including but not limited to skillset and years and depth of experience. Bonuses and other incentives are awarded at the Company's discretion and are based upon individual contributions and overall company performance. Pioneer is proud to offer a comprehensive benefits package that includes meaningful time off and paid holidays, parental leave, 401(k) including employer match, tuition reimbursement, and a broad range of health and welfare benefits including medical, dental, vision, life, long and short-term disability, etc.