Be an early applicantLess than 25 applicants

Company

Mutual of Omaha · 3 hours ago

Data Engineer (Solution Lead) - Remote

United States

Full-time

Remote

Senior Level, Lead/Staff

$110K/yr - $130K/yr

5+ years exp

Maximize your interview chances

Auto InsuranceCommercial Insurance

Actively Hiring

No H1B

Insider Connection @Mutual of Omaha

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Over the next two years, key deliverables include:

ESS Cloud Data Strategy: To align with enterprise goals, we must refine the migration path to Snowflake and expand data visualization capabilities with Sigma or another tool. Over the next 18 months, we will migrate 7 years of Special Risk data to the cloud, supporting data visualization for a broker portal.

Institutional Annuity Growth Catalyst Data Strategy: Develop an ETL framework, centralize data, and enable real-time analytics. Streamline SDLC processes and establish a single source of truth for SQL changes in SSRS and Sigma. Use GitHub for documentation and Alation for metadata management. Improve health of data across our test environments to enable faster software delivery.

Automated Data Testing: Implement automated data validation, reducing manual reporting processes. Leverage Snowflake or other tools for error handling and validation across data sources. Focus on automating the validation of the 600+ Special Risk reports generated monthly.

Design, build, and maintain efficient data systems and pipelines to support both analytic and operational data needs, including data movement, modeling, and reporting.

Collaborate with enterprise teams in data science, architecture, and governance to align on standards and optimize production environments for performance and security.

Work with business owners to enhance data collection, storage, and usage, ensuring data solutions maximize information value across supported systems.

Translate business requirements into data architecture solutions, implementing and optimizing these solutions within production environments.

Develop and deploy data orchestration pipelines, including data sourcing, cleansing, and quality control, as well as basic machine learning models in partnership with business units.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLETL/ELTPythonSnowflakeData GovernanceData VisualizationGitData ArchitectureInformaticaSSRSAWS

Required

At least 5 or more years of experience at an expert level solving build, development, and implementation challenges with: Traditional data technologies and methodologies, such as RDBMS, SQL, and ETL/ELT, as well as emerging technologies like data science, programming languages, and cloud platforms including experience with Python development.

Foundational knowledge in analyzing data systems for structure, relationships, and impact to create effective data pipelines that align with business needs via ETL processes and data pipeline management.

Experience with cloud data warehousing platforms (preferably Snowflake), OLAP architecture, data modeling, and building data architectures for internal and external reporting.

Proficiency in version control (Git) and change management to manage data pipelines, reporting changes, and code deployments.

Strong understanding of data governance, security, and compliance (e.g., HIPAA, GDPR).

Ability to create compelling visualizations using tools like Sigma that communicate data insights and support data-driven decision-making.

Excellent communication and teamwork skills, with the ability to collaborate across teams, quickly understand business context, and implement data solutions that align with organizational goals.

Strong problem-solving and learning agility.

You promote a culture of diversity and inclusion, value different ideas and opinions, and listen courageously, remaining curious in all that you do.

Able to work remotely with access to a high-speed internet connection and located in the United States or Puerto Rico.

Preferred

Intermediate to expert knowledge of: Informatica, SSRS, AWS, Snowflake

Benefits

401(k) plan with a 2% company contribution and 6% company match.

Regular associates working 40 hours a week can earn up to 15 days of vacation each year.

Regular associates receive 11 paid holidays in 2024, which includes 2 floating holidays that are added to your prorated personal time to be used at your discretion.

Regular associates are provided sick leave through the use of personal time. Associates working 40 hours a week can receive up to 40 hours of personal time in 2024, which is prorated based on the start date.