Data Engineer
Job Description
Hoar Construction is seeking a Data Engineer to help design, scale, and support end-to-end data and analytics solutions that enable self-service and analytics initiatives. In this role, you will partner with business teams to convert business questions into automated workflows and reliable, functional data resources.
What you’ll be doing
- Create and maintain an optimal data pipeline architecture.
- Assemble large, complex datasets that align with functional requirements.
- Identify, design, and implement internal process improvements, including automating manual processes, optimizing data delivery, and redesigning infrastructure for scalability.
- Build infrastructure for efficient data extraction, transformation, and loading (ETL) from a range of sources using SQL.
- Create Power Platform objects that support data insertion and data consumption.
- Develop analytics tools that leverage the data pipeline to deliver actionable insights into customer acquisition, operational efficiency, and other key performance metrics.
- Collaborate with stakeholders across the Executive, Product, Data, and Design teams to address data-related technical issues and support data infrastructure needs.
- Maintain data separation and security across boundaries using multiple databases, servers, data centers, and Azure regions.
- Create analytics-focused data tools and support the data architect.
- Build processes that support data transformation, data structures, metadata, dependencies, and workload management.
Key qualifications
- 5+ years of experience in a Data Engineer or similar role.
- Bachelor’s Degree in Computer Science, Information Systems, a related field, or equivalent work experience.
- Advanced working knowledge of SQL, including query authoring and experience with relational databases, plus familiarity with a variety of databases.
- Experience performing root cause analysis on internal and external data and processes to answer business questions and find improvement opportunities.
- Strong analytical skills working with unstructured datasets.
- Strong project management and organizational skills.
- Experience supporting and working with cross-functional teams in a dynamic environment.
- Experience with Power BI, Power Automate, and Power Platform tools.
Technologies
- SQL, Power Platform, Power BI, Power Automate, Azure, and relational databases.
Location and work environment
- Location: Austin, TX (onsite)
- Environment: Primarily a standard office setting with extensive public contact and frequent interruptions.
- Physical demands: Ability to work in an office setting, sit or stand for extended periods, and occasionally stoop, bend, kneel, crouch, reach, and twist. Ability to lift, carry, push, and/or pull light to moderate weight up to 50 lbs. Ability to operate office equipment requiring repetitive hand movement and fine coordination, including use of a computer keyboard. Ability to travel to other locations using various modes of private and commercial transportation.
- Vision: See in the normal visual range with or without correction.
- Hearing: Hear in the normal audio range with or without correction.