Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
ETL Data Management SQL MS Excel Data Warehousing Data Mining Consultant
(Jobs i
 
Requirement id 19418
Job title Consultant
Job location in Manhattan, NY
Skills required Data Analysis, Data Modeling, ETL, Data Management SQL MS Excel Data Wareho
Open Date 25-Jun-2014
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
Apply
   Email Recruiter: coolsoft
Job Description Consultant: Data Analysis, Data Modeling, ETL, Data Management SQL MS Excel Data Wareho

Job Description

Gathers data for analysis purposes using complex data mining instructions/ scenarios.
Designs and develops SQL queries for extracting information, trends, insights and metrics from data stored in the database.
Well versed in using relational database management systems, specifically SQL Server.
Utilizes Trillium data profiling tool for analysis purposes and configures tool for specific data needs.
Defines and writes functional specification in support of the data quality requirements.
Perform Data Analysis/Data Profiling on key Master Data entities in order to report and plan data remediation and data cleanup activities
Create metrics and reports (ad-hoc and repetitive) to support data management, data quality and Data Governance programs

Job Experience
Detailed knowledge of Data Modeling, both relational and dimensional
Familiarity with ETL protocols
Strong analytical and data management skills
Extensive experience with SQL
Adept in MS Excel and report building tools
Exposure to Data Profiling and Data Warehousing Best Practices
Experience with developing entity and attribute business rules within the Trillium toolset.
Experience in data mining techniques, procedures and best practices.
Works with Data Owners and Data Analyst to understand the data for purposes of technical data analysis and to understand the query related requirements.
Has worked on large data set sets
Experience in supporting all aspects of Trillium Software, specifically Trillium Quality and Discovery components of TSS 14 or later versions on Linux platform. The person should have detailed technical knowledge of the tool suite, have the ability to setup new users and explain the intricate details about the tool to others. The person selected for this role will provide service and support for the tool as the primary focus of their time. Assignment to specific project teams will be made on an as needed basis.
Required Skills
A MS/BS degree in a technical field or related discipline preferred
2-5 or more years of experience using Trillium Software for analyzing large datasets.
2-5 or more years of demonstrated experience related to Data Analysis (gathering data Rules and Requirements, performing data analysis on a data warehouse and/or source systems, and implementation experience in a large-scale, multi-user environment, work with functional specs, use cases, test cases, test plans) working with users to tweak patterns and multi table complex rules
Self-motivated, team player
Excellent verbal and written communication skills.
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 19418 while calling.
 
Other jobs in NY: Albany (4), Bethpage (6), BUFALLO (1), Buffalo (6), Commack (4), Commack Long (1), Jericho (5), Long Island (4), Long Island City (2), Manhattan (5), Midtown NYC (1), New York (41), New York City (8), NYC (2),
 
 Data Analysis job openings in other states
Jobs List

Quality Assurance Analyst II - 148940
Create date: 29-Sep-2025
Start Date :10/27/2025
End Date :06/30/2026

Submission Deadline :10/6/25 at 4:00 PM CST

Client Info : DHS

Note:

* Onsite or Remote? Candidate MUST be a WI resident or willing to relocate to WI prior to starting the role at their own expense.

* Position is 100% remote within the state o.... (This job is for - job Jobs in WI Madison Analyst - (in Madison, WI))

Mainframe Developer Intermediate - 64848
Create date: 15-Sep-2025
Start Date :10/6/2025
End Date :10/31/2026

Submission Deadline : 09/19/2025

Client Info : Ne TRANS

Note :

* Position Location: On Site

* Candidate Must Be Local

* Local candidates preferred for onsite work in Lincoln, Nebraska (or must be willing to relocate).... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE))

DOAS HCM Training Specialist (774896)
Create date: 13-Aug-2025
Start Date :8/25/2025
End Date :04/30/2026

Submission Deadline :08/18/2025

Client Info : DOAS

Note:

* Agency Interview Type: Either Web Cam or In Person

* LOCAL CANDIDATES ONLY: DOAS participates in a hybrid work environment and telework is encouraged with some days in.... (This job is for - job Jobs in GA Atlanta Specialist - (in Atlanta, GA))

VSP - Help Desk Analyst 4 - (774531)
Create date: 08-Aug-2025
Start Date :9/1/2025
End Date :06/30/2026

Submission Deadline :08/13/2025

Client Info : VSP

Note:

* Please Submit your Best two candidates

* Candidates must be able to work on site.

* Local Candidates Strongly Preferred.

* Please submit your top .... (This job is for - job Jobs in VA NorthChesterfield Analyst - (in North Chesterfield, VA))

Business Analyst/Consultant IV - 143210
Create date: 30-May-2025
Start date : 07/28/2025

End Date : 06/30/2026

Submission deadline : 6/6/2025 4:00:00 PM

Client Info : ETF

Note:

* Interview Process: remote via MS Teams

* Duration: 6/30/2026, likely to extend

* Onsite or Remote? Must be a current WI resident. This position can work .... (This job is for - Stakeholders Jobs in WI Madison Analyst - (in Madison, WI))
 
 Data Analysis job openings in NY
Jobs List

Expert Business Analyst - 6911
Create date: 12-Jul-2022
Description:

Day-to-Day tasks

Work with Agency/Business Users to develop/document new business strategies and models.
Demonstrate up-to-date expertise in Information Systems and apply this to the development, execution and improvement of action plans by providing advice and guidance to others in the application of.... (This job is for - Business Analyst Jobs in NY Albany Analyst - (in Albany, NY))

Senior Software Developer - 6563
Create date: 04-May-2022
Description:

Day-to-Day tasks

Create detailed, comprehensive, and well-structured test plans, test scenarios, and test cases for manual as well as automated testing to address business use cases
Guide Development Team for Project including reviewing and reporting on Team progress and assigning Developers tasks JSON Jobs in NY Albany Developer - (in Albany, NY))

Expert Business Analyst - 5839
Create date: 13-Dec-2021
Description:

Day-to-Day Tasks include, but not limited to:

Work as a liaison among stakeholders in order to elicit, communicate and validate the requirements for changes to current business reporting requirements and policies for the development of new operational reports and analytics.
Conduct data analysis of bu.... (This job is for - ETL Jobs in NY Albany Analyst - (in Albany, NY))

Expert IT Specialist - 5363
Create date: 12-Aug-2021
Description:

Day-to-Day Tasks include, but not limited to:

Coordinate the activities of the project teams.
Estimates, performs and measures technical deliverables and activities for a CĂșram application and using Rational Rose.
Prioritizes and assigns work during all phases of the software development life.... (This job is for - Project Manager ITS Jobs in NY Albany Specialist - (in Albany, NY))

Senior .Net Programmer - 4682
Create date: 03-Mar-2021
On-site/Remote:
On-site

Description:

Responsibilities

Are you a Guru? Excited by what you do? We have a project with our client in Albany, NY that requires a Senior .Net Programmer.

Day-to-Day Tasks include, but not limited to:

The consultant will serve as a Programmer, utilizing M.... (This job is for - job Jobs in NY Albany Consultant - (in Albany, NY))
(Consultant: Data Analysis, Data Modeling, ETL, Data Management SQL MS Excel Data Wareho in Manhattan, NY)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us