Looking for an experienced and analytical System Analyst with mainframe systems experience to be part of our Business Intelligence (BI) team, driving new data technology platform using Azure Databricks.
Mandatory Skill(s)
- Degree in Computer Science, Information Technology, Engineering, Data Science;
- At least 6 years of experience in systems analysis, design (include database design), development, implementation, and quality assurance;
- Working experience on IBM Mainframe (COBOL, MVS, ESA, JCL, DB2, VSAM and CICS) environment;
- Good Experience in Python, Powershell, SAS to process large scale data, big data and advanced analytics;
- Good experience in using IBM Debugger, IBM RDz, IBM IDS for z/OS and Microsoft SQL DTS/SSIS;
- Should have knowledge of data profiles, data quality and data lineage;
- Experience in designing & development of ETL processes using ETL tools;
- Able to write complex SQL queries;
- Knowledge on Azure Databricks Infrastructure Setup;
- Working knowledge of cloud computing on AWS and Azure;
- Familiar with Agile Software Development methodologies, Software Configuration Management (SCM) and deployment automation (CI/CD);
- Good written and oral communication skills.
Desirable Skill(s)
- Experienced with IBM Mainframe tools such as Easytrieve Plus;
- Experience using ChatGPT.
Responsibilities
- Formulating user specifications for systems and databases after gathering user requirements, data profiling and gap analysis;
- Design, build, integrate and manage the data flows from various sources into data models;
- Create and maintain optimal data pipeline architecture;
- Work closely with application and vendor teams to ensure that they understand the data model/flow and provide the subject matter expertise for Data related matters;
- Establish data strategies, design, architecture, build conceptual/logical/physical data models and flows and communicate with the application development team for adoption;
- Perform SIT & UAT and refinement of user specifications to cater for changes in business rules and translate them into technical specifications;
- Work with DBA team on schema changes and performance tuning on physical data model by building physical data structures and re-normalization;
- Responsible for Performance tuning of the data ETL processes and issue resolution of complex processes.
If you are interested in this role, click on the “Apply to this job” button below or you could also write in with your CV to Cecilia Chong at cecilia@sciente.com quoting the job title.
