Demo

Senior Business Intelligence Data Engineer

Authority Brands
Columbia, MD Full Time
POSTED ON 3/28/2025
AVAILABLE BEFORE 4/26/2025

Authority Brands, LLC. Headquartered in Columbia, MD 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 provides expert knowledge and elite tools needed to grow a successful franchise business. Our data-driven tools and solutions help Franchise Owner’s optimize their operations efficiency and market profitability.


The Business Intelligence Data Engineer is responsible for development of Enterprise Data Warehouse, Data Mart, and Business Intelligence Reporting environments. BI Data Engineer will be responsible to work on internal, external various data sources and system and integration of those system with business applications.


BI Data Engineers will work closely with technical engineering architects, product owners to design and implement reporting and analytical solutions, including the design and development of table structures and the processes used to populate those structures with data from internal and external sources.


Duties and Responsibilities:

  • Develop ETL processes using SQL, AWS cloud native tools with consideration to fault-tolerance, error logging, auditing and data quality
  • Create data integration and technical solutions using, AWS DB Services and MS SQL Server
  • Data Modeling and Requirements Analysis
  • Prepare storage logical and physical models based on requirements
  • Create end-to-end analytics and reporting solutions
  • Perform complicated analyses to extract learnings and drive insights
  • Perform technical walk-through as needed to communicate design/coded solution and to seek input from team lead and members
  • Implement data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for landing data successfully into the appropriate destinations
  • Work closely with SMEs to provide datasets necessary for experiments and creating analytical models
  • Analyze and profile current data to ensure data qualities
  • Work with quality assurance team to build test plans to validate that new systems meet business requirements
  • Build/automate reports/dashboards (in Power BI and reporting tools) that allow the business leaders to get a clear snapshot of their operations

 

Knowledge, Skills and Abilities:


  • Experience with technical analysis, technology selection process and creating reference architectures
  • Experience in using AWS cloud-based services for data warehousing/analytics; Redshift, RDS, Glue, data pipelines
  • Knowledge of SQL Server Reporting Services and Analysis Services
  • Strong Data Modeling skills to include data quality, source systems analysis, business rules validation, source target, mapping design, performance tuning and high-volume data loads.
  • Sr. level understanding of warehousing architectures including ETL / data pipe design, staging, transformations, delta/change data capture, star-schemas, cubes, and history loading
  • Experience leveraging ETL frameworks to develop scalable solutions. Design and develop code packages, configuration files, stored procedures, tables, views and functions
  • Understand database platform layouts and configurations
  • Experience working in an agile team environment. Understanding of code promotion, code turnover to operations, version control, and QA procedures. Conduct code walkthroughs, peer reviews, and produce technical documentation
  • Strong analytical skills and problem-solving ability, including an expertise in soliciting and interpreting customer business needs and translating them into application and operational requirements
  • Demonstrable strong organizational and critical thinking skills with the ability to prioritize and negotiate with stakeholders
  • Excellent communication skills
  • Demonstrable teamwork and interpersonal skills


Systems and Standards:

  • Completes tasks in a timely manner as instructed by the supervisor.
  • Cooperates with senior management and coworkers to ensure that services can be adequately maintained and meets the needs of internal and external customers
  • Treats clients and associates with courtesy, respect and dignity
  • Interfaces with management and technology support personnel


Qualifications:

  • Bachelor’s degree in Computer Science, Engineering, or equivalent education; Master’s degree, preferred
  • Minimum 10 years of experience with software development leveraging cloud-based technologies
  • 6 years of Data Modeling, Data Warehouse development technologies
  • Experience with technology architecture, solutioning and reference architecture development
  • Demonstrated proficiency with Microsoft Office Suite of products and with Structured Query Language (SQL)
  • Demonstrated ability to write transact-SQL queries
  • Demonstrated ability to interact cross-functionally at all levels internally and externally, and ability to develop relationships with vendors, customers and prospects, when appropriate
  • Ability to quickly learn and effectively leverage operations, enabling technology, processes and other assets
  • Demonstrated negotiation, facilitation and consensus building skills

 

We believe our greatest asset are our employees, we offer competitive salaries and a full benefits package to include, PTO, paid holidays, in office celebrations and more.

 

Authority Brands LLC 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 LLC is an Equal Opportunity Employer

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Senior Business Intelligence Data Engineer?

Sign up to receive alerts about other jobs on the Senior Business Intelligence Data Engineer career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$180,084 - $244,913
Income Estimation: 
$202,391 - $284,225
Income Estimation: 
$71,122 - $96,652
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$92,929 - $122,443
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$122,257 - $154,284
Income Estimation: 
$143,391 - $179,890
Income Estimation: 
$168,522 - $211,152
Income Estimation: 
$189,259 - $248,928
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Authority Brands

Authority Brands
Hired Organization Address Westlake, OH Full Time
Lawn Squad has been proudly serving the local community for over 20 years! Our Lawn Technicians specialize in numerous f...
Authority Brands
Hired Organization Address Marion, OH Full Time
Lawn Technician Columbus, OH 43219, USA Columbus, OH 43220, USA Columbus, OH 43228, USA Columbus, OH 43235, USA Delaware...
Authority Brands
Hired Organization Address Naples, FL Full Time
We are seeking an HVAC Installation Apprentice who will assist in the installation of HVAC systems while providing excep...
Authority Brands
Hired Organization Address Denver, CO Full Time
Authority Brands Inc. headquartered in Columbia, MD is a leading provider of home services, building brands that support...

Not the job you're looking for? Here are some other Senior Business Intelligence Data Engineer jobs in the Columbia, MD area that may be a better fit.

Principal Data Engineer

Blue Health Intelligence(BHI), Baltimore, MD

Business Development and Program Capture - Senior

Boeing Intelligence and Analytics, Annapolis, MD

AI Assistant is available now!

Feel free to start your new journey!