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 Q/A teams or perform Q/A 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 problem-solving and metadata skills Understands BI tool architecture, functions, features Customizes BI tool to meet user needs Maintain ample documentation within programs and adhere to in-house 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 high-quality 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 multi-dimensional designs. Understand and comply with all appropriate regulations. Understands and utilizes all appropriate tools such as MS Project, Word, Excel, etc.
VertiSystem - 2 years ago