Senior Software Engineer

Empower LLC; Northern (KY); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401(k) with company matching

Tuition reimbursement

Job summary

Empower LLC seeks a Senior Software Engineer with 5+ years in enterprise reporting, data analytics, and cloud data platforms to lead modernization efforts. You will work with Data Architects and stakeholders to design scalable reporting solutions, optimize data pipelines, and ensure governance and security across platforms.

The role emphasizes technical leadership, collaboration, and hands-on development in modern BI environments and cloud data services.

Qualifications

• Bachelor's degree in CS, IT, Engineering, Data Analytics, or related field or equivalent experience.
• 5+ years in software engineering, enterprise reporting, BI, data warehousing, or analytics.
• Strong experience designing and modernizing enterprise reporting solutions.

Responsibilities

• Provide technical leadership for report discovery, modernization, and migration.
• Analyze reporting landscape to identify duplicates and critical reports.
• Lead transformation of legacy reports into modern analytics solutions.
• Ensure reporting aligns with data architecture, security, governance, and performance.
• Collaborate with stakeholders to understand requirements and data dependencies.
• Translate requirements into scalable designs, data models, and ETL plans.
• Design and optimize data pipelines, datasets, and reporting structures.
• Document data lineage, transformations, and report dependencies.
• Define testing strategies including data reconciliation and performance testing.
• Mentor engineers on modern reporting and cloud data platforms.

Skills

Cloud data platforms

SQL optimization

Data warehousing

Data analytics

Agile methodologies

Technical leadership

Education

Bachelor's degree or equivalent

Tools

Power BI

Amazon QuickSight

AWS S3

AWS Lambda

dbt

Airflow

CI/CD

Job description

Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them.

Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself.

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa at this time, including CPT/OPT.

We are seeking a Senior Software Engineer with 5+ years of relevant experience in enterprise reporting, data analytics, cloud data platforms, and report modernization.

This role requires strong hands‑on experience with Cloud Data Warehouses, Data Analytics and Reporting tools, along with working knowledge of legacy reporting technologies. The candidate will lead the enterprise reporting solutions partnering with Data Architects, Data Product Owners, business stakeholders, leadership, and engineering team members.

What you will do:

• Provide technical leadership for report discovery, assessment, consolidation, modernization, migration, and decommissioning.

• Analyze the existing reporting landscape to identify duplicate, obsolete, underused, and business‑critical reports.

• Lead the transformation of legacy reports into modern reporting and analytics solutions.

• Partner with Data Architects to ensure reporting solutions align with enterprise data architecture, security, governance, and performance standards.

• Collaborate with Data Product Owners and business stakeholders to understand reporting requirements, business rules, usage patterns, and critical data dependencies.

• Translate business reporting requirements into scalable technical designs, data models, transformation logic, and implementation plans.

• Design and optimize data pipelines, queries, semantic layers, datasets, and reporting structures.

• Perform source-to-target analysis and document data lineage, transformation rules, report dependencies, and reconciliation requirements.

• Ensure migrated reports maintain functional accuracy and consistency with legacy report outputs.

• Define testing and validation approaches, including data reconciliation, regression testing, performance testing, and user acceptance testing.

• Identify and resolve data quality, report performance, and platform integration issues.

• Establish reusable reporting patterns, development standards, templates, and technical best practices.

• Support governance processes related to report ownership, access control, auditability, data classification, retention, and lifecycle management.

• Lead technical discussions, design reviews, code reviews, and troubleshooting sessions.

• Mentor engineers and provide guidance on modern reporting, cloud data platforms, SQL optimization, and software engineering practices.

What you will bring:

• Bachelor's degree in Computer Science, Information Technology, Engineering, Data Analytics, or a related field, or equivalent professional experience.

• 5+ years of relevant professional experience in software engineering, enterprise reporting, business intelligence, data warehousing, or data analytics.

• Strong experience designing, developing, supporting, or modernizing enterprise reporting solutions.

• Hands‑on experience with cloud data warehouses, data analytics platforms, relational databases, advanced SQL development, and query optimization.

• Working knowledge of legacy reporting technologies.

• Experience analyzing legacy reports, underlying SQL, stored procedures, data sources, business rules, schedules, and downstream dependencies.

• Strong understanding of reporting architecture, data pipelines, semantic models, metadata management, and data lineage.

• Ability to troubleshoot complex data discrepancies and reconcile report outputs across legacy and modern platforms.

• Experience working in Agile software delivery environments.

• Strong technical leadership, problem‑solving, analytical, and decision‑making skills.

• Ability to work collaboratively with Data Architects, Data Product Owners, business stakeholders, leadership, engineers, analysts, and other team members.

What will set you apart:

• Experience with modern business intelligence and visualization tools such as Power BI, Amazon QuickSight, or equivalent technologies.

• Experience with AWS services such as S3, Lambda, Step Functions, IAM, CloudWatch, or related services.

• Experience with data transformation and orchestration tools such as dbt, Airflow, or equivalent platforms.

• Experience with CI/CD pipelines, version control, and AI-based development tools.

• Knowledge of data governance, master data management, metadata management, and enterprise security controls.

• Experience leading large‑scale reporting rationalization or business intelligence modernization programs.

• Familiarity with financial, operational, regulatory, or executive reporting environments.

This job operates in a professional office environment.

This job description is not intended to be an exhaustive list of all duties, responsibilities and qualifications of the job. The employer has the right to revise this job description at any time. You will be evaluated in part based on your performance of the responsibilities and/or tasks listed in this job description. You may be required to perform other duties that are not included on this job description. The job description is not a contract for employment, and either you or the employer may terminate employment at any time, for any reason, as per terms and conditions of your employment contract.

This job description is not intended to be an exhaustive list of all duties, responsibilities and qualifications of the job. The employer has the right to revise this job description at any time. You will be evaluated in part based on your performance of the responsibilities and/or tasks listed in this job description. You may be required perform other duties that are not included on this job description. The job description is not a contract for employment, and either you or the employer may terminate employment at any time, for any reason.

What we offer you

We offer an array of diverse and inclusive benefits regardless of where you are in your career. We believe that providing our employees with the means to lead healthy balanced lives results in the best possible work performance.

• Medical, dental, vision and life insurance
• Retirement savings - 401(k) plan with generous company matching contributions (up to 6%), financial advisory services, potential company discretionary contribution, and a broad investment lineup
• Tuition reimbursement up to $5,250/year
• Business-casual environment that includes the option to wear jeans
• Generous paid time off upon hire - including a paid time off program plus ten paid company holidays and three floating holidays each calendar year
• Paid volunteer time - 16 hours per calendar year
• Leave of absence programs - including paid parental leave, paid short- and long-term disability, and Family and Medical Leave (FMLA)