BI Architect
Vertisystem Inc. - Las Vegas, NV

This job posting is no longer available on Dice. Find similar jobs:Bi Architect jobs - Vertisystem jobs

Duties and Responsibilities Works with business requirements analyst to identify and understand source data systems Maps source system data to data warehouse models Develops and tests extraction transformation and load (ETL) processes Defines and captures meta data and rules associated with ETL processes Adapts ETL processes to accommodate changes in source systems and new business user requirements Complete mapping and transformation programs Schedules for extraction and load processes Work as third level support of business critical applications Work with vendor and facilitate knowledge transfers Create support documentation specific to deployment Create and implement solutions to increase productivity and benefit of data warehouse based applications Identify areas improve efficiency in data extraction techniques and query optimization Provide database specific information to aid in query development and troubleshooting Adhere to the established Change Control process for implementing changes and enhancements Provide task status updates and commitments to achieve tasks within previously determined estimates May work with users or assist a team to accurately define and develop business requirements May be assigned to participate on QA teams or perform QA process tasks Write and maintain system design and technical documentation as assigned Track time against assigned projects and tasks Maintain expertise in evolving development tools platforms and coding methodologies Installs configures deploys and tunes BI tools and analytic servers Troubleshoots BI tool problems and tunes for performance Develops multidimensional semantic layer and BI query objects for end users Creates reports and report templates Helps business users select the appropriate BI tool(s) Develops and manages BI training documentation and help desk capabilities Translates business questions and requirements into reports views and BI query objects Knowledge of BI tool architectures functions and features Understands SQL and relational and multidimensional designs Strong problemsolving and metadata skills Understands BI tool architecture functions features Customizes BI tool to meet user needs Maintain ample documentation within programs and adhere to inhouse naming conventions and programming standards Ensure that applications are developed in compliance with architectural guidelines and standards and consistent with the Software Development Life Cycle Required Knowledge and Skills Understanding of source and target data structures ETL processes and products Data quality assessment skills and query performance tuning Operating platforms Metadata management Experience developing and implementing highquality business intelligence processes Experience in establishing methodologies and procedures based on industry best practices Experience in logical and physical database design and modeling Completes mapping and transformation programs Schedules extraction and load processes ETL metadata documented and maintained in metadata repository Ability to build follow and interpret use case scenarios Conceptual and analytic skills Knowledge of business domain Translate business questions and requirements into reports and views Knowledge of BI tool architectures functions and features Understand SQL and relational and multidimensional designs Understand and comply with all appropriate regulations Understands and utilizes all appropriate tools such as MS Project Word Excel etc Required Education and Work Experience Minimum 7 years of experience in Information Technology which can include Application Development Project Management etc Work experience in related Gaming Industry can qualify toward experience Accreditations Certifications in industry standard database platforms (MS SQL Teradata etc) Strong knowledge in various BI platforms which can include Tableau Cognos etc Ability to assume responsibility for independentselfdirected action Preferred experience with specific applications that would be supported by this position Bachelor’s Degree Preferred BI Architect cognos ETL SQL metadata
About this company
VertiSystem is a professional services company, supporting the gaming as well as other industries. We are dedicated to delivering...