Lead Data Analytics Engineer
Transamerica8 days ago
Philadelphia, PA, USA or Denver, CO, USAStaff+
Base Salary
$120k - $1300k/yr
Responsibilities
- Lead the design, development, implementation, and support of enterprise analytics, reporting, dashboard, and data solutions.
- Partner with business and technology stakeholders to gather requirements and deliver data-driven insights.
- Analyze complex datasets to identify trends, risks, and opportunities and translate findings into recommendations.
- Design, develop, and optimize SQL queries, data transformations, and analytical datasets.
- Create and maintain scalable data models, Power BI reports, dashboards, and enterprise reporting solutions.
- Develop and support SSRS, cloud analytics platforms, and reporting environments using AWS Athena, Snowflake, and Microsoft Fabric.
- Collaborate with data architecture and engineering teams to improve data pipelines, warehouses, cloud platforms, and reporting frameworks.
- Establish standards for data governance, quality, security, validation, performance, and reporting best practices.
- Troubleshoot complex data and reporting issues and improve accuracy, reliability, efficiency, and scalability.
- Provide technical leadership, design oversight, mentorship, and guidance for analytics modernization, cloud migration, and continuous improvement initiatives.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent professional experience.
- At least 7 years of experience in data analytics, business intelligence, data engineering, reporting, or a related discipline.
- Advanced experience developing and optimizing SQL queries and working with Microsoft SQL Server.
- Experience developing and supporting enterprise reporting solutions with SQL Server Reporting Services and Power BI.
- Experience with data modeling, data warehousing, data transformation, and data integration.
- Experience with AWS Athena and Snowflake.
- Experience with Microsoft Fabric, including pipelines, OneLake, and data synchronization optimization.
- Experience leading analytics, reporting, or data engineering initiatives from design through implementation.
- Strong analytical, problem-solving, stakeholder management, and communication skills.
- Preferred qualifications include enterprise-scale analytics and reporting experience, data governance and quality experience, ETL and ELT development knowledge, cloud-native analytics architecture experience, mentoring experience, relevant Microsoft, AWS, Snowflake, or analytics certifications, and experience leading cross-functional initiatives.
Benefits
- Hybrid office environment with in-office work Tuesday through Thursday; locations include Cedar Rapids, Denver, and Philadelphia.
- Competitive pay and eligible employee bonuses.
- Pension plan, 401(k) match, and employee stock purchase plan.
- Tuition reimbursement, career training and development, employee discounts, and referral bonus programs.
- Medical, dental, vision, disability, and employee assistance benefits.
- Paid time off starting at 160 hours annually in the first year and ten paid holidays per year.
- Wellness coaching and reward dollars through the Be Well program.
- Paid parental leave of fifteen days per calendar year for eligible employees with at least one year of service, plus adoption assistance and backup care.
- Volunteer PTO, matching gifts, employee resource groups, inclusion and diversity programs, and employee recognition programs.
About Transamerica
Transamerica provides insurance, retirement, and investment products to individuals, employers, and financial professionals in the U.S. Offerings include life insurance, annuities, workplace retirement plans, and investment solutions distributed through agents, advisors, and employer channels. Founded in 1904 and headquartered in Baltimore, it operates as a subsidiary of Aegon and supports millions of customers nationwide.