Data Analyst - Data Engineer, Monee Credit
Summary
As a Data Warehouse & Automation Engineer, you will design and maintain Data Warehouse tables, build automated data pipelines, and manage Reverse ETL workflows for operational tools and regulatory reporting. The role involves using SQL, Python, and Apache Spark to ensure data quality and optimize database performance.
Job Description
- As a Data Warehouse & Automation Engineer, you will sit at the intersection of data warehouse engineering, automated workflows, and regulatory compliance.
- You will own the design, build, and maintenance of robust Data Warehouse & Data Mart tables, while building automated data pipelines and Reverse ETL workflows to stream critical data back into operational tools and regulatory reporting bodies.
- Collaborate with BI, Regulatory Compliance, and Project teams to translate business and compliance requirements into Data Mart & Business Automation solutions.
- Implement data validation, error handling, and automated data quality checks to ensure accuracy, consistency, and reliability across all warehouse layers.
- Apply software engineering best practices to analytics codebases, optimize database queries, partitioning, and storage to handle growing data volumes efficiently.
- Build and maintain secure, automated data pipelines to format, validate, and push compliance data directly to regulatory portals.
Requirements
- Bachelor’s degree in Computer Science, Data Analytics or related field with +2 years of professional experience in a Data Warehouse Engineering or related roles
- Advanced SQL skills with focus on query performance tuning and best practices.
- Proficiency in designing robust data warehouse architectures that support high-volume analytics and business reporting.
- Working knowledge of Python focused on scripting, operational automation, and reverse-ETL.
- Proficiency in Apache Spark (PySpark/Spark SQL) for large-scale data engineering.
- Experience with analytics engineering concepts and tools (dbt, Dataform, or equivalent tool) is a plus.
- Good communication skills in English is a must, with the ability to explain insights clearly to non-technical stakeholders.