Data and Workflow Integration Analyst

About This Role

This role is for a systems thinker who connects data, processes, and people to create cohesive, efficient operational ecosystems. The analyst will design and implement technical solutions that optimize business workflows, streamline system integrations, and expand data accessibility across the organization. This person excels at untangling complexity, identifying inefficiencies, and strengthening organizational connectivity through smarter systems and better data.

Responsibilities

• Design, build, and maintain data systems across SharePoint, MS SQL, and related platforms
• Develop automation scripts using PowerShell and Python to streamline tasks and optimize workflows
• Build and refine data models using DAX within the Power Platform (Power BI, Power Automate, etc.)
• Map, analyze, and visualize business workflows to improve logic, reduce friction, and increase efficiency
• Collaborate with departments for requirements gathering and translating business needs into scalable solutions
• Lead and deliver small-to-mid-sized systems integration, data automation, and process optimization projects
• Maintain documentation standards and life cycle best practices to ensure transparency and audit readiness
• Prioritize multiple projects independently while ensuring communication with all stakeholders

Requirements

• 5+ years of experience in a technical analyst, systems integration, or business process automation roles
• 5+ years hands-on experience with relational databases (MSSQL, MySQL, PostgreSQL, or equivalent)
• Proficiency with PowerShell and/or Python scripting for automation, data handling, or systems configuration
• Experience writing, maintaining, and adapting automation scripts for business workflow or data optimization
• Experience with Power Platform DAX language, or willingness to learn
• Proficiency with Microsoft Power BI
• Familiarity with workflow automation platforms, such as Power Automate or similar tools
• Strong documentation skills for technical processes, SOPs, or audit-readiness artifacts
• Strong technical writing skills, including user-facing documentation and training materials
• Exceptional communication skills—written, verbal, and interpersonal
• Demonstrated success in cross-departmental collaboration and stakeholder alignment
• Ability to obtain and maintain a U.S. Secret security clearance
• High school diploma or GED

Qualifications

• High school diploma or GED
• 5+ years of experience in a technical analyst, systems integration, or business process automation role with hands-on experience with relational databases.

Nice to Have

• Bachelor's degree in computer information systems or a related field
• Experience designing or administering SharePoint, including hubs, page outlines, RBAC, and automation
• Certified in or proven experience with process improvement methodologies (Lean Six Sigma, or similar)
• Previous experience supporting technical initiatives in a regulated, aerospace, defense, or federal contractor environments

Skills

* Required skills