MIDLAND STATES BANK Solutions Engineer -DW in Effingham, Illinois
This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/ada/r/jobs/7791624 Status:FULL TIMESOLUTIONS ENGINEER DATA WAREHOUSEPOSITION SUMMARYThis 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. Were 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* Maintain compliance with all applicable regulations including, but not limited to, the Bank Secrecy Act (BSA)* Participate in after-hours support processes as requiredPOSITION QUALIFICATIONSEDUCATION/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)OTHER SKILLS/COMPETENCIES:* Leading Employees and Forging Synergy* Leading Change* Risk-taking, Innovation, Courage* Strategic Planning* Self-Awareness* Embracing Flexibility* Global Awareness* Inspiring Commitment* Recognizing Trade-offs* Business Perspective* Clarifies Complex Data* Creates New ConceptsMidland States Bancorp, Inc. is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, gender identity, sexual orientation, protected veteran status, or any other applicable federal or state-protected classification.