Sign upLog in

BI Developer Services Level III

Compu-Vision Consulting Inc.

Los Angeles, CA(remote)

Apply
JOB DETAILS
SKILLS
Amazon Web Services (AWS), Application Programming Interface (API), Business Intelligence, Cloud Computing, Cloud Storage, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Data Analysis, Data Lake, Data Management, Data Migration, Data Modeling, Data Quality, Data Storage, Data Warehousing Applications, Database Extract Transform and Load (ETL), Git, Laptop PC, Microsoft Excel, Microsoft SharePoint, Microsoft Word, Oracle, Oracle Database, Oracle PL-SQL, Security Monitoring, Software Development, Statement of Work (SOW), Stored Procedures, Test Plan/Schedule, Unix Shell Programming, Writing Skills
LOCATION
Los Angeles, CA(remote)
POSTED
26 days ago
Title: BI Developer Services – Level III
Location: Remote
Duration: 6 months

Minimum Qualifications:
• Minimum of 10+ years of demonstrated experience in the services listed in the Statement of Work.

Qualifications and Duties:
  • Design, automate and support sophisticated data extraction, transformation, and loading applications.
  • Strong knowledge of Oracle database for batch application development within data warehouse / data lake environment.
  • Perform data ingestion from heterogeneous data sources to on-premises or cloud data storage, (including and not limited to snowflake, AWS, etc.)
  • Experience managing ETL using DBT, ODI, Oracle PL/SQL, Oracle SQL and ShellScript.
  • Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports. Work with all stakeholders including business customers, vendors, and internal resources to facilitate team communication and achieve the mission.
  • Creates and improves data solutions that enable smooth data delivery and is in charge of gathering, processing, maintaining, and analyzing enormous amounts of data.
  • Experience in data quality validation.
  • Knowledge/Experience in API development frameworks.
  • Knowledge/Expierience in Cloud native data integration technologies
  • Data lake migration experience from on prem systems to cloud platform
  • Previous Experience working on LAUSD Data Lake systems
  • Min 3 years' experience in building incremental models/handling raw data layers and building DBT models for LAUSD Vendors/Application
  • Proficiency in dbt (Data Build Tool) development, including macros, hooks, and incremental models. Experience converting complex Oracle stored procedures into modular dbt models.
  • Ability to write DBT tests for data quality and manage security on DBT models.
  • Expert-level knowledge of Git workflows, implementing branching strategies, and establishing CI/CD pipelines for automated deployment
Work Schedule:
The resource(s) shall be available to begin work upon full execution of the agreement. Standard eight (8) work hours will be Monday through Friday between 8:30 AM to 5:00 PM (Pacific Time), unless other arrangements are mutually agreed upon.

Others:
For the duration of the engagement period, the proposed firm and/or resource are expected to bring their own laptop computer equipped with appropriate tools such as Microsoft Word, Excel, SharePoint, etc.

About the Company

C

Compu-Vision Consulting Inc.