Job Location: Portland, OR
Project Duration: 9-12 months
Detailed JD
· As a member of the Client's Data Architecture & Reporting (DAR) team, the BI/Data Warehouse Data Analyst will perform requirements gathering and system analysis, data analysis, data mapping, Logical Data Modeling, functional design, and data quality improvements.
· This individual will be working closely with end users, ETL developers, Data Modelers / architects, Report Developers and Functional teams.
· Perform business analysis to capture data and reporting requirements and translating to technical specs for the enterprise data warehouse
· Perform extensive data analysis and develop data mapping and functional solution design documents for ETL developers
· Works with the DAR Team and other IT teams to ensure feasibility of design and clarify user requirements
· Performs source data model / data analysis, and target EDW data model / data analysis
· Capture business rules and builds physical design document to meet user requirements
· Work with Data Modelers and DBA's to create/update EDW data models
· Understand and Interpret logical design document and data model diagrams to understand requirements to build physical design document
· Effectively communicate the functional design to developers and confirm the same with the business analysts team
· Document overall business processes and data/information flow. Suggest and implement process improvement and data collection opportunities. ? Functional testing of reports and ETL data auditing
· Design and maintain SharePoint website to enable collaboration of various required data deliverables.
· Provide user training including creation of training documentation.
Other responsibilities as necessary
· Good knowledge and experience in understanding logical mapping and data model to build Physical Design documents
· 3-5 years of extensive hands-on experience with all aspects of the BI/DW Life Cycle
· Working knowledge of MS SQL Server & Oracle data structures preferred
· 2-3 year of experience in one or more BI tools (Cognos, Microsoft Reporting, etc)
· Experience in implementing a data warehouse; understanding of Inmon or Kimball DW methodologies
· Strong communication and presentation skills
· Strong data modeling skills (normalized 3rd NF modeling and dimensional modeling)
· Demonstrated project management skills
· Must be detail and process oriented
· Ability to work under pressure, adapt to changing environment, and multi-task
· Possess a collaborative working style and the ability to work independently in a team environment
Thanks & Regards
Ankur Bhatia
E : ankurhmg@gmail.com
You received this message because you are subscribed to the Google Groups "CVMSCRM" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cvmscrm+unsubscribe@googlegroups.com.
To post to this group, send email to cvmscrm@googlegroups.com.
Visit this group at http://groups.google.com/group/cvmscrm.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment