Note: The job is a remote job and is open to candidates in USA. American Unit, Inc is seeking a skilled Data Engineer within their Enterprise Business Intelligence team to support data platform evolution and cloud migration initiatives. The role involves reverse engineering legacy SQL Server SSIS packages and converting them into modern cloud ETL/ELT pipelines, while also building scalable data architectures.
Responsibilities
- Legacy Refactoring & Conversion: Analyze and reverse engineer legacy SSIS packages, stored procedures, and SQL Server objects, translating them into modern ETL/ELT pipelines
- Cloud Pipeline Development: Build, optimize, and maintain data pipelines using Azure Data Factory (ADF) , Databricks , and Snowflake
- Data Modelling & Semantics: Design and construct enterprise Power BI semantic models, data lake structures, and modern platform architectures (including support for Apache Iceberg and cloud-native frameworks)
- CI/CD & DevOps Integration: Implement and maintain data engineering workloads using Azure DevOps and GitHub for version control, automated testing, and release management
- Collaboration & Governance: Work closely with Enterprise BI, Data Quality & Governance, Data Architecture, Cyber Security, and Credit Risk teams to deliver reliable, secure, and performant data assets
Skills
- Strong hands-on experience with Snowflake, Databricks, or Azure Data Factory (ADF)
- Proven capability to reverse engineer SSIS packages and convert them into modern ETL tools
- Advanced SQL / T-SQL development skills and Python experience
- Power BI Semantic Models, Azure DevOps / GitHub, Apache Iceberg, SQL Server Management Studio (SSMS)
- Prior experience with traditional Data Warehouses, Data Lakes, and Financial/Banking industry platforms (e.g., Credit Risk Management)
- Self-starter capable of leading technical efforts independently while collaborating actively within an Agile delivery team
- Exposure to Cortex and AIM technologies is highly desirable
Company Overview