Data Analyst/Engineer

Rea & Associates is a growing Top 100 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 offices throughout Ohio, North Carolina and Florida our firm has a culture that respects a work-life balance for our team. We also provide competitive compensation and a robust benefits plan. 

As a Data Analyst/Engineer, you will be responsible for assisting in the development, implementation, and maintenance of data pipelines and reporting systems. You will work closely with our data engineering team to ensure data integrity and availability, supporting various business intelligence and analytics initiatives.

This position is based in Ohio, and candidates must possess the ability to travel to various office locations throughout the state as required.

Key Responsibilities:

• Data Pipeline Development: Assist in building and maintaining data pipelines using Python and SQL to ensure efficient data flow and integration across different systems. ETL of data from on premise SQL databases and cloud hosted API’s.
• Database Management: Collaborate in managing and optimizing on premise and cloud databases to support data processing and retrieval.
• Reporting and Visualization: Utilize Power BI to create and manage interactive dashboards and reports that provide actionable insights to stakeholders. Utilize SQL to write queries as a foundation of the Power BI reports.
• Data Quality Assurance: Monitor and ensure data accuracy, consistency, and quality across all data sources and pipelines.
• Collaboration: Work with cross-functional internal and external teams to understand data needs and provide technical support for data-related queries.
• Documentation: Maintain clear and comprehensive documentation for data processes, pipelines, and reports.

Requirements

• Bachelor’s degree in Computer Science, Data Science, Data Analytics, Finance, Information Technology, or a related field.
• Strong knowledge of SQL for querying and managing relational databases.
• Proficiency in Python preferred for data manipulation and pipeline development.
• Experience with Power BI for creating visualizations and reports.
• Ability to analyze complex data sets and derive meaningful insights.
• Ability to learn new concepts quickly and how to apply them to problems in new and novel ways through training or self-learning.
• Strong problem-solving skills with attention to detail.
• Good verbal and written communication skills, with the ability to present technical information to non-technical stakeholders.
• Ability to work collaboratively in a team environment and contribute to group goals.

Preferred Qualifications:

• Experience with additional data engineering tools or platforms (e.g., Apache Spark, Snowflake, AWS, Azure).
• Familiarity with data warehousing concepts and ETL processes.
• Experience with CI/CD version control systems like Git.
• Experience with Application Programming Interfaces (API’s).
• Previous experience working with external customers is a bonus.
• SSIS, SQL Stored Procedures, Views, query performance tweaking.

Benefits

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 with 3% contribution)
• Life Insurance (Basic, Voluntary & AD&D)
• Family Leave (Maternity, Paternity)
• Short Term & Long Term Disability
• Training & Development
• 'Work From Anywhere' Option
• Wellness Resources
• Four (4) weeks PTO
• Twelve (12) paid holidays, of which three (3) are floating holidays

Rea & Associates, Inc. is committed to providing equal employment opportunity for all individuals regardless of race, color, religion, sex (including without limitation pregnancy, sexual orientation and gender identity), age, ancestry, military status, national origin, genetic information, disability or other characteristics protected by applicable law. Equal opportunity extends to all aspects of the employment relationship, including but not limited to hiring, transfers, promotions, training, and terminations, working conditions, compensation, benefits, and other terms, conditions or privileges of employment, or any matter directly or indirectly related to employment.

Rea & Associates 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 & Associates will not be responsible for fees related to unsolicited resumes and for candidates who are sent directly to our hiring managers.