Data Engineer

Easterseals Southern California; Irvine (CA); Presencial; USD 87 000 - 110 000; Tempo integral

Resumo da oferta

Easterseals Southern California is seeking a Database Administrator to design, implement, and maintain database architectures supporting our business applications and EDW. You will manage data ingestion, ETL processes, security, and performance optimization to ensure data integrity and availability.

Collaborate with IT Security, Compliance, and analytics teams to enable data-driven decisions while maintaining governance and regulatory compliance.

Qualificações

• 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).
• 3-5 years of experience as a Database Administrator and cloud architecture (e.g., Databricks, Snowflake, AWS, Google, etc.) or in a similar role.
• Experience with Spark, PySpark, and KQL, Notebooks and Lakehouses preferred.
• Proficiency in managing relational database management systems (RDBMS) such as T-SQL, MySQL, PostgreSQL, or Oracle.
• Strong SQL skills and the ability to write and optimize complex SQL queries.
• Experience with database performance tuning and optimization techniques.
• Knowledge of database security best practices and experience implementing security measures such as encryption, access controls, and auditing. DevOps experience preferred.

Responsabilidades

• Designs, implements, and maintains database schemas that support our applications and business processes.
• Manages data ingestion and ETL/ELT processes for the Enterprise Data Warehouse (EDW).
• Ensures backup and recovery procedures are documented, reviewed against IT security and compliance standards.
• Serves as the primary Major Incident Management resource for the EDW and monitors EDW users.
• Collaborates with IT Security and Compliance to ensure proper data governance guidelines are followed.
• Monitors and optimizes database performance for efficient queries and system reliability.
• Implements security measures to protect sensitive data from breaches.
• Plans database upgrades and patching to keep systems up to date and secure.
• Diagnoses and resolves database-related issues to minimize downtime.

Conhecimentos

SQL queries

Data governance

Azure Purview

ETL pipelines

Security best practices

Formação académica

Bachelor's degree in CS/IT

Database Administration certification

Ferramentas

Databricks

Snowflake

AWS

KQL/Notebooks

Lakehouses

Descrição da oferta de emprego

Easterseals Southern California transforms lives every day. For over a century, Easterseals has championed inclusion and independence—delivering essential services like early childhood programs, autism services, employment and independent living support to more than 29,000 people each year. Through advocacy and education, we break barriers and create opportunities for the one-in-four Americans with disabilities.

Responsible for designing, implementing, and maintaining database architectures that support business applications and processes. Responsible for data ingestion, ETL processes, database security, and performance optimization within the Enterprise Data Warehouse (EDW). Ensures compliance with data governance policies, backup and recovery protocols, and industry regulations. Collaborates with stakeholders to provide insights, manage projects, and support data-driven decision-making. With expertise in database management and security, plays a key role in maintaining system integrity, anticipating capacity needs, and ensuring seamless database operations.

Starting Salary Range: $87k - $110k / yr.

Overview Of Position

Responsible for designing, implementing, and maintaining database architectures that support business applications and processes. Responsible for data ingestion, ETL processes, database security, and performance optimization within the Enterprise Data Warehouse (EDW). Ensures compliance with data governance policies, backup and recovery protocols, and industry regulations. Collaborates with stakeholders to provide insights, manage projects, and support data-driven decision-making. With expertise in database management and security, plays a key role in maintaining system integrity, anticipating capacity needs, and ensuring seamless database operations.

Essential Functions

• 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.
• Analyzes 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.

Education

• 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).

Experience

• Proven experience with Microsoft ecosystem. 3 - 5 years of experience as a Database Administrator and cloud architecture (e.g., Databricks, Snowflake, AWS, Google, etc.) or in a similar role.
• Experience with Spark, PySpark, and KQL, Notebooks and Lakehouses preferred.
• Proficiency in managing relational database management systems (RDBMS) such as T-SQL, MySQL, PostgreSQL, or Oracle.
• Strong SQL skills and the ability to write and optimize complex SQL queries.
• Experience with database performance tuning and optimization techniques.
• Knowledge of database security best practices and experience implementing security measures such as encryption, access controls, and auditing. Experience with Microsoft Purview preferred.
• Preferred experience includes DevOps or similar environments.

Knowledge, Skills, Abilities

• Demonstrated proficiency with MS Office applications (Word, Excel, Outlook).
• Ability to maintain customer service orientation and professionalism in all interactions.
• Ability to translate technical concepts into business-friendly language for non-technical stakeholders.
• Effective communicator with cross-functional teams including IT, compliance, and analytics. Ability to mentor and train team members on database management best practices and new implementations.
• Ability to mentor and train team members on database management best practices and new implementations.
• Ability to exercise independent judgment, exercise discretion and maintain a high level of confidentiality with sensitive documentation and/or situations.
• Ability to obtain and maintain a criminal record/fingerprint clearance from the Department of Justice and Federal Bureau of Investigation per Easterseals Southern California and/or program requirements.

Physical Requirements In Accordance With Ada

• Carrying/Lifting: Occasional / Up to 30 lbs.
• Standing: Occasional / Up to 3 hours per day.
• Sitting: Constant / Up to 8 hours per day.
• Walking: Occasional / Up to 3 hours per day.
• Travel: 0-20%.
• Repetitive Motion/Activity: Keyboard activity, telephone use, writing. The position requires occasional standing, bending, reaching, stooping, squatting, kneeling, grasping, lifting and twisting.
• Visual Acuity: Ability to view computer monitor and read newsprint.
• Environmental Exposure: None.