[Remote] Data Analyst
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. This mid-level role involves developing and maintaining Power BI reports, ensuring data accuracy, and collaborating with various teams to support reporting outputs.
Responsibilities
- Analyze current and potential disparate data sources
- Build, update, and maintain Power BI reports and dashboards
- Maintain Measures and Metrics reports to assure the continued accuracy and performance
- Validate data accuracy and participate in routine data quality checks
- Gather user requirements and determine sources of data
- Work with the Measures and Metrics team to create and further define projects and tasks from verbal customer cues and requests
- Assist with the extraction of metrics requirements and assignments for proposed or impending initiatives
- 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 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
- Streamline Power BI M queries where possible
- Work with SQL DBAs to create and refine data sources for Power BI reporting
- Monitor and troubleshoot Power BI data refreshes and refresh issues
- Escalate Power BI refresh issues to the Corporate Data Warehouse (CDW) team
- Document Power BI permissions, workspaces, and report deployment steps
- Gather, prepare, and deliver weekly and ad hoc Power BI based reports via PowerPoint and Excel
- Provide general administrative and reporting support to the Measures and Metrics team
- 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 Analytics, Engineering, or related technical field
- Equivalent experience or industry certifications may substitute for formal education
- 3–5 years of experience supporting reporting, analytics, or business operations
- Tableau or Microsoft Power BI development experience (visuals, datasets, filters, publishing, workspace familiarity, DAX, and M Query)
- Experience working with Microsoft Excel and PowerPoint for data presentation
- United States government related work (e.g., Department of Defense, VA)
- Microsoft Word, Excel, PowerPoint, Outlook, and Visio 2013 or higher
- SharePoint Online
- Remote Desktop Connection
- Communication tools (Teams, SharePoint)
- VBA, Microsoft Power Automate
- 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
- 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
- Employer sponsored group dental
- Employer sponsored group vision
- Short-term and long-term disability
- Life insurance
- AD&D coverage
- Legal services
- Identity theft
- 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
- Employer contribution match that is immediately vested
- Professional courses
- Certifications
- Tuition reimbursement programs
- Flexible spending account options offer pre-tax savings for qualified medical, dental, and vision expenses
Company Overview