Data Engineer

Hoar; Birmingham (AL); On-site; USD 95,000 - 130,000; Full time

Job summary

Hoar is seeking a Data Engineer to design and scale end-to-end data and analytics solutions that empower self-service analytics. You will partner with business teams to translate problems into automated, scalable data resources and support across the organization.

The role emphasizes building robust ETL pipelines using SQL, enabling cross-functional data access, and ensuring data security across multiple databases and Azure regions.

Qualifications

• 5+ years in Data Engineer or similar role.
• Bachelor's degree in CS, Information Systems or related field, or equivalent experience.
• Advanced SQL knowledge and experience with relational databases and query authoring.
• Experience with Power Platform tools for data insertion and consumption.
• Ability to translate business problems into automated data processes.

Responsibilities

• Create and maintain optimal data pipeline architecture.
• Assemble large, complex data sets to meet functional requirements.
• Identify and implement internal process improvements for data delivery and scalability.
• Build infrastructure for ETL using SQL across diverse data sources.
• Create Power Platform objects for data insert and consumption.
• Develop analytics tools that harness the data pipeline for insights into key metrics.
• Collaborate with executives, product, data and design teams on data infrastructure needs.
• Maintain data separation and security across databases, servers and Azure regions.
• Create data tools to support analytics and data architecture.
• Build processes for data transformation, structures, metadata, dependencies, and workload management.

Skills

SQL

Analytical

Data analysis

Project management

Cross-functional work

Education

Bachelor's degree in CS/IS or related field

Tools

Power BI

Power Automate

Power Platform

Azure data services

Job description

The Data Engineer role is responsible for developing and scaling end-to-end data and analytics solutions that enable self-service and analytics efforts. This role will work with key business partners across the organization to understand business problems and translate them into automated processes and functional data resources.

Responsibilities

• Create and maintain optimal data pipeline architecture.
• Assemble large, complex data sets that meet functional requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL.
• Create Power Platform objects for data insert and data consumption.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep our data separated and secure across boundaries through multiple databases, servers, data centers, and Azure regions.
• Create data tools for analytics and support the data architect.
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.

Requirements

• 5+ years in Data Engineer or similar role
• A Bachelor's Degree in CS, Information Systems, a related field or equivalent work experience
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to 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.

Physical Demands and Working Environment

The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.

Environment: Work is performed primarily in a standard office environment with extensive public contact and frequent interruptions.

Physical: Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight 50 lbs; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; to travel to other locations using various modes of private and commercial transportation; and to verbally communicate to exchange information.

Vision: See in the normal visual range with or without correction.

Hearing: Hear in the normal audio range with or without correction.

EOE - Vets/Disabilities