Senior Business Intelligence Data Engineer

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