What are the responsibilities and job description for the Data Warehouse Engineer position at Kimley-Horn?
Overview
We are seeking a Data Engineer to join our Raleigh, NC team to develop scalable data warehouse solutions, integrate new systems with existing infrastructure, and align data solutions with business objectives. The ideal candidate will have the ability to analyze business requirements, see the "bigger picture" of data needs, and develop strategic plans for data management. The role requires adaptability to evolving technologies and business requirements. Strong collaboration skills and a strategic mindset are essential.
Responsibilities
- Create and optimize data models and structures for the warehouse to ensure efficient data storage and retrieval.
- Implement and manage Extract, Transform, and Load (ETL) processes to move data from various sources into the warehouse.
- Ensure the accuracy, integrity, and security of data within the warehouse, establishing policies and auditing regularly.
- Monitor and optimize database and system performance, troubleshooting issues to ensure efficiency.
- Document technical designs, workflows, and best practices to facilitate knowledge sharing and maintain system documentation.
- Provide technical guidance and support to team members.
Qualifications
- Certification in SQL, BI, or related areas (e.g., Microsoft Certified: Azure Data Engineer Associate, CBIP).
- Experience with cloud-based BI and data solutions (e.g., AWS, Azure).
- Experience with SSIS and Azure Data Factory
- Familiarity with programmatic data analysis tools (e.g., Python, R) is a plus.
- Experience with relational database design and development a plus, Oracle and SQL Server ideal.
- Bachelors degree in Computer Science or related field
- 5-10 years of experience
Why Kimley-Horn?
At Kimley-Horn, we do things differently. People, clients, and employees are at the forefront of who we are. Clients know we prioritize achieving their goals and growing their success. Employees know our culture and approach to business are built on a desire to provide an environment for everyone to flourish. Our commitment to quality is only as good as the people behind it— that’s why we welcome and develop passionate, hardworking, and proactive employees. We take pride in how our employee retention, robust benefits package, and company values have led to Kimley-Horn’s placement on the Fortune “100 Best Companies to Work” list for 18 years!
Key Benefits at Kimley-Horn
- Exceptional Retirement Plan: 2-to1- company match on up to 4% of eligible compensation (salary bonus) and additional profit-sharing contribution.
- Comprehensive Health Coverage: Low-cost medical, dental, and vision insurance options.
- Time Off: Personal leave, flexible scheduling, floating holidays, and half-day Fridays.
- Financial Wellness: Student loan matching in our 401(k), and performance-based bonuses.
- Professional Development: Tuition reimbursement and extensive internal training programs.
- Family-Friendly Benefits: New Parent Leave, family building benefits, and childcare resources.