<p>About Us: Authority Brands is a leading provider of home service franchises, dedicated to supporting franchise owners with elite marketing, advanced technology, and strong operational support. Founded in 2017, Authority Brands has grown to include 15 industry-leading home service franchisors, providing a wide range of services from plumbing and electrical work to lawn care and pest control.</p> <p>Mission: Our mission is to empower franchise owners to succeed by offering best-in-class training, operational support, and marketing systems. We aim to deliver exceptional home services that customers trust and rely on.</p> <p>Culture: At Authority Brands, we foster a collaborative and supportive work environment where innovation and excellence are encouraged. We believe in the power of teamwork and are committed to helping our franchise owners achieve their personal and professional goals.</p> <p>Job Overview: The Data Analytics team at Authority Brands is seeking a skilled Data Engineer with at least 4 years of experience, strong SQL expertise, Python programming skills, and hands-on experience with AWS, including AWS Glue. You will collaborate with our data analytics and development teams to build, maintain, and optimize our data pipelines and infrastructure. We are looking for a candidate who enjoys solving complex data challenges and is eager to contribute to a dynamic team.</p> <p>Key Responsibilities:</p> <ul> <li>Develop and optimize complex SQL queries to ensure efficient data retrieval, manipulation, and reporting. </li><li>Collaborate with data analysts, data scientists, and cross-functional teams to understand their data requirements and deliver solutions. </li><li>Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions. </li><li>Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation. </li><li>Analyze and solve problems at their root, stepping back to understand the broader context in a timely manner. </li><li>Design, build, and maintain efficient and reliable data pipelines that support the company's data platform. </li><li>Leverage Python for ETL processes, automation scripts, and data pipeline development. </li><li>Utilize AWS services, including S3, RDS, Redshift, Lambda, and AWS Glue, to design and maintain cloud-based data infrastructure. </li><li>Work with AWS Glue for ETL transformations, data cataloging, and automation of data processes. </li><li>Monitor and improve the performance of data pipelines and data processing systems. </li></ul> <p>Qualifications:</p> <ul> <li>Bachelor's degree in Computer Science, Engineering, or a related field. </li><li>Minimum of 4 years of experience in data engineering or a related role. </li><li>Strong proficiency in SQL for querying, optimizing, and managing large datasets. </li><li>Experience with data modeling and schema design. </li><li>Solid programming skills in Python, with experience in building and optimizing ETL pipelines. </li><li>Hands-on experience with AWS cloud services, including data-related tools such as S3, Redshift, RDS, Lambda, and AWS Glue. </li><li>Familiarity with version control (e.g., Git), CI/CD pipelines, and agile methodologies. </li><li>Experience working with large datasets and building scalable solutions. </li><li>Strong problem-solving skills and ability to work independently or within a team. </li><li>Excellent communication skills with the ability to explain technical concepts to non-technical stakeholders. </li></ul>