Data Engineer

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.

Th e Data Engineer will play a crucial role in designing, implementing, and maintaining our organization's data platforms. This role will collaborate extensively with business stakeholders to source and manage data from across our organization and may serve client-facing requests as needed. This role involves data integration, pipeline development, automation, and supporting analytics through visualization and self-service tools. 

Responsibilities

• Design, develop, and maintain scalable data pipelines using SQL, Spark (Spark SQL / PySpark) and other technologies to support the organization’s growing data Lakehouse
• Ensure that data platforms are properly architected for scalability, performance, and data integrity. Work cross-functionally to make sure data platforms are properly integrated with other systems
• Design ETL/ELT processes to ingest data from various sources and integrate them into existing data platforms. Work cross-functionally to surface high-quality data for analytics, data visualization, and data science
• Collaborate with internal teams to gather requirements and translate them into technical solutions. Help other members of the organization develop data skills and an understanding of data quality and governance
• Ensure data quality, consistency, security, and compliance across all projects. Monitor and tune data platforms as needed to ensure a high level of service for users
• Create, maintain, and enhance documentation on systems and data products. Ensure that code is properly version controlled and managed as it moves from development to production

Knowledge, Skills, and Abilities

• Highly experienced with ETL/ELT concepts and tools for data integration and management
• Highly experienced with SQL Server, Microsoft Azure, Azure Functions, Azure Storage, Azure Data Factory, Azure Synapse, Azure Databricks, Microsoft Fabric
• Highly experience with API integration techniques and data management
• Highly experienced with SQL, Python, Spark (Spark SQL & PySpark), Git
• Familiarity with other Microsoft data products such as Power BI, Power Automate, Power Platform
• Understanding of data modeling concepts, dimensional modeling, normalization, and medallion architecture
• Understanding of data security, data privacy and their related compliance standards
• Proficiency with Git for source control management and an understanding of CI/CD concepts
• Excellent problem-solving skills and the ability to troubleshoot complex data-related issues  
• Strong communication skills to collaborate with technical and non-technical stakeholders  
• Experience with Machine Learning and Artificial Intelligence a plus 

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field 
• Proven experience (5+ years) as a Data Warehouse Engineer or in a similar role 
• Proficiency in designing and implementing data solutions using technologies such as SQL, Spark, Azure, or other comparable technologies
• Ability to travel to clients as needed

Rea & Associates 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.