Data Engineer
Job Description
Hoar Construction is hiring an onsite Data Engineer in Austin, TX to help build and scale end-to-end data and analytics solutions for self-service and analytics initiatives. In this role, you will partner with business teams to turn business problems into automated processes and functional data resources, with a focus on reliable pipelines, secure data foundations, and analytics that support key business decisions.
What You’ll Do
- Create and maintain data pipeline architecture designed for optimal performance and maintainability.
- Assemble large, complex datasets that meet functional requirements.
- Identify and implement internal improvements such as automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.
- Build ETL infrastructure to extract, transform, and load data from a wide range of sources using SQL.
- Create Power Platform objects that support data insertion and data consumption.
- Develop analytics tools that use the data pipeline to deliver actionable insights for customer acquisition, operational efficiency, and other performance metrics.
- Collaborate with stakeholders including the Executive, Product, Data, and Design teams to resolve data-related technical issues and support data infrastructure needs.
- Ensure data separation and security across boundaries using multiple databases, servers, data centers, and Azure regions.
- Create analytics-focused data tools and provide support to the data architect.
- Build processes for data transformation, data structures, metadata, dependency, and workload management.
What You Bring
- 5+ years in Data Engineering or a similar role.
- A Bachelor’s Degree in CS, Information Systems, a related field, or equivalent work experience.
- Advanced SQL skills and experience with relational databases, including query authoring.
- Working familiarity with a variety of databases.
- Experience performing root cause analysis on internal and external data and processes to address business questions and identify improvement opportunities.
- Strong analytic skills with unstructured datasets.
- Project management and organizational skills.
- Experience supporting 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
- Relational databases
Working Environment
- Environment: Standard office environment with extensive public contact and frequent interruptions.
- Physical: Ability to perform office-based work, including standing/sitting for prolonged periods; occasionally stoop, bend, kneel, crouch, reach, and twist; lift/carry/push/pull light to moderate weight up to 50 lbs; operate office equipment requiring repetitive hand movement and fine coordination (computer keyboard); 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.