Automation Engineer

About the role

About Us

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.