WoodmenLife is looking for a Data Engineer I to transform data into a format that can be easily analyzed, develop algorithms to help make raw data more useful to the enterprise, and create solutions mapping from the ground up.
Requirements
- Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), as well as working familiarity with a variety of databases
- Experience building and optimizing ‘big data’ data pipelines, architectures, and data sets, utilizing the Microsoft stack with ADF and SSIS
- Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
- Strong analytic skills related to working with unstructured datasets
- Experience building processes supporting data transformation, data structures, metadata, dependency, and workload management
- Relational SQL and NoSQL data sources (e.g., MS SQL, MarkLogic, Snowflake)
- Data pipeline and workflow management tools (e.g., ADF, Airflow, and SSIS)
Responsibilities
- 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
- Creates SQL queries to compare data from the source system to the target system for conversion accuracy and quality and to meet audit requirements
- 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
Other
- Ability to engage well with others and be passionate about providing an exemplary customer experience
- Strong project management and organizational skills
- Experience supporting and working with cross-functional teams in a dynamic environment
- Ability to motivate and gain acceptance for your ideas
- Bachelor's degree or higher (not explicitly mentioned but implied as a general requirement)
