Lead Data Analytics Engineer

Transamerica•Cedar Rapids, IA

1d•$120,000 - $1,300,000•Hybrid

About The Position

Provides technical leadership in the design, development, and delivery of enterprise analytics and reporting solutions. Partners with business and technology teams to translate complex data and reporting needs into scalable data models, dashboards, and reporting solutions. Establishes analytics standards, improves data quality and reporting processes, and serves as a technical resource for modern cloud data and visualization technologies. The role leads analytics modernization, cloud migration, and continuous improvement initiatives, and works with stakeholders and data architecture and engineering teams to improve enterprise data and reporting capabilities. The position is based in an office environment with a hybrid schedule of Tuesday, Wednesday, and Thursday, in Cedar Rapids, Denver, or Philadelphia. The salary generally ranges from $120,000 to $1,300,000 annually as stated in the posting; actual starting pay depends on several factors. Applicants must be legally authorized to work in the U.S. without immigration-related employment authorization sponsorship.

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent professional experience.
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 using SQL Server Reporting Services (SSRS) and Power BI.
Experience with data modeling, data warehousing, data transformation, and data integration concepts and practices.
Experience with cloud analytics technologies, including 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.
Legal authorization to work in the U.S. without immigration-related employment authorization sponsorship.

Nice To Haves

Experience supporting enterprise-scale analytics and reporting environments.
Experience with data governance, metadata management, data quality, and reporting standards.
Knowledge of ETL and ELT development and data integration practices.
Experience with cloud-native analytics architectures and modernization of data platforms or data warehouses.
Experience mentoring technical professionals and leading cross-functional initiatives.
Relevant certifications in Microsoft, AWS, Snowflake, or analytics technologies.

Responsibilities

Lead the design, development, implementation, and support of enterprise analytics, reporting, and dashboard solutions.
Partner with business and technology stakeholders to gather requirements and deliver data-driven insights that improve business outcomes.
Analyze complex datasets to identify trends, risks, and opportunities, and translate findings into actionable recommendations.
Design, develop, and optimize SQL queries, data transformations, and analytical datasets for reporting and decision-making.
Create and maintain scalable data models, Power BI reports, dashboards, and other enterprise reporting solutions.
Develop and support SSRS, cloud-based analytics platforms, and reporting environments, including AWS Athena, Snowflake, and Microsoft Fabric.
Collaborate with data architecture and engineering teams to enhance data pipelines, warehouses, cloud platforms, and reporting frameworks.
Establish and promote standards for data governance, quality, security, validation, performance, and reporting best practices.
Troubleshoot and resolve complex data and reporting issues while improving accuracy, reliability, efficiency, and scalability.
Provide technical leadership, design oversight, mentorship, and guidance for analytics modernization, cloud migration, and continuous improvement initiatives.

Benefits

Competitive pay
Bonus for eligible employees
Benefits package
Pension plan
401(k) match
Employee stock purchase plan
Tuition reimbursement
Disability insurance
Medical insurance
Dental insurance
Vision insurance
Employee discounts
Career training and development opportunities
Paid time off starting at 160 hours annually for employees in their first year of service
Ten paid holidays per year
Holistic wellness program with wellness coaching and reward dollars
Paid parental leave for eligible employees
Adoption assistance
Employee assistance program
Back-up care program
PTO for volunteer hours
Employee matching gifts program
Employee resource groups
Inclusion and diversity programs
Employee recognition program
Referral bonus programs