Analytics Engineer
By joining AAA Life, you will have the opportunity to strengthen the name and reputation of the brand that millions have come to rely upon for financial piece of mind. We are company dedicated to our members and our employees. We value the unique attributes and contributions of our associates to build an inclusive, collaborative and innovative workplace where all employees are engaged and feel they belong. Delivering our company’s promise to members is what drives each of our associates every day.
We offer a dynamic work environment, excellent benefits, and competitive compensation, that will allow you will exercise your potential to innovate, finding ways to increase efficiency and enhance our business processes.
What you will do
Do you have experience building and maintaining data infrastructures? AAA Life is looking for creative, collaborative, and curious Analytics Engineer design data architecture to facilitate analysis and ensure best-in-class operational reliability using data modeling, including modularity, best practices.
NOTE: This position may be done in office or remote.
Position Responsibilities
- Designing, building, and maintaining critical data models and dashboards to ensure highly accurate and reliable business reporting.
- Collaborating with stakeholders to understand their data requirements and ensure that data solutions meet their needs.
- Monitoring daily job execution as well as diagnosing/fixing issues within our data platform to ensure SLAs are met with internal stakeholders.
- Writing and maintaining scalable, efficient, and maintainable SQL, Jinja, and Python code for data analysis, transformation, and visualization.
- Creating and maintaining CI/CD pipelines using dbt and GitHub actions.
- Identify gaps in our data collection capabilities and collaborate with product and engineering on data capture specifications.
- Designing and implementing data visualization dashboards and reports using Power BI.
** For the states of California, Colorado, New York and Washington the pay scale is $79,403.00 to $119,105.00 and pay scales may vary based upon location.*
Required Experience
Required Education/Experience
- BS degree in Engineering, Computer Science, Math or a related technical field.
- 2+ years’ experience in an analytics engineering, data engineering, business intelligence, or data analyst role.
- Our ideal candidate will have expertise with SQL or dbt, including modeling and transforming data.
- Dimensional Modeling experience utilizing Kimball or Inmon principals like star schema, snowflake, data vault, fact and dimension tables.
- Proficiency in Python including the Pandas and Numpy libraries.
- Expertise with version control software like Git and the ability to participate in code reviews with peers.
- Ability to leverage tools, business intuition, and attention to detail for data validation, QA, and technical documentation.
- Experience with data visualization tools such as Looker, Tableau, or Power BI.
- Familiarity with a cloud data warehouse like Redshift, Snowflake, or Big Query a plus