NEED Data Warehouse Analyst(Need US Citizen/GC ONLY)

Hi,

Hope you are doing great.

Please find the requirement below and send me matched resumes to  rajesh@spgamerica.com  (OR) 732-343-7688 x 3049 .

 

Job Title : Data Warehouse Analyst

Location: Bloomington, MN
Duration: 6 months

 

Need US Citizen/GC ONLY

ACCOUNTABILITIES:

·  Gather functional business specification requirements from business and users

·  Translate functional business requirements into data design and technical specifications that adhere to the architectural framework

·  Develop technical specification for integration components and collaborate closely with ETL developers on ETL map development and testing

·  Participates in design reviews, the quality assurance and testing process, and follows the defined SDLC process

·  Performs a technical data role and drives tasks to conclusion

·  Troubleshoots and resolves technical challenges within timelines and budget

·  Collaborates with interface teams and business owners to control scope and makes necessary decisions to complete the project on time

·  Follow the HealthPartners Data strategy with regard for the Enterprise Data Warehouse architecture - including but not limited to the Research, Health Plan and Clinical Care Delivery

·  Follow Data Warehouse standards, policy, and processes for HealthPartners Enterprise Data Warehouse architecture in regards to the development of the Research Data Warehouse

·  Ensure expected requirements are met according to HealthPartners standards and principles

·  Develop data models and data designs for Enterprise Data Warehouse deliverables with Data Modeler and Data Architect

·  Performs other duties as assigned

REQUIRED QUALIFICATIONS:

·  Bachelor's degree or equivalent experience

·  Minimum 3 years of experience in designing & developing logical & physical data model using data warehouse methodologies, including Star schema - Star-joined schemas, conformed dimensions data architecture, early/late binding techniques, and data modeling

·  Hands-on technical knowledge of Data Warehouse Architecture, ETL, Database & SQL performance tuning

·  Experience with Data Modeling Tools such as Erwin, Embarcadero

·  Solid understanding of and experience in ETL (extract, transform, load) processes

·  Hands on experience in Oracle 11g (features, functions, & utilities)

·  Excellent knowledge of SQL: PL-SQL, T-SQL, SQL scripting

·  Technical specification development experience

·  Ability to estimate data development efforts

·  Ability to manage tasks and work independently

·  Strong documentation and diagramming skills

·  Excellent verbal and written communication skills

·  Problem solving skills

·  Patience and strong customer service skills

·  Multi-tasking ability

·  Interpersonal communications skills

 

PREFERRED QUALIFICATIONS:

·  Understanding of data models, staging, landing and data cohorts, ODS, OLAP, multi-dimensional analysis, and various schemas

·  Experience with successfully demonstrating the ability to create industry proven standards, models and concepts that meet the needs and requirements of the Management team

·  Experience using ETL Tools such as SSIS, DataStage, Informatica

·  Hands on experience in SQL Server 2012 (features, functions, & utilities)

·  Experience with large / complex data warehouse environments preferably in a clinical care delivery environment

·  Hands on experience in Data Warehouse Data Analysis (Source Systems), Data Architecture, Data Modeling, and Data Propagation design and specification

·  Solid Knowledge of Dimension Modeling and Data Warehouse concepts

·  Good understanding of Query optimization technique used in Data Warehouse domain

·  Health Care Research experience

·  Experience working with healthcare related data and applications including but not limed to Health Plan and Clinical Care Delivery

·  General knowledge about the health care industry, understanding of underlying business functions

·  Knowledge and/or experience with Cache and Microsoft SQL Server database technologies

·  Experience with Data Quality tools & processes

·  Knowledge of data warehouse software development lifecycles (SDLC) including Project Management and BI analytics using Lean and Agile

Thanks for your Time and Support

Rajesh | Technical Recruiter

Software Programming Group

15 Corporate Place South, Suite #421, Piscataway, NJ - 08854

Tel: 732-343-7688 x 3049  || Fax: 732-343-7689

Email: |rajesh@spgamerica.com | URL : www.spgamerica.com

Hangout:bvrajeshgowd

IT Services ||  Consulting

USA || INDIA

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at https://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.