Mid Power BI Data Analyst

ITA International is seeking a Mid-Level Power BI Data Analyst to support the U.S. Army T2COM mission in a hybrid role based in Fort Eustis, Virginia. The position focuses on analyzing, transforming, modeling, and visualizing data to support mission operations and leadership decision-making.

Key Responsibilities

• Design, develop, test, deploy, and maintain Power BI reports, dashboards, semantic models, and analytical solutions.
• Collect and analyze reporting and data requirements from government stakeholders and mission users.
• Translate business questions and mission requirements into data and visualization solutions.
• Identify appropriate data sources and create repeatable extraction, transformation, and preparation processes.
• Use Power Query to connect, transform, cleanse, and combine data from multiple sources.
• Build scalable Power BI semantic models.
• Create and maintain DAX measures, calculated columns, calculated tables, and analytical expressions.
• Develop dashboards and reports that clearly communicate operational and mission information for intended audiences.
• Implement filtering, drill-down, drill-through, and interactive reporting functionality.
• Support dashboards for operational users, program managers, analysts, and senior leadership.
• Connect Power BI to enterprise data sources including Dataverse, SQL databases, SharePoint, Excel, APIs, Microsoft 365, and other approved sources.
• Validate data accuracy, completeness, consistency, and timeliness; identify data-quality issues and coordinate resolution with data owners and technical teams.
• Contribute to data dictionaries, metadata, business definitions, and reporting standards.
• Partner with Business Analysts to define reporting requirements, metrics, key performance indicators, and business rules.
• Coordinate with Power Platform developers and architects to integrate Power BI capabilities into broader Power Platform solutions.
• Support development and maintenance of Power Apps and Power Automate solutions where reporting and analytics are required.
• Optimize Power BI reports, models, queries, and datasets for performance.
• Configure and maintain data refresh processes and support Power BI deployment across development, test, and production environments.
• Participate in peer reviews and technical design reviews; troubleshoot issues related to reports, datasets, refresh processes, data sources, and visualizations.
• Document data sources, transformations, calculations, assumptions, and report logic; create test cases and perform data validation.
• Support user acceptance testing and incorporate stakeholder feedback.
• Monitor production reports and resolve issues according to established support procedures.
• Assist with data analysis and ad hoc reporting requests; identify opportunities to improve data accessibility, reporting automation, and analytical capabilities.
• Apply established security, governance, data handling, and access-control requirements.
• Stay current with Microsoft Power BI and related data platform capabilities.
• Perform other data analysis and reporting duties needed to support T2COM mission objectives.
• Develop and maintain Power BI dashboards embedded within Power Apps using Power BI tiles.

Required Qualifications

• Bachelor’s degree in a related technical discipline (Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Business Analytics, or equivalent) or equivalent professional experience.
• 4+ years of experience in data analysis, business intelligence, reporting, data visualization, or a related field.
• 2+ years of hands-on Power BI development experience.
• Demonstrated experience developing production-quality Power BI reports and dashboards.
• Strong experience with Microsoft Power BI, Power Query, DAX, data modeling, data visualization, and data analysis.
• Experience developing relational data models and working with structured data.
• Experience working with SQL and relational databases.
• Experience connecting Power BI to multiple data sources.
• Experience developing calculated measures and analytical expressions using DAX.
• Experience cleansing, transforming, and validating data using Power Query or comparable tools.
• Experience gathering and documenting reporting and analytical requirements.
• Ability to translate business requirements into meaningful analytical products.
• Strong understanding of data quality, data validation, and data governance concepts.
• Experience working with business and technical stakeholders.
• Strong analytical, problem-solving, and critical-thinking skills.
• Strong written and verbal communication skills.
• Ability to obtain and maintain a Secret security clearance.

Technologies

• Microsoft Power BI, Power Query, DAX
• Dataverse, SQL, SharePoint, Microsoft 365, Excel
• Power Platform, Power Apps, Power Automate
• Azure, Azure SQL, Azure Data Lake, Azure Synapse, Microsoft Fabric
• APIs, REST APIs, custom data connectors
• Power BI semantic models
• Row-level security (RLS)
• Azure DevOps, Git
• Power BI deployment pipelines
• Power BI tiles

Compensation and Location

Location: Newport News, VA (hybrid).
Salary: USD 110,000 - 125,000 per year.

Benefits

• Medical, dental and vision plans
• Life Insurance
• Short Term Disability insurance (where applicable)
• Voluntary ancillary benefit options
• 401k retirement benefits with employer matching contributions
• Pay range for this position is $110,000 - $125,000 annually

Preferred Qualifications

• Microsoft Power BI Data Analyst Associate certification.
• Microsoft Power Platform certifications.
• Experience with Microsoft Fabric and/or Azure data services.
• Experience with Azure SQL, Azure Data Lake, Azure Synapse, or other Azure data technologies.
• Experience with Microsoft Dataverse.
• Experience with Power Apps and Power Automate.
• Experience with SharePoint Online and Microsoft 365.
• Experience developing Power BI solutions using REST APIs and custom data connectors.
• Experience with advanced DAX optimization and performance tuning.
• Experience implementing row-level security (RLS).
• Experience with Power BI deployment pipelines and Azure DevOps.
• Experience with Git or other source-control technologies.
• Experience developing executive-level dashboards and performance scorecards.
• Experience supporting U.S. Army, DoD, or federal government programs.
• Familiarity with RMF, NIST, FISMA, DISA STIGs, Zero Trust, and federal cybersecurity requirements.
• Experience working with controlled, sensitive, or mission-critical data.
• Familiarity with federal data governance and information-handling requirements.
• Active Secret security clearance.