SQL Data Warehousing ETL MS Office Analyst (Jobs in Boston, MA)   Requirement id 10339 Job title Analyst Job location in Boston, MA Skills required SQL Queries, SQL Server, SQL Technologies, Data Warehousing ETL MS Office Open Date 21-Jun-2012 Close Date Job type Contract Duration 12 Months Compensation DOE Status requirement --- Job interview type Phone Screen and Face to Face interview    Email Recruiter: coolsoft Job Description Analyst: SQL Queries, SQL Server, SQL Technologies, Data Warehousing ETL MS Office [Note: Submission Deadline : 06/22/2012 05:00PM] Description: Responsibilities: We are seeking an experienced Data Conversion Analyst to analyze and verify that SQL Server production data is transformed correctly in a large system conversion project. This involves analyzing data from several source operational systems and determining whether the data is transformed accurately, completely and sensibly into the new system. Candidate must be well-versed in understanding how to devise a validation/test plan based on data quality standards for a data conversion project. He/she should be able to understand data discrepancies and how to fix them using SQL. Candidate needs to know how to read and interpret complicated data models to understand how data is transformed between systems. He/she must be capable of creating reconciliation reports against the source systems and destination system to validate the integrity and accuracy of the transformed data and recommend how to fix problems. Candidate will also consult on data related issues, data cleanup efforts, and contribute to standardization and process improvements. General Qualifications: • Experience in creating SQL queries to query data from various data sources to support analysis. • Experience with and understanding of Data Warehousing and ETL (SSIS & DTS) • Experience with reporting technologies • Experience in application level problem diagnosis and trouble shooting, resolution and testing. • Experience in MS Access front ends and back ends • Experience working on large scale analysis projects • Demonstrated experience in writing process, analytic and technical flows Mandatory Requirements: • Minimum of 6+ years experience in SQL Server and development with SQL technologies • Strong SQL competency • Experience in utilizing Microsoft office applications (Word, Excel, Access) • Experience with Data Quality standards • Strong analytic skills • Identify key assumptions that could impact recommendations and strategies • Identify opportunities for process and data improvements • Develop and run reports to illustrate results of the analysis • Present reports and findings to the internal and/or external customers • Research existing systems and business processes to derive business rules to use as the basis of data analysis • Experience in MS Access design and development with SQL technologies • Superior organizational skills, with a disciplined approach to implementation, support and documentation. • Hands-on approach with ability to deliver to commitments. • Self motivated and highly professional with ability to take on responsibility and work independently. • Ability to work under pressure and tight deadlines. • Excellent client (internal & external) communication and liaison skills. • Fiscal and accounting background a plus.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 10339 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), SQL Queries job openings in Boston, MA Jobs List ITS63 Accela JavaScript Developer -SP Create date: 17-Sep-2020 Bid Number: BD-21-1042-IT-IT001-54965 Note: Email Submission Note: Total Number of Positions Sought Up to 1 Note: Maximum number of resumes per ITS63 Vendors: 2 Submission Deadline: 9/22/2020 12:00:00 PM EST Start Date: 10/2/2020 End Date: 6/30/2021 Client: Executive Office of Energy and Environm.... (This job is for - Crystal Reports Jobs in MA Boston Developer - (in Boston, MA)) ITS63 EHS FY20 Healthcare Data Analyst 004 DSRIP Fmla -SP Create date: 03-Apr-2020 Note: Submission Note: Total number of positions sought: 1 Note: Maximum number of resumes per ITS63 Vendor: 3 Submission Deadline: 4/9/2020 Start Date: 4/20/2020 End Date: Client: EOHHS Description: To meet envisioned demand for new analytic work, MassHealth seeks contractors .... (This job is for - SASTableau Jobs in MA Boston Analyst - (in Boston, MA)) ITS63 Data Warehousing Developer -SP Create date: 25-Feb-2020 Note: In the document submission deadline is March 6th 3:00 PM EST Bid Number: BD-20-1107-1107T-TRC01-49065 Note: Online Submission Interview: Initial contact by phone, interview may be in person Note: Total number of positions sought: 1 Note: Maximum number of resumes per ITS63 Vendor: 2 Submission D.... (This job is for - job Jobs in MA Boston Developer - (in Boston, MA)) ITS63 20ITSDD2 EOE Quality Assurance Analyst (1 Of 1) -SP Create date: 24-Jul-2019 Bid Number: BD-20-1036-EDU02-EDU02-42269 Note: Email and Online Submission Note: Total number of positions: 1 Note: Total number of resumes accepted per vendor: 3 per posting Submission Deadline: 8/7/2019 3:00 PM EST Start Date: 8/19/2019 End Date: 6/30/2020 Client: Executive Office of Education .... (This job is for - Quality Assurance Jobs in MA Boston Analyst - (in Boston, MA)) ITS63 FY19 DOT LIMMS Senior Business Analyst 010 -SP Create date: 01-May-2019 Bid Number: BD-19-1030-0P100-0P110-39040 Note: RTR form must be submitted. Note: Online Submission Note: Maximum number of resumes per ITS63 Vendor: 2 Submission Deadline: 5/10/2019 04:00:00 PM EST Start Date: 5/20/2019 End Date: 11/19/2019 Client: Department of Transportation Descript.... (This job is for - Workflow Jobs in MA Boston Analyst - (in Boston, MA))    SQL Queries job openings in other states Jobs List NCDA CS - Technical Architect- Expert (728547) Create date: 03-Apr-2024 Remote start date :04/29/2024 End date :04/27/2025 submission deadline :04/08/2024 client info :NCDA&CS Description : ***This is a remote position, but the candidate has to be located in either the Eastern or Central time zones. .... (This job is for - SSRS Jobs in NC Raleigh Architect - (in Raleigh, NC)) DBHDS - Data Analyst 3 - (729231) Create date: 16-Feb-2024 Job Title: DBHDS - Data Analyst 3 - IN PERSON INTERVIEWS ONLY! (729231) Hybrid start date :03/04/2024 End date :06/28/2024 submission deadline :2/21/2024 client info :DBHDS Description : IN PERSON INTERVIEWS ONLY! No excepti.... (This job is for - Tableau Jobs in VA Richmond Analyst - (in Richmond, VA)) TAX - Jr Software Tester/QA Analyst 2 (727768) Create date: 16-Jan-2024 Hybrid start date :01/29/2024 End date :01/31/2025 submission deadline :1/18/2024 client info : TAX Description : Virginia Tax seeks a qualified person who works well with team with 1- 2 years of experience in the following: .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) Programmer Analyst 6 - 123865 Create date: 01-Nov-2023 Start date : 11/27/2023 End Date : 09/30/2024 Submission deadline :11/6/23 at 10am EST. Client Info :DIFS Note : * Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared so share screen if asked. Use of headphones is strongly discouraged. A screenshot photo.... (This job is for - Powerbuilder Jobs in MI Lansing Analyst - (in Lansing, MI)) Employee Data Support Specialist - 123524 Create date: 18-Oct-2023 Start date : 11/13/2023 End Date : At least 1 Years from projected start date Submission deadline : 10/25/2023 3:00:00 PM Client Info : MDES Note : * Onsite required. Do NOT submit candidates that want remote. Description : Provide support for data transfer and qualit.... (This job is for - TN3270 Jobs in MS Jackson Specialist - (in Jackson, MS))    SQL Queries job openings in MA Jobs List ITS63 Quality Assurance Analyst -SP Create date: 22-Apr-2020 Bid Number: BD-20-1003-1003C-1003L-50872 Note: Online or Email Submission Note: Total number of positions sought: 3 Note: Maximum number of resumes per ITS63 Vendor: 3 Submission Deadline: 4/29/2020 12:00:00 PM EST Start Date: 5/8/2020 End Date: 6/30/2020 Client: Executive of Administration and F.... (This job is for - job Jobs in MA Chelsea Analyst - (in Chelsea, MA)) ITS63 Senior Application System Analyst/Programmer -SP Create date: 12-Feb-2020 Bid Number: BD-20-1003-1003C-1003L-48581 Note: Online or Email Submission Interview: Initial contact by phone, interview may be in person Note: Total number of positions sought: 1 Note: Maximum number of resumes per ITS63 Vendor: 3 Submission Deadline: 2/19/2020 12:00:00 PM EST Start Date: 3/2/2020 En.... (This job is for - job Jobs in MA Chelsea Analyst - (in Chelsea, MA)) Atlassian Administrator - 50028 Create date: 22-Jul-2019 Description: Our client is a Large Tech Company specializing in the Energy/Utilities industry that is looking for an Atlassian Administrator to fill a 6 month contract to full time/perm position. Our client is currently seeking four innovative, adaptable, and results-oriented Atlassian Administrators to support and maintain Da.... (This job is for - job Jobs in MA Waltham Administrator - (in Waltham, MA)) ITS63 19ITSDD23 QA Analyst (1 Of 1) -SP Create date: 29-Jan-2019 Note: Total number of resumes accepted per vendor: 3 per posting Note: • This position may be filled prior to close date BID SOLICITATION NUMBER: BD-19-1036-EDU02-EDU02-34976 Submission Deadline: Start Date: 2/11/2019 End Date: 6/30/2019 Client: Executive Office of Education Descripti.... (This job is for - job Jobs in MA Malden Analyst - (in Malden, MA)) ITS63 19ITSDD15 QA Tester (1 Of 1) -SP Create date: 18-Dec-2018 Note: This position may be filled prior to close date BID SOLICITATION NUMBER: BD-19-1036-EDU02-EDU02-33940 Submission Deadline: 1/4/2019 3:00:00 PM Start Date: 1/14/2019 End Date: 6/30/2019 Client: Executive Office of Education Description: 1. CANDIDATE NAME: Bidders must provid.... (This job is for - job Jobs in MA Malden Tester - (in Malden, MA)) (Analyst: SQL Queries, SQL Server, SQL Technologies, Data Warehousing ETL MS Office in Boston, MA)

Featured Jobs Web Developer (Jobs in Lincoln, Nebraska) ASP.Net JavaScript Manager (Jobs in COLUMBIA, South Carolina) Cloud Manager (Jobs in Lincoln, Nebraska) Standard Engineer (Jobs in Dauphin County, Pennsylvania) SIEM PowerShell C/C++ Python Analyst (Jobs in COLUMBIA, South Carolina) - Consultant (Jobs in Bismarck, North Dakota) SOAP JavaScript XML Written Developer (Jobs in Nashville, Tennessee) Organizational Analyst (Jobs in Richmond, Virginia) Business Analyst Medicaid Manager (Jobs in Lansing, Michigan) Technical Administrator (Jobs in Bismarck, North Dakota)