Senior Power Platform & Data Automation Analyst

Openkrill; United States; Remote; USD 135,000 - 150,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Federal holidays

401K matching

Job summary

Blue Water Thinking is seeking a Senior Data Analyst to design, implement, and maintain enterprise data solutions using Dataverse, Power Platform, and Microsoft 365. You will automate processes with Power Automate, build semantic models in Power BI, and ensure robust data integration from SharePoint, Excel, and other sources.

The ideal candidate brings 5+ years of experience, expertise with Azure Databricks, and strong problem‑solving and documentation skills.

Qualifications

• 5+ years delivering enterprise data, reporting, automation, or Power Platform solutions.
• Must have proven experience using Azure Databricks.
• Hands-on experience designing, developing, and supporting solutions using Dataverse, Power Automate, Power BI, Power Query, and ALM practices.

Responsibilities

• Design, develop, and maintain enterprise data solutions using Dataverse, SharePoint, Microsoft 365, file‑based data sources, and approved enterprise systems.
• Create and maintain Dataverse tables, relationships, business rules, security roles, and scalable data models.
• Develop and support Power Automate cloud flows, business process flows, and workflow automation solutions.
• Develop Power BI semantic models, datasets, dashboards, reports, and dataflows utilizing DAX and Power Query best practices.
• Troubleshoot and optimize Power Query transformations, dataflows, refresh processes, dataset performance, and reporting solutions.
• Integrate solutions with Microsoft 365 services, SharePoint, Teams, Outlook, Dynamics 365, and external APIs as allowed.
• Support data ingestion, transformation, validation, and reporting from enterprise systems and file‑based sources.
• Deploy and manage Power Platform solutions across Development, Test, and Production environments using ALM practices.
• Maintain technical documentation, release notes, test cases, solution diagrams, and support procedures.
• Provide Level II/III support, troubleshoot production issues, and conduct user training and knowledge transfer.
• Collaborate with business stakeholders to gather requirements and translate business needs into scalable Power Platform solutions.
• Participate in solution design discussions, architecture reviews, and continuous improvement initiatives.

Skills

Azure Databricks

Dataverse

Power Automate

Power BI

Power Query

DAX

Power Fx

JSON

REST APIs

Microsoft 365 integrations

Job description

Blue Water Thinking is seeking a Senior Data Analyst to design, implement, and maintain enterprise data solutions using Dataverse, Power Platform, and Microsoft 365. You will automate processes with Power Automate, build semantic models in Power BI, and ensure robust data integration from SharePoint, Excel, and other sources.

The ideal candidate brings 5+ years of experience, expertise with Azure Databricks, and strong problem‑solving and documentation skills.