REPLY TO: [email protected]
*BI Data warehousing Consultant (8 years of experience at-least)* *Emeryville, CA* *6 month Contract* *Job Summary*: Designs and validates databases, data flows, and integrations between operational data sources and downstream consumers. Responsible for preparation of system requirements, analysis, and design throughout the data warehouse implementation. Responsible for performing highly complex systems process analysis, design, and simulation across multiple platforms and/or cross-function in business areas. Reviews data loaded into the data warehouse for accuracy. Performs process improvement and re-engineering, with an understanding of technical problems and solutions as they relate to the current and future business environment. Responsible for developing innovative IT solutions for risky and demanding business situations. This is a senior role and may function as a team leader and provide procedural and technical guidance to less experienced systems analysts. Will function as a specialist in a particular aspect of systems analysis and as an integrator of analysis and design across technology platforms, business areas, or locations. *Essential Functions* * Develop data warehouse process models, including sourcing, loading, transformation, and extraction. * Create or implement metadata processes and frameworks. * Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. * Design and implement warehouse database structures. * Develop data extraction procedures from other systems, such as administration, billing, or claims. * Maintains standards, such as organization, structure, or nomenclature, for the design of data warehouse elements, such as data architectures, models, tools, and databases. * Work with business partners to develop business rules and business rule execution via stored procedures, middleware, or other technologies. * Map data between source systems, data warehouses, and data marts. * Collaborate with management, business partners, analysts, developers, technical resources, and Application Support team to support audit/environmental health needs. * Direct and engage in audit activities, including contributions to functional design, prototyping, build, test and audit documentation as needed. * Create and document best practices guidelines based on department requirements and industry standards. * Conducts quality assurance activities such as peer reviews. * Responsible for verifying accuracy of data, testing methods and the maintenance and support of the data warehouse. * Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing. * Has the openness and the willingness to learn new skills. *Knowledge/Skills/Abilities*: Expert (can teach/instruct others) * in SQL * in relational database concepts * ability to design and implement scalable solutions * interpersonal skills * written and verbal communication and decision making skills * ability to communicate effectively with both technical and non-technical personnel. * analytical, problem solving, negotiation, issue resolution and facilitation skills are required *Experience (requires little direction)* * with composing functional requirements, detailed technical specifications, and test cases for new or modified projects * with and understanding of data sources (e.g., 3rd party RDBMS, MS access, SQL server, Oracle, and Teradata) * with ETL tools and data integration (e.g., Informatica, SSIS) * with Business Intelligence * with Master Data Management * with XML * with SOA and Web Services * with executing deliverables using Agile * with Data Governance *Knowledge (may need to be taught but already understands the concepts)* * of Salesforce.com and SaaS products * of data virtualization * of APIs *Education & Experience / Licenses & Certification* * Bachelor's degree in computer science/data processing or equivalent * 5+ years IT experience * 2 years ETL Experience * 2 years in operational data * 1 year in master data management * 1 year in data analysis and BI Tools/Reporting REPLY TO: [email protected] *Thanks & Regards,* *Vipin Kaushal* [image: cid:[email protected]] 20, Industrial Park Drive, Nashua, NH-03062. Ph: 603-324-4011 E-mail: [email protected] <[email protected]> Website: www.universal-sw.com *G-Talk: **click2vipin || Yahoo IM: click2vipin*
