Data Engineer

Key Responsibilities: Data Engineering & Pipeline Management Design, build, and optimize T-SQL stored procedures, functions, and scripts for high-volume data processing and ECM scoring. Develop, deploy, and monitor end-to-end ETL/ELT workflows (e.g., SQL Server Agent, SSIS, Azure Data Factory, or Airflow) with checkpoint/rollback, job tracking, and recovery capabilities. Perform data cleansing, preparation, and transformation to support business intelligence and machine learning workflows. Engineer and maintain reusable feature store tables (per entity/tax type) for ML models and operational scoring. Model and maintain data warehouse structures (3NF, dimensional/star/snowflake), ensuring proper documentation of data lineage. Prepare and deliver curated, scored datasets for downstream consumption in Power BI dashboards and analytics environments. Develop and maintain audit, telemetry, and job tracking tables to ensure data reliability, restartability, and monitoring visibility. Support ...