Software Engineer - CRM Team (Open to hiring at the Senior level)

Company Description

Why Wellmark: We are a mutual insurance company owned by our policy holders across Iowa and South Dakota, and we’ve built our reputation on over 80 years’ worth of trust. We are not motivated by profits. We are motivated by the well-being of our friends, family, and neighbors–our members. If you’re passionate about joining an organization working hard to put its members first, to provide best-in-class service, and one that is committed to sustainability and innovation, consider applying today!

Why Wellmark Technology? Wellmark is building innovative, modern solutions using cutting edge technology. We are driving organizational transformation and business strategy by empowering our technology team to innovate new and elegant solutions to enhance the customer experience. Together, we are leaning into the future, owning the outcome, and driving organizational change to transform how we work. 

Job Description

We are seeking a talented Software Engineer with a strong focus on back-end development and data to join our team. The ideal candidate will have deep experience working with complex datasets, building scalable data pipelines, and developing APIs that support data-driven applications. This role emphasizes proficiency in SQL and ETL processes. 

Key responsibilities include designing and maintaining robust data integrations, implementing ETL workflows, and developing APIs using Node.js or other backend technologies. Experience with source-to-target mappings (S2Ts), data transformation logic, and working with structured and semi-structured data is essential. Candidates should be comfortable working in cloud or hybrid environments and collaborating with cross-functional teams to deliver business-critical data solutions.  

In addition, you will support operational and analytic data needs for the Enterprise CRM team by handling complex data projects and ensuring the completion of data analysis and mapping activities.  

You will use your strong SQL skills to improve the integration of data from multiple internal and external sources. You will enjoy looking for alternative system solutions to meet overall business requirements. 

You will design, develop, test, implement, maintain, and document software solutions in support of Wellmark’s business strategy and Technology vision. Ensure completed activities meet specifications, requirements, and Wellmark standards. In addition, participate in determining Technology alternatives and solutions and assist with system integration. 

Qualifications

Preferred: 

• Previous experience creating data focused Intergrations between web applications  
• Experience working within an Agile team environment. 
• Ability or interest in mentoring/coaching others. 
• Experience partnering with global staffing vendors to deliver projects. 
• Minimum 2 years' experience with various data techniques such as: gap analysis, data profiling and source to target mapping for both structured and unstructured data sources (ETL, Widgets, JSON, etc.).   
• Strong expertise in SQL development including knowledge of joining multiple data sources; hands on experience with advanced SQL functions such as creating sub queries, joining, grouping, and filtering to analyze data sources. 

Required: 

• Bachelor’s degree in Computer Science, MIS, or related field of study and at least 1 year of software development experience (ex. Angular, NodeJS, TypeScript, C++, .NET, Java, SQL) OR 5+ years of related and applicable experience. 
• Strong analytical problem-solving skills. Accuracy and high attention to detail. Previous experience troubleshooting and developing creative technical solutions. 
• Strong ability to gather information, perform necessary research needed for root cause analysis, problem definition and formulation, recommend solution implementation, verification, and ongoing optimization, using data to support recommendations. 
• Demonstrated ability to build relationships to reach outcomes that gain the support and acceptance of all parties. Ability to communicate key information in a timely manner to the appropriate stakeholder audience with the ability to adjust communication style that will best suit the audience. 
• Ability to communicate with and coach/mentor team members, while setting an example in maintaining a positive attitude, staying calm under pressure, being approachable, and respectful and taking responsibility when needed. 
• Ability to thrive in fast-paced environment with changing priorities. Excellent organizational skills. Strong time management skills with the ability to set and meet established timeframes with little direction, while assuring data and information integrity. 
• Eagerness to learn and stay current on industry trends a