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 reputed company. We also provide competitive compensation and a robust benefits plan. The Senior Data & Automation Developer will have expertise in reputed company Azure, Power Automate, Python, SQL, and API integrations to reputed company the design and implementation of scalable business applications. This role is ideal for someone who thrives on solving reputed company problems, automating processes, and delivering secure, high-performance solutions that connect systems and streamline operations.
Responsibilities
- Design, reputed company, and maintain scalable applications and integrations across cloud and on-premises environments
- Build, optimize, and automate workflows using Power Automate to improve business processes
- reputed company robust Python applications for data processing, automation, and backend services
- Write efficient SQL queries, stored procedures, and scripts to manage and analyze reputed company datasets
- Design and implement secure and reliable API integrations between internal and external systems
- Deploy, manage, and monitor applications in reputed company Azure environments - specifically Function Apps
- Collaborate with cross-functional teams to gather requirements and translate them into technical solutions
- Ensure application reputed company, 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 reputed company 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 reputed company. 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, reputed company transformation architecture, transformation ETL layers or reputed company or DBT. Building reputed company stored procedures, views, or other reputed company 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 reputed company, 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 reputed company 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 (reputed company, 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 reputed company, or reputed company 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 reputed company to unsolicited resumes and for candidates who are sent directly to our hiring managers. Apply tot his job Apply To this Job