Note: The job is a remote job and is open to candidates in USA. Brooksource is recruiting a Data Engineer for an unnamed enterprise client’s Client Communications team. The role leads data modeling and performance work for a MySQL-to-PostgreSQL migration, builds and operates ETL pipelines, and maintains data contracts and platform health while using and advancing AI-assisted development practices.
Responsibilities
- Build conceptual, logical and physical data models for the client communications domain in PostgreSQL and drive the migration from the existing MySQL instance
- Own data performance across both engines: indexing, query plans, partitioning and load testing
- Build and operate hands-on ETL that moves communication, template and delivery data between MySQL, Postgres, Iceberg tables and downstream consumers
- Expose clean, versioned data contracts to application services and the federated graph
- Maintain data dictionaries, entity relationships and pipeline documentation; enforce data quality checks; handle upgrades, patches and backups
- Use AI coding tools (GitHub Copilot or similar) across the full workflow and help the team adopt new tooling and practices
Skills
- 5+ years in data engineering or database development, with production experience in both MySQL and PostgreSQL, ideally including a migration between them
- Significant data modeling skill: normalized and analytical models, schema evolution and migrations
- Strong data performance skills: advanced SQL, query optimization and tuning under real load
- Hands-on ETL experience building and running pipelines, not just designing them, using Python, Node.js or SQL-based tooling
- Experience with Apache Iceberg table formats
- Hands-on with AI coding tools and an AI-assisted development workflow
- Bachelor's degree in computer science or a related field, or equivalent experience
- Databricks
- Power BI
- Spark, Airflow or similar orchestration; Kafka
- GraphQL or federated graph exposure; Dynatrace; AWS and Kubernetes
Benefits
- Medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage, with plans that can fit each employee’s needs
- 401k plan with a company match, fully vested after you become eligible
- Paid time off
- Sick time
- Paid company holidays
- Employee Assistance Program (EAP), with services like virtual counseling, financial services, legal services, and life coaching
Company Overview
Company H1B Sponsorship