DBT Data Engineer /Lead

DBT Data Engineer/Lead Location New York ,NY Onsite Type :Contract Must-have Skil lsStrong hands-on expertise with dbt Core model development Jinjamacros sources tests documentation and packaging reusabili tyAdvanced SQL complex transformations performance tuning query optimizati onSolid dimensional data warehouse modelling knowledge star snowflake facts dimensions SCD concepts as applicab leExperience delivering ELT on Databricks Databricks SQL Delta Lake concepts efficient joins file layouts understanding of medallion patterns bronze silver gold where us edGit proficiency with PR based workflows branching code reviews merge strategies cherry picki ngCI practices for dbt eg run dbt compilebuildtest in pipelines enforce quality gat esAbility to build scalable maintainable models modular layers naming conventions documented contrac ts Secondary Nice to Have Ski llsExposure to Orchestration tools ADFAirflowDagsterPrefect etcFamiliarity with downstream consumption patte rnsComfortable using AIassisted dev tools eg Copilot in accordance with company pol icy Soft Sk illsStrong problem-solving and analytical thin kingExcellent communication skills to collaborate with cross functional teams data engineersanalysts product mana gersAbility to mentor junior engineers and promote best pract icesDetailoriented with a focus on data quality and reliabi lityAdaptability in fastpaced evolving environm entsOwnership mindset with proactive approach to challe nges