Senior Power Platform Automation Engineer (Onsite)

Tier4 Group; Fort Meade (MD); On-site; USD 110,000 - 165,000; Full time

Job summary

Tier4 Group is seeking an Automation Engineer to design and build business process automation and reporting solutions, primarily using Microsoft Power Platform and Power BI. This on-site role collaborates with customers to define needs, document designs, and implement in dev and production environments.

Ideal candidates have 8+ years IT experience, 5+ years delivering Power Platform/Power BI solutions, and a DoD TS/SCI clearance with SCI eligibility.

Qualifications

• 8+ years of relevant IT experience.
• 5+ years building production solutions on Power Platform and Power BI.
• Bachelor's degree in a related field.
• Must have and maintain a current DoD Top Secret clearance with SCI eligibility.
• Must have and maintain at least one certification compliant with DoD IAT level II, such as CompTIA Security+CE or equivalent.

Responsibilities

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

Skills

Power Platform

Power BI

Requirements gathering

Stakeholder communication

End-to-end ownership

Education

Bachelor's degree

Tools

SharePoint Online

Dataverse

Outlook

Teams

SQL

Excel

REST/Microsoft Graph

Job description

Tier4 Group is seeking an Automation Engineer to design and build business process automation and reporting solutions, primarily using Microsoft Power Platform and Power BI. This on-site role collaborates with customers to define needs, document designs, and implement in dev and production environments.

Ideal candidates have 8+ years IT experience, 5+ years delivering Power Platform/Power BI solutions, and a DoD TS/SCI clearance with SCI eligibility.