Sr Data Engineer (Databricks, MDM, SNOWFLAKE, ELASTIC SEARCH)

Job Title: Sr Data Engineer (Databricks, MDM, SNOWFLAKE, ELASTIC SEARCH) Location: Chicago, Il ( All 5 days Onsite) - need locals Duration 12 months Required Qualificati • ons10+ years of hands-on Data Engineering experience - building, operating, and troubleshooting production ETL/ELT pipelines (not just BI/reporting developmen • t).Strong, demonstrable Snowflake experience - data modeling, warehouse sizing/performance tuning, RBAC/security, Streams/Tasks/Snowpipe, and cost optimization. Candidates should be prepared to speak to specific Snowflake implementations or migrations they've deliver • ed.Advanced SQL skills - complex joins, window functions, query optimization, and data reconciliation across heterogeneous sourc • es.Experience with cloud data platforms (Azure preferred) and modern ELT tooling (dbt, Fivetran, ADF, or equivalent) also strong knowledge of AWS environme • nt.Proven ability to work independently with minimal ramp-up time; comfortable operating in an ambiguous environment where source-system documentation may be incomple • te.Strong written and verbal communication in English; able to work core U.S. business hours regardless of locati on. Preferred Qualificat • ionsExperience with Databricks (medallion architecture, Delta Lake, Unity Catalog) - Newmark's Enterprise Data Lake runs on Databricks and this role will interface with • it.Exposure to Reltio or other MDM platfo • rms.Experience migrating from/to BI tools such as Tableau, Power BI, or Metab • ase.Prior experience in commercial real estate, financial services, or other data-governance-heavy industr • ies.Elastic Search experie nce. What Success Looks • LikeRapid ramp-up with minimal hand-holding - able to independently reverse-engineer existing pipeline logic from source systems with limited documenta • tion.Clean, well-documented, production-grade pipeline code - not prototype-quality • work.Proactive identification of data quality/reconciliation issues before they reach downstream BI consu • mers.Reliable delivery against weekly milestones in a fast-moving, multi-workstream environ ment.