Power Automate Specialist

Technomics, Inc.; Troy (MI); On-site; USD 75,000 - 110,000; Full time

Job summary

Technomics, Inc. is seeking a data analytics professional to support a fast-paced, high-visibility client in Troy, MI. You will develop automated data collection and workflows using Power Apps and Power Automate, build Power BI dashboards, and ensure data is refreshed daily from client data sources.

You will also help design data architecture and governance for ongoing analysis. The role requires 3+ years of quantitative analysis, familiarity with Advana/Palantir/Azure, and experience with

Qualifications

• 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.
• Candidates must be U.S. Citizens.
• Experience supporting the Navy and/or 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.

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.
• Establish digital processes to facilitate workflows, automate processes, and collect data.
• Develop Power BI dashboards summarizing data stored on the client environment and publish Power BI products to production with automated daily data refresh.
• Identify and implement opportunities to improve client workflows through automation best practices.
• Support establishment of a robust data architecture and enterprise data management process with ETL to a centralized repository.
• Support development of data pipelines from external sources (ADVANA, Palantir, Azure) to transform raw data into analysis-ready data.
• Prepare written documentation describing data, techniques, results and insights; defend work to colleagues and clients.

Skills

Quantitative analysis

Problem solving

Communication (written)

Communication (verbal)

Self-starter

Tools

Power Apps

Power Automate

Power BI

ADVANA

Palantir

Azure

Python

R

SQL

Job description

Current job opportunities are posted here as they become available.

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 (i.e., 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 (e.g., technical reports, presentations) describing the data and analytical techniques used, results produced and associated insights and recommendations
• Verbally explain/defend 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

• 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 U.S. Citizens
• Experience supporting the Navy and/or 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.