Senior Data Analytics Engineer, Distribution and Marekting
Job Description
Liberty Mutual’s Data Office within Insights & Solutions partners across the organization to define data strategy, deliver data products, and govern data for quality, security, and compliance. On the Distribution & Marketing Data Products team, you’ll help turn emerging needs into reliable, reusable data solutions that support better business decisions.
In this onsite role in Plano, TX, you will translate ambiguous business questions into scalable data products on Snowflake. You’ll prototype and build dependable, maintainable solutions using advanced SQL and Python, with data quality, governance, security, and compliance embedded throughout delivery.
What you’ll do
- Translate ambiguous business needs into scalable data solutions by partnering with Distribution & Marketing stakeholders to analyze data, clarify problems, and define detailed requirements and acceptance criteria.
- Recommend solution approaches that balance business needs, technical feasibility, scalability, and end-user experience.
- Prototype and iterate on complex data challenges by building, testing, and maintaining prototypes and proofs of concept, evaluating viability, performance, and scalability.
- Develop and maintain product-oriented data solutions on Snowflake, refining data models, transformation logic, and documentation.
- Manage competing priorities by aligning customer value, dependencies, and sequencing with product owners and delivery partners.
- Communicate trade-offs and set realistic expectations across audiences.
- Embed data quality controls and incorporate governance, security, and compliance into requirements, testing, and implementation.
- Present findings, progress, risks, and recommendations clearly to business partners, technical teams, and senior leaders.
- Explore emerging technologies and AI-enabled approaches through practical experimentation to assess value and demonstrate impact.
- Provide technical leadership and mentorship by promoting sound development practices and helping junior associates strengthen analytical and technical skills.
What you bring
- Advanced SQL and Python for complex transformations, query optimization, reusable code, and automation.
- Hands-on experience across data solutioning, including modeling, warehousing, and ELT/ETL on cloud platforms, preferably Snowflake, with strong testing, version control, and documentation.
- Strong analytical and problem-solving skills to convert ambiguous needs into clear requirements, hypotheses, prototypes, and scalable recommendations.
- Effective prioritization and communication to manage complex solutions and explain technical concepts across business and engineering teams.
- Knowledge of data quality, governance, privacy, and security practices, plus experience working with data engineers to move prototypes into production.
- Independent execution and technical leadership, including cross-team influence and mentorship.
- Distribution & Marketing domain experience, preferably in property and casualty insurance.
- A bachelor’s degree in a quantitative field and at least 4 years of relevant work experience (typically 6 years).
- A master’s degree and project management experience are preferred.
- Strong written and oral communication skills required.
- Bachelor’s degree preferred in Computer Science, Computer Engineering, or related discipline; Master’s strongly preferred in the same or related disciplines.
- 5-7+ years experience coding for data management, data warehousing, or other data environments including Python, SQL, ETL, Spark, and Snowflake.
- 5-7+ years experience as a developer with top quadrant Business Intelligence tools.
Technologies
- SQL, Python, Snowflake, ELT/ETL, ETL, Spark
Compensation & fair chance notices
Salary: USD 94,000 - 176,000 per year.
Pay philosophy: The typical starting salary range is determined by factors including skills, experience, education, certifications, and location. Some roles may include a corresponding compensation plan that can include commission and/or bonus earnings based on multiple factors set forth in the compensation plan for the role.
Fair chance notices: California; Los Angeles Incorporated; Los Angeles Unincorporated; Philadelphia; San Francisco.