Power Platform Data Analyst

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

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Vision insurance

Paid time off

Professional development

Job summary

Constellation Inc. in Washington, DC is seeking a Power Platform Data Analyst to join a hybrid work arrangement. The role focuses on building Power Apps data repositories, automating reports, and delivering dashboards for client management and decision support.

You will work with Power BI, SQL, and SharePoint tools to transform data and support program outcomes within a federal context. Strong collaboration with clients is required.

Qualifications

• BS degree in a related field and ability to obtain a DHS background clearance.
• Minimum of 4 years experience in BI, data analytics, or reporting roles.
• Strong proficiency with PowerApps, Power BI, and SharePoint forms/lists.
• Proficient SQL skills for querying, transforming, and analyzing large datasets.

Responsibilities

• Develop and maintain applications in MS Power Apps to collect inputs and automate reports.
• Collaborate with the client to implement apps across the organization for field use.
• Assist with data exploration, categorization, and visualization solutions for decision makers.
• Inspect, clean, transform, and model data to reveal useful insights and trends.
• Access and analyze data from client systems and external products like Dynamics and SharePoint.
• Create dashboards feeding agency-level dashboards and place mats for programs.

Skills

PowerApps

Power BI

SQL

SharePoint

Education

Bachelor's Degree

Tools

MS Dynamics

Azure

Excel

MS Access

Case Management Systems

SharePoint

Job description

Pay

$100,000.00 - $140,000.00 per year

Job Description

Power Platform Data Analyst (Hybrid)

Job Summary

Provide statistical and data analytical knowledge by conducting research, preparing statistical reports, handling information requests, and data manipulation requests. Utilize various programs to collect, clean, and display data sources, analysis, strategies and methodologies. Use MS Power Apps to build and maintain data repositories and automate the collection and dissemination and presentation of information. Expand efforts to automate key client management processes and data points.

Key Responsibilities

• Developand maintainapplications in MS Power Apps to collect field inputs, developautomated reports and workflows and capture previously manually created information in a digital platform.
• Workwith the client to implement applications across the organization for field use.
• Supportclient in exploring, categorizing, and reviewing data in all its forms, and developing solutions for curation and visualization.
• Inspect, clean, transformand modeldata with the goal of discovering useful information, informconclusions and supportdecision-making.
• Access, utilize, and analyzedata from client systems and external commercial products, (such as MS Dynamics, Azure, Excel, MS Access, Case Management Systems, SharePoint, etc)
• Reviewand validatedata 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.
• Createand managemultiple program-level dashboards that directly feed agency level dashboards and placemats, representing all programs in the security portfolios.
• Reviewdatabase architecture and data control policies and offer recommendations for utilization, improvements, or new investments.
• Assistwith developing documentation and collecting data that supports program goals and objectives; update security information on organization SharePoint sites.

Qualifications

• Ability to obtain and maintain a DHS CBP Tier 5 Background Investigation (BI).
• 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

Additional Requirements

• Be a U.S. citizen able to pass a background investigation by the client agency
• Must be able to commute to client site periodically.
• Position is Hybrid / Remote, in Washington, DC.

Job Type

Full-time

Work Location

Hybrid (Washington, D.C.)

Education

Bachelor's Degree (Required)

Experience

• PowerApps: Min 4years (Required)
• Power BI: Min 4years (Required)

Benefits

• 401(k)
• 401(k) contribution
• Medical insurance
• Dental insurance
• Vision insurance
• Life & Disability Insurance
• Flexible Spending Account
• Paid time off
• Professional development
• Employee assistance program
• Work-life balance

Company Information

This position offers the opportunity to support one of the nation’s critical agencies in enhancing financial operations and driving efficiency. The role is ideal for individuals looking to grow their career in a dynamic environment while making a meaningful impact on national operations.

Application Question(s)

• This position requires U.S. citizenship. Are you a U.S. citizen currently residing in the U.S.?
• Do you hold a DHS CBP Tier 5 Background Investigation (BI) clearance?