ETL Process SSRS 2005 Or Greater Database Architecture Database Administration SDL   Requirement id 90208 Job title Developer Job location in Boston, MA Skills required Database Management Systems, Relational Database Systems, SQL Queries, ETL Process SSRS 2005 Or Greater Databas Open Date 21-Mar-2019 Close Date Job type Not specified Duration 2 Months Compensation DOE Status requirement --- Job interview type Face to Face interview    Email Recruiter: coolsoft Job Description Developer: Database Management Systems, Relational Database Systems, SQL Queries, ETL Process SSRS 2005 Or Greater Databas Note: Maximum number of resumes per ITS63 Vendors: 3 Note: RTR form must be signed by candidate. Submission Deadline: 3/29/2019 Start Date: 4/9/2019 End Date: 6/30/2019 Client: EOHHS Description: Background: The Massachusetts Department of Public Health (DPH) Bureau of Substance Abuse Services (BSAS) is operating and constantly improving a DataMart containing data from various systems. This DataMart supports the collection, storage, and reporting of critical data. We also leverage the infrastructure and standardization of tools for enhanced data collection and reporting. Challenge: In light of the Opioid Epidemic and the on-going objective of improved reporting and data analysis to provide insights to management the DataMart is and will continue to be vital to provide data for addressing public health challenges. The position reports jointly to the director of the BSAS OSE as well as the IT Program Manager at the Bureau for Substance Addiction Services (BSAS) in Boston. The Database Administrator will work closely with the BSAS DataMart team and IT staff as well as the BSAS OSE. Their role will be to proactively identify, develop and drive DataMart strategies. The Database Administrator is responsible for understanding the Bureaus data management goals and needs and how these relate to the existing and evolving DataMart, and its architecture, while ensuring compliance with IT policies and procedures. The Database Administrator will apply industry best practices and concepts to achieve DataMart goals and aid in ensuring the completion of all project deliverables on time and on budget while maintaining documentation in a centralized repository. These skills will include ongoing problem identification, impact analysis and resultant coding necessary to compensate for those issues: incomplete/inconsistent enrollment submission by programs, historical changes in assessment forms that do not align over time and other data consistency and completeness issues. The goal is to work towards the ability to reallocate resources currently committed to data resolution to more business analytic efforts supporting OSE. Duties: • The DW Developer evaluates, designs, and manages database systems in a client/server, mainframe or cloud environment and works with users to analyze requirements and define specifications for database access, structure, format, documentation, security, back-up and recovery. • The DWD performs validation checks, maintains database dictionaries and coordinates the installation of new and revised database systems. The role requires a thorough knowledge of relational database systems, structured query language (SQL), and a working knowledge of referential integrity, triggers and stored procedures. ? Data and database operational support including database operations/administration, data management/configuration and, internal (e.g. incorporation of new data channels) and external dataset integration. ? Regular Data Refresh including modifications to data tables. ? Data quality initiatives embedded in the data and database operational support framework to address regular and intermittent data issues caused by inconsistencies in the data presented to the DataMart. ? Report production and enhancement ensuring the timely generation and distribution of regular provider and population reports. ? Other activity primarily focused on ad-hoc support. ? Manage application upgrades and migration activities. ? Create and maintain written procedure manuals. ? Maintain professional interaction with internal and external teams and management. ? Working with Providers. ? Partnering with DPH and Mass Highway (internal IT staff). ? Expertise with relational database architecture, design, capacity planning, security, and other distributed data issues. ? Review the current database arc   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 90208 while calling.   Other jobs in MA: Boston (103), Burlington (1), Cambridge (1), Canton (3), Chelsea (9), Franklin (1), Lexington (2), Malden (10), Marlborough (2), Maynard (2), Newton (1), Quincy (6), Sharon (1), Waltham (1), Welesley (1), Wellesley (6), Westborough (1), Westbourough (1),    Database Management Systems job openings in other states Jobs List CRM Integration Architect IV - 121209 - SP Create date: 07-Aug-2023 Start date : 08/14/2023 End date : 06/30/2024 Submission deadline : 8/9/23 at 4:00PM CST. Client info : DHS Note : * Interview Process: MS Teams Video - at least 1 Round * Duration: 6/30/2024 with possibility of extension for a minimum of 1 year * Remote or On-site? Th.... (This job is for - CRM Jobs in WI Madison Architect - (in Madison, WI)) Database Administrator III - 118205- SP Create date: 18-May-2023 Start date : 07/01/2023 End Date : 06/30/2024 Submission deadline : 5/22/2023 4:00:00 PM Client Info :DHS Note: * Interview Process: Teams interview * Duration: 6/30/24 with extensions possible * Remote or On-site? Hybrid schedule. Local candidates or willing to relocate at the candid.... (This job is for - Specifications Jobs in WI Madison Administrator - (in Madison, WI)) CRM Integration Architect IV - 113602 - SP Create date: 23-Jan-2023 start date : 02/06/2023 End date : 06/30/2023 submission deadline : 1/25/23 at 4:00PM CST. client info : DHS Note : * Interview Process: MS Teams Video - at least 1 Round * Duration: 6/30/2023 with possibility of extension for a minimum of 1 year * Remote or On-site? T.... (This job is for - CRM Jobs in WI Madison Architect - (in Madison, WI)) GOV - SQL Server DBA/Data Warehouse Architect (648155) Create date: 23-Mar-2021 Start Date :04/05/2021 End Date :09/30/2021 Submission Deadline :03/29/2021 Client Info : SOA Note : * Agency Interview Type : Web Cam Interview Only Description : This position develops, tests, and maintains scalable and efficient data pipelines to acquir.... (This job is for - job Jobs in VA NorthChesterfiel Architect - (in North Chesterfiel, VA)) Database Administrator - 47258 Create date: 14-May-2019 Job Description : Description: Coordinates physical changes to databases. Codes, tests, and implements physical database, applying knowledge of database management system. Designs logical and physical databases, reviews description of changes to database design to understand how changes to be made affect .... (This job is for - job Jobs in WI Madison Administrator - (in Madison, WI))    Database Management Systems job openings in MA Jobs List Enterprise Architect - 39769 Create date: 23-Oct-2018 We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens Job Description : Position: Enterprise Solutions Architect Position Description: Our client is a Large Utilities Company that is located in the Waltham, MA area. Our client is looking for an Enterprise Solutions Architect for a 8+ mo.... (This job is for - job Jobs in MA Waltham Architect - (in Waltham, MA)) (Developer: Database Management Systems, Relational Database Systems, SQL Queries, ETL Process SSRS 2005 Or Greater Databas in Boston, MA)

Featured Jobs System Analyst (Jobs in Madison, Wisconsin) Consultant (Jobs in Dauphin County, Pennsylvania) Project Analyst (Jobs in Lincoln, Nebraska) - Consultant (Jobs in Lincoln, Nebraska) Business Analyst Written Analyst (Jobs in COLUMBIA, South Carolina) .Net Developer (Jobs in Nampa, Idaho) Agile TFS Analyst (Jobs in COLUMBIA, South Carolina) Pega Case Consultant (Jobs in Trenton, New Jersey) SQR Billing Consultant (Jobs in COLUMBIA, South Carolina) Workflow Health Consultant (Jobs in Jackson, Mississippi)