Power Platform Data Analyst: Remote Dashboards & Automation

Constellation Inc; Washington (District of Columbia); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

401(k)

Medical insurance

Dental insurance

Vision insurance

Life & Disability Insurance

Flexible Spending Account

Paid time off

Professional development

Employee assistance program

Work-life balance

Job summary

Constellation Inc. is seeking a Power Platform Data Analyst to transform client data into actionable insights. The role focuses on building automated reports and dashboards using Power Apps and Power BI, and leveraging SharePoint for data capture and workflow automation.

You will collaborate with clients to implement applications, clean and model data, and develop visualizations that support decision-making across programs. A BS in a related field and 4+ years BI experience are required.

Qualifications

• BS degree in Data Science, Computer Science, Business Analysis or related discipline.
• Minimum of 4 years of experience in business intelligence, data analytics, or reporting roles.
• Highly experienced in using BI platforms such as PowerApps, Power BI, or SharePoint forms and lists.
• Proficiency in SQL for querying, transforming, and analyzing data across large datasets
• Demonstrated ability to translate business requirements into effective dashboards
• Experience creating data visualizations in multiple tools including Power BI, Tableau, or other visualization programs

Responsibilities

• Develop and maintain applications in MS Power Apps to collect field inputs, develop automated reports and workflows and capture previously manually created information in a digital platform.
• Work with the client to implement applications across the organization for field use.
• Support client in exploring, categorizing, and reviewing data in all its forms, and develop solutions for curation and visualization.
• Inspect, clean, transform and model data with the goal of discovering useful information, informing conclusions and supporting decision-making.
• Access, utilize, and analyze data from client systems and external commercial products, (such as MS Dynamics, Azure, Excel, MS Access, Case Management Systems, SharePoint, etc)
• Review and validate data to assist in developing applications and data visualization (graphics, charts, tables, websites, training materials) that focus on reducing manual and redundant processes and develop pertinent business information for decision makers.
• Create and manage multiple program-level dashboards that directly feed agency level dashboards and placemats, representing all programs in the security portfolios.
• Review database architecture and data control policies and offer recommendations for utilization, improvements, or new investments.
• Assist with developing documentation and collecting data that supports program goals and objectives; update security information on organization SharePoint sites.

Skills

Power Apps

Power BI

SQL

Dashboard design

Education

BS degree in Data Science, Computer Science or related discipline

Tools

Power Apps

Power BI

SharePoint

Tableau

Job description

Constellation Inc. is seeking a Power Platform Data Analyst to transform client data into actionable insights. The role focuses on building automated reports and dashboards using Power Apps and Power BI, and leveraging SharePoint for data capture and workflow automation.

You will collaborate with clients to implement applications, clean and model data, and develop visualizations that support decision-making across programs. A BS in a related field and 4+ years BI experience are required.