Pay: $100,000.00 - $130,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:- Developing and maintaining applications in MS Power Apps to collect field inputs, developing automated reports and workflows and capture previously manually created information in a digital platform.
- Working with the client to implement applications across the organization for field use.
- Supporting client in exploring, categorizing, and reviewing data in all its forms, and developing solutions for curation and visualization.
- Inspecting, cleaning, transforming and modelling data with the goal of discovering useful information, informing conclusions and supporting decision-making.
- Accessing, utilizing, and analyzing data from client systems and external commercial products, (such as MS Dynamics, Azure, Excel, MS Access, Case Management Systems, SharePoint, etc)
- Reviewing and validating 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.
- Creating and managing multiple program-level dashboards that directly feed agency level dashboards and placemats, representing all programs in the security portfolios.
- Reviewing database architecture and data control policies and offer recommendations for utilization, improvements, or new investments.
- Assisting with 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 4 years (Required)
- Power BI: Min 4 years (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
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?
