Senior Data Analyst (Power Platform & Data Solutions)

OpenKrill; United States; On-site; 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

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.

Eligibility:

• Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.


• Must be able to obtain and maintain the required federal public trust clearance for this role.

Compensation:

Salary for this position is determined by various factors, including but not limited to, location, the candidate’s particular combination of knowledge, skills, competencies, and experience, as well as contract specific affordability and organizational requirements. The proposed salary range for this position is outlined below.

Salary Range: $135,000 - $150,000

Benefits:

Blue Water Thinking offers a comprehensive benefits package including health insurance (medical, dental and vision), paid time off, federal holidays, and matching 401K plan.Reasonable Accommodation for Applicants

Blue Water Thinking is committed to providing reasonable accommodations to qualified individuals with disabilities throughout the application and hiring process. If you require a reasonable accommodation to search for a position, complete an application, or participate in the interview process, please contact Resource Management at resourcemanagement@bw‑thinking.com. Requests for accommodation will be handled promptly and confidentially in accordance with applicable law.

Our Commitment to Equal Employment Opportunity.

Blue Water Thinking is an Equal Opportunity Employer. We recruit, hire, train, and promote qualified individuals without regard to race, color, religion, sex, national origin, age, disability, protected veteran status, genetic information, or any other characteristic protected by applicable federal, state, or local law.