Senior SQL Developer Jobs in Boston MA | Government,Software/Application Development and Architecture Job Recruiters

Senior SQL Developer

Boston, MA | Work from home flexibility

Posted: 01/27/23 Category: Government, Software/Application Development and Architecture Job Number: 19633

Job Description

Position: Senior SQL Developer 
Location: Boston, MA - Hybrid
Job Type: Contract
Duration:  5 Months to start
Job Description
The Developer will develop SSIS packages for the standardization of incoming data and on Data Cleanup and Standardization projects. The incumbent will work closely with Business Analysts and Data Architects who will provide the requirements for the code development.

Job Duties
  • Review the current database architecture, re-design & develop the new database to improve the efficiency, usability and streamline data import and export processes.
  • Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions.
  • Document specific requirements for data integration, including file format, fields, etc.
  • Develop ETL processes for the import and export of data between the DPH internal systems using SQL Server Integration Services (SSIS) and advanced T-SQL to include stored procedures, user-defined functions, views, etc.
  • Design, develop, revise, and maintain a wide variety of custom SSRS reports to support our business.
  • Assist in the Creation and Analysis of optimized stored procedures for data pulls for reports/exports.
  • Develop data warehouse objects and processes for the purpose of supporting business intelligence, including ETL, fact/dimension tables, and cubes.
  • Research, analyze, document, and maintain internal Applications and Database architectures. Provide technical assistance and information to technical and non-technical users.
  • Analyze, design, implement and maintain the businesses critical systems, maintaining at all times the proper data security standards set forth by the organization.

Required Skills
  • Analytical thinking
  • Structured approach to problem skill with attention to details
  • Self starter
  • Communicate with technical and non-technical stakeholders
  • Good customer service skills

Qualifications
  • Bachelor’s degree in Computer Science, Computer Information Systems, Information Management or equivalent work experience
  • Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms, Data Warehousing…
  • 10 Years working in a data centric IT environment.
  • 5 years hands on experience with ETL tools and integration engines, preferably MS SSIS, Snowflake
  • Proven track record of designing and implementing complex and large scale Enterprise Databases
  • Documenting databases using Entity Relationship Models and Data Dictionaries
  • Writing SQL scripts
#LI-Hybrid

Queen Consulting Group is an equal opportunity employer. Our goal is to promote an environment that helps our employees and clients appreciate the benefits that diversity provides.

Meet Your Recruiter

Nick Pierce

Apply Online

Send an email reminder to:

Share This Job:

Related Jobs: