Leads a multi-year migration from Amazon Redshift to Databricks on AWS, designs Medallion architecture and data models, develops SQL and Python ETL pipelines, and establishes data quality and governance standards. Manages 4–5 data engineers and Power BI developers while partnering with stakeholders to support trusted reporting and analytics. The role requires hands-on architecture and engineering, technical leadership, LLM-enabled workflow development, and clear communication across technical and non-technical teams.
Authority Brands Inc. is a leading provider of home services, building brands that support the success of our franchisees, as well as bettering the lives of the homeowners we serve and the people we employ.
Authority Brands is seeking a highly skilled principal data architect with 10+ years of relevant experience to lead a data analytics platform migration from Redshift to Databricks and lead a small team (4-5 direct reports) of data engineers & Power BI developers. This will be a muiti-year transformation and hands on experience is required to build out the Medallion architecture.
Key Responsibilities:
- Lead analytics platform migration in AWS from Redshift environment (S3, RDS, Lambda, Glue) to new Databricks environment.
- Design, build, and optimize logical data model and stand up bronze, silver and gold semantic layer in Databricks.
- Develop and optimize complex SQL and Python‑based ETL processes across AWS service
- Own data modeling and schema design to support analytics, reporting, and downstream use cases.
- Partner with cross‑functional teams to understand data requirements and deliver well‑governed solutions.
- Establish and uphold data quality, validation, and documentation standards across pipelines and datasets.
- Monitor pipeline performance and proactively identify opportunities to improve reliability, scalability, and efficiency.
- Communicate technical concepts and data tradeoffs clearly to both technical and non‑technical stakeholders.
- Support the enablement of metrics, dashboards, and reporting by providing well‑modeled, trusted data foundations.
Qualifications:
- Bachelor’s degree in Computer Science, Engineering, or a related field. Graduate degree in similar domain preferred.
- 10+ years of experience in data architecture & engineering or a closely related role.
- Strong SQL expertise and experience working with large datasets.
- Proficiency in Python for ETL, automation, and data pipeline development.
- Hands‑on experience with Databricks and Redshift environments within AWS data services
- Experience with data modeling, version control (Git), and CI/CD practices.
- Hands‑on experience leveraging LLMs such as Claude for accelerating data engineering workflows, including code generation, ETL transformations, test creation, schema documentation, and troubleshooting.
- Strong understanding of prompt design and model constraints within enterprise security guidelines
- Strong problem‑solving skills and ability to work independently in a fast‑moving environment.
- Excellent communication skills and comfort collaborating with cross‑functional partners.
We believe our greatest assets are our employees, we offer competitive salaries and a full benefits package to include, PTO, paid holidays, 401(k) and more.
Authority Brands Inc. conducts drug screens and background checks on applicants who accept employment offers. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions however we do not sponsor Visa’s at this time.
Authority Brands Inc. is an Equal Opportunity Employer
Similar Jobs
AdTech • Digital Media • Marketing Tech • Software • Automation
Develops and presents integrated media strategies for brand and agency clients, oversees media planning quality, negotiates vendor inventory and pricing, manages insertion orders and campaign budgets, and ensures KPI delivery. Partners with research, analytics, ad operations, finance, and sales teams to execute campaigns, resolve issues, improve client satisfaction, and retain accounts. Mentors junior planners and provides clients with insights on digital advertising trends and innovation.
Top Skills:
DatoramaDemand-Side Platforms (Dsps)Digital MediaMedia Planning ToolsExcelMicrosoft PowerpointProgrammatic MediaReal-Time BiddingSyndicated Research ToolsThird-Party Ad Servers
Artificial Intelligence • Consumer Web • Edtech • HR Tech • Information Technology • Software • Conversational AI
Manage strategic customer accounts after purchase, driving onboarding, adoption, retention, expansion, and renewal. Advise learning leaders on digital learning strategies, establish success metrics, conduct business reviews, monitor account health, mitigate churn risk, resolve issues, and identify upsell opportunities. Collaborate with account executives and internal teams while demonstrating product value and supporting organizational upskilling initiatives.
Top Skills:
ChurnzeroExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft WordSalesforce CRM
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Monitor and respond to real-time security alerts across endpoint, identity, email, and cloud environments. The analyst communicates with customers, investigates EDR telemetry, logs, forensic artifacts, Microsoft 365 threats, BEC, and AITM attacks, and provides remediation guidance. The role also supports incident detection processes and countermeasures while developing cybersecurity, systems administration, network analysis, scripting, and AI-assisted security operations skills. Candidates must work a hybrid 4x10 schedule, including one weekend day.
Top Skills:
Active DirectoryAi ModelsBashEdrLinuxmacOSMicrosoft 365Microsoft Entra IdMitre Att&CkNg-SiemOktaPowershellPrompt EngineeringPythonWindows
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
