Senior Data Engineer

MUST BE ON W2 - NO SUBVENFING/THIRD PARTY RECRUITERS PERMITTED Senior Data Engineer Start Date: ASAP Duration: 12 months (extension and conversion possible, based on performance/business needs) Location: Remote (EST or CST time zones only) Summary: We are seeking an experienced Data Engineer to support the development of a complex data model focused on financial crime analytics. The role involves designing and building robust ETL pipelines, curating high-quality data, and enabling downstream analytical work. The successful candidate will work with cross-functional teams in a highly collaborative environment, with exposure to advanced AI use cases. Key Responsibilities: • Develop and maintain complex data models (structured and unstructured data, star schemas, SCD tables, medallion architecture). • Design, build, and optimize ETL pipelines; perform exploratory data analysis to validate and reconcile data sources. • Collaborate with stakeholders to identify requirements and deliver curated datasets. • Apply coding expertise to build scalable data solutions (SQL, Python, PySpark). • Work on Azure and Databricks cloud platforms. Must-Have Skills: • 8–10 years’ experience in data engineering. • Proficiency in data modeling (OLAP vs. OLTP, medallion architecture). • Strong ETL pipeline development and validation skills. • Hands-on coding in SQL, Python, PySpark. • Experience with Azure and Databricks. Nice-to-Have Skills: • Financial services/banking data experience (accounts, transactions, AML, risk). • Exposure to LLMs (prompt engineering, training/fine-tuning). • Programming or web development background. • BI tools such as Tableau or Power BI.