Data/Business Analyst. Candidates will be writing technical and functional requirements so these candidates need to be able to understand DW environments; although they are not going to be doing any sort of development but they definitely need to speak the lingo and understand things like what dimensional modeling is etc. They are using SSIS (2008) for an ETL tool and Microstrategy for their BI tool. He has an immediate need for a BA that has worked in a data warehouse environment/ DW projects. This person has to be pretty technical, more of a Data Analyst ...View Job Details

Position: 1 Looking for a Data/Business Analyst. Candidates will be writing technical and functional requirements so these candidates need to be able to understand DW environments; although they are not going to be doing any sort of development but they definitely need to speak the lingo and understand things like what dimensional modeling is etc. They are using SSIS (2008) for an ETL tool and Microstrategy for their BI tool. He has an immediate need for a BA that has worked in a data warehouse environment/ DW projects. This person has to be pretty technical, more of a Data Analyst. Position: 2 The role will be working closely with Business Analysts, DBA’s, Data Modelers, and the Data Architect in an analytic role focused on understanding data, as it is implemented in existing applications and databases and at the level of requirements for new data. This role has key analysis responsibilities including data profiling, source system analysis, identification and definition of data transformation rules, analysis of data structures, and other activities in the area of how data is stored and moved throughout the application environment. ...View Job Details

Data Analyst Skills: property & casualty, ETL, BI Sun Prairie, WI 6 Months Phone Hire 2 to 5 years experience in data solutions including a combination of data requirements gathering, data documentation and mapping, data delivery and data quality assurance. Techniques applied should include some combination of direct experience in or exposure to: data processes, data modeling, data integration, database implementation, ETL development, business intelligence development, operational data store deployment, data warehouse deployment and data mart deployment. 1 to 3 years experience within the property & casualty insurance business including multiple lines of business/product types, multiple functional areas and the complete insurance life cycle with emphasis on claims. Demonstrated knowledge of or exposure to a database platform (DB2, MS SQL Server) and SQL language constructs, stored procedures or similar techniques. Demonstrated ability to communicate complex technical information to non-technical personnel both verbally and in writing. Scope of Work: The scope of this engagement is to assist in the collection of metadata necessary to support the conversion of data from our legacy claims systems to Guidewire's ClaimCenter. Specific activities will include: Provide guidance and serve as a resource in the collection of metadata elements to the Subject Matter Experts associated with each SoR. ...View Job Details

Hi, Wisdom Infotech is an award winning IT Services firm providing innovative IT Services for client across the globe. We are currently seeking a Teradata Analyst to assist our client’s projects and process. The Job Details are as follows:- Position Title: Teradata Analyst Location: San Jose, CA Duration: 12 + Months (Long Term Project) Skills: An ideal candidate should be with 8+ yrs of exp in · Teradata ( A certification would be a plus) · Data Analysis · Analytics · Data Warehouse · Business Intelligence BI · Site Catalyst Regards, Loha Wisdom Infotech ...View Job Details

NOTE : Please forward your resume to Job Position : Data Analyst Job Location : Madison, WI Job Duration : 6+ months Job Description: Client is looking immediate need for a Data Analyst with Property and Casualty Insurance experience. Skills: Property and Casualty Insurance, Claims knowledge Thanks & Regards Vincent Saxon Global Inc Phone ext 209 Fax Email : 1320 Greenway Drive, Suite 660, Irving, TX-75038 ...View Job Details

Title: Data Analyst Location: Sun Praire, Wisconsin 2 to 5 years experience in data solutions including a combination of data requirements gathering, data documentation and mapping, data delivery and data quality assurance. Techniques applied should include some combination of direct experience in or exposure to: data processes, data modeling, data integration, database implementation, ETL development, business intelligence development, operational data store deployment, data warehouse deployment and data mart deployment. 1 to 3 years experience within the property & casualty insurance business including multiple lines of business/product types, multiple functional areas and the complete insurance life cycle with emphasis on claims. Demonstrated knowledge of or exposure to a database platform (DB2, MS SQL Server) and SQL language constructs, stored procedures or similar techniques. Demonstrated ability to communicate complex technical information to non-technical personnel both verbally and in writing. Scope of Work: The scope of this engagement is to assist in the collection of metadata necessary to support the conversion of data from our legacy claims systems to Guidewire's ClaimCenter. Specific activities will include: Work with QBE America’s business and Strategy and Technology personnel to collect, document and verify data requirements for assigned data project tasks. Provide guidance and serve as a resource in the collection of metadata elements to the Subject Matter Experts associated with each SoR. ...View Job Details

