Senior Operations Data Analyst - PowerApps

Operations Data Analyst, Senior - PowerApps

Location: Oakland, CA

Onsite Flexibility: Hybrid up to 3 days per week on-site

Contract Details

• Position Type: Contract
• Contract Duration: 5 months
• Pay Rate: $60.00 $66.00 / Hour (USD)
• Work Authorization: Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Job Summary

The Senior Operations Data Analyst 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.

Required Skills

• 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.
• 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.

Preferred Skills

• Experience using Microsoft Power Platform technologies such as Power Apps, Power Automate, Dataverse, SharePoint Online, and Microsoft 365 is strongly preferred.
• 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.

Education Requirements

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

Required 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.

Benefits

• Medical, Vision, and Dental Insurance Plans
• 401k Retirement Fund

Important Notes

• Local candidates only within the assigned territory.
• A client laptop will be provided. Any other tools must be provided by the candidate/vendor.

About the Client

This client is one of the largest combined natural gas and electric energy utilities in the United States, delivering energy to approximately 16 million people across a 70,000-square-mile service area spanning northern and central California. With roughly 25,000 employees, the organization operates some of the most complex energy infrastructure in the country transmission lines, pipelines, substations, and generation facilities that keep homes, businesses, and communities powered every day. As the energy sector undergoes rapid transformation, this organization is at the center of it, managing the intersection of traditional infrastructure and emerging clean energy solutions creating genuine learning and growth opportunities for engineers, technologists, data professionals, business analysts, and operations specialists alike.

About GTT

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.

Job Number: 26-11303 Industry: Data & Analytics

#LI-Onsite