Power Platform Engineer
4+ months
Oakland, CA (Hybrid upto 3 days per week) 

Local candidates only
EQUIPMENT: Client laptop will be provided. 

TOP THINGS:

• Prior utility experience
• Specific Power Apps domain knowledge (building, releasing, and maintaining Power Apps Solutions for teams) and other power platform skills such as Power BI, Power Automate, and Dataverse experience
• Cross functional requirements gathering and partnership experience.

Department
Electric Risk & Compliance – Visual Management & Insight Services (VMIS)

Position Summary
Manages complex data analysis, business intelligence, Power Apps development, automation, and reporting projects with limited supervision from initial request through delivery of actionable results. This role supports enterprise compliance, risk, operations, governance, and executive reporting initiatives by translating business objectives into scalable Power Apps, Power Platform, Power BI, and data analytics solutions.

The Senior Operations Data Analyst designs, develops, tests, deploys, and maintains data-driven business applications and reporting solutions that improve operational efficiency, compliance visibility, decision-making, user experience, workflow transparency, and business process consistency. The role combines advanced data analysis, Power Apps solution design, automation, application development, reporting, stakeholder engagement, and project management capabilities to deliver high-quality solutions on time and within scope.

Key Responsibilities
• Manages complex data analysis, dashboard, automation, and Power Apps development projects with limited supervision from initial request through presentation of results, ensuring work is completed on time, within budget, and aligned with business objectives.
• Designs, develops, tests, deploys, and supports Canvas and Model-Driven Power Apps that improve operational efficiency, user experience, structured data capture, workflow visibility, compliance tracking, governance processes, and field or office business operations.
• Builds intuitive, user-centered Power Apps with clear navigation, effective screen design, role-based experiences, embedded business rules, validation logic, forms, galleries, approvals, and data-entry controls that reduce manual work and improve data quality.
• Integrates Power Apps with SharePoint Online, Dataverse, Power Automate, Microsoft 365, Teams, Outlook, Excel, SQL databases, APIs, Power BI, and other enterprise data sources or systems to create connected end-to-end business solutions.
• Applies Power Apps governance, solution lifecycle management, documentation, testing, version control, environment strategy, permissions, access controls, and support practices to ensure applications are scalable, secure, maintainable, and aligned with enterprise standards.
• Designs analyses, reports, dashboards, scorecards, and data models to achieve business objectives; processes, cleanses, validates, and analyzes data to develop clear findings, trends, profiles, KPIs, and actionable insights tailored to specific audiences.
• Develops and maintains Power BI dashboards, executive reporting solutions, operational reports, compliance reports, KPI scorecards, and self-service analytics products that support risk, compliance, governance, and performance management activities.
• Designs and implements scalable semantic models, datasets, dimensional data models, fact and dimension tables, data relationships, and DAX calculations to support enterprise reporting needs and large data sets.
• Creates advanced DAX measures, calculated columns, KPIs, time intelligence calculations, running totals, period-over-period comparisons, dynamic measures, and statistical calculations; monitors and improves Power BI performance through model optimization and best practices.
• Designs and maintains Power Automate workflows that automate approvals, notifications, document management, data refreshes, reporting processes, and other repeatable business activities connected to Power Apps and enterprise reporting solutions.
• Manages complex data extracts, list pulls, data transfers, and data integration activities while ensuring accuracy, consistency, quality, governance, and appropriate security controls.
• Creates automated data routines, ETL/ELT processes, Power Query transformations, and reporting refresh processes to support efficient and accurate data manipulation, cleansing, and delivery.
• Implements row-level security, data governance controls, lifecycle management practices, and reporting standards to support secure and reliable business intelligence and Power Platform solutions.
• Gathers and documents business requirements, facilitates stakeholder workshops and solution design sessions, translates business needs into technical requirements, prototypes Power Apps concepts, and provides user training, documentation, and knowledge-transfer support.
• Develops and communicates clear, concise, and actionable analyses, findings, recommendations, and presentations for clients, business partners, and leadership audiences.
• Identifies opportunities for Power Apps development, automation, analytics, data quality improvements, database enhancements, process optimization, and continuous improvement using Microsoft Power Platform, Power BI, and related technologies.

