SQL Developer
Commonwealth Financial Network - Waltham, MA

This job posting is no longer available on Commonwealth Financial Network. Find similar jobs: SQL Developer jobs - Commonwealth Financial Network jobs

The Development department creates, builds, and maintains software applications to help everyone associated with Commonwealth work more efficiently.

The Development department creates, builds, and maintains software applications to help everyone associated with Commonwealth work more efficiently.

We are looking for a strong SQL developer to work as part of a small team of developers, business analysts, and business owners to architect, develop, implement, and support and troubleshoot Commonwealth’s Product Master database and application.

As an SQL developer, your responsibilities would include:
Creating and altering stored procedures, functions, triggers, and other SQL database objects that assist in the implementation of business logic and data flows through Commonwealth’s data and application infrastructure

Ensuring that the integrity of company databases is maintained

Monitoring and troubleshooting SQL jobs, DTS, and integration services

Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner daily

Actively helping our Data Integrity team reconcile data

Writing reports for the general business, as requested

Taking part in disaster recovery planning

Working with application developers to assist in database design, query tuning, index assignment, and trigger and procedure creation

Implementing data models and database designs

Supporting the business and the helpdesk on data issues

The ideal candidate would also meet the following requirements:

Excellent communication skills; works well in a team environment

Minimum of 3–5 years of Microsoft SQL server experience on SQL 2000–2012

Ability to write, troubleshoot, and performance tune stored procedures and triggers

Ability to reverse engineer and understand code

Experience with data warehousing

Bachelor’s degree in a technology-related field or equivalent work experience

Ability to learn new technical skills easily and troubleshoot data-related issues and errors

A solid understanding of relational and dimensional modeling

Experience in the financial sector a plus

Specific skills:
SQL 2005, SQL 2008, SQL 2012

Microsoft Report Services

SSIS

Stored procedure writing

Proven experience writing data loads using stored procedures and SSIS packages

Extensive knowledge of ETL techniques, methods, and best practices

Experience using Metadata driven process development

Experience with Pivoting and Unpivoting data within stored procedures

SQL Reporting Services experience

Excellent troubleshooting skills and the ability to reverse engineer in a timely manner

Experience and knowledge of financial products a plus

Waltham, MA position

Commonwealth Financial Network - 2 years ago - save job
About this company
9 reviews
If it were up to Commonwealth Equity Services we'd all have wealth in common. Operating as Commonwealth Financial Network, the...