Senior Data Engineer

• →Clean, standardize, and integrate large, messy datasets from diverse ERP, finance, and operational systems, applying AI-driven approaches for anomaly detection, data quality monitoring, and metadata enrichment.
• →Maintain and optimize relational database schemas (PostgreSQL), including materialized views for transactional and reporting systems.
• →Build and maintain ETL pipelines using Python, Airflow, DBT and related tooling leveraging AI-powered developer tools (e.g., Copilot, Claude, Cursor) to accelerate coding, testing, and documentation.
• →Establish and enforce data quality rules, validation logic, and monitoring standards.
• →Create database connections and integrations between PostgreSQL and Microsoft applications.
• →Document data models, pipelines, and business logic to ensure scalability and knowledge sharing.
• →Collaborate with business stakeholders to understand data requirements and deliver actionable solutions.
• →Contribute to data governance practices, including metadata management and access controls.
• →Design data models to support complex ERP and operational domains.
• →Support vendor management and coordinate contributions from internal and external implementation teams.
• →Participate in tool evaluations and contribute to the evolution of our modern data stack (warehouse, orchestration, catalog, etc.).

May participate in vendor/tool selection and cost-performance tradeoffs, but does not own a budget directly.

Will address highly complex, multi-source data integration challenges spanning ERP, inventory, finance, and operations. Requires balancing long-term scalability with short-term tactical needs.

Ability to collaborate with other developers, product team, vendors, and stakeholder;

• None required; cloud platform certifications (e.g., Azure Data Engineer Associate) are a plus.

• Preferred: Bachelors degree in Computer Science, Data Engineering, or related STEM field (Not Required)

• 8+ years of experience in data engineering or database architecture roles
• Nice to have: 2+ years in a lead or architect capacity

• Strong experience with relational database design (PostgreSQL preferred)
• Deep understanding of Modern ELT/ETL best practices and tools (Python, Airflow, dbt, etc)
• Experience designing databases and integrations for ERP system
• Direct experience using modern AI development tools like Copilot, Claude, or Cursor to accelerate coding, testing, and documentation.
• Preferred: Familiarity with applying AI/ML services in Azure (e.g., Cognitive Services, Azure Machine Learning) for advanced data engineering use cases.
• Preferred: Experience in Distribution or transactional accounting