Power BI Analyst

LMI Consulting, LLC; Tysons (VA); Remote; USD 76,000 - 131,000; Full time

Job summary

LMI is seeking a Senior Power BI Analyst to support a federal program management office in the National Capital Region. This remote role involves designing dashboards and reports, cleansing and modeling data, and delivering actionable insights to inform program decisions.

Ideal candidates will have 3–5+ years in BI, strong Power BI/Tableau/Qlik skills, and experience with data transformation (SQL/Power Query). The role emphasizes data quality, governance, and executive-ready analytics.

Qualifications

• Minimum 3–5+ years of related experience.
• Proficiency with Tableau, Qlik, and/or Power BI dashboards and data visualization.
• Experience with data transformation using SQL/Power Query.
• Strong cross-functional collaboration and storytelling with data.

Responsibilities

• Gather reporting requirements from project teams and stakeholders to design Power BI dashboards and reports.
• Ingest and harmonize data from multiple systems for portfolio reporting.
• Develop and optimize data models, measures, and KPIs using DAX.
• Configure data refresh schedules and troubleshoot data issues.
• Prepare executive-grade dashboards and briefing materials for leadership.

Skills

Power BI

Tableau

Qlik

SQL

DAX

Data Visualization

Data Analytics

Excel

Education

Bachelors degree in CS/Engineering/Data science/Math

Tools

Power Query

Power Automate

SharePoint

Job description

Power BI Analyst

Overview

LMI is seeking a Senior Power BI Analyst to support a federal program management office in the National Capital Region. Join our team of collaborative self-starters focused on delivering practical and efficient solutions to help our client keep U.S. borders safe and facilitate travel and trade. As part of our high-performing team, you will augment our vital work to provide \"eyes and ears\" technology to protect our nation.

LMI is a new breed of digital solutions provider dedicated to accelerating government impact with innovation and speed. Investing in technology and prototypes ahead of need, LMI brings commercial-grade platforms and mission-ready AI to federal agencies at commercial speed.

Leveraging our mission-ready technology and solutions, proven expertise in federal deployment, and strategic relationships, we enhance outcomes for the government, efficiently and effectively. With a focus on agility and collaboration, LMI serves the defense, space, healthcare, and energy sectors-helping agencies navigate complexity and outpace change. Headquartered in Tysons, Virginia, LMI is committed to delivering impactful results that strengthen missions and drive lasting value.

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.

Qualifications

• Ability to pass a government background investigation, including financial, criminal, residential, educational, foreign affiliation, prohibited substance abuse, and employment verifications; active U.S. Customs and Border Protection background investigation preferred. Please note that only U.S. citizens are eligible for a suitability determination.


• Bachelors degree required. Degree in computer science, engineering, data science, operations research, industrial engineering, mathematics, or a related discipline preferred.


• 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.

Desired:

• 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.

The target salary range for this position is $76,390 - $130,605.

The salary range displayed represents the typical salary range for this position and is not a guarantee of compensation. Individual salaries are determined by various factors including, but not limited to location, internal equity, business considerations, client contract requirements, and candidate qualifications, such as education, experience, skills, and security clearances.

Job Locations

US-Remote

LMI is an Equal Opportunity Employer. LMI is committed to the fair treatment of all and to our policy of providing applicants and employees with equal employment opportunities. LMI recruits, hires, trains, and promotes people without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, pregnancy, disability, age, protected veteran status, citizenship status, genetic information, or any other characteristic protected by applicable federal, state, or local law. If you are a person with a disability needing assistance with the application process, please contact

Colorado Residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.