Solution Engineer - DW at Midland States Bank in Effingham, Illinois

Job Description:

Salary Range: $75,000-$105,000

At Midland States Bank, base salary is one component of our Total Rewards program. Exact compensation is determined by factors such as (but not limited to) education, skills, internal equity, and experience. This position offers additional compensation in the form of short-term incentives (i.e. bonus and/or commission) and may include long-term incentives (i.e. stock awards). Benefits for this role include comprehensive healthcare, well-being benefits, paid family leave as well as generous paid time off. Total Rewards also include banking perks, an Employee Stock Purchase Plan, 401K plan with company match and may include the opportunity to participate in our Non-Qualified Deferred Compensation plan. Incentives and benefits are subject to eligibility requirements.

Position Summary

This role participates in the complete EDW development lifecycle, including data profiling, integration pipeline design and development, debugging/testing, and support and enhancements. You will work closely with our stakeholders and other members of MSB IT.  We’re looking for someone who is data-driven, a great communicator, naturally curious, and committed to professional/technical growth.  This position reports to the Team Lead – Data Engineering.

 

Primary Accountabilities

 

• Discover, profile, and learn about the source systems' data being ingested
• Partner with peers within and outside the team, to understand reporting and analysis requirements
• Translate requirements into data models, including relational and dimensional (star-schema) marts
• Design and develop ETL code to load and transform the source data from various formats and sources (databases, REST services) into the DW database.  
• Conduct thorough peer review and testing of ETL code to ensure quality of data produced
• Keep documentation and metadata up-to-date to support regulatory requirements
• Conduct ETL and database performance tuning, troubleshooting, support, and capacity estimation
• Work effectively and collaboratively with both Agile and waterfall methodologies
• Participate in after-hours support processes as required
• The role requires occasional travel for training and team meetings, and willingness to travel periodically, to locations within market as needed.
• May require work in a Midland office to ensure collaboration and support of internal and external customers. 
• Maintain compliance with all applicable regulations including, but not limited to, the Bank Secrecy Act (BSA).
• Other duties as assigned. 

Position Qualifications

 

Education/Experience:

• Bachelor or Masters degree in a technical discipline (CS, MIS) 
• 5+ years of experience in Data Warehouse, Data Engineering, or Analytics
• Expert SQL coding/querying skills in a relational database such as Oracle, SQL Server, or MySQL
• Skilled with relational and dimensional (star schema) database design/modeling using tools such as ERstudio or ERwin
• Experience with Business Intelligence/Dashboarding tools such as Tableau, Cognos, or MS Power BI
• Strong communication and interpersonal skills.  Can work independently and as part of a team.
• Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools quickly 
• Helpful but not required:
  • Banking industry experience
  • Big-data experience (Hadoop/Hive)
  • Streaming, event-based, or log-processing data experience
  • Certifications (MCITP, TDWI)

 

Competencies: 

• Business insight
• Cultivates innovation
• Drives results
• Makes sound decisions
• Being a brand champion
• Collaborates
• Communicates effectively
• Customer focus
• Being Authentic
• Emotional Intelligence
• Self development
• Being flexible and adaptable

 

At Midland States Bank, we believe that when we can bring our whole selves to work each day, we become happier, more comfortable, more confident and more excited to do great things for our customers, each other and our company. We’re proud to be an Equal Opportunity and Affirmative Action employer. At Midland, we recruit, employ, train, compensate and promote without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. If you are looking for a place to grow, we encourage you to apply at Midland States Bank, because you belong here.

If you require reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employee selection process, please direct your inquiries to Midland States Bank Human Resources at HR@midlandsb.com.

 

THIS JOB DESCRIPTION DOES NOT CONSTITUTE A CONTRACT FOR EMPLOYMENT

Equal employment opportunity, including veterans and individuals with disabilities.

PI265642832

Apply Now