Responsible for gathering, analysing business requirements, planning & preparing, implementing, and delivering business intelligence solutions.
Requirements
Developing technology specifications and ensuring that new technology solutions are designed for optimal access and usefulness, and leveraging existing technologies when possible
Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability
Identifying the technologies to employ based on business requirements coverage, price, performance, service agreements and organisation constraints
Participate and lead research and development efforts (proofs of concept, prototypes), as subject matter experts, when introducing new technologies.
Provide technical expertise to propose level of effort estimates (LOE), work breakdown structures and technical resource planning for proposed and current work
Provide input to management throughout the project management lifecycle
Ensures technology solutions are production ready and meet the defined specifications, and that the solution can be maintained via production support methodologies and resources.
Provide technical guidance to coach and mentor team members; provide performance feedback to manager(s).
Benefits
Good analytical skills (skilled in analysing and documenting business requirements and corresponding solution specifications)
Good knowledge of software design methods and techniques
Experience of BI/DWH maintenance and design
Experience of ETL development and data modelling, preferably on several platforms and with different tools
Very good knowledge of databases eg. Oracle, MySQL, Teradata, MS SQL
Experience with database development of stored procedures, triggers, views
Experience with Big Data ecosystem
Experience with Data Warehouse in cloud ecosystems
Good knowledge of SQL, PL/SQL ,T-SQL
Good knowledge of SQL optimization
Good knowledge of Unix-Shellscripts
Good knowledge of Data Modeling concepts, methodologies and processes
Basic database administration skills
Leadership experience is an advantage
Fluency in written and spoken English, preferably also German