SSIS Developer (Remote Night Shift)

MED-METRIX INTERNATIONAL PH-I, INC.; Metro Manila; Remote; PHP 500,000 - 900,000; Full time

Benefits offered by this job

8-Hour Shifts

Fixed Weekends Off

HMO for you + 2 dependents

Medical Cash Allowance

Rice Allowance

Clothing Allowance

Free Lunch Daily

Paid Time Off

Training and Staff Development

Employee Engagement Activities

Opportunities for Internal Mobility

Job summary

Med-Metrix International PH-I, INC. seeks a database engineer to develop complex ETL and analytics solutions using SQL, SSIS, and SSRS, in a fully remote team.

You will work with project managers to align reports with business needs, maintain SSIS packages, optimize SQL performance, and provide technical leadership while communicating status to clients and stakeholders.

Qualifications

• Four-year degree in Computer Science or Information Technology.

Responsibilities

• Develop complex ETL and analytics programs using SQL, stored procedures and various query tools.

Education

Four-year degree in Computer Science/Information Technology

Tools

SSIS

SSRS

T-SQL

MS SQL Server

Visual Studio Foundation Server

C#

VB.NET

Job description

Experience these Xtraordinary benefits when you join Med-Metrix!

• 8-Hour Shifts, Fixed Weekends Off

• Day 1 HMO with 2 of your dependents covered for FREE

• Medical Cash Allowance

• Rice Allowance

• Clothing Allowance

• Free Lunch Daily

• Paid Time Off

• Training and Staff Development

• Employee Engagement Activities

• Opportunities for Internal Mobility

Description

• Develop Complex ETL and Analytics Programs using SQL, Store Procedures and various query tools.

• Work with project managers to ensure that reports and metrics identify business needs and opportunities for process improvement.

• Develop, maintain and support SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process using Microsoft SQL Server 2012 or later

• Maintain HIPPA transactions specifically 835 and 837 transaction sets, create the ad hoc reports to query the transaction sets.

• Responsible for data profiling as well as SQL and database tuning / optimization

• Analyze the client requirements and design technical solutions based on those requirements.

• Perform day to day troubleshooting of issues related to QA and Production.

• Design ETL audit control and scheduling processes.

• Develop testing and implementation strategy, conduct appropriate functional and performance testing to identify and resolve process bottlenecks and data quality issues

• Guide the developers in the team to implement the client requirement and review the software developed by the team members.

• Provide technical leadership by making recommendations for application development to enhance the existing solution or resolve production issues

• Work within a fast paced, objective oriented environment

• Managing and versioning the SSIS projects using Visual Studio Foundation Server.

• Participates in Client meetings, lead technical review meetings with team and/or client as required.

• Responsible for providing accurate and timely communication of the status of assignment, job responsibilities, and the resolution of problems to the appropriate parties following established policies and procedures.

Requirements

• Requires a four-year degree in Computer Science/Information Technology

• Minimum two years working as a Database engineer or a related role.

• Minimum of one year SSIS experience

• Thorough understanding of database structures, theories, principles, & practices.

• Ability to write & troubleshoot SQL code & design stored procedures, functions, tables, views, triggers, indexes, & constraints.

• Extensive knowledge of MS SQL Server

• Extensive knowledge with SSRS\SSIS\T-SQL

• Experience with C# and\or VB.NET.

• Technical knowledge of MS SQL Server internals with emphasis on query performance.

• Knowledge and know-how to troubleshoot potential issues; experience with best practices around database operations.

• Strong oral and written communication skills with the ability to communicate technical and non-technical concepts to peers, customers, and management

• Must be capable of routinely making effective and timely decisions in alignment with departmental direction and based on sound business knowledge and industry best practices.

• Require ability to work independently with minimal supervision

• Ability to multi-task with several complex and demanding Projects

Working Conditions:

• Remote: You'll be joining a distributed, fully remote team. Experience working remotely is a plus.

• Physical Demands: While performing the duties of this job, the employee is occasionally required to move around the work area; Sit; perform manual tasks; operate tools and other office equipment such as computer, computer peripherals and telephones; extend arms; kneel; talk and hear.

• Mental Demands: The employee must be able to follow directions, collaborate with others, and handle stress.

• Work Environment: The noise level in the work environment is usually minimal.

• Work Timings: You are expected to work in Eastern time zone with US team initially.