Note: The job is a remote job and is open to candidates in USA. Planned Systems International (PSI) is a Government Contractor seeking a Metrics Reporting Specialist for their metrics department. The role supports SQL data operations, workflow automation, and collaboration with senior technical staff to ensure reliable metrics processes and reporting automations.
Responsibilities
- Support SQL-based data processes, including writing and modifying intermediate-level SQL queries
- Support the senior SQL DBA with routine data operations, job monitoring, and database process improvements
- Analyze current and potential disparate data sources
- Review and suggest refinements to proposed database modifications
- Assist in monitoring and maintaining SSIS packages; troubleshoot and escalate failures or performance issues
- Develop, maintain, and optimize automated workflows using Microsoft Power Automate Flows
- Use Microsoft Copilot to streamline documentation, automate repetitive tasks, and enhance analytics workflows
- Learn and apply Power BI to create, modify, and maintain dashboards and reports (Power BI experience preferred but not required)
- Maintain Measures and Metrics reports to assure the continued accuracy and performance
- Validate data accuracy and participate in routine data quality checks
- Work with the Measures and Metrics team to create and further define projects and tasks from verbal customer cues and requests
- Support all phases of solution deployment activities in Power BI or other accepted reporting/data visualization tools (i.e Power BI Desktop, Power BI Workspaces, Power BI Apps, Power BI Service security and user navigation)
- Assist with the extraction of metrics requirements and assignments for proposed or impending initiatives
- Assist with documenting processes, data flows, automations, and reporting procedures
- Contribute to meeting notes, agendas, and metrics documentation as needed
- Collaborate with the Measures & Metrics team on metric definitions, reporting updates, and automation opportunities
- Contribute to or write portions of Measures and Metrics documentation
- Support quality and process improvement methodologies to develop and continuously update team and program processes, documentation and artifact templates
- Possible work in assisting with the design, creation and maintenance SharePoint sites, pages, lists, and libraries
Skills
- Bachelor's degree in Information Technology, Computer Science, Data Analytics, Business
- Equivalent experience or industry certifications may substitute for formal education
- 1–2 years of experience in a data analyst, data operations, BI support, or similar technical role
- Working knowledge of SQL, including writing and modifying queries and stored procedures
- Experience creating and maintaining SSIS packages
- Experience with automation tools such as Power Automate Flows
- Exposure to AI-assisted productivity tools (e.g., Copilot) or willingness to adopt them
- Experience with version control, structured documentation, or process-driven work environments
- Microsoft Word, Excel, PowerPoint, Outlook, and Visio 2013 or higher
- SharePoint Online
- Remote Desktop Connection
- Communication tools (Teams, SharePoint)
- VBA, Microsoft Power Automate
- Power BI experience is a plus (visuals, datasets, publishing, workspace familiarity, DAX, and M Query)
- Experience automating tasks using VBA, Microsoft Power Automate, or other scripting languages is a plus
- Understanding of data quality principles and dashboard design concepts
- Experience with Power BI: datasets, measures, and report development
- Experience with SQL: tables, indexes, relationships, complex queries, stored procedures, jobs, job schedules
- Experience with data modeling, ETLs, and SSIS
- Experience with SharePoint, Teams, or workflow/documentation management tools
- Prior exposure to government, VA, or DoD environments is beneficial
- Current Moderate Background Investigation (MBI) and VA network access a plus
Benefits
- Paid leave
- Employer sponsored group medical, dental, vision, short-term and long-term disability, life insurance, AD&D coverage, legal services, identity theft, and accident insurance
- Flexible spending account and health saving account options offer pre-tax savings for qualified medical, dental, and vision expenses
- Company sponsored 401(k) retirement plan has an employer contribution match that is immediately vested
- Professional courses, certifications, and tuition reimbursement programs
Company Overview