Offshore dbt Developer
Roles & Responsibilities
• Translate Informatica mappings, transformations, and business rules into dbt models (SQL) on Snowflake.
• Design and implement staging, core, and mart layers using standard dbt patterns and folder structures.
• Develop and maintain dbt tests (schema tests, data tests, custom tests) to ensure data quality and integrity.
• Implement snapshots, seeds, macros, and reusable components where appropriate.
• Collaborate with Snowflake developers to ensure physical data structures support dbt models efficiently.
• Work with functional teams to ensure functional equivalence between legacy Informatica outputs and new dbt outputs.
• Participate in performance tuning of dbt models and Snowflake queries.
• Integrate dbt with CI/CD pipelines (e.g., Azure DevOps, GitHub Actions) for automated runs and validations.
• Contribute to documentation of dbt models, data lineage, and business rules.
• Participate in defect analysis, bug fixes, and enhancements during migration and stabilization phases.
Experience & Skills
• 7+ years of experience in Data Engineering / ETL / DW, with 2+ years working with dbt (Core or Cloud).
• Strong SQL skills, especially on Snowflake or another modern cloud DW.
• Experience with dbt concepts: models, tests, sources, seeds, snapshots, macros, exposures.
• Prior experience with Informatica (developer-level understanding of mappings/workflows) is highly desirable.
• Understanding of CI/CD practices and integrating dbt into automated pipelines.
• Knowledge of data modeling (dimensional models, SCDs, fact/dimension design).
• Experience working in offshore delivery with onshore coordination.
• Good communication skills and ability to read/understand existing ETL logic and requirements documentation.
...Position Description The Senior Enterprise Data Architect will be responsible for designing and implementing solutions within Business Intelligence and Data Management software and hardware to meet business requests. The ideal candidate should be able to create data...
...Additional Information About the Role BJC HealthCare is hiring CRNAs for our highly respected Magnet-Recognized hospital, Missouri Baptist Medical Center, located in an esteemed area of St. Louis, MO. Certified Registered Nurse Anesthetist (CRNA) ~ Full Time...
...Description We are seeking a motivated, customer-centric Automotive Sales Representative to join our growing dealership team. In this... ...the presentation and staging of vehicle displays on the sales floor and lot. Requirements and Qualifications Education: High...
...To support a growing marketing team, the full-time Digital Marketing Associate will build and deploy multi-channel digital marketing campaigns, coordinate with external ad vendors, and collaborate with creative teams to produce compliant and effective marketing materials...
...CMS Mortgage is looking for a Loan Officer Assistant to serve as a true right-hand partner to our Loan Officer. This is not an entry-level support role. We are seeking someone with strong mortgage experience who is client-facing, detail-oriented, and confident in managing...