Data Engineer: EDW, ETL & Security

Easterseals Southern California; Irvine (CA); In loco; USD 87.000 - 110.000; Tempo pieno

Descrizione del lavoro

Easterseals Southern California is seeking an experienced Database Administrator to design, implement, and maintain our EDW DB architectures and security posture. You will manage ingestion, ETL/ELT, backups, and performance tuning across cloud platforms.

Collaborate with IT security, compliance, and analytics teams to ensure data governance and regulatory alignment, including GDPR, HIPAA, or PCI DSS. Strong communication and mentoring are essential in this role.

Competenze

• Bachelor’s degree in computer science, information technology, or related field or commensurate experience or equivalent work experience.
• Certification in database administration desired (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate).

Mansioni

• Designs, implements, and maintains database schemas that support our applications and business processes.
• Manages data ingestion and ETL/ELT processes for all data related to the Enterprise Data Warehouse (EDW). Ensures backup and recovery procedures are documented, reviewed against IT security, infrastructure and compliance standards and tested.
• Serves as the primary Major Incident Management (MIM) resource for the EDW. Monitors EDW users and conducts audits as requested.
• Collaborates with IT Security and Compliance to ensure proper data governance guidelines are followed.
• Monitors and optimizes database performance to ensure optimal query execution and system efficiency.
• Implements and maintains security measures to protect sensitive data from unauthorized access or breaches.
• Develops and implements backup and recovery plans to ensure the integrity and availability of our data.
• Plans and execute database upgrades and patching to ensure that our database systems are up to date and secure.
• Diagnoses and resolves database-related issues in a timely manner to minimize downtime and ensure the reliability of our systems.
• Leads technical sessions and projects, representing the EDW team in managing the Microsoft Fabric environment.
• Maintains accurate documentation of database configurations, processes, and procedures. Preferred experience in DevOps or similar.
• Analyses data usage trends to forecast capacity needs and support scalability planning.
• Serves as a key EDW resource, collaborating with development and IT teams to provide insights and recommendations. Ensures that our databases comply with relevant regulations and standards, such as GDPR, HIPAA, or PCI DSS.
• Collaborates with data scientists and analysts to support advanced analytics and data-driven decision-making.
• Develops and maintains data models and metadata to ensure data consistency and quality.
• Provides training and support to other team members on database management and best practices and new implementations.
• Performs other duties as assigned.

Conoscenze

MS Office

Cross-functional communication

Mentoring

Business translation

Independent judgment

Confidentiality

Formazione

Bachelor’s degree in CS/IT or related field

Database administration certification

Strumenti

Databricks

Snowflake

AWS

Google Cloud

T-SQL

MySQL

PostgreSQL

Oracle

Azure Purview

Spark

PySpark

Descrizione del lavoro

Easterseals Southern California is seeking an experienced Database Administrator to design, implement, and maintain our EDW DB architectures and security posture. You will manage ingestion, ETL/ELT, backups, and performance tuning across cloud platforms.

Collaborate with IT security, compliance, and analytics teams to ensure data governance and regulatory alignment, including GDPR, HIPAA, or PCI DSS. Strong communication and mentoring are essential in this role.