Note: The job is a remote job and is open to candidates in USA. Planned Systems International (PSI) is a Government Contractor seeking a Junior Data Analyst for their Metrics Reporting team. The role involves supporting SQL data operations, collaborating with senior technical staff, and developing reporting capabilities using tools like Power BI and Microsoft Copilot.
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
- Strong analytical thinking and problem-solving skills
- Ability to support multiple tasks, projects, and deadlines simultaneously and handle changing priorities
- Capable of prioritizing tasks
- Comfortable collaborating with senior technical staff and learning from mentorship
- Detail-oriented and capable of documenting technical processes clearly
- Strong communication skills, including explaining technical issues to non-technical users
- Ability to work independently and take ownership of assigned responsibilities
- Excellent customer service skills (This position works closely with the Customer.)
- Customer-service-oriented approach with internal stakeholders
- Self-driven and goal oriented with focus of providing the best possible work product and improving efficiency
- Ability to work well with and communicate effectively with all levels of an organization
- Required Technical/Business Tools Experience: 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
- Options for 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
- The company sponsored 401(k) retirement plan has an employer contribution match that is immediately vested
- We invest in the professional growth of our employees through professional courses, certifications, and tuition reimbursement programs
Company Overview