Location: Remote must be available to work PST hours
Overview: STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in Los Angeles, New York, New Jersey, Atlanta, and more including internationally in Mexico and India.
The Oracle BI Developer will design, automate, and support data extraction, transformation, and loading applications across data warehouse and data lake environments. This role will support data ingestion, ETL development, data modeling, validation, and cloud-based data integration. The position requires strong Oracle database knowledge, DBT development experience, and the ability to build scalable data solutions that support enterprise reporting and analytics needs Qualifications & Responsibilities
Design, automate, and support sophisticated data extraction, transformation, and loading (ETL) applications.
Demonstrate strong knowledge of Oracle databases for batch application development within data warehouse and data lake environments.
Perform data ingestion from heterogeneous data sources into both on-premises and cloud-based data storage platforms, including but not limited to Snowflake and AWS.
Manage ETL processes using DBT, ODI, Oracle PL/SQL, Oracle SQL, and Shell Scripting.
Develop dimensional hierarchies and design data models that support multiple Enterprise Data Management reports. Work closely with business stakeholders, vendors, and internal teams to facilitate communication and achieve project objectives.
Create and improve data solutions that enable efficient data delivery and support the gathering, processing, maintenance, and analysis of large-scale datasets.
Perform and support data quality validation processes.
Possess knowledge and experience with API development frameworks.
Demonstrate knowledge and experience with cloud-native data integration technologies.
Have experience migrating data lakes from on-premises systems to cloud platforms.
Previous experience working on LAUSD Data Lake systems is required.
Minimum of three years of experience building incremental models, handling raw data layers, and developing DBT models for LAUSD vendors and applications.
Demonstrate proficiency in DBT (Data Build Tool) development, including experience with macros, hooks, and incremental models, as well as experience converting complex Oracle stored procedures into modular DBT models.
Ability to write DBT tests for data quality validation and manage security for DBT models.
Expert-level knowledge of Git workflows, including implementing branching strategies and establishing CI/CD pipelines for automated deployment processes.
10+ years of experience in the field
Benefits
Medical coverage and Health Savings Account (HSA) through Anthem
Dental/Vision/Various Ancillary coverages through Unum
401(k) retirement savings plan
Paid-time-off options
Company-paid Employee Assistance Program (EAP)
Discount programs through ADP WorkforceNow
Additional Details The base range for this contract position is $72 - $88 / per hour, depending on experience. Our pay ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Qualified applicants with arrest or conviction records will be considered.
About Us STAND 8 provides end-to-end IT solutions to enterprise partners across the United States and globally with offices in Los Angeles, Atlanta, New York, Mexico, Japan, India, and more. STAND 8 focuses on the "bleeding edge" of technology and leverages automation, process, marketing, and over fifteen years of success and growth to provide a world-class experience for our customers, partners, and employees. Our mission is to impact the world positively by creating success through PEOPLE, PROCESS, and TECHNOLOGY. Check out more at www.stand8.io; and reach out today to explore opportunities to grow together! By applying to this position, your data will be processed in accordance with the STAND 8 Privacy Policy.
Numbers & Facts
Location
Los Angeles, California (Remote)
Skills
ADPunmatched
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Application Programming Interface (API)unmatched
Automationunmatched
Business Intelligenceunmatched
Cloud Computingunmatched
Communication Skillsunmatched
Continuous Deployment/Deliveryunmatched
Continuous Integrationunmatched
Customer Experienceunmatched
Data Lakeunmatched
Data Managementunmatched
Data Migrationunmatched
Data Modelingunmatched
Data Qualityunmatched
Data Setsunmatched
Data Storageunmatched
Data Warehousing Applicationsunmatched
Database Extract Transform and Load (ETL)unmatched
Employee Assistance Planunmatched
Gitunmatched
Marketingunmatched
Model Validationunmatched
Oracleunmatched
Oracle Databaseunmatched
Oracle PL-SQLunmatched
Process Managementunmatched
Scalable System Developmentunmatched
Security Monitoringunmatched
Stored Proceduresunmatched
Test Plan/Scheduleunmatched
Unix Shell Programmingunmatched
Writing Skillsunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.