About AVB:

AVB is a fast-growing, stable company that has a firm mission to do whatever it takes to keep our members profitably in business. Our vision is to deliver best in class growth solutions and service fueled by a passionate mission belief, innovation, and an unwavering commitment to doing what is right for our members, organization, and team members. AVB has an experienced development team, smart strategy team, bright and creative designers, along with the rest of our dream team of enthusiastic, entrepreneurial minded individuals who want to help drive the success of our members!

We offer competitive salaries, full benefits, a flexible remote work environment, an employee reimbursement program to support enriching your life, EAP, employee discounts, a WFH stipend, an annual allowance for AVB apparel, 401k options, a robust sick time policy, and 5 Floating Holidays per year, along with a minimum of 10 days of vacation time that starts accruing from your first day.

In addition, from time to time, our team members will be required to engage in travel to attend AVB’s Annual All-Employee Meeting, as well as other travel obligations which may be required of the position- such as meetings with members, attendance at conventions, and other events, where you will represent AVB! 

We are always looking for smart, resourceful, and dynamic people to join the team, so if you are looking for a company that will welcome you, collaborate with you, challenge you, and help develop your skills to the next level- then we are looking for you! We are geared up for growth, are you ready to grow with us?

Home - AVB Marketing

Position Summary/Objective:

The Business Intelligence Data Engineer is part of an analytics team focused on building and maintaining systems that collect, manage, and transform data with the goal of driving decision making and supporting expanded data programs, services, process optimization and advanced business intelligence. The incumbent will be the project owner of AVB’s data warehouse. Additionally, this role is responsible for developing processes and strategies for maintaining and assuring data quality from external sources.

Essential Functions and Responsibilities:

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.

·         Responsible for developing and maintaining data pipelines that support and enable the overall strategy of expanded data programs, services, process optimization and advanced business intelligence

·         Leading data discovery sessions with business teams, comprising product owners, data analysts, and cross-team technologists to understand data requirements of analytics projects

·         Partner with business domain experts, system analysts, data/application architects, and development teams to ensure data design is aligned with business strategy and direction

·         Identify and document methodologies, standards, and architecture guidelines

·         Architect and Design Data models

·         Utilize SQL to create, transform, and investigate data sources and models

·         Work to automate ELT processes including extraction from various sources (API, Flat files, etc..)

·         Dive deep, as required, to assist Business Intelligence Engineers through technical hurdles impacting delivery

Required Skills and Abilities:

·         Thorough understanding of best practices related to data management including database architecture and data warehousing

·         Experience in custom ELT design, implementation, and maintenance

·         Hands on experience designing and working with relational databases – specifically MSSQL, MySQL, and BigQuery/RedShift

·         Familiarity working with/on servers (mostly SQL, Web, and FTP)

·         Knowledge of programming languages (e.g. Python and Object Oriented Programming)

·         Strong knowledge and experience with CI/CD processes and Agile/Scrum methodology and iterative practices in a service delivery lifecycle

·         Experience with internal development and source control tools including git/GitHub, Visual Studio, Agile, and JIRA

·         Excellent communication and interpersonal skills with a demonstrated ability to influence a large organization

·         Passionate about data solutions, technologies, and frameworks

Education and Experience:

·         5+ years of technical experience related to data architecture such as data analysis, data modeling, and data integration.

·         3+ years of experience with SQL and at least one programming language: Python, JavaScript, PowerShell, and/or other languages

·         3+ Experience with BigQuery, RedShift, SQL Server, MySQL

·         Bachelor’s degree in Computer Science, Information Systems, or related field

Physical Requirements:

·         Prolonged period of sitting at a desk and working on a computer.

·         Must be able to lift up to 15 pounds at times.