SQL Developer

Commonwealth of Massachusetts

Contract Boston, Massachusetts, United States Posted 5 years ago

 Write a Review Add Vendor   Add Contact  

About Position

SQL Developer (Contract)

$65.00 / Hourly

Boston, Massachusetts, United States

SQL Developer

Contract Boston, Massachusetts, United States Posted 5 years ago

Description

Summary We are currently seeking an SQL Developer to work on VRM (Vendor Report Management) Project. This position reports to the Director of Application Systems for the Operational Services Division and works closely with the ANF OSD technical team.This position requires that the candidate be a skilled SQL developer and able to design, develop, and support complex integration processes (including interfaces) using SQL Server technology, stored procedures and SQL program code. In addition, the candidate will be involved in database administration, implementing data transformation rules and data validations into the data warehouses. The ideal candidate for this position will have strong technical knowledge and be very analytical.Primary Responsibilities Creates and manages physical models to support Data Warehouse domains that include Operational Data Stores, Data Mart, Business, Reference/Master Data and Extract Transform Load (ETL) environments.Develop data models to meet the needs of the organization's information systems.Manages the flow of information across various applications and departments using relational databases.Maintains data integrity by working to eliminate redundancy.Interact with Users to understand reporting requirements and identify the data sources to fulfill those reporting requirementsData analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business ownersProvide status reports and create/contribute to project estimatesWork with Director of Application Systems to ensure successful transition of VRM project deliverables to production environmentFollow established business, technical and project policies and guidelines aligned with OSD, ANF and client principles and standards to include the following use of best practices, meeting management, project plans, status reports and dashboards, risk and issue tracking, change requests and resource management.Education, Skills and Competencies5 + years SQL DBA/Development experienceExtensive knowledge of SQL Server including the writing of complex stored procedures, functions and SSIS packages as well as basic knowledge of database administrationExpert level knowledge of SQL administration, engineering, and monitoring toolsDemonstrated expertise in performance tuning including both query and server optimizationExperience with the Microsoft SQL Server stack SQL Server databases, SQL Server Integration Services, SQL Server Reporting ServicesData Integration design, development and deploymentStrong relational and dimensional data modeling and database design skillsExperience with techniques for addressing performance issues and ability to Tune SQL QueriesExperienced in ETL development, data analysis, mapping, and automated loading.Experience with Business intelligence platform, Tableau and PowerBIAbility to translate business needs into technical solutions

By applying to a job using PingJob.com you are agreeing to comply with and be subject to the PingJob.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Questions / Comments:

Display Questions / Comments:

No Questions / comments

Commonwealth of Massachusetts Vendors

( Login to see all the 7 vendors)
TEK Systems
Write a Review

971 Corporate Boulevard
Linthicum
Maryland
www.teksystems.com ( 85 vendors)

Kforce Professional Staffing Firm
Write a Review

1001 E Palm Avenue
Tampa
Florida
www.kforce.com ( 82 vendors)

Overture Partners LLC
Write a Review

10 Kearney Road
Needham
Massachusetts
www.overturepartners.com ( 11 vendors)

Job Summary

$65.00 / Hourly

Contract

Boston, Massachusetts, United States

Experience Required : 7 Year/s

Posted : 5 years ago

Deadline : February 21, 2019 5 years ago

Job ID : Job0000014580

Commonwealth of Massachusetts

200 Arlington Street

www.mass.gov