AAA Life is seeking an Analytics Engineer to add to our team! You will be responsible for building and maintaining data infrastructure essential to AAA Life’s business intelligence, data governance and operational reporting efforts. You will also support data processes from end-to-end, including data ingestion, transformation, visualization, and design data architecture to facilitate analysis and ensure best-in-class operational reliability and modularity.

POSITION RESPONSIBILITIES

• Understand business context and translate stakeholder needs into ETL and dashboard requirements.
• Design, build, and maintain critical data pipelines and dashboards to ensure highly accurate and reliable business reporting.
• Monitor daily job execution as well as diagnose/fix issues to ensure SLAs are met with internal stakeholders.
• Identify data discrepancies and maintain transparent and up-to-date code to ensure business requirements and ETL logic match.
• Make data model and ETL code improvements to improve pipeline efficiency and data quality
• Identify gaps in our data collection capabilities and collaborate with product and engineering on data capture specifications.
• Build and extend CRUD applications to enable data capture.

Required Skills

• USES EFFECTIVE COMMUNICATION SKILLS - Candid, clear and concise in communication. Effectively matches style, tone and method to audience.  Connects with intended audience.  Manages communication and feedback within the organization.
• TECHNICAL/PROFESSIONAL SKILLS - Hold self and others to high standards. Strives to stay ahead of technical/professional expertise, is proactive and inspires others to stay current in areas of technical expertise.
• ACHIEVES RESULTS/HAS BIAS FOR ACTION - Achieves stretch results. Strong bias for action with sense of urgency and high energy.  Practices collaborative working environment to achieve more.
• CUSTOMER FOCUS - Has ability to look from customer’s view. Viewed as business partner by external and internal customers.  Anticipates customer needs to ensure no barriers to doing business.
• STRATEGIC EFFECTIVENESS – Demonstrates an organization-wide perspective and creates a shared vision and purpose.
• BUSINESS MANAGEMENT – Demonstrates sound business principles and planning processes, and defines and measures results.

Required Experience

• 2+ years’ experience in a data engineering, business intelligence, or technical data analytics role.

• 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).

• Proficiency in Python including the Pandas and Numpy libraries.

• Proficiency in using JavaScript to tag websites for analytics.

• Expertise in data pipeline management technologies with dependency checking, such as Airflow, as well as schema design and dimensional data modeling.

• 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.

• BS degree in Engineering, Computer Science, Math or a related technical field.

• 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 with data ingestion tools such as Fivetran, Stitch, Talend or Matillion.

• USES EFFECTIVE COMMUNICATION SKILLS - Candid, clear and concise in communication. Effectively matches style, tone and method to audience.  Connects with intended audience.  Manages communication and feedback within the organization.
• TECHNICAL/PROFESSIONAL SKILLS - Hold self and others to high standards. Strives to stay ahead of technical/professional expertise, is proactive and inspires others to stay current in areas of technical expertise.
• ACHIEVES RESULTS/HAS BIAS FOR ACTION - Achieves stretch results. Strong bias for action with sense of urgency and high energy.  Practices collaborative working environment to achieve more.
• CUSTOMER FOCUS - Has ability to look from customer’s view. Viewed as business partner by external and internal customers.  Anticipates customer needs to ensure no barriers to doing business.
• STRATEGIC EFFECTIVENESS – Demonstrates an organization-wide perspective and creates a shared vision and purpose.
• BUSINESS MANAGEMENT – Demonstrates sound business principles and planning processes, and defines and measures results.