Deliverables
• Production-ready Canvas and Model-Driven Power Apps solutions that support business processes, compliance tracking, governance workflows, structured data capture, and operational decision-making.
• Power Apps prototypes, user interface designs, data-entry forms, role-based experiences, app documentation, testing evidence, release notes, and knowledge-transfer materials.
• Automated business processes using Power Automate, including workflows connected to Power Apps, SharePoint, Dataverse, Outlook, Teams, and enterprise reporting processes.
• Executive and operational Power BI dashboards.
• Compliance, risk, governance, and performance reporting products.
• Enterprise semantic data models, datasets, KPIs, and DAX-based reporting solutions.
• Automated reporting, data refresh, data extraction, and data delivery processes.
• Clear analytical findings, recommendations, user guides, technical documentation, and training materials.
• Recommendations for ongoing Power Apps enhancement, automation, analytics, database, and process improvements.

Education Minimum
• BA/BS Degree in Marketing, Business, Computer Science, Engineering, Data Analytics, Information Systems, or other related field, or equivalent work experience.

Minimum Experience
• 4 years of related work experience in data analysis, business intelligence, reporting, operations analytics, database management, automation, Power Apps development, or application development.
• Experience designing, building, deploying, and supporting Canvas or Model-Driven Power Apps in a business or enterprise environment.
• Experience developing Power BI dashboards, enterprise reporting solutions, data models, or KPI scorecards.
• Experience using Microsoft Power Platform technologies such as Power Apps, Power Automate, Dataverse, SharePoint Online, and Microsoft 365 is strongly preferred.

Knowledge, Skills, and Abilities
• Advanced data analysis, data processing, data visualization, and reporting skills with ability to translate complex data into actionable business insights.
• Advanced Microsoft Excel and Access skills, including complex formulas, graphing, VBA, data manipulation, and reporting automation.
• Advanced skill writing SQL queries using Oracle, Business Objects, SQL Server, or related database technologies.
• Proficiency with Power Apps, including Canvas apps, Model-Driven apps, forms, galleries, components, connectors, formulas, validation logic, role-based functionality, app testing, app deployment, app documentation, and user support.
• Proficiency with Power BI, DAX, Power Query, data modeling, semantic models, star schema design, fact and dimension tables, data relationships, and dashboard design.
• Proficiency with Power Automate, SharePoint Online, Dataverse, Microsoft 365, Teams, Outlook, Excel, and workflow automation concepts.
• Familiarity with Power Platform governance, application lifecycle management, environment strategy, security roles, permissions, solution packaging, release management, and maintainability practices.
• Familiarity with ETL/ELT processes, REST APIs, data warehousing, data governance, data quality controls, and row-level security.
• Familiarity with utility operations, compliance, risk management, audit, governance, or executive reporting environments.
• Knowledge of UNIX shell programming, base-SAS, Visual Basic, Perl, C, Azure Data Factory, Azure SQL, Synapse Analytics, Microsoft Fabric, or other data platforms is preferred.
• Strong organizational skills with ability to independently prioritize work, manage multiple projects, meet deadlines, and deliver high-quality work products with limited supervision.
• Strong communication, presentation, facilitation, and stakeholder management skills, including ability to tailor findings and recommendations to technical and non-technical audiences.
• Strong analytical, problem-solving, troubleshooting, project management, and continuous improvement skills.

Ideal Candidate
The ideal candidate is a highly analytical, technically proficient, and self-directed professional who can independently manage complex data analysis projects, design and support user-centered Power Apps, build enterprise-grade reporting and automation solutions, and partner effectively with stakeholders. The candidate should combine strong Power Apps, Power BI, Power Platform, SQL, data modeling, and communication skills with a practical understanding of utility operations, compliance visibility, governance, workflow improvement, and executive reporting needs. 
 
At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's pay range is $58.00/hr - $62.00/hr.