RPA Senior Specialist - Business Intelligence & Analytics

This position is responsible for leading automation efforts using UiPath, providing technical support of inbound and outbound eligibility feeds, dashboard development, and custom report generation in support of internal and external customer needs. Also provides advanced technical product support for Employer Population Health applications working closely with internal and external customers.

This position is also responsible for gathering business requirements for inbound analytics requests, designing and developing solutions using UiPath (RPA), Tableau, Power BI, and/or Alteryx, and presenting findings and strategic output to leadership. This position does not directly supervise others but is responsible for driving results across cross-functional teams and coaching junior developers on the best use of models, automated processes, and data standards.

This is a remote opportunity however the incumbent must reside in a commutable distance to one of our Major labs in Kansas (Lenexa Lab), Missouri (St Louis Lab), Colorado (Denver Lab), Ohio (Cincinnati Lab), Indiana (Indianapolis Lab), Illinois (Wood Dale Lab, Schaumburg Lab)

No Sponsorship available. 

Pay Range: $80,000 - $100,000/ year, 5% Bonus

Salary offers are based on a wide range of factors including relevant skills, training, experience, education, and, where applicable, certifications obtained. Market and organizational factors are also considered. Successful candidates may be eligible to receive annual performance bonus compensation.

Benefits Information:

We are proud to offer best-in-class benefits and programs to support employees and their families in living healthy, happy lives. Our pay and benefit plans have been designed to promote employee health in all respects – physical, financial, and developmental. Depending on whether it is a part-time or full-time position, some of the benefits offered may include:

· Medical/Prescription Drugs

· Dental

· Vision

· Flexible Spending Accounts (FSAs)

· Supplemental Health Plans

· 401(k) Plan – Company match dollar-for-dollar up to 5%

· Employee Stock Purchase Plan (ESPP)

· Supplemental Life Insurance

· Dependent Life Insurance

· Short- and Long-Term Disability buy-up

· Blueprint for Wellness

· Emotional Well-Being Resources

· Educational Assistance

· Paid time off / Health Time

Work Experience

• UiPath & Automation: 3+ years of hands-on experience designing, developing, and implementing enterprise-scale Robotic Process Automation (RPA) solutions using UiPath (UiPath Advanced Developer certification is a plus).
• Data & Analytics: 5+ years of progressive, recent Data Science related experience including Data Analytics, Business Intelligence, Dashboarding, Data Profiling, and Data Management.
• Data & Analytics: 5+ years of progressive, recent Python experience including Data Analytics, Business Intelligence, Dashboarding, Data Profiling, and Data Management.
• BI Visualizations: Demonstrated strong experience in Power BI or Tableau for high-quality dashboard creation, data profiling, and visual data storytelling.
• Data Querying & ETL: Proven proficiency in SQL and ETL tools. Experience with Alteryx (1+ years of workflow development) and Snowflake is highly preferred.
• Industry Experience: 1–2 years of experience in the Healthcare, Diagnostics, or Clinical Laboratory industry is preferred.
• Project Management Tools: Experience with Smartsheet workflow automation, portfolio tracking, and automated communication streams is an asset.
• 2+ years of any Intelligent Automation platform like Power Automate, UiPath/gen AI, etc.
• 2+ years strong demonstrated business intelligence experience including dashboarding in Tableau/Power BI/Looker for dashboard creation and visual data storytelling, data visualization – creating dashboard and giving insights from the data.
• Demonstrated proficiency in SQL and ETL processes

Technical Skills & Competencies

• Expert Proficiency in UiPath: Expert-level capability in building, deploying, and managing automated bots (Attended, Unattended, and Studio) along with orchestrator experience.
• Advanced Data Analysis: Strong capability to dissect complex operational datasets (e.g., specimen collection volumes, turnaround times, and onboarding lifecycles) and translate them into actionable business insights.
• Database & SQL Mastery: Exceptional skill in writing, tuning, and optimizing complex SQL queries and managing data pipelines.
• Visual Storytelling: Advanced skill in designing intuitive Power BI and Tableau dashboards utilizing best-practice UI/UX principles.
• Workflow Design: Strong analytical mindset with the ability to map out current-state business workflows and design automated future-state processes.
• Communication & Collaboration: Excellent communication skills with the ability to convey complex technical architectures and automated workflows to non-technical executive stakeholders.

Education

• Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or a related quantitative field. Equivalent work experience will be considered.

• Lead RPA and Automation Initiatives: Lead the end-to-end design, development, testing, deployment, and ongoing support of scalable and sustainable automation solutions using UiPath to streamline business operations and eliminate manual data processing.

• Requirements Gathering: Independently lead the process of gathering and evaluating complex business requirements for incoming business analytics and workflow automation requests; translate requirements into efficient and effective technical solutions.

• Analytics & Reporting Solutions: Lead the design, development, deployment, and maintenance of sustainable/automated Business Intelligence (BI), reporting, and analytical dashboards using Tableau and Power BI. Create scorecards, operational workflows, and highly interactive visualizations for regional leadership.

• Database & Query Optimization: Design, develop, deploy, and support measure algorithms in the form of complex SQL scripts, stored procedures, and database queries (primarily within Snowflake and SQL Server environments).

• Data Hierarchy & Account Management: Support database administration and datasets tracking client onboarding lifecycles, and manage complex parent–child account hierarchies to ensure seamless rolled-up executive reporting.

• Ad-Hoc Business Reporting: Run and support monthly and ad-hoc client reporting pipelines. Investigate, troubleshoot, and resolve issues related to automated data processing and external system integrations.

• Cross-Functional Collaboration: Partner with national teams, database administrators, and business stakeholders to execute project tasks, implement security protocols (including row-level access controls), and maintain infrastructure stability.