Senior Power BI / Data Analytics Developer, MCoE-MFCD

Yorktown Systems Group; Auburn (AL); Hybrid; USD 95,000 - 140,000; Full time

Job summary

Yorktown Systems Group is seeking a Senior Power BI / Data Analytics Developer to support the U.S. Army and MCoE at Ft. Benning, GA.

Lead developer for enterprise Power BI visualizations, with AI-enabled capabilities to automate staff tasks and improve operational readiness in secure DoD networks. The role focuses on data collection, transformation, and presentation from multiple Army platforms to provide timely, actionable information for leaders and staff.

Qualifications

• Advanced experience with DAX, including measures, KPI development and optimization.
• Advanced experience using Power Query for data transformation and ETL.
• Strong data modeling skills with relationships, schemas, and semantic model design.
• Experience integrating data from multiple sources into consolidated analytics products.
• Experience developing automated reporting and decision-support outputs.
• Working knowledge of relational databases and structured data querying.

Responsibilities

• Design, develop, test, deploy, and maintain Power BI dashboards and analytics products.
• Create automated data pipelines collecting data from multiple Army systems and sources.
• Build semantic models, measures, KPIs, and relationships to support operations.
• Develop and optimize DAX expressions and Power Query ETL processes.
• Prototyping dashboards quickly and refining based on user feedback.
• Ensure security and governance compliance across analytics solutions.

Skills

Power BI

Data Analytics

DAX

Power Query

ETL

SQL

AI/ML concepts

Tools

Power BI

Power Query

DAX

SQL

SharePoint

Power Automate

Job description

Senior Power BI / Data Analytics Developer, MCoE-MFCD - (2598)

Share this job as a link in your status update to LinkedIn.

ABOUT THE ORGANIZATION Yorktown Systems Group, Inc., and its wholly‑owned subsidiaries, are a committed team of dedicated former military and civilian professionals who believe in providing ethical and quality services to Government customers. Our leadership team is composed primarily of Veterans who are now serving in a corporate environment rather than in uniform. Our customer's missions become our own and we are committed to working as a team to achieve success. Because of the depth and experiences of our corporate leadership, we can assure all our customers that "we will do what we say we can do" and will focus on our customer's missions rather than corporate goals. Our business model is based on a personal commitment from our leaders to maintain contact with our customers to continually and consistently gauge our performance. Yorktown Systems Group was founded on the idea that providing quality and ethical services with a laser focus on our customer's goals is an effective long‑term business model. Our mission, therefore, is to help our customers meet their requirements and goals. The contractor will not discharge or in any other manner discriminate against any employee or applicant for employment because such employee or applicant has inquired about, discussed, or disclosed the compensation of the employee or applicant or another employee or applicant. This provision shall not apply to instances in which an employee who has access to the compensation information of other employees or applicants as a part of such employee's essential job functions discloses the compensation of such other employees or applicants to individuals who do not otherwise have access to such information, unless such disclosure is in response to a formal complaint or charge, in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or is consistent with the contractor's legal duty to furnish information. The Unconventional, LLC is a wholly‑owned subsidiary of Yorktown Systems Group, Inc.

Summary:

Yorktown Systems Group is seeking a qualified Senior Power BI / Data Analytics Developer to support the U.S. Army and the Maneuver Center of Excellence (MCoE) Maneuver Forces Capability Development at Ft. Benning, GA. This position serves as the lead developer and technical expert for the design, development, and deployment of enterprise‑level data visualization applications using the US Army PowerBI suite. The role leverages expertise in Large Language Models (LLMs) and generative AI technologies to build secure, intelligent solutions that enhance decision‑making, automate complex staff tasks, and improve overall operational readiness within secure Department of War networks. The position will focus on developing automated operational products that collect, transform, and present data from multiple Army platforms to provide leaders and staff with timely, accurate, and actionable information. A key objective of the position is to help transition manually maintained staff products and operational running estimates into automated or semi‑automated solutions that remain current as underlying data changes.

The Senior Power BI / Data Analytics Developer will work closely with Government functional experts, staff members, data owners, and technical personnel to identify requirements, refine concepts, prototype solutions, and develop automated products. The position requires the ability to understand an operational problem, determine how available data can support the requirement, and independently develop a practical technical solution. The Senior Developer will also support the employment and integration of locally developed Artificial Intelligence (AI) capabilities being developed by the Government. The position is not primarily an AI development position; rather, the Senior Developer should understand AI‑enabled capabilities sufficiently to assist with their integration into Army data, analytics, and decision‑support workflows.

