A key role within ACIS IT Systems Development who provides technical consultancy and direction to all the projects and initiatives of one or more technical streams. Self-driven to learn new technologies and evangelizes on new developments in the technical streams through informal and formal means. A hands-on technical leader with in-depth knowledge on the trends both current and emerging
A minimum of 10 years of development experience using the relevant technologies.
Data warehouse stream
Strong knowledge of Base SAS, SAS BI tools like DI Studio, OLAP Cube studio, IDP, Web Reporting studio, Enterprise Guide and Management console.
Strong knowledge of SQL
Knowldege of UNIX, LINUX
Responsible for assessing requirements and defining the strategy, technical architecture, implementation plan, and delivery of data warehouse projects as per business requirements.
Must have prior experience leading successful data warehousing implementations as well as a broad background and experience with IT application development. Also responsible for establishing the long-term strategy and technical architecture as well as the short-term scope for data warehouse.
Need strong professional consulting skills and the ability to communicate well at all levels of the organization.
Specific skills include
Generate and Design executive level support for the data warehouse initiative
Define key business drivers for the data warehouse initiative
Deliver a project scope that directly supports the key business drivers
Define the overall data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts)
Define technical requirements, technical and data architectures for the data warehouse
Recommend/select data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI)
Direct the discovery process
Design and direct the ETL process, including data quality and testing
Design and direct the information access and delivery effort for the data warehouse
Define and direct the implementation of security requirements for the data warehouse
Define meta data standards for the data warehouse
Direct the data warehouse meta data capture and access effort
Define production release requirements and sustainment architecture
Strong knowldege on dimensional modelling
Good knowledge in RDBMS
Ability to come up with multiple solution options and articulating the same to all the stakeholders including business, helping them to arrive at the Optimal solution
Prepare various architectural artifacts like Architectural Notes, System/sub-system Architectural Document, etc.
Gather info on technology trends, evolutions and external regulations and analyse its impact on the existing systems/projects within the organization.
Plans, organizes, and directs critical technical/project work.
Introduce data warehouse best practices to Allianz
Manages core components projects.
Represent MIS in Technology Competency Group
Develops or prototypes particularly complex aspects of applications.
Prototypes application of new data warehouse technologies to show capabilities.
Participates in all the phases of ACDM life cycle.
Recommend appropriate solutions to business problems.
Prepares high level and low level system design.
Guides developers on best practices in the development process and generally accepted programming standards and techniques to ensure efficient program logic and data manipulation.
Code reviews project work to ensure that code quality is up to standard.
Identifies technology related blockers in projects and works to eliminate them.
Assists in troubleshooting during testing and production phases of project.
Analyse the performance of software interfaces and identifies alternatives for optimizing the usage.
Assists in delivery of projects through strategy, design, estimation, and Project Management.
Engages with other architects to collaborate on design of new data warehouses
Conducts system impact analysis.
Acts as a point of contact for technical issues within the organization