SSIS-Data Engineer

We are looking for a talented Data Engineer who will be leading the data engineering activity for Santechture. The role is reporting to the Associate Director - Data Insights.

What you will be doing

Your mission will be to implement and roll out the data engineering activity with the goal of solving business needs:

• Your primary objective is to create the data products and make sure theyre delivered through reliable data pipelines.
• Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages.
• Analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Design a data pipeline and develop ETL processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases.
• Provide database support for development and deployment of database scripts in Development, Test, Pre-Production and Production environments.
• Design and develop enterprise and departmental business intelligence and data warehousing solutions.
• Test programs or databases, correct errors, and make necessary modifications.
• Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure.
• Modify existing databases and database management systems or direct programmers and analysts to make changes.
• Develop methods for integrating different products so they work properly together.
• Develop standards and guidelines to guide the use and acquisition of software and to protect changes to database.
• Revise/write company definition of data as defined in data dictionary.
• Train users and answer questions.
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases.
• Identify and evaluate industry trends in database systems to serve as a source of information and advice for upper management.

Who you are:

• Software engineering background specialized in big data.
• Work experience as a DevOps Engineer or similar software engineering role.
• Have exceptional SQL Server programming skills as follows:
• - Advanced Business Intelligence experience
• - BIML scripting
• - SSIS, SSRS, SSAS
• - Power BI
• Extensive experience with reporting using Power BI.
• Experience coding complex stored procedures (using T-SQL).
• Experience with developing SSIS packages.
• Performs ad-hoc analysis using T-SQL query language within the database systems using a process-oriented approach.
• Understands the concept of Data marts, Data warehouse and Data lakes and experience with migrating legacy systems to data marts/ warehouse /lake.
• Uses additional cloud technologies (e.g., understands concept of Cloud services like Azure SQL server).
• Uses SQL Server Analysis Services to enhance existing, or develop new, OLAP cubes used in the EDW system.
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.