• Design, develop, test, deploy, and maintain complex Microsoft Power BI dashboards, applications, and operational decision‑support products.
• Develop automated and semi‑automated products that collect and integrate data from multiple Army systems and information sources.
• Design Power BI semantic models, relationships, measures, calculations, and key performance indicators to support operational and staff requirements.
• Develop and optimize DAX (Data Analysis Expressions) used in dashboards, reporting applications, and analytical products.
• Develop Power Query and ETL (Extract, Transform, Load) processes to acquire, clean, transform, combine, and prepare data from disparate sources.
• Build and maintain repeatable data pipelines and automated data‑refresh processes that reduce manual staff workload and improve the timeliness of information.
• Translate Government operational requirements and business processes into data‑driven technical solutions.
• Work collaboratively with Government personnel to identify opportunities for automation and assist in defining requirements that may not be fully developed at project initiation.
• Rapidly prototype dashboards, reports, workflows, and other automated products and refine them based on user feedback.
• Identify opportunities to improve existing staff processes through data integration, visualization, automation, and approved AI‑enabled capabilities.
• Employ and integrate Government‑developed AI tools in support of current programs, analytical workflows, and automated products.
• Assist users in determining where AI‑enabled capabilities can enhance data analysis, information retrieval, reporting, workflow execution, and decision support.
• Integrate data from databases, spreadsheets, SharePoint‑based sources, and other available enterprise data sources as required.
• Ensure applications, data flows, dashboards, and automated products comply with applicable Army cybersecurity, data governance, information protection, and OPSEC requirements.
• Provide technical advice to Government personnel regarding data analytics, automation, Power BI, and emerging AI‑enabled capabilities.
• Present analytical products and technical concepts to both technical and nontechnical audiences, including senior leaders.
• Develop appropriate technical documentation, user instructions, and training materials and provide user training as required.

Job Requirements

Required Qualifications:

• Advanced experience with DAX, including development of measures, calculations, KPIs, and optimization of complex analytical models.
• Advanced experience using Power Query for data transformation and ETL.
• Strong understanding of data modeling, including relationships, schemas, data structures, and development of effective semantic models.
• Experience integrating data from multiple disparate systems or data sources into consolidated analytical products.
• Experience developing automated or semi‑automated reporting, analytics, or operational decision‑support products.
• Working knowledge of relational databases and the ability to query and manipulate structured data.
• Ability to independently translate functional or operational requirements into technical solutions.
• Demonstrated ability to work directly with customers and subject matter experts to identify requirements, develop prototypes, obtain feedback, and iteratively improve technical products.
• Ability to troubleshoot data, integration, visualization, and application‑performance issues.
• Strong analytical, problem‑solving, and communication skills.
• Ability to communicate complex technical concepts to nontechnical users and senior leaders.

Desired Qualifications:

• Experience supporting the U.S. Army, Department of Defense, or another Federal Government organization.
• Experience developing analytical products within a DoD Microsoft enterprise environment.
• Experience working with Army operational, readiness, training, planning, or staff processes.
• Experience developing or supporting operational dashboards, command‑and‑staff running estimates, readiness products, or executive decision‑support tools.
• Working knowledge of SQL and relational database concepts.
• Experience creating automated data‑refresh processes and integrating multiple enterprise data sources.
• Experience with Microsoft Power Automate or similar workflow‑automation capabilities.
• Familiarity with Microsoft Power Platform tools beyond Power BI.
• Understanding of cybersecurity, data governance, access controls, and protection of sensitive Government information.

AI / Emerging Technology Qualifications:

• Working knowledge of generative AI and Large Language Model capabilities.
• Understanding of practical applications of AI for data analysis, information retrieval, summarization, automation, and decision support.
• Ability to learn, employ, and integrate Government‑developed AI tools into existing staff processes and analytical products.
• Ability to collaborate with AI developers, data owners, functional experts, and users to determine how locally developed AI capabilities can support operational requirements.
• Understanding of the importance of data security, permissions, governance, validation, and responsible use when applying AI to Government information.

Preferred Qualifications:

• Experience with Microsoft Power Apps.
• Experience with Microsoft SharePoint and Microsoft Lists as data sources for analytical products.
• Experience with Python, scripting, APIs, or other data‑integration technologies.
• Experience with advanced data visualization and user‑interface/user‑experience design.
• Experience supporting Army headquarters or operational staff organizations.
• Microsoft Power BI, Power Platform, data analytics, or related professional certifications.

Clearance

Able to get a SECRET security clearance

Travel

Some travel may be required

Security Clearance

Eligible for Secret Security Clearance (1)

Job Type

Full‑Time

Exemption Type

Exempt

Category

Contractors

EEO STATEMENT Yorktown Systems Group, Inc., and its wholly‑owned subsidiaries, are an Equal Opportunity Employer. No employee or applicant for employment is denied equal opportunity because of race, color, sex, national origin, religion, age, disability, marital status, pregnancy, sexual orientation, gender identity, genetic information, any other non‑merit‑based factor, or other characteristics protected by law. As part of the company's equal employment opportunity policy, Yorktown Systems Group, Inc., and its subsidiaries, will also take affirmative action as called for by applicable laws and Executive Orders to ensure that minority group individuals, females, disabled veterans, recently separated veterans, other protected veterans, Armed Forces service medal veterans, and qualified disabled persons are introduced into our workforce and considered for promotional opportunities. The Unconventional, LLC. is a wholly‑owned subsidiary of Yorktown Systems Group, Inc.