Senior Data and Automation Developer

Rea is a growing Top 100 business advisory & accounting firm providing our clients services in tax, accounting, and business consulting. We have a ‘People First’ culture and we focus on our employees’ well-being and professional development. With over 400 professionals and locations throughout Ohio, our firm has a culture that respects a work-life balance for our team. We also provide competitive compensation and a robust benefits plan.

The Senior Data & Automation Developer will have expertise in Microsoft Azure, Power Automate, Python, SQL, and API integrations to lead the design and implementation of scalable business applications. This role is ideal for someone who thrives on solving complex problems, automating processes, and delivering secure, high-performance solutions that connect systems and streamline operations.

Responsibilities

• Design, develop, and maintain scalable applications and integrations across cloud and on-premises environments
• Build, optimize, and automate workflows using Power Automate to improve business processes
• Develop robust Python applications for data processing, automation, and backend services
• Write efficient SQL queries, stored procedures, and scripts to manage and analyze complex datasets
• Design and implement secure and reliable API integrations between internal and external systems
• Deploy, manage, and monitor applications in Microsoft Azure environments – specifically Function Apps
• Collaborate with cross-functional teams to gather requirements and translate them into technical solutions
• Ensure application security, performance, and scalability best practices are followed
• Provide technical leadership, mentor junior developers, and support peer code reviews
• Stay up to date with emerging technologies and recommend solutions to improve system efficiency
• Other duties as assigned

Knowledge, Skills and Abilities

• Strong hands-on experience with Microsoft Azure services (App Services, Logic Apps, Functions, Azure SQL, etc.). Experience with alerting, Azure data factory, Azure Synapse or equivalent cloud data system such as Redshift or Snowflake. Knowledge of event based data pipelines or functions
• Proven expertise in Power Automate workflow development or automation using an equivalent tool or coding language.
• Experience with Power Apps and dataverse
• Expert in Python for automation, data processing, and backend development. Pyspark and pandas dataframes. Manipulation and loading of structured data using python. Integrations between applications
• Advanced SQL skills, including query optimization and database design. Understanding of data pipelines, slowly changing dimension tables, medallion transformation architecture, transformation ETL layers or databricks or DBT. Building complex stored procedures, views, or other complex datasets. Good understanding of data structure, availability, and scalability
• Experience in RESTful API design, integration, and troubleshooting. Types of API authentication, pagination, change data capture for incremental loads, understanding of throttling and retry logic, translating api calls into data pipelines or automations using python libraries like Requests and Pandas
• Solid understanding of application security, authentication, and authorization standards (OAuth, Azure AD, etc.)
• Experience with Agentic AI platforms such as Copilot Studio or ChatGPT Agent
• Strong problem-solving and analytical skills
• Excellent communication and collaboration abilities
• Experience in overseeing the entire development lifecycle
• Strong ability to work autonomously and move projects forward proactively
• Preferred Skills
• Experience with Git, CI/CD pipelines, Azure DevOps and DevOps best practices

• Familiarity with Power Platform (Power BI, Power Apps)

• Knowledge of containerization (Docker, Kubernetes)

• Optional machine learning, data science, and data exploration experience is a bonus

Requirements:
• Post-secondary education in the field of computer science, information systems, networking, information security, or related discipline
• 5+ years of professional software development experience
• Less than 25% travel to Rea offices

Benefits:
Rea offers a wide variety of benefits to help support our employees' health, wellness and financial goals.

• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Family Leave (Maternity, Paternity)
• Short Term & Long Term Disability
• Training & Development
• Wellness Resources
• Four (4) weeks PTO
• Twelve (12) paid holidays, of which three (3) are floating holidays

Rea does not accept unsolicited resumes from individual recruiters or third-party recruiting agencies without pre-approval from Rea’s Talent team. Pre-approval is required before any external candidate can be submitted. Rea will not be responsible for fees related to unsolicited resumes and for candidates who are sent directly to our hiring managers.