- Excellent analytical skills, including the ability to perform advanced research that involves interpretation and analysis of data from a variety of sources
- Translation of business questions and requirements into reports, views, and SQL queries
- Expert knowledge of data warehouse architecture, data design patterns and data transformation best practices in environments of medium to large volume of data
- Advanced experience in tunning T-SQL query performance, identifying the need and creation of SQL indexes
- Advanced hands-on experience with T-SQL, data warehouse concepts including dimensional modeling
- Strong problem-solving and tenacity in creating solutions for complex and performant data challenges while handling hundreds of millions of records
- Intermediate to advance knowledge of DAX
- Knowledge in at least one scripting language for predictive analytics and data visualization. (R or Python) is a plus
- Hands on expertise with implementation of a MS Analyses Services Cube using the Tabular model and PowerBI data models is required
- Working knowledge in developing Azure Data Factory is a plus
- Good knowledge of server hardware, server storage and other infrastructure, client/server applications, and server utilities
- Expert knowledge of SQL Server 2016/2019/2022 and strong T-SQL skills is required
- Strong discipline in following SQL coding styles which improves code readability and supportability
- Experience supporting a 24x7 production environment
- Ability to work effectively with both users and technical staff in team-oriented environments
- Excellent oral and written communication skills and interpersonal skills including the ability to effectively communicate technical information to both technical and non-technical personnel
- Ability to work successfully and independently in an atmosphere of multiple projects, shifting priorities, and deadline pressures
- Working knowledge of Information Technology Infrastructure Library (ITIL), Microsoft Operations Framework, ISO 9000 or similar process discipline is preferred
Senior Business Intelligence Engineer - Boston, United States - WilmerHale
Description
No prior banking experience necessary to join this rewarding career
As The Bank of You, North Shore Bank is about helping families thrive, businesses grow and communities flourish. And it's our employees that make the difference. With offices located throughout eastern Wisconsin, we offer a work culture that has been recognized as a Top Workplace eleven times by the Milwaukee Journal Sentinel.
As a mutual company, North Shore Bank isn't publicly-owned, which means when we come to work every morning, our sole focus is on providing high-touch service to our customers and employees, and supporting our local communities. Are you looking for a company that places long-term growth ahead of short-term profits? Where you can put your customers first and think creatively to solve challenges? Where respect, integrity and being true to your word are valued and rewarded? This is the place.
North Shore Bank's Traveling Tellers are the Bank's personal representatives for its customers, providing efficient, accurate and friendly service, who build strong relationships between the customer and the Bank. Our Tellers actively promote and sell North Shore Bank products and services.
Successful Tellers are comfortable in a sales referral role and actively engage our customers in meaningful conversations; ask questions to identify cross-selling opportunities; and make an appropriate blend of qualified referrals to other branch personnel and branch business partners.
In this role, you will also reach out to customers via telephone to develop banking relationships and inform customers of our products and services.
We look for employees who embody our brand of The Bank of You – Together Achieving More. We seek individuals who give their all to their fellow employees throughout the bank, and who are interested in learning and developing skills as a Teller. Our customers demand Tellers who are friendly, knowledgeable, accurate, responsible, and will make their banking experience a personalized service. Our pay rates are extremely competitive, starting at $18/hr plus DOE, along with a 401k plan with matching benefits, medical plans, and other employee benefits. This position will require travel to various branch locations as Brookfield, West Allis, Southwest, Southridge, Forest Home and Muskego; must have reliable transportation. Travel time and mileage reimbursement provided. Must have availability to work some Saturday mornings. Education and Experience: High school diploma or equivalent and at least six months of related experience is required. Related experience includes a combination of cash handling, direct customer service, and retail or other sales. Required Skills Required Experience Qualifications:
What You Will Bring