This role, Solution Analyst, Technical Data Modeling and Application DBA, is the analyst that understands the IT product or applications in their area and how these can support the business. The main focuses are to provide subject matter technical competence in designing data model, implementing, maintaining and administrating the end-to-end integrated data warehouse solutions.
You are responsible to develop solutions to bridge gaps and make sure the project scope is maintained, and solutions implemented in line with design.
Key Responsibilities:
Business Engagement
§ Support pre-project consulting for a portfolio pipeline of initiatives
§ Capture business challenges and requirements
§ Analyze technically viable ideas to improve the business performance
§ Interact and work closely with solution provider or internal teams
Technology Design and Implementation
§ Understand and translate business needs into data models supporting long-term solutions
§ Collaborate with the Application Development teams to implement data strategies, build data flows and develop conceptual and physical data models
§ Understand and critically review physical data models
§ Develop, implement, and support IT products and applications to meet the customer and IT needs
§ Contribute best practices in continuous integration and delivery
§ Generate ideas to improve data quality
§ Streamline delivery of product/system with adherence to security policy and data governance framework
Project Delivery
§ Focus on multiple small to medium to large scale initiatives
§ Plan and execute tasks / initiatives
§ Test all solution aspects including but not limited to security, performance, integration
§ Facilitate project progress through relevant gates
§ Understand areas of risk and act on the mitigation for the projects
§ Adapt to changes as per project progress
Minimum:
- Degree qualification in Information Technology related discipline, Masters preferred
- 4 years of related IT experience covering but not limited to:
- Software development
- System analysis
- Business analysis
- Solution definition
- System Testing
§ At least 2 years of working experience in implementing large scale data warehouse with hands-on experience in ETL (data modelling, data integration/ETL/ ELT, metadata management, data quality management etc.)
§ Experience with dimensional modelling including star schema and slowly changing dimensions etc.
§ Competent on RDBMS including SQL query and physical design tuning
§ Knowledge in Airflow, Python, Spark , AWS Lambda, Glue
- Excellent analytical, problem-solving, and decision-making skills, leveraging both logic and creativity
- Hands on experience in software / data driven SDLC and agile development project
- Proven troubleshooting skills; ability to identify patterns and generate ideas
- Experience in working and managing vendors in delivering quality and within target timeline
- Outstanding verbal and written communication skill
- Experience in driving technical innovation
- Proven extensive client facing experience with successful relationship management
- Airline or travel industry knowledge is highly beneficial
- Professional, passionate, innovative, self-motivated and able to present solutions to diverse groups of stakeholders
Understanding of cloud, DevOps, APIs / Mobility would be added advantage
1. Hands on experience in ETL, data integration and data quality management
2. Strong understanding on data warehouse and data modelling
3. Excellent analytical and problem solving skills.