The candidate must have Experience database, data warehouse applications - Oracle / SQL Server databases
Data architect with Business Intelligence BI implementation skills : requirements / process analysis, conceptual and detailed design, relational conceptual, logical and physical modeling and dimensional modeling star / snowflake schema , implementation of cube data warehouse , testing, training, and support.
ETL Design, Scheduling, Deployment and data loading using SSIS. DAX and MDX querying background.
Understands business requirements and translates into technical solutions. Applies technical knowledge of technology and industry trends to develop, implement and maintain complex data solutions.
Leads the resolution of complex data problems for large / complex projects
Elicit review, and validate data requirements, including : Data integration (ETL, EAI, web services), Meta data, Modelling (Conceptual, Logical, Physical), Data delivery, and Business intelligence.
Participate in research and method selection for solutions, being actively involved in design meetings with stakeholders.
Designs and builds the data architecture and data integration layers
Leads in data quality analysis / data profiling, to produce a data quality assessment (and baseline).
Respond to ad hoc analysis requests for data and analytics needed by senior management.
Education and Experience Required :
Bachelor's degree in Data Base Management / Systems Engineering or related Engineering. Specialization, Masters or Phd level degree is desirable.
Additional formal studies will be a plus.
SSIS (SQL Integrationg Services) / SQL / PL SQL language, MS SQL Server, Windows Server and Unix / Linux Operating Systems, Programming Languages (Minimum of 3 to 5 years of related work experience).
Experience working on Service Operations with a high customer orientation is strongly preferred.
Ability to effectively communicate design proposals and architectures, and negotiate options at senior leadership levels
Knowledge and Skills :
Expert knowledge and experience with data modeling, data warehousing, dimensional modeling, big data solutions and ETL development
Solid track record of transforming concepts and requirements into workable products and solutions is a must
Expert knowledge of software development life-cycles with its principles, practices, strategies and tactics.
Excellent project management skills and ability to execute on multiple projects simultaneously.
Familiarity with the Knowledge Hierarchy / Data, Information, Knowledge, Wisdom pyramid
Data literacy : Finding and managing data, cleansing data, appropriately address extremes, outliers, etc., manipulating data.
Mathematical reasoning; Competent in the interpretation of numeric data, understand and / or practice statistical principles.
Advanced verbal and written communication skills for writing reports / proposals and making presentations, in particular the ability to clearly and effectively communicate technical results to a non-technical business audience
Ability to work independently under a fast-paced environment, comfortable to deliver results under pressure.
Strong work ethics and collaborative attitude.
Self / starter Innovative thinker with analytical / problem solving skills.