SQL Data Warehouse Engineer

VigorCare Pediatric Services; Boston (MA); On-site; USD 100,000 - 150,000; Full time

Job summary

VigorCare Pediatric Services in Boston is seeking a seasoned SQL Developer to design, develop, and maintain our SQL databases and data warehouse. You will collaborate with the IT team to ensure performance, security, and reliability.

The role emphasizes ETL, data integration from multiple sources, and creating documentation and data standards. Strong SQL, data warehousing, and analytics skills are essential.

Qualifications

• Bachelor's degree in CS, IT, or related field.
• Strong SQL and database design knowledge.
• Experience with data warehousing and ETL processes.
• Familiarity with data visualization tools.
• Excellent problem-solving and analytical skills.
• Ability to work independently and communicate effectively.
• Knowledge of healthcare industry and HIPAA regulations is a plus.

Responsibilities

• Design, develop, and maintain SQL databases and data warehouse.
• Develop and implement data extraction, transformation, and loading processes.
• Optimize database performance and troubleshoot any issues that arise.
• Create and maintain database documentation, including data standards, procedures, and definitions.
• Collaborate with IT team to integrate data from various sources into our databases.
• Develop and maintain SQL queries and stored procedures for data analysis and reporting.
• Ensure data security and compliance with industry standards and regulations.
• Stay current with industry trends and advancements in database technology.

Skills

SQL

Database design

ETL processes

Data warehousing

Data analysis

Data security

HIPAA knowledge

Education

Bachelor's degree in Computer Science or related field

Job description

VigorCare Pediatric Services in Boston is seeking a seasoned SQL Developer to design, develop, and maintain our SQL databases and data warehouse. You will collaborate with the IT team to ensure performance, security, and reliability.

The role emphasizes ETL, data integration from multiple sources, and creating documentation and data standards. Strong SQL, data warehousing, and analytics skills are essential.