Note: The job is a remote job and is open to candidates in USA. LMI is a digital solutions provider serving federal agencies with technology, analytics, and mission-focused solutions. The Senior Power BI Analyst will support a federal program management office by developing and maintaining dashboards, reports, data models, and performance metrics. The role will analyze and improve program data, support executive reporting, automate processes, and ensure reporting products meet governance and security requirements.
Responsibilities
- Collaborate with integrated project teams, program managers, and executive stakeholders to gather reporting requirements and translate business needs into actionable Power BI dashboards, reports, and metrics
- Compile, integrate, clean, transform, and analyze large datasets from multiple systems and platforms to support project, program, and portfolio reporting
- Design, develop, enhance, and maintain Power BI dashboards, scorecards, reports, and data models that provide clear, actionable insights into cost, schedule, technical performance, quality, risks, issues, and program health
- Develop and maintain data transformation logic using Power Query, SQL, Excel, or other approved tools to prepare data for reporting and analysis
- Create and optimize Power BI data models, measures, calculated columns, and KPIs using DAX
- Configure, monitor, and troubleshoot scheduled data refreshes in Power BI Service or other approved reporting environments
- Support executive and management reporting by preparing dashboards, briefing materials, and performance measures that inform strategies, decisions, and management actions
- Analyze program and project cost, schedule, technical performance, and quality data to identify trends, anomalies, common issues, and areas requiring management attention
- Support data quality improvement by identifying inconsistencies, gaps, duplicate records, and validation issues across source systems and reporting products
- Recommend data visualization approaches that improve transparency, usability, and decision support for project, program, and portfolio reporting
- Identify opportunities to automate recurring reports, manual data manipulation, and business processes using Power BI, Power Query, Power Automate, Excel, or other approved tools
- Test, validate, and document dashboard logic, data sources, business rules, calculations, and refresh processes
- Troubleshoot and resolve report, dashboard, data model, access, and data refresh issues
- Maintain reporting products in accordance with applicable data governance, records management, cybersecurity, and privacy requirements
Skills
- Bachelors degree required
- 3-5+ years of related experience required
- High level of proficiency using/creating Tableau, Qlik, and/or Microsoft Power BI dashboards, workbooks, and databases; using data to drive business decisions; and building effective and engaging visualizations
- Self-starter with the vision to independently identify opportunities for improvement through data analytics
- Experience visualizing data through the creation of dashboards and balanced scorecards summarizing organization performance using data analytics tools (e.g., Tableau, Microsoft Power BI) in collaboration with others as well as independently
- Expertise in building and cleaning databases from multiple data sources, combining cost and performance information
- Experience with developing queries for routine data requests and reports
- Statistical analysis experience
- Experience creating formulas within PowerBI/Tableau/Qlik
- Experience with Power Query when creating dashboards
- Proficiency in Microsoft Word, Excel, Outlook, PowerPoint, ServiceNow, and SharePoint
- A true team player who maintains a positive attitude in a dynamic environment
- Experience with building, implementing, and supporting complex Tableau and/or Microsoft Power BI visualizations
- Demonstrated ability to understand technical concepts and structure research that simplify these concepts
- Strong cross-cultural communication, collaboration, and organizational skills with an ability to thrive in a fast-paced environment
- Please note that only U.S. citizens are eligible for a suitability determination
- Degree in computer science, engineering, data science, operations research, industrial engineering, mathematics, or a related discipline preferred
- Active U.S. Customs and Border Protection background investigation preferred
- Tableau, Microsoft Power BI, or Qlik certification a plus
- Experience utilizing Data Analysis Expressions (DAX) in PowerBI
- Experience with SQL
- Previous work with CBP is a plus
- A current and fully-adjudicated CBP Background Investigation (BI) is a plus
- Masters degree preferred
- 5-7+ years of experience preferred
Company Overview