Let’s get started
By clicking ‘Next’, I agree to the Terms of Service
and Privacy Policy
Jobs / Job page
Data Warehouse Engineer image - Rise Careers
Job details

Data Warehouse 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.

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.

Similar Jobs
Posted 10 days ago
Photo of the Rise User
Fandom Remote New York City (Remote)
Posted yesterday
Inclusive & Diverse
Friends Outside of Work
Collaboration over Competition
Empathetic
Dental Insurance
Disability Insurance
Flexible Spending Account (FSA)
Health Savings Account (HSA)
Vision Insurance
Family Medical Leave
Paid Holidays
401K Matching
Learning & Development
Flex-Friendly
Weekday AI Remote No location specified
Posted 2 days ago
Photo of the Rise User
Red Gate Group Hybrid Chantilly, VA, USA
Posted 7 days ago
Photo of the Rise User
Posted yesterday
Welcome Tomorrow Remote No location specified
Posted 13 days ago
Photo of the Rise User
Experian Remote 80 Victoria St, London SW1E 5JL, UK
Posted 3 days ago
Photo of the Rise User
Pinterest Hybrid San Francisco, CA, US; Seattle, WA, US
Posted 3 days ago

Research and Education Association (REA), founded in 1959 and based in Piscataway, New Jersey, publishes test preparation and study guide books and software for high school, college, graduate students, and professionals. REA products are sold in m...

18 jobs
MATCH
VIEW MATCH
FUNDING
DEPARTMENTS
SENIORITY LEVEL REQUIREMENT
TEAM SIZE
EMPLOYMENT TYPE
Full-time, hybrid
DATE POSTED
April 16, 2025

Subscribe to Rise newsletter

Risa star 🔮 Hi, I'm Risa! Your AI
Career Copilot
Want to see a list of jobs tailored to
you, just ask me below!