Senior Analytics Engineer

Overview:

AAA Life Insurance Company is looking for a Senior Analytics Engineer to build and maintain data infrastructure essential to AAA Life’s business intelligence, data governance and operational reporting efforts. You will support data processes from end-to-end, including data ingestion, transformation, and visualization, and design data architecture to facilitate analysis and ensure best-in-class operational reliability and modularity.

The ideal candidate will have experience with Data Build Tool (DBT) and other data analytics tools, as well as a strong background in data engineering and data modeling. This individual will be responsible for designing, developing, and maintaining data pipelines and analytical data models, as well as supporting and optimizing our data infrastructure. The Senior Analytics Engineer will be expected to provide leadership and/or mentorship for junior staff.

Responsibilities:

Translate business needs into ETL and report requirements, as well as provide expert advice and education in the usage and interpretation of data.

Ability to diagram complex technical processes and translate abstract problems into discrete technology actions.

Design and implement data pipelines with DBT, Python, and GitHub using software and data engineering best practices to ensure that data is accurate, reliable, and timely.

Enhance development and implementation environments by implementing new and custom DBT libraries, and writing/modifying Python and shell scripts.

Monitor daily job execution and fix issues as they arise to ensure SLAs are met with internal stakeholders.

Enhance data warehouse design using data modeling best practices and identify gaps in our data collection capabilities.

Collaborate with product and engineering, governance, and security on requirements for data capture, retention, and security.

Develop reports and dashboards using to answer key business questions clearly, accurately, and with minimal latency.

Work with Cloud Engineering to configure docker images.

Coordinate with Data Platform Engineering team, Enterprise Data Analyst Team, Data Governance Team, and IT Teams to align with change management processes and to ensure performance, processes and access is optimal for our reporting solutions.

Qualifications:

Bachelor’s degree in Engineering, Computer Science, Math or a related technical field required.

A minimum of 7 years experience in data engineering and analytics, with a focus on ETL development, data modeling, and data analysis.

Expertise in SQL and ETL optimization techniques, especially within cloud-based data warehouses like Snowflake, BigQuery, and Redshift, as well as use of command line and version control software (git).

Experience with cloud-based data storage solutions such as AWS S3, Azure Blob Storage, or Google Cloud Storage.

Proficiency in Python including the Pandas and Numpy libraries.

Ability to leverage tools, business intuition, and attention to detail for data validation and QA.

Excellent communication skills, particularly when explaining technical or complex matters to less technical co-workers.

A high degree of motivation to be proactive and go above and beyond the task at hand.

Understanding of major marketing channels, such as TV, direct mail, social media, search.

Familiarity with data schemas and logging of common marketing platforms, such as Salesforce, Adobe Campaign, and Google Analytics.

Experience mentoring and guiding junior data engineers and analysts.

WHAT WE OFFER:

A collaborative, energetic work environment where you can put your passion for people to work

Medical, Dental, Vision, Life and Disability coverage available day one

Pension Plan

Performance-based incentive plan

401k available with a Company match

Holidays and Paid Time Off

AAA Basic Membership

Compensation Disclaimer (Text Only):

For the states of California, Colorado, New York and Washington the pay scale is $115,218 to $172,826 and pay scales may vary based upon location.

Permanent