Cambridge Savings Bank is a full-service banking institution committed to improving the quality of life of its employees, customers, and communities. The Associate SQL Business Analyst role involves translating business requirements into high-quality data extracts, engaging with stakeholders, and supporting data engineers with quality assurance and documentation of internal database architecture.
Responsibilities
- Demonstrated ability to work independently and ensure on time completion of requested activities with a strong attention to detail
- Proactively engages with key stakeholders across our business, gathers requirements, suggests new solutions or improvements to existing tasks and or new problems
- Clear ability to independently manage and prioritize multiple competing priorities in a fast-paced environment
- Demonstrated ability to work with internal stakeholders to collaborate with ease in order to build trust and to help influence outcomes
- Support Data Engineers through the quality assurance type code review/ smoke tests etc. to identify coding issues and data exceptions, as well as cleansing of data
- Ability to mine databases, create views, database tables, troubleshoot existing queries and develop new queries
- Support ongoing documentation of internal database architecture, data models etc
- Develop a thorough understanding of the bank’s Data landscape and strive to become a recognized SME on key applications used in the bank
- Perform additional duties as required
Skills
- College education in Computer Science, Mathematics, Statistics or 1-2 years of systems analyst experience in a SQL Analyst/Data Analyst/ BI role
- Advanced Experience working with writing T-SQL and PL-SQL and extracting information from Oracle and or SQL databases, Data Warehouse environments
- Experience with Visual Studio, ETL tools or SSIS Package development, data governance tools
- Strong analytical, communication and organizational skills
Benefits
- Healthcare
- Parental planning
- Mental health benefits
- Performance bonus opportunities
- A 401(k) plan and match
- Flexible time off
- Others
Company Overview
Cambridge Savings Bank is a public bank serving both individuals and businesses. It is a sub-organization of Ivy Bank. It was founded in 1834, and is headquartered in Cambridge, Massachusetts, USA, with a workforce of 201-500 employees. Its website is http://www.cambridgesavings.com.