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 NCDIT - Applications System Analyst (751874) Create date: 25-Nov-2024 No of Submissions : 2 Start date : 12/02/2024 End Date : 06/30/2025 Submission deadline : 12/03/2024 Client Info : NCDIT Note: * Agency Interview Type : Webcam Interview Only * Remote Description : · The primary purpose of this position is to.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Programmer Analyst 6 -134720 Create date: 06-Sep-2024 Bid Limit Per Vendor : 1 Start date : 10/07/2024 End Date : 09/30/2025 Submission deadline : 9/12/2024 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 headphone.... (This job is for - Powerbuilder Jobs in MI Lansing Analyst - (in Lansing, MI)) NCDIT - Applications System Analyst (735593) Create date: 18-Jun-2024 * Remote No of Submissions : 2 Start date :06/01/2024 End Date :10/29/2024 Submission deadline :06/20/2024 Client Info :NCDIT Note: * Webcam Interview Only Description : · The primary purpose of this position is to work in partnership with exte.... (This job is for - Jira Jobs in NC Raleigh Analyst - (in Raleigh, NC)) Programmer/Developer -62703 Create date: 08-May-2024 No of Submissions : Start date : 06/01/2024 End Date : 06/01/2025 Submission deadline : 05/20/2024 Client Info : CT DCF Position Location : Hybrid Description : ------------------------------------------------------ The Department of Children and Families depends on th.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) 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))    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 Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)