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 ---    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 VITA Market Research-Financial Analyst (728526) Create date: 29-Jan-2024 Hybrid start date :02/12/2024 End date :02/12/2025 submission deadline :2/1/2024 client info :VITA Description : *Local Richmond, VA candidates required for onsite work *Candidates must work onsite 3 days a week with 2 remote job Jobs in VA Richmond Analyst - (in Richmond, VA)) VDOT Business Analyst With Agile/Scrum (726886) Create date: 16-Jan-2024 Hybrid start date :01/29/2024 End date :06/30/2024 submission deadline : 1/19/2024 client info : VDOT Description : **candidate must be able to come to Richmond, VA occasionally **candidate must have experience working in Agile/Scru.... (This job is for - Wireframes Jobs in VA Richmond Analyst - (in Richmond, VA)) VDOT Senior Power BI Developer (723760) Create date: 14-Nov-2023 Hybrid Start date :12/11/2023 End date :06/30/2024 Submission deadline :11/17/2023 Client info :VDOT Description : *Local candidates only please *Candidate must also be able to work onsite 2-3 days/week. *Contractor will be r.... (This job is for - job Jobs in VA Richmond Developer - (in Richmond, VA)) Business Analyst Sr - 61540 Create date: 03-Oct-2023 Start date : 11/01/2023 End date : 11/01/2024 Submission deadline : 10/11/2023 Client info : TN EC Note : * Position Location : Hybrid Description : Analyze and document business requirements and processes related to publ.... (This job is for - UX Jobs in TN Nashville Analyst - (in Nashville, TN)) GA TECH IT Business Analyst 2 (721168) Create date: 26-Sep-2023 Remote start date :10/23/2023 End date :04/19/2024 submission deadline :09/29/2023 client info :Georgia Tech - OIT Description : The Business Analyst will act as a key link between business stakeholders and technical teams, facilitatin.... (This job is for - Tableau Jobs in GA Atlanta Analyst - (in Atlanta, GA))    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)

Featured Jobs Business Analyst SDLC Product Consultant (Jobs in Lincoln, Nebraska) Business Analyst Project Architect (Jobs in Lincoln, Nebraska) System Analyst (Jobs in Lincoln, Nebraska) UAT Analyst (Jobs in Lincoln, Nebraska) ASP.Net JQuery Azure Developer (Jobs in Des Moines, Iowa) Antivirus Cisco Writing Specialist (Jobs in Raleigh, North Carolina) Azure Administrator (Jobs in Jackson, Mississippi) Help Desk Troubleshooting TechLead (Jobs in Jackson, Mississippi) VDI VPN Architect (Jobs in Raleigh, North Carolina) Patching Dataverse Engineer (Jobs in Madison, Wisconsin)