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
Artificial Intelligence • Cloud • Consumer Web • Productivity • Software • App development • Data Privacy
Provides high-level executive administrative support to Dropbox’s Chief Business Officer, managing complex calendars, domestic and international travel, meeting preparation, communications, events, expenses, and follow-through. Partners closely with the Chief of Staff and executive offices to prioritize work, surface risks, coordinate leadership activities, and improve operating systems. Requires exceptional judgment, organization, communication, adaptability, and accuracy in a fast-changing environment.
Top Skills:
Ai ToolingConcurDropboxGmailGoogle DocsNavanSlack
Fintech • Financial Services
Leads software quality engineering across digital banking products by designing scalable automated tests, expanding frameworks, integrating testing into CI/CD, analyzing defects, and closing testing gaps. Partners with engineering and product teams on quality strategy, reviews automation code, mentors SDETs and QA professionals, leads testing teams, supports bug triage, and establishes consistent testing standards across multiple product areas.
Top Skills:
C#Ci/CdGherkinGitGit FlowJavaScriptJestMochaMstestNunitPlaywrightPuppeteerPytestPythonSeleniumSpecflowSQLTrunk-Based DevelopmentTypescriptUnittestWindowsXunit
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Leads a team of approximately eight Account Executives serving mid-market public-sector organizations. Responsibilities include coaching sales strategy, reviewing pipelines, achieving quarterly targets, hiring and onboarding, developing training content, managing performance plans, providing feedback, forecasting pipeline, and collaborating cross-functionally. The manager will also foster an inclusive, high-performing team culture and support complex sales cycles involving multiple decision-makers and products.
Top Skills:
GongInternet Of Things (Iot)SalesloftSFDC
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
