BI Developer - Level III

Science Systems and Applications, Inc. (SSAI) is seeking a senior BI Developer / Data Engineering professional to support enterprise data initiatives for a public sector education client. The selected candidate will design, automate, support, and improve data extraction, transformation, loading, data warehouse, and data lake solutions.

This position is Onshore / Remote and requires availability during Pacific Time business hours.

This role is ideal for a senior data professional with deep experience in Oracle, dbt, ETL/ELT, data ingestion, dimensional modeling, cloud data integration, data quality validation, and Git/CI-CD deployment practices. The work supports large-scale enterprise data management and reporting needs across business customers, vendors, and internal technical teams.

Key Responsibilities:

• Design, automate, support, and enhance sophisticated data extraction, transformation, and loading applications.
• Develop and support Oracle database batch applications within data warehouse and data lake environments.
• Ingest data from heterogeneous sources into on-premises or cloud data storage platforms, including environments such as Snowflake, AWS, and related cloud data services.
• Build and manage ETL/ELT workflows using dbt, Oracle Data Integrator (ODI), Oracle PL/SQL, Oracle SQL, and shell scripting.
• Develop dimensional hierarchies and data models to support enterprise data management reports and analytics needs.
• Create and improve data solutions that support smooth, reliable data delivery across large volumes of data.
• Perform data quality validation, write dbt tests, and help resolve data integrity or reporting issues.
• Support API development frameworks and cloud-native data integration technologies as needed.
• Support data lake migration from on-premises systems to cloud platforms.
• Build incremental models, manage raw data layers, and develop modular dbt models for vendor/application data.
• Convert complex Oracle stored procedures into maintainable dbt models using macros, hooks, incremental models, and modular design practices.
• Use Git workflows, branching strategies, and CI/CD pipelines to support automated deployment of data solutions.
• Collaborate with business customers, vendors, and internal resources to clarify requirements, resolve issues, and support successful delivery.
• Provide weekly status updates and maintain required project/time reporting.

Required Qualifications:

• 10+ years of demonstrated experience in BI development, data engineering, ETL/ELT, data warehouse, data lake, enterprise data management, or closely related services.
• Strong knowledge of Oracle database development for batch applications in data warehouse or data lake environments.
• Hands-on experience with data ingestion from multiple heterogeneous sources into on-premises and/or cloud data platforms.
• Experience using dbt, ODI, Oracle PL/SQL, Oracle SQL, and shell scripting to manage ETL/ELT processes.
• Experience developing dimensional hierarchies and data models for enterprise reporting.
• Experience creating, maintaining, processing, and analyzing large data volumes.
• Experience with data quality validation, reconciliation, and testing.
• Knowledge or hands-on experience with API development frameworks.
• Knowledge or hands-on experience with cloud-native data integration technologies.
• Experience supporting data lake migration from on-premises systems to cloud platforms.
• 3+ years of experience building incremental models, handling raw data layers, and building dbt models for vendor/application data.
• Proficiency in dbt development, including macros, hooks, incremental models, data quality tests, and model security.
• Experience converting complex Oracle stored procedures into modular dbt models.
• Expert-level knowledge of Git workflows, branching strategies, and CI/CD pipelines for automated deployment.
• Strong communication skills and ability to work with business stakeholders, vendors, and technical teams.

Desired Qualifications:

• Previous experience working on LAUSD Data Lake systems or similar large education/public-sector data platforms.
• Hands-on experience with Snowflake, AWS, or other cloud data platforms.
• Experience with Oracle Data Integrator (ODI) in enterprise environments.
• Experience modernizing legacy Oracle/PL SQL data processes into dbt-based models.
• Experience supporting cloud data migration, data validation, and data reconciliation activities.
• Experience working with vendor/application datasets and enterprise reporting requirements.
• Strong technical problem solver with deep Oracle, dbt, ETL/ELT, data warehouse, and data lake experience.
• Experience in Agile, DevOps, or CI/CD-enabled data delivery environments.

EEO/AA Veterans and Individuals with Disabilities

Physical Requirements: While performing the duties of this job, the employee is regularly required to stand, walk, and use hands to touch, handle or feel objects, tools or controls. The employee frequently is required to talk and hear and occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl. Must regularly lift and/or move up to 10 pounds, and occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this job include close vision, peripheral vision, depth perception and the ability to adjust focus.