Data Engineer I

We are currently looking for a Data Engineer I to join our team at WoodmenLife.

As a Data Engineer I at WoodmenLife, you will be responsible for finding trends in data sets and developing algorithms to help make raw data more useful to the enterprise. You will help transform data into a format that can be easily analyzed. You will also develop, maintain, and test infrastructures for data generation. If you enjoy working closely with data scientists and others who analyze data for trending, forecasting, predictive analysis, etc. then this might be the position for you. If you can utilize a significant set of technical skills, including a deep knowledge of database design and multiple programming languages, you will be a good fit for this position.

Why would you enjoy working as a Data Engineer I for our team?

This is an awesome opportunity for the right person. We are looking for someone who really loves to create solutions mapping from the ground up. If you have worked with SSIS packages or Azure Data Factory, this would be an ideal position for you to use those skills to grow your career with WoodmenLife. This position will be working on our HIGHEST priority when it comes to IT and Multiple Business Units. We are looking for your passion, vision, desire, and experience to join our team. You will be working with some of the best people in town. We are looking for someone who is focused on providing great customer support and creating excellent solutions. This position will create an impact and lift our team, no doubt! If you consider yourself to be a top performer with the desire to make a difference every day, this would be a great fit for you! We are looking for your experience, your talent, your input, and your ideas to bring to our WoodmenLife family.

WoodmenLife is one of the best places to work in Omaha and has been in business for 135 years. As a member of the WoodmenLife family, you’re joining others who share your commitment to family, community, and country. Through WoodmenLife, you’ll have opportunities to connect with others, give back locally, and honor those who make an impact. As a not-for-profit life insurance company, we’ve been helping to protect the financial future of families, making a difference in hometowns across America since 1890. We are passionate about our members, serving others, being open-minded, and providing an environment of inclusion and collaborative spirit. We also provide world-class benefits to our associates. Is this the type of company you could work for?

What we are looking for:
Creates and maintains an optimal data pipeline architecture
Analyzes and understands data from source and target systems in order to convert different types of data from one system to another. Gathers and analyzes data requirements, which includes data quality, proper data formatting and table structures, balancing of data, and data cleanliness issues
Creates SQL queries to compare data from the source system to the target system for conversion accuracy and quality and to meet audit requirements
Knowledge of data analysis using SQL-based tools
Ensure the creation and maintenance of Data Conversion documentation, including:
Writing database mapping requirements
Reviewing documentation in business areas
Assist with data conversion documentation for internal auditing
Assembles large, complex data sets that meet functional and non-functional business requirements
Identifies, designs, and implements internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Builds the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and ‘big data’ technologies
Builds analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics
Keeps data separated and secure across boundaries through multiple data sources and regions
Creates data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader
Understands the information needs of the enterprise, with an emphasis on executive information consumption and data that comes from or is provided to parties external to the enterprise
Leverages internal and external data sources to enhance the consumer experience and create additional opportunities for sales
Collaborates with Solution Architects on architectural decisions to ensure solutions are designed for successful implementation within the vision of the enterprise architecture
Assists in technical discussions with vendors and provides input regarding data storage, consistency, and integrity considerations of the system
May work on more than one enterp