Logo for Navitas Partners, LLC

Senior Developer Level II (Offshore)

Navitas Partners, LLC

Role overview

Qualifications

  • At least 5 years of experience as a dbt developer
  • Strong focus in Snowflake
  • Knowledge of snowflake, git, pull requests, visual studio code, and dbt
  • Proficient in creating and maintaining complex SQL statements

Responsibilities

  • Establish and document technical requirements for reporting software
  • Assist in all phases of reporting software development cycle
  • Facilitate SQL design sessions and code walk-throughs
  • Train staff members on development processes and standards

About the company

Navitas Partners, LLC logo

Navitas Partners, LLC

IT Services & IT Consulting

Navitas Partners LLC is a diversity led business, headquartered in NJ, as a dynamic IT professional services and workforce solutions company. We believe creating the best solutions in human resource services means always going above and beyond - and people are our most important asset. Our “DNA” invokes core values of knowing, trusting and serving our relationships. The better we know our clients and candidates, the better our relationship, and the better we match the needs and exceed expectations. We want our client’s experience with us to reflect a transparent, professional and driven relationship. At Navitas Partners we strive for Excellence in People, and grow with you to become a true extension of your HR specific business requirements, while remaining sensitive to your price & business needs. Certified Diversity Employer: SBE • WOSB • WBE • MBE • NMSDC NAICS: 541511, 541512, 541513, 541519, 54164, 518210, 811212, 561320 https://form.jotform.com/223145471243247

Company details

Company typeSME
IndustryIT Services & IT Consulting
Company size51 - 200

Links

Website LinkedIn See all jobs

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

Title: Senior Developer Level II
Location: India (Offshore)
Duration: 7 months
Note: Candidate will be paid in Indian Rupees (Monthly Salary)
Shift: PST (USA)

QUALIFICATIONS AND DUTIES:
DEVELOPER LEVEL II :
  1. Establish and document the technical requirements for reporting software including tables, views, report design, unit test plans, and test cases.
  2. Assist in all phases of the reporting software development cycle including requirements gathering, analysis, design, testing, implementation, and production support.
  3. Proficiently create and maintain complex SQL statements to generate tables and views that will be used by PowerBI developers to drive visualizations. Develop and enhance SQL-based tables and views as per user requirements.
  4. Facilitate SQL design sessions and SQL code walk-throughs to ensure adherence to development standards and best practices using dbt.
  5. Have at least 5 years of experience as a dbt developer, with a strong focus in Snowflake.
  6. Knowledge of snowflake, git, pull requests, visual studio code, and dbt is strongly recommended.
  7. Develop and maintain documentation on all database models, tables, guidelines, methods, and standards to ensure consistency and clarity.
  8. Provide recommendations for further definition of development standards and application architecture based on industry best practices and emerging technologies.
  9. Conduct unit testing and assist in user testing of complex SQL statements or report modifications to ensure quality and functionality meet requirements.
  10. Train other staff members on development processes and standards to ensure consistency across the team.
  11. Design, implement solution using AWS for vendor inbound/outbound data transfer in LAUSD Data lake environment.
  12. Design, implement data lake inbound/outbound solutions using cloud technologies Five Tran, AWS Glue, AWS (Transfer Family, Step Function, Event Bridge, lambda).
  13. Other duties as assigned

SCOPE OF SERVICES
The District seeks resource(s) that will perform the required work closely with client's project team members and perform below responsibilities:

DEVELOPER (Level II): Offshore Resources (Development & Operations Level)
Focus: Execution, Transformation Logic, and Continuous Monitoring.
  1. dbt Development , Data Transformation and Migration from Oracle to Snowflake
  • Model Conversion: Rewrite legacy Oracle stored procedures and views into modular dbt models.
  • Testing & Documentation: Implement dbt-tests (schema, unique, not_null) and maintain the schema.yml documentation for all migrated IODS tables.
  • Refactoring: Optimize Oracle SQL to leverage Snowflake's micro-partitioning and clustering keys to reduce warehouse costs.
  1. Migration Execution (ELT):
  • Pipeline Monitoring: Monitor the extraction jobs to ensure data lands correctly in the staging area before dbt takes over.
  • Data Validation: Run "Row Count " and "Checksum " comparisons between the Monolithic Oracle source and Snowflake target.
  • Environment Management: Perform routine dbt runs (dbt run, dbt test) across Dev and QA environments to ensure code parity before Onsite UAT.

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Related jobs

California (USA)

Other jobs at Navitas Partners, LLC

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.