Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
BI Developer - Level III
Job
FileImport - Science Systems and Applications, Inc. | Science System and Applications, Inc
Lanham, MD (In Person)
Full-Time
Review key factors to help you decide if the role fits your goals.
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
74
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
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.
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.
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 ...For full information see follow application link. SSAI is an Equal Employment Opportunity and Affirmative Action Employer.
EOE, including disability/vets
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 ...For full information see follow application link. SSAI is an Equal Employment Opportunity and Affirmative Action Employer.
EOE, including disability/vets