Job Title : Systems Analyst with Databases Location: Bellevue, WA Duration: 6 Months contract Sureshot Placement Required Skills : Ability to collaborate with data architects and BI developers to translate requirements into technical specifications Determine and validate potential data sources, build validation plan, assisting with or building scripts, executing the scripts, and communicating results in non-production environment Experience in writing SQL and understanding of ETL Development Tools is a must Experience in logical and physical database design and implementation Experience using data warehouse or analytic tools for business purposes Experience with ad-hoc query development (Crystal Reports, Business Objects, SAS, or other) Experience developing reports using a reporting tool or through data extraction queries Demonstrates thorough working knowledge of UML documentation of various business process and modeling to build Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process decomposition, and Use Case Scenarios Looking forward to hear from you. Very Truly, Ben Smith Sr.Technical Recruiter CAT Technology Inc. Voicex 238 Fax Email: Gtalk : Yahoo : Website:  ...View Job Details

Role: Data Analyst Location: Madison, WI Duration: Long Term The key to getting an offer has always been extensive property and casualty insurance experience. Required: 5+ years of Data Analysis experience 5+ years of Data Warehousing experience 3+ years of Property and Casualty Insurance experience Ability to speak about multiple business-side functions like: claims, underwriting, billing, agencies, etc. _ Anusha Resource Executive Net2Source Inc., MBE Certified - NMSDC SBE Certified (State of NJ) Board Ext.: 436| Fax Email: ...View Job Details

Consultant will help client to place the utilization management data in order. The Data Analyst must have health data experience and experience in report & analysis as well. ...View Job Details

Job Title: Data Analyst with P&C Insurance. Location: Madison, WI Duration: 6+ Months THE KEY TO GETTING AN OFFER HAS ALWAYS BEEN EXTENSIVE PROPERTY AND CASUALTY INSURNACE EXPERIENCE. Required: 5+ years of Data Analysis experience 5+ years of Data Warehousing experience 3+ years of Property and Casualty Insurance experience Ability to speak about multiple business-side functions like: claims, underwriting, billing, agencies, etc. ...View Job Details

Hi, Greetings from Sriven systems!!! I have an immediate requirement of Data Analyst at NYC, NY. Please go through the below requirement and send me the Profiles…. Thank you Title: Data Analyst Location: NYC, NY Duration: 1 Year Experience: 8+ Years Description: SUMMARY: Work with user groups to define system and reporting requirements, communicate requirements to IT, analyze source system data, and validate system outputs, processes and reporting data. Develop queries against various data sources to analyze and report data. Identify data trends and data abnormalities. KEY DUTIES: -Gather, analyze, and document governmental programs data and reporting requirements and translate these requirements into functional and technical specification. Make recommendation related to proposed technical solution 30% of time -Lead the effort to develop programs and queries to analyze source system data, systems outputs and reporting data. Identify areas of improvement and make recommendations. Work with the data modeler to create data mapping specification 30% of time -Work closely with the Information management groups to develop, test, and validate systems and reports 20% of time -Attend and assist in facilitation of meetings between users and IT 10% of time -Document business, technical and systems requirements 10% of time Ensure that the business, systems, and reporting requirements for the Governmental Programs groups are identified, accurate and properly communicated to IT Ensure that the systems solutions produced meet Governmental Program user requirements. REQUIRED: Extensive experience reporting and analyzing data. Experience working in a data warehousing environment and using Business Intelligence Experience in the Healthcare industry Ability to develop and general queries and reports using SQL. and SAS Strong experience analyzing and documenting business requirements Ability to effectively communicate to business users and IT Skills: HIPPA 5010, Data Analysis, SQL,SAS Thanks & Regards, Chandhu. Sriven™ Systems, Inc [MBE Certified Company] 560 Broad hollow Rd., Suite 311, Melville, NY 11747 T Ex 304| F | | | ...View Job Details

Consultant will help client to place the utilization management data in order. The Data Analyst must have health data experience and experience in report & analysis as well. ...View Job Details

Title: ETL/ Informatica Data Analyst Duration: 6-12+ months Location: Fort Lauderdale, FL Phone Hire. Summary: Responsible for translating business needs into technical solutions and specifications, and designing relational and dimensional models to meet project requirements. Develop, manage, and update conceptual, logical, and physical data models in a multi-tiered Data Warehouse environment. Possess proven skills in both dimensional and relational data modeling and have a clear understanding of how ETL (Extraction, Transformation and Loading) and BI (Business Intelligence) tools influence the final database design. Responsible for understanding source system database structures and underlying data. Perform data profiling, analysis, and knowledge transfer expertise to project team members. Design, develop, maintain, test, reverse engineer, and modify ETL (Extraction, Transformation and Loading) processes within the context of Business Intelligence and Data Warehousing solutions. Possess proven skills and sound knowledge of ETL/BI processes and best practices and be experienced in development activities. Collaborate with team members throughout the SDLC to perform model reviews, data reviews, issues resolution, and assure the successful delivery of the Panel Reprogramming solution. Candidates should have no less than 5 years of experience with Data Analysis, Database Design (ERWin or Embarcadero on Oracle platform), and ETL Development using Informatica Power Center. Duties and Responsibilities: Interview business users and/or technical SME’s to obtain source system information for new integration or analytic application. Perform source system data profiling including structure, data, and relationship discovery. Design conceptual, logical, and physical models to meet project requirements. Evolve existing models to meet new and changing business requirements. Consolidate and deliver data centric project artifacts including data profile findings, data quality requirements, business metadata (table/column), source to target mappings (data lineage specifications), data transformation logic, source system specification, operational requirements (data retention, archiving, and purge), etc Conduct model reviews with DBA’s and project team members. Develop, design, maintain, test and install ETL (Extraction, Transformation and Loading) and BI processes. Experience: Minimum 7 years of hands-on experience delivering IT solutions Minimum 5 years of experience in designing integration and analytic solutions. Minimum 5 years of experience in designing and implementation of ETL processes using Informatica suite of products A sound understanding of BI and Data Profiling and Quality Tools, preferably Business Objects and Trillium Discovery and Data Quality respectively Strong Oracle database experience is required. Excellent SQL and DDL / DML skills a must. Oracle performance optimization skills strongly preferred Experience with enterprise data integration and data strategy programs is a plus Proven knowledge of Data warehousing theories & methodologies Skills: Demonstrated knowledge and experience in the delivery of Business Intelligence, Data Warehouse, and Data Integration projects Ability to translate business needs into technical solutions Customer Focus - Is dedicated to meeting the expectations and requirements of internal and external customers; gets first-hand customer information and uses it for improvements in products and services; acts with customers in mind; establishes and maintains effective relationships with customers and gains their trust and respect. Planning/Program Management - Accurately scopes out length and difficulty of tasks and project segments; sets objectives and goals; breaks down work into the process steps; develops schedules and task/people assignments; anticipates and adjusts for problems and roadblocks; measures performance against goals; evaluates results. Team Building - Blends people into teams when needed; creates strong morale and spirit in his/her team; shares wins and successes; fosters open dialogue; lets people finish and be responsible for their work; defines success in terms of the whole team; creates a feeling of belonging in the team preferred Cross Functional Collaboration – Collaborates with cross functional teams who are situated in disparate geographical regions. Participates as a subject matter expert in other functional programs and projects. Thanks & Regards? Somya Garg È x 122 | | * ...View Job Details

Job Title : Systems Analyst with Databases Location: Bellevue, WA Duration: 6 Months contract Sureshot Placement Required Skills : Ability to collaborate with data architects and BI developers to translate requirements into technical specifications Determine and validate potential data sources, build validation plan, assisting with or building scripts, executing the scripts, and communicating results in non-production environment Experience in writing SQL and understanding of ETL Development Tools is a must Experience in logical and physical database design and implementation Experience using data warehouse or analytic tools for business purposes Experience with ad-hoc query development (Crystal Reports, Business Objects, SAS, or other) Experience developing reports using a reporting tool or through data extraction queries Demonstrates thorough working knowledge of UML documentation of various business process and modeling to build Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models, Context Models, Event Modeling, State Modeling, Process decomposition, and Use Case Scenarios Looking forward to hear from you. Very Truly, Ben Smith Sr.Technical Recruiter CAT Technology Inc. Voicex 238 Fax Email: Gtalk : Yahoo : Website:  ...View Job Details

Data Analyst Location: Agoura Hills, CA Duration: Long Term Contract In-person interview required (GC,EAD & CITIZENS ONLY) - Develops, enhances, tests, supports, maintains and debugs software applications that support Data Quality functions in Information Management area. - Participates in the design, development and implementation of Data Quality rules and Data Profiling, often using IBM IIS products like Information Analyzer etc. - Experience on IBM IIS tool suite 8.x or above versions is required and experience with DataStage is a plus. - Utilizes in-depth knowledge of technological alternatives and business system requirements to recommend innovations that enhance and/or provide a Data Quality measurement solutions to the organization. - Typically requires 5-7 years of hands-on experience. - Information Analyzer experience a must, experience with data quality rules a huge plus - DataStage experience a must - Metadata workbench and Business Glossary experience huge plusses - Column analysis experience - Data quality analysis background ...View Job Details

RESPONSIBILITIES & DUTIES: The following application tasks are expected to be executed by the Data Warehouse systems/application analyst. All tasks will involve some degree of up front analysis prior to development or execution, as well as several phases of system and user acceptance testing. These tasks/skills do not include database administration support or technical infrastructure support tasks, as these responsibilities fall under a different support area within the SCDOR IRM organization. Work with SCDOR Operations & Support team to set up the new “Model Office/User Acceptance Test” environment, including virtual machines (servers) and databases. Install the PW software in successive environments, from “Sandbox” to “Development” to “Model Office/User Acceptance Test.” Apply release upgrades in all environments as they become available. Coordinate testing efforts in all environments; log defects and track until resolved. Create work items for other Data Warehouse team members as appropriate. Testing must include, at minimum: oPreparing and loading of data into the Data Warehouse using the Extract, Transform, and Load (ETL) tools. oSetting up and running the PW Associate and Grow (A&G) offline process for data cleansing and matching. oDevelopment of tax calculations via the PW “Tax Calc” component. oCreating and executing “views” to be utilized by the PW audit selection process. oTesting all application level configurations and parameters for the PW product. In addition to items listed above, these include various system reference codes, workflow rules, scoring parameters, correspondence templates, as well as configuration of various 3rd party products such as Group 1, SSA, and DT Studio. oTesting of PW offline processes.These include primary indicator, legacy system gateway, nightly data refresh process, and collections scoring. Work with senior RSI onsite support and the RSI Solutions Center to diagnose and resolve issues, and to apply patches and hot fixes as needed. Prepare final package of software and data for migration to Production environment. Ensure that all installation tasks, test results, and component configurations are fully documented. REQUIRED SKILLS: The successful candidate will have, at minimum, the following skills: Experience and expertise in software installation and implementation. Experience and expertise in software testing; familiarity with testing methodologies and preparation of test plans. Experience and expertise in isolation and diagnosis of software defects, including use of diagnostic tools such as monitors and traces. Experience and expertise in gathering and analyzing business user requirements. Proficiency in Java development. Experience and expertise in SQL, including development of T/SQL queries and data manipulation. Expert knowledge of databases and relational database concepts.Experience with SQL Server 2005 required. Experience with Windows XP operating system and the Windows 2003/2008 server environment. Experience with Data Warehouse concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. Ability to communicate clearly and concisely, both orally and in writing. Ability to establish and maintain good working relationships with business users, management, vendors, and peers. Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. Understanding of deployment methodology concepts including design, build, testing, and deployment. The individual will operate with very limited supervision, within standards and processes established for the SCDOR Data Ware ...View Job Details

Description: Need a technical analyst that can define Source System to External Interface mappings. Define data validations, define error messages, define use case. Participate in design sessions with technical teams, and write interface specification documents. Thanks Shantanu Sharma Direct ...View Job Details

. Receives conceptual data flow from data architect as input to developing data interface design . Performs data analysis to determine data quality issues . Develops functional design of data interfaces and data conversions . Creates plan for ETL and conversion tech design, build and implementation . Inspects data interface and data conversion technical designs to ensure adherence to functional designs ...View Job Details

Must Haves: - Data Modeling - ETL - Informatica - Embarcadero (data base tool) - Create tables - Strong Oracle Database experience - Strong relational and dimensional data modeling and database design - data definition language (DDL) and data manipulation language (DML) Day to Day: This candidate will work on a separation project. They will be working to take data from 3 different sources, design the data, build tables, then pull the data and filter the information. They will be using Embarcadero as the main data modeling tool on this project. ...View Job Details

Data Quality Analyst/Lead Location: Charlotte/ Cary,NC Duration: 6 Months Contract to hire Who has a good experience with the below skills. Information Analyzer Datastage Trillium SQL ...View Job Details

Business/Data Analyst with exp in SQL Skillset ...View Job Details

Data Analyst Location: Raleigh, NC 6 months + Data Analyst - Experience in handling large Volumes of Data with MS Excel or MS Access with Business Reporting using the above tools - Need Strong experience in Business Analysis and reporting using the above tools - Experience on Business Object - Previous Cisco experience a Plus ...View Job Details

Sr. ETL Developer Suitland, MD We currently have a Long Term (Multi Year) Contract opportunity for ETL Developer with our federal client located in Suitland, MD. Responsibilities will include, but are not limited to: Data modeling and database design of relational and multi-dimensional data models, with database schema focused on functionality and performance Define and implement Extract/Transformation/Loading standards and rules. Design, develop and implement Extract, Transformation and Load (ETL) processes, programs and scripts using structured software development method. Develop data/metadata models and technical specifications using standard modeling techniques Define technical standards; evaluate alternative protocols, tools and standards. Provide subject matter expertise in the maintenance of existing and creation of new Interface Control Documents (ICDs Consult with analysts, data providers, and business operations staff to understand and elaborate data dissemination requirements and propose technical solutions Identify and develop prototypes to address requirements (both functional and non-functional) Analyze database issues and provide recommendations as required to support the Development and System Administration teams in the design, development, testing, and tuning of the supporting applications, queries, and or, the relational Oracle data base. Conduct root cause analysis and resolve production problems Create documentation of implemented ETL processes for knowledge sharing and hand-off Develop impact assessments including level of effort estimates for design and implementation of new solutions or system enhancements Provide technical leadership and direction to junior developers in implementing technical solutions Qualifications: Significant experience with designing and implementing custom back-office ETL systems for complex and large size data applications Experience with enterprise-scale relational Data Models and Data Warehouse, including both relational and dimensional models and the use of standard data modeling tools, preferably ER/Win Experience with diagramming and documentation requirements, including ERD, Data Dictionary, Data Flow Diagrams Experience with modeling and managing metadata Experience with configuration management practices and procedures Experience with Oracle 10g Significant experience with developing Oracle PL/SQL stored procedures and anonymous blocks for data conversion purposes Experience with Perl and Korn shell scripting Knowledge and understanding of approaches for business intelligence, data marts Demonstrated technical leadership in developing solutions for complex problems Experience with providing technical leadership and direction to less experienced members of the team Experience with modeling data using XML desired Experience with XLST, XPath and XQuery, DOM and SAX parsers desired Experience with SAS, ArcGIS, or Endeca information access software desired Candidate must be able to quickly diagnose and debug technical challenges through reading code and supporting technical documentation. Candidate should have very strong teamwork, interpersonal and written/verbal communication skills, ability to work well independently and as part of the team. Candidate should be able to work with analysts, business operations staff, data providers, developers and DBAs. Candidate should have 5-10 years of progressive experience in the area of ETL program development and operations Tools: Erwin, Putty, Oracle client 10g, Rational ClearQuest/ClearCase, Quest Software TOAD, PL/SQL Developer, SAS Programming Languages: PL/SQL, Perl, Korn shell, XML, XSLT, SAS (desirable), ArcGIS (desirable), Endeca (desirable) Industry Knowledge: The ideal candidate will have an in-depth knowledge of: data analysis, including demographic, economic, and geographic data Work Environment: Must be prepared to occasionally work late on weekday evenings (1+ times week) and occasional weekends. Must be able to work independently with customers. Must have excellent verbal/written communication skills. If interested please email your MS Word resume to and reference in the email Subject IJID_ETLMD_0110 and include the completed skills-matrix in the body of your email. Full name: Degree Major: Total IT exp: Total Data Modeling exp: Total ETL Development exp: Total Oracle 10g exp: Total PL/SQL exp: Total Perl and Korn shell scripting exp: Total Erwin exp: Total Putty exp: Total exp in XML/XSLT/XPath: Total Rational ClearQuest/ClearCase exp: Total SAS exp: Are you an US Citizen/Green Card Holder/Others? If H1B, Start of H1B Visa in USA (MM/YYYY): Day #: Evening #: Cell#: Availability: Current City and State: About INSYS For 16+ years, INSYS has been providing Federal, State & Fortune 500 companies tailored IT solutions that drive customer success and, at the same time, provide a commitment to our consultants to offer a rewarding career. The core strength of our company is the technical ability. We take the time to understand our customers IT environment and challenges to provide the right talent with the required technology integration skills to solve their challenges. Our objective is to build a clear sense of purpose and strong relationships with our clients and consultants in dedicated technologies so that the consultants can then aspire to be the technology expert whose quality services set the standard by which others are measured and so that our clients ask for them by name. INSYS is a GSA Schedule 70 contract holder and hold prime contracts with Federal and State Agencies and prime vendors for Fortune 500 companies ...View Job Details

Position: Senior Data Warehouse business analyst Duration:6+ Months Location: Chapel Hill, NC Job Purpose Analyzes data brought into the data warehouse from transactional system and vendor extracts. In addition, this role will work with the business and data stewards to identify and document business rules that need to be applied to this extracted data. Document source and table specifications to be used by ETL developers and Quality Assurance Analysts in the construction phase of a project. Revises and/or creates new data integration related standards that are compliant with industry standard. Major Job Functions/Components Identifies opportunities to improve efficiency of Data Analyst tasks to facilitate completion of projects within the allocated time and budget. Assists the Data Integration Architects in the determination of Enterprise Information Model entity and attribute definitions to ensure the accuracy of the data model in relation to the business terminology. Revises existing data integration related standards or creates new standards that are current and compliant with various industry standards. Signs-off on Data Integration Analyst peer reviewed documents to maintain quality and to comply with standards. Provides project-specific Data Integration Analyst coordination to serve as the single point of contact and eliminate redundancy. Interfaces with the Project Manager and ISDS Management on smaller projects when assigned to ensure resources needed to move through the Service Development Life Cycle process. Mentors and provides input to performance reviews of Data Integration Analyst I’s and II’s to achieve a consistent review process. Assists the Project Manager in developing the project schedule as it relates to Data Integration Analyst activities, dependencies and timelines to facilitate accurate project schedules. Participates in project risk assessment to identify potential obstacles ahead of time. Accountable for Data Integration Analyst related deliverables and responsible for the deliverable’s quality. Hiring Requirements/Qualifications Education/Experience Bachelor’s Degree 5 years experience as a Data Analyst In lieu of degree, 7 years experience as a Data Analyst Professional Certification Hiring Preferences Additional Education/Experience Preferences Experience in data integration and/or data warehousing preferred Experience in migrating data from one system or platform to another preferred Experience in Health Care preferred Experience working on a Teradata platform preferred Soft Skills/Abilities: Ability to apply advanced SQL skills required Ability to interpret and correct analysis performed by others Ability to analyze and resolve highly complex problems Adaptable to changing business needs Strong customer focus Accountability for results Interpersonal skills to build working relationships Professional Certification Working Conditions This position participates in an on-call rotation schedule. Some evening and weekend hours required. ...View Job Details