Lead Data Analytics Engineer (Power BI)

Location: Hybrid office environment, Tuesday through Thursday, in Cedar Rapids, Denver, or Philadelphia, United States

Salary: $120,000–$1,300,000 annually

Company

hirify.global is a financial services company providing insurance, retirement, investment, employee benefits, and related solutions as part of the Aegon group.

What you will do

• Lead the design, development, implementation, and support of enterprise analytics, reporting, dashboards, and data models.
• Partner with business and technology stakeholders to translate reporting needs into data-driven insights and recommendations.
• Develop and optimize SQL queries, data transformations, analytical datasets, Power BI reports, SSRS solutions, and enterprise reporting environments.
• Support AWS Athena, Snowflake, Microsoft Fabric, data pipelines, warehouses, cloud platforms, and reporting frameworks.
• Establish standards for data governance, quality, security, validation, performance, and reporting best practices.
• Provide technical leadership, design oversight, mentorship, troubleshooting, and guidance for analytics modernization and cloud migration.

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 with SQL Server Reporting Services and Power BI.
• Experience with data modeling, data warehousing, data transformation, and data integration concepts and practices.
• 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.
• Must possess legal authorization to work in the United States without immigration sponsorship or an employer of record for immigration employment purposes.

Nice to have

• Experience supporting enterprise-scale analytics and reporting environments.
• Experience with data governance, metadata management, data quality, reporting standards, ETL, ELT, 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 Microsoft, AWS, Snowflake, or analytics technology certifications.

Culture & Benefits

• Full-time employment in a hybrid office environment with attendance Tuesday through Thursday.
• Benefits may include competitive pay, eligible employee bonuses, pension, 401(k) match, employee stock purchase, insurance, and tuition reimbursement.
• Paid time off starts at 160 hours annually in the first year, with ten paid holidays per year.
• Additional offerings include parental leave, adoption assistance, wellness programs, backup care, employee assistance, volunteer time, and professional development.
• Employee resource groups, inclusion and diversity programs, recognition programs, and community giving initiatives are available.