Automation Engineer

Age-Solutions; Fort Meade (MD); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

26 Days Paid Leave

Performance Bonuses

401(k) with Match

Life Insurance

Job summary

AGE Solutions is seeking an Automation Engineer to design and implement business process automation, custom apps, and reporting using Microsoft Power Platform and Power BI. The role collaborates with customers to define needs, documents designs, and deploys in development and production environments.

Responsibilities include leading discovery sessions, creating design artifacts, building Power Automate flows and Power Apps, and developing star-schema BI models with Power BI. Onsite work at Ft.

Qualifications

• ,

Responsibilities

• Lead requirements discovery sessions with customer stakeholders and map current-state processes into requirements.
• Produce solution design documents and data flow diagrams for customer review and approval.
• Build, test, and deploy Power Automate flows and Power Apps integrating SharePoint Online, Dataverse, Outlook, Teams, SQL, Excel, REST/Graph.
• Use Power Query (M) as data transformation layer across Power BI, Dataflows, and Excel for reliable models.
• Build Power BI semantic models, including star-schema modeling, DAX, RLS, gateway configuration, and refresh.
• Design Dataverse tables, relationships, and security roles; decide where SharePoint lists suffice vs Dataverse.
• Implement application lifecycle management with environments, references, and managed deployments.

Skills

Power Platform

Power BI

SharePoint Online

Dataverse

SQL

Data modeling

Documentation

Communication

Education

Bachelor's degree

Tools

Power Automate

Power Apps

Power Query

SharePoint Online

Dataverse

Graph/REST APIs

Job description

AGE Solutions is a premier technology and professional services company, providing in-depth consulting, advanced technology solutions, and essential services throughout the U.S. government, defense, and intelligence sectors. Prioritizing innovation and client-focused solutions, we assist major agencies in addressing intricate issues and ensuring a more secure future.

We're seeking an Automation Engineer to design and build business process automation, custom applications, and reporting solutions, primarily utilizing Microsoft Power Platform and Power BI. This position works directly with customers to define what needs to be built, develops and documents the design, and ultimately implements in both development and production environments.

Responsibilities Include:

• Lead requirements discovery sessions with customer stakeholders, map current-state business processes, and translate them into documented functional and technical requirements.


• Produce solution design documents, data flow diagrams, and process maps ahead of development, and present designs for customer review and approval.


• Build, test, and deploy Power Automate cloud flows and Power Apps (canvas and model-driven) integrating SharePoint Online, Dataverse, Outlook, Teams, SQL, Excel, REST/Microsoft Graph, and other data sources as necessary.


• Use Power Query (M) as the primary data transformation layer across Power BI, Dataflows, and Excel: ingest, shape, merge, and cleanse data from disparate sources into reliable, reusable models.


• Build Power BI semantic models and reports, including star-schema data modeling, DAX measures, row-level security, gateway configuration, and scheduled/incremental refresh.


• Design Dataverse tables, relationships, and security roles, and make sound calls on when SharePoint lists are sufficient versus when Dataverse is warranted.


• Implement application lifecycle management: solutions, dev/test/prod environments, connection references, environment variables, and managed deployments.

Required Skills, Qualifications, and Experience:

• Experience:
  
  
  
  • 8+ years of relevant IT experience
  
  
  • 5+ years building production solutions on Power Platform and Power BI.
  
  
  
  


• Education:
  
  
  
  • Bachelor's degree in a related field.
  
  
  
  


• Clearance:
  
  
  
  • Must have and maintain a current DoD Top Secret clearance with SCI eligibility.
  
  
  
  


• Certifications:
  
  
  
  • Must have and maintain at least one certification compliance with DoD IAT level II, such as CompTIA Security+CE or equivalent.
  
  
  
  


• Location:
  
  
  
  • This position is onsite full-time at our customer’s location in Ft. Meade, MD.
    
    
    
    • Applicants must reside within a commutable distance of Ft. Meade.
    
    
    
    
  
  
  
  


• Skills and Knowledge:
  
  
  
  • Experience with Power Platform in GCC, GCC High, or DoD regions; including awareness of connector and feature gaps relative to commercial.
    
    
    
    • Advanced Power Query (M): custom functions, parameters, query folding, and incremental refresh.
    
    
    • Power Automate: expressions, error handling (scopes, configure run-after), approvals, child flows, and HTTP/Graph calls.
    
    
    • Power Apps: Power Fx, delegation-aware design, component libraries, and responsive layouts.
    
    
    • Power BI: DAX, data modeling, RLS, deployment pipelines, and on-premises data gateway administration.
    
    
    • SharePoint Online lists, libraries, and permissions, including working with SharePoint and Graph APIs.
    
    
    
    
  
  
  • Demonstrated experience running requirements sessions with non-technical stakeholders and producing design documentation they can sign off on.
  
  
  • Excellent written and verbal communication skills, including presenting designs and status to customer leadership.
  
  
  • Ability to own a solution end to end with minimal supervision.
  
  
  
  

Preferred Qualifications:

• Microsoft certifications such as PL-300 (Power BI Data Analyst) or PL-400 (Power Platform Developer); PL-200 or PL-600 held prior to retirement.


• Experience with Copilot Studio, custom connectors, or Azure services (Logic Apps, Functions, SQL).


• Experience supporting DoD or federal customers.

The projected salary range for this position is $120,000+ annually. Final compensation will be determined based on factors including years of relevant experience, active security clearance level, certifications, technical skillset, contract requirements, and overall qualifications.

At AGE Solutions, we reward performance, invest in growth, and share success. Our benefits support the whole person, professionally, financially, and personally.

• 26 Days Paid Leave: Includes vacation, sick, personal time, and holidays. You choose how to use it.


• Performance Bonuses: Performance bonuses are awarded based on individual contributions and company-wide results, aligning recognition with impact.


• 401(k) with Match: We match 3% of your contributions with immediate vesting.


• Financial Protection: Company-paid life insurance up to $300K and options for additional coverage for you and your dependents.


• Health Benefits: Multiple medical plans, dental, vision, FSA and HSA options to fit your needs.


• Parental Leave: 15 days of fully paid leave for new parents, because family matters.


• Military Differential Pay: We bridge the gap for employees on active duty, so they don’t take a financial hit while serving.


• Professional Growth: Paid training and certifications, tuition reimbursement, and the tools and tech to get the job done right.


• Shared Success: In the event of a company sale, our CEO has committed to returning 80% of net proceeds to employees. This ensures our team shares in the long term value they help create.

At AGE, you’ll do work that matters, supported by a company that delivers for its people.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in AGE Solutions’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval, or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.