Power Automate Specialist

Technomics; Troy (MI); On-site; USD 85,000 - 120,000; Full time

Job summary

Technomics is a growing employee-owned decision analytics company that specializes in cost and economic analysis to facilitate better decisions for federal clients. This role is based in Troy, MI and focuses on delivering data-driven insights using Power BI, Power Apps, and automation to streamline workflows.

You will develop dashboards and data pipelines, contribute to enterprise data management, and collaborate with a cross-functional team.

Qualifications

• Bachelor's degree in a quantitative discipline.
• At least 3 years of quantitative analysis experience.
• Experience with process automation tools, preferably Power Automate.
• Ability to digest client workflows and identify automation opportunities.
• US Citizenship and active Secret Clearance.

Responsibilities

• Support a fast-paced high-visibility client with data-driven decisions.
• Develop understanding of client needs and project objectives.
• Implement Power Apps and Power Automate solutions to automate data calls.
• Develop Power BI dashboards and publish to production with daily data refresh.
• Develop data pipelines from external sources to ensure up-to-date analysis data.
• Prepare technical reports and presentations describing methods, results and insights.

Skills

Quantitative analysis

Power Apps

Power Automate

SQL

Data visualization

Communication

Project management

US Citizenship

Education

Bachelor's degree in a quantitative discipline

Tools

Power BI

Azure

Excel

Palantir

ADVANA

Python

R

Job description

Technomics is a growing employee owned decision analytics company that specializes in cost and economic analysis to facilitate better decisions faster We enable a wide range of clients across the Federal government from senior level policy makers to program managers to choose smartly buy effectively and operate efficiently We deliver practical credible and defensible results offering actionable insights by applying data driven and analytics based approaches in combination with multidisciplinary talent subject matter experts and tangible and repeatable assets in the form of databases models approaches and techniques Analysts use problem solving principles processes and methods and complementary software applications to support client engagements and have a direct and significant impact on deliverables to clients Your work will be guided by more experienced team members but you will work with autonomy Our employee owners pride themselves on their ability to apply deep analytical rigor and innovative thought that assist clients in understanding and solving a myriad of challenging resource planning and management problems This position is located Troy MI

Responsibilities

• Support a new fast paced high visibility client in making data driven decisions
• Develop a thorough understanding of your clients and their needs; overall project objectives and their relationship to client needs; how your work fits in achieving project objectives; how other project team members work relates to your work and project objectives ie acquire situational awareness
• Establish digital processes to facilitate workflows automate processes and collect data Implement Power Apps and Power Automate solutions to replace data calls with automated solutions that allow for rapid insights
• Develop Power BI dashboards summarizing data stored on the client environment Flankspeed and publish Power BI products to a production environment with automated daily data refresh from the underlying Excel files
• Identify and implement opportunities to improve client workflows through results driven automation best practices
• Support establishment of a robust data architecture and enterprise data management process Collect and aggregate existing data from authoritative sources develop and implement necessary extract transform load processes that load data into a centralized repository for analysis
• Support development of the necessary data pipelines from external sources such as ADVANA Palantir Azure etc to transform raw data into analysis quality data through easy low cost continuing operations to ensure up to date data
• Support development of data governance and guidance documentation required to capture data necessary for perform execution functions to include the data format structure and periodicity of reporting
• Prepare written documentation eg technical reports presentations describing the data and analytical techniques used results produced and associated insights and recommendations
• Verbally explaindefend in process and completed work to colleagues and clients in informal and formal settings
• Develop proficiency in various software applications to support solving client problems in an efficient repeatable intuitive and transparent manner

Qualifications

• Bachelors degree in a quantitative discipline
• Minimum of 3 years of quantitative analysis and problem solving experience
• Experience utilizing process automation tools preferably power automate to streamline data collection and streamline program actions
• Ability to independently understand and digest the current client workflow and identify potential avenues for process automation improvements
• Self starter who is creative inquisitive quantitative and enjoys solving challenging problems in a collaborative environment
• Ability to effectively communicate technical work in writing and verbally
• Ability to manage multiple deadlines and work products at the same time
• Candidates must be US Citizens
• Active Secret Clearance

Desired Experience

• Desired Experience supporting the Navy andor a rapid capabilities office
• Familiarity with Advana Palantir or other enterprise data platforms
• Experience in data languages like R Python or SQL
• Experience with Power Apps and other Power Platform tools

Technomics is an Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard to protected status under applicable law including disability and protected veteran status