• Your primary objective is to create the data products and make sure they’re 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.