Data Engineer

We are seeking an experienced Data Engineer to support transactional database engineering, database modernization, and cloud-based data platform initiatives. The role focuses on SQL Server assessment, PostgreSQL/Aurora migration, data modeling, and the development of reliable, scalable data solutions using Amazon S3, Databricks, and DevOps practices. The ideal candidate will have experience modernizing database environments, implementing data engineering best practices, and supporting secure, reliable data access across transactional, integration, and analytical systems., Assess existing SQL Server environments, including database structures, dependencies, performance, and migration considerations. Support database migration initiatives involving PostgreSQL and Amazon Aurora. Design and implement data models that support transactional processing, integration, and analytical use cases. Contribute to database modernization initiatives and cloud-based data engineering solutions. Develop and maintain data engineering solutions using Amazon S3 and Databricks. Support lakehouse and medallion architecture patterns for organizing, processing, and managing data. Implement data quality, validation, and schema management practices to improve data reliability and consistency. Apply DevOps and CI/CD practices to database and data engineering workflows. Support infrastructure automation and environment management using tools such as Terraform. Contribute to automated schema validation, version control, deployment automation, and controlled release processes. Collaborate with architecture, application, and data teams to establish effective data access and integration patterns. Support API-based data access, event-driven integration, data contracts, and domain-oriented architecture principles. Help establish appropriate separation between transactional databases, integration services, and analytical data platforms. Maintain technical documentation covering data models, migration processes, system dependencies, and operational procedures.

5+ years of experience in data engineering, database engineering, or a related technical discipline. Hands-on experience with Amazon S3. Experience with Databricks and modern data engineering platforms. Experience with DevOps practices supporting data engineering or database environments. Knowledge of transactional database engineering and database modernization. Experience assessing SQL Server databases and evaluating migration requirements. Experience with PostgreSQL and/or Amazon Aurora migration initiatives. Strong understanding of data modeling, database structures, and data dependencies. Ability to analyze data requirements and support reliable data integration across systems. Strong analytical, troubleshooting, documentation, and cross-functional collaboration skills.