250 Washington Street
Boston,
MA
02111
US
| Work from home flexibility
TELECOMMUTE
US
Posted: 01/27/23
2023-01-24
2023-02-26
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
- 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.
