*Job Title* *BI Architect*
*Project Location* *Los Angeles CA* *Duration* *6 months /Contract* * Skills Required and Job Description:* Job description: The BI Architect defines and maintains both vision and guidelines by encapsulating significant architectural best practices for future state systems that align with Enterprise Architecture roadmaps to enable business success. Establish and formalize standards and guiding principles necessary to define and build business and data models to integrate with ETL and Application Interfaces along with data quality management solutions. Able to construct and analyze both functional and business requirements and design solutions based on existing BI solution tool sets. Highly skilled in profiling the data sources and conceptualizing. Familiar with Big Data stack is desired. Highly skilled in driving enterprise standards for report design, development and deployment into BI Platform in compliance with Industry and SPE Security best practices and data flow model Media & Entertainment experience is a plus. Teradata and Erwin experience is a must. Experience in Master Data Management, HADOOP and MapR technologies is an added skill set. Familiarity with BI SDLC is required. *Responsibilities include:* • Interacting with Business Users/ Business Relationship Managers to understand the BI needs • Identify the right data sources / data completeness to meet the BI needs • Data profiling to build the entity relationships across multiple sources • Build conceptual and logical data models based on the BI needs • Develop and maintain Business Glossary across the organization LOBs • Recommend Data Quality Management methodologies for various projects • Develop optimized database design to achieve acceptable performance by tuning views, tables and indexes for proper response time –rollup to Teradata in depth skillset (see below) • Provides consultation to ETL teams on the data load strategy • Identify the right End User Reporting/Strategy solutions. • Maintain the data lineage for the data acquisitions and reporting done *Key outputs include:* • Data entity relationship and models for new data sources • Data integration solutions for syndicate data with internal data • Reporting recommendations considering the analytical nature of the BI solutions • Recommend best practices to manage Data Quality and Data integrity • Contribution of documentation to IT knowledge database *Core Responsibilities:* 25% 1. Work with Business Users and IT team to gather the business requirements in BI space and convert these into functional and technical requirements 25% 2. Data profiling, building conceptual and logic models, delivering effective and efficient physical models 20% 3. BI Strategy around data acquisition for integrating transactional systems or syndicate/industry data into Enterprise Data Warehouse or DataMart. 20% 4. Maintain the Business Glossary, Data Lineage and a governance process for Data Quality Management 5% 5. Assist reporting teams and Business Users in designing and building reporting solutions 5% 6. Evaluation of the latest BI tool set that fits or enhances the existing SPE BI tool stack. *Qualifications:* • 10+ of years of IT work experience and 5+ years in the similar role of BI Data Modeler/Architect. Any Media & Entertainment experience is an added plus • Any Teradata or BI related Certification is a plus. • Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models) • Data modeling tools – Erwin is a must and familiarity with ER studio, Visio and Embardigo • Data Warehouse database platforms – Teradata is a must and any experience with EDW platforms like Exadata, HP blade or Netezza or Greenplum is and added advantage. • Experience with Business Objects/Tableau and any BI Reporting tools is required • Knowledge of BI tools like PowerBI is a plus and any familiarity with Tools that interact and interface with Big Data is a plus; such as Alteryx • Knowledge and experience of any data profiling tool is required • Familiar with any major ETL tools is required; DataStage / Informatica, Talend • Experience with any Data Quality Management full life cycle is an added advantage. • In depth hands on experience with SQL programming skills • Both Traditional RDBMS and Document Oriented databases • Excellent Analytical skills • Excellent communication skills with both business and technical customers • Demonstrate a high level of integrity and maturity • Take a proactive approach to cross-functional communication • actively seek out feedback from management and peers, to improve own performance based on that feedback *Regards,* *Meenu Sharma* *Head –Recruitment* *RG Talent Inc.* *39120, Argonaut Way, Suite #157, Fremont, CA 94538* *Phone: 510-443-0757 x 105* *Fax: 510-952-4633* *Email *me...@rgtalent.com ,* Hangout: meenu.rgtalent* In my absence please contact *Adil Zaman* at the following address *adil.za...@rgtalent.com* <adil.za...@rgtalent.com> *Disclaimer: Under Bill s. 1618 Title III passed by the 105th U.S. Congress this mail cannot be considered spam as long as we include a way to be removed from our mailing list. Simply send us an e-mail at * rem...@rgtalent.com* and we will gladly REMOVE you from our mailing list.* -- You received this message because you are subscribed to the Google Groups "SAP-UK" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-uk+unsubscr...@googlegroups.com. To post to this group, send email to sap-uk@googlegroups.com. Visit this group at http://groups.google.com/group/sap-uk. For more options, visit https://groups.google.com/d/optout.