Senior Data Analyst (Power Platform & Data Solutions) Fully Remote - Based in USA

Blue Water Thinking, LLC; Northern (KY); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Blue Water Thinking is seeking an experienced Senior Data Analyst to design, develop, and maintain enterprise data, automation, and reporting solutions using the Microsoft Power Platform. You will work with Dataverse, Power Automate, Power BI, and Dataflows to deliver scalable analytics and automation across enterprise sources.

The ideal candidate will have hands-on experience with Dataverse, Power Automate, Power BI, Power Query, and ALM practices, and will support data ingestion from

Qualifications

• 5+ years delivering enterprise data, reporting, automation, or Power Platform solutions.
• MUST have proven experience using Azure Databricks.
• Experience designing and maintaining Dataverse data models, relationships, security roles, and scalable enterprise data solutions.
• Experience developing and supporting production Power Automate solutions.
• Experience developing Power BI reports, datasets, dashboards, and dataflows.

Responsibilities

• Design, develop, and maintain enterprise data solutions using Dataverse, SharePoint, and other enterprise sources.
• Create and maintain Dataverse tables, relationships, security roles, and scalable data models.
• Develop and support Power Automate flows, business processes, and automation solutions.
• Develop Power BI semantic models, datasets, dashboards, and reports using DAX and Power Query.
• Troubleshoot data transformations, dataflows, refresh processes, and dataset performance.
• Collaborate with stakeholders to capture requirements and translate them into scalable Power Platform solutions.

Skills

Dataverse

Power BI

Power Automate

Power Query

ALM

JSON

REST APIs

Azure Databricks

DAX

Tools

GitHub

Azure DevOps

Job description

Senior Data Analyst (Power Platform & Data Solutions)

Fully Remote - Based in USA

About Blue Water Thinking

Guided by our principles of value generation, continuous innovation, customer-centricity, and vested collaboration, Blue Water Thinking proudly supports our Federal clients in achieving their Agency goals.

Founded by a decorated twenty-eight year Veteran of the United States Army, Blue Water Thinking understands and supports the mission of our Nation's war fighters, Veterans, their families and caretakers.

Leveraging our executive team's military experience and private and public sector consulting expertise, Blue Water Thinking takes an integrated "one-team" approach and brings to bear best-fit solutions, thought leadership, and grit to meet our client's transformational needs.

Fueled by our values of integrity, respect, professionalism, stewardship and customer service, the Blue Water Thinking team understands the power of the human connection, collaboration, humility and loyalty to one another, our clients and industry partners.

Lastly, our formula for success is simple: Build something good, take care of our people, keep our clients satisfied, nurture our work ethic and reputation, build long-lasting partnerships, enjoy what we do and give back as much as possible.

Job Description:

Blue Water Thinking is seeking an experienced Senior Data Analyst to support the design, development, and maintenance of enterprise data, automation, and reporting solutions using the Microsoft Power Platform. This role is responsible for developing and supporting Dataverse solutions, automating business processes, troubleshooting data integrations, and delivering reporting and analytics capabilities through Power BI. The ideal candidate will possess hands-on experience with Dataverse, Power Automate, Power Query, Power BI, Dataflows, and Power Platform Application Lifecycle Management (ALM) practices. The majority of data consumed by this role originates from enterprise applications, SharePoint, Excel workbooks, MicroStrategy exports, CSV files, and other file-based sources. Candidates should be comfortable working with diverse data sources and leveraging Power Platform tools to transform, manage, and deliver business solutions. Experience developing Power Apps solutions is highly desirable.

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 authorized external APIs.
• Support data ingestion, transformation, validation, and reporting processes from enterprise systems and file-based data sources.
• Deploy and manage Power Platform solutions across Development, Test, and Production environments using ALM best practices.
• Maintain technical documentation, release notes, test cases, solution diagrams, and support procedures.
• Provide Level II/III support, troubleshoot production issues, manage enhancements, 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.

Minimum Qualifications

• 5+ years of experience 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 (semantic models, DAX, reporting, and dashboard development)
• Power Query
• Power BI Dataflows and data transformation processes
• Experience designing and maintaining Dataverse data models, relationships, business rules, security roles, and scalable enterprise solutions.
• Experience developing and supporting production Power Automate solutions.
• Experience developing and supporting production Power BI reports, datasets, semantic models, dashboards, and dataflows.
• Proficiency with:
• DAX
• Power Fx
• JSON
• REST APIs
• Microsoft 365 integrations
• Experience troubleshooting dataflows, refresh failures, data quality issues, and production support incidents.
• Experience deploying and supporting solutions using Power Platform ALM practices.
• Strong analytical, troubleshooting, communication, and documentation skills.

Preferred Qualifications:

• Experience developing Canvas Apps and Model-Driven Apps using Dataverse.
• Experience integrating Power Platform solutions with SharePoint, Teams, Outlook, Dynamics 365, external APIs, and other enterprise applications.
• Experience working with Excel, CSV, SharePoint, MicroStrategy exports, and other file-based data sources to support data ingestion, automation, reporting, and analytics solutions.
• Familiarity with SQL and relational database concepts.
• Experience with GitHub or Azure DevOps for source control, release management, and deployment pipelines.
• Experience designing, implementing, or supporting enterprise data lake and analytics platforms.
• Experience with Microsoft Fabric, OneLake, Azure Data Lake Storage, Data Factory, or similar cloud-based analytics technologies.
• Experience with enterprise data governance, security, retention, auditing, and compliance requirements.
• Experience supporting Power Platform solutions in healthcare, federal government, or other complex enterprise environments.
• Must be legally authorized to work in the United