Senior Data Engineer

Med-Metrix; Pasig; Remote; PHP 800,000 - 1,200,000; Full time

Benefits offered by this job

Day 1 HMO with dependents covered

Group Life Insurance

Paid Time Off

Training and Staff Development

Job summary

A healthcare technology company is seeking a Senior Data Engineer to work remotely. This role requires expertise in T-SQL and a minimum of 10 years in database and software development. Key responsibilities include optimizing SQL Server databases and ensuring data quality through validation processes. This position is part of a collaborative team working US hours, offering an excellent environment for professional growth and development.

Qualifications

• Minimum 10 years of Database and software development experience.
• Healthcare domain experience preferred.
• Experience with any public cloud platform for data storage and processing.

Responsibilities

• Assist with the development, maintenance and optimization of SQL Server databases.
• Collaborate with the team to identify, prioritize, and execute key data delivery milestones.
• Perform data profiling to identify quality issues and cleanse data.

Skills

T-SQL

Data validation

Complex SQL queries

ETL process

Analytical skills

Interpersonal skills

Education

Bachelor's Degree from an accredited college/university

Tools

SQL Server

Microsoft Office Suite

Job description

Med-Metrix - Pasig, National Capital Region, Philippines

Senior Data Engineer

Benefits

• Day 1 HMO with 2 of your dependents covered for FREE
• Group Life Insurance
• Medical Cash Allowance
• Rice Allowance
• Clothing Allowance
• Holiday Gift
• Bereavement Assistance
• Paid Time Off
• Training and Staff Development
• Employee Engagement Activities
• Opportunities for Internal Mobility

Job Purpose

The Senior Database Engineer will collaborate with cross-functional teams to define, design, and ship new features while simultaneously improving existing functionality. The Senior Database Engineer will fix reported bugs and work towards improving application performance, as well as continuously discover, evaluate, and implement new technologies to maximize development efficiency.

Duties and Responsibilities

• Assist with the development, maintenance and optimization of several SQL Server databases that support highly available enterprise software applications
• Master of Dynamic SQL, Joins, query formatting, debugging SQL Procedures
• Perform data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information
• Commit quality code, reliably and on time to help the team achieve roadmap goals and customer commitment
• Collaborate with the team to identify, prioritize, and execute on key data delivery milestones
• Prepare technical design document & data dictionary
• Evaluate code to ensure validity, HIPAA compliance, secure coding practices, and compatibility
• Report any security or HIPAA violations or concerns to the HIPAA Officers in a timely fashion
• Other duties as assigned
• Use, protect and disclose patients’ protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards
• Understand and comply with Information Security and HIPAA policies and procedures at all times
• Limit viewing of PHI to the absolute minimum as necessary to perform assigned duties

Qualifications

• Bachelor's Degree from an accredited college/university or equivalent work experience
• Minimum 10 years of Database and software development experience
• Healthcare domain experience preferred
• Working experience with ETL process using SSIS preferred
• Experience with any public cloud platform for data storage and processing
• A strong Hands-on exp of T-SQL is essential. Should be able to write complex queries to retrieve, manipulate, and update data in relational databases
• Expertise in writing complex SQL Queries, stored procedures, functions, triggers, views, and indexes
• Ability to ensure data quality by implementing data validation checks and data cleansing processes
• Skills in optimizing SQL queries, indexing, and database performance to ensure efficient data retrieval and processing
• Clear communication around technical concepts and ideas and the ability to collaborate with engineering and other parts of the organization
• Strong analytical and critical thinking skills, attention to detail, and the ability to work both independently and as part of a team
• Good documentation practices to maintain records of database schemas, ETL processes, and data flows
• Be a self-starter and work well independently as well as in a collaborative team environment
• Proven ability to work calmly under tight deadlines or in critical situations
• Proficiency in Microsoft Office Suite
• Strong interpersonal skills, ability to communicate well at all levels of the organization
• Strong problem solving and creative skills and the ability to exercise sound judgment and make decisions based on accurate and timely analyses
• High level of integrity and dependability with a strong sense of urgency and results oriented
• Excellent written and verbal communication skills required
• Gracious and welcoming personality for customer service interaction

Working Conditions

• Work set-up: Work From Home
• Work Schedule: US hours, night shift; must be flexible to accommodate business needs
• 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

Med-Metrix will not discriminate against any employee or applicant for employment because of race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, veteran status, other non-merit based factors, or any other characteristic protected by federal, state or local law.

Seniority level: Mid-Senior level

Employment type: Full-time

Job function: Information Technology

Industries: Hospitals and Health Care