Job details

Data Warehouse Engineer

Get a free resume review

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 Data Warehouse Engineer will play a crucial role in designing, implementing, and maintaining our organization's data warehouse infrastructure. This role will contribute to efficient storage, retrieval, and analysis of data, enabling informed decision-making across our clients’ companies. 

Responsibilities

Collaborate with cross-functional teams and clients to understand data requirements and design efficient data warehouse solutions 
Develop and maintain a robust data warehouse architecture that ensures scalability, performance, and data integrity 
Design ETL (Extract, Transform, Load) processes to ingest data from various sources and APIs into the data warehouse 
Design, implement, and optimize ETL workflows to transform raw data into usable formats for analysis 
Ensure data quality and accuracy throughout the ETL process by implementing data validation and cleansing mechanisms 
Monitor and tune the data warehouse performance to ensure optimal query execution and data retrieval times 
Identify and resolve bottlenecks in the ETL pipelines and data warehouse infrastructure 
Develop and maintain data models, including dimensional and star schemas, to support efficient querying and reporting 
Collaborate with data analysts and business stakeholders to understand reporting requirements and translate them into effective data structures 
Implement security measures to protect sensitive data within the data warehouse 
Ensure compliance with data privacy regulations and industry standards 
Work closely with data engineers, analysts, and other stakeholders to understand their data needs and provide necessary support 
Document data warehouse processes, data dictionaries, and ETL workflows for knowledge sharing and future reference

Knowledge, Skills, and Abilities

Strong experience with ETL tools and techniques for data integration
Solid understanding of data modeling concepts, including dimensional modeling and normalization
Familiarity with data security and compliance standards, as well as best practices for maintaining data privacy
Proficiency in scripting languages (e.g., Python, Bash) for automation and data manipulation
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 version control systems (e.g., Git) and agile development methodologies is a plus
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 warehouse solutions using technologies such as SQL databases (e.g., PostgreSQL, MySQL) and cloud-based data warehousing services (e.g., Amazon Redshift, Google BigQuery, Snowflake) 
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.

Average salary estimate

$100000 / YEARLY (est.)

min

max

$80000K

$120000K

If an employer mentions a salary or salary range on their job, we display it as an "Employer Estimate". If a job has no salary data, Rise displays an estimate if available.

What You Should Know About Data Warehouse Engineer, Rea

At Rea & Associates, we're on the lookout for a talented Data Warehouse Engineer who is ready to make a significant impact in a growing Top 100 business advisory and accounting firm. In our vibrant culture, we prioritize a 'People First' philosophy, recognizing that our employees' well-being and professional development are paramount. As a Data Warehouse Engineer, you will play a pivotal role in the design, implementation, and maintenance of our organization's data warehouse infrastructure. Your skills will help streamline the storage, retrieval, and analysis of data, empowering our clients with the insights needed for informed decision-making. You'll collaborate with cross-functional teams to understand detailed data requirements, and your expertise in ETL processes will ensure that data is efficiently transformed and validated. You'll also develop data models and implement security measures, all while maintaining compliance with various regulations. Working at Rea means you'll be part of a team that values work-life balance and competitive compensation, along with a comprehensive benefits package including health care, retirement plans, and generous PTO. If you are passionate about data and eager to contribute to a supportive environment, we would love to hear from you!

Frequently Asked Questions (FAQs) for Data Warehouse Engineer Role at Rea

What are the primary responsibilities of a Data Warehouse Engineer at Rea & Associates?

As a Data Warehouse Engineer at Rea & Associates, your primary responsibilities include designing and maintaining our data warehouse architecture, developing ETL processes to ingest data from various sources, and ensuring data quality and accuracy. You will collaborate with cross-functional teams to understand their data needs and implement solutions that support efficient querying and reporting.