MIDLAND STATES BANK Solutions Engineer - BI in Rockford, Illinois
This job was posted by https://illinoisjoblink.illinois.gov : For more information, please see: https://illinoisjoblink.illinois.gov/ada/r/jobs/7787191 Status:FULL TIMESOLUTIONS ENGINEER - BIPOSITION SUMMARYThis roleparticipates inthe complete Analytics development lifecycle, including data profiling, report and dashboard/scorecard design and build, debugging/testing, and support and enhancements. You will work closely with our business partners and other members of MSB IT.The Solutions Engineer - BI provides data-driven solutions, using a variety of technologies and data sources. Their deliverables include analytic-embedded processes and automation, business analytic modeling, and ad-hoc data discovery and ultimately enables business insights. This role reports to the Team Lead Data Analytics.PRIMARY ACCOUNTABILITIES* Consult with business owners and leaders on ways to improve efficiency, increase revenue, and reduce risk using analytics.* Communicate complex data analysis concepts to diverse audiences in non-technical terms.* Lead business datagathering, analysis, and reporting projects.* Develop conceptual and logical data models to meet business data management, process automation, and decision support needs.* Develop and manage documentation and logs to support the accuracy and controls of analytic models and reports.* Conduct design reviews and code reviews for projects. Follow and embrace team standards and development best practices.* Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment. Manage releases of analytic models and reports throughout the SDLC.* Ensure data security and privacy issues are taken into consideration during design, development, and deployment.* Implement and support analytic models and reports, including backups, recovery, tuning, security, accuracy. Capture and analyze model and report performance to identify improvements in indexing, file structure, maintenance processes, and query performance.* Plan and conduct periodic reviews of analytic models and reports through the lifecycle, retraining or retiring models no longer fit-for-use.* Maintain and expand expertise in one or more technical skills through continuous self-study, training, and certifications.* Mentor other team members on business data, tools, and techniques.* Maintain compliance with all applicable regulations including, but not limited to, the Bank Secrecy Act (BSA).POSITION QUALIFICATIONSEDUCATION/EXPERIENCE:* BS or MS in Computer Science, Information Systems, Statistics or related quantitative or business field.* 5+ years of experience designing, implementing and managing data models and analytic models* Expert in Relational database querying using SQL (Oracle, Microsoft, MySQL etc.)* Experienced with data visualization and reporting tools, such as Cognos, MS PowerBI or Tableau* Expert verbal and written communication skills. Can communicate effectively with technical and non-technical audiences at any level.* Experience in a variety of other analytic software and technologies is a plus, including* Analytic Modeling (SAS, SPSS, R)* Cloud-based analytics platforms such as RedShift, Snowflake, Azure* Linux and Windows operating systems* Scripting using Python, Perl, PHP, DOS Batch, SFTP etc.* Exposure to Automated data test suites such as QuerySurge* Must be comfortable working in a fast-paced, flexible environment, and take the initiative to learn new tools quickly* Prefer experience with:* Banking or Financial Services industry* General accounting principles* Data testing tools and methodologies for reconciliation of da ta to base applications* SOX requirements* Experience in ITIL or other formal SDLC methodologies and governance practicesCOMPETENCIES/OTHER SKILLS:* Leading Employees and Forging Synergy* Leading Change* Risk-taking, Innovation, Courage* Strategic Planning* Embracing Flexibility* Global Awareness* Inspiring Commitment* Recognizing Trade-offs* Business Perspective* Clarifies Complex Data and 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.