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.

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

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