• Monitor and manage overnight scraper and ingestion runs, triaging failures and applying fixes in real time to minimize data gaps before US market open • Verify data completeness and quality across all automated feeds, flagging anomalies and coordinating with the Houston team on persistent issues • Maintain run logs, error documentation, and escalation notes for seamless async handoffs • Build and maintain scrapers, parsers, and ingestion pipelines across a growing set of energy market data domains • Contribute to the design and build-out of our broader ETL infrastructure, including scheduling, orchestration, and error handling • Write transformation logic to clean, normalize, and load raw data into PostgreSQL staging and production tables • Optimize existing pipelines for performance, reliability, and cost efficiency • Help build monitoring dashboards and alerting for pipeline health and data freshness • Document data lineage, schema changes, and pipeline dependencies

• Transform financial lives through innovative data solutions • Support internal mobility and create a diverse environment

• Lead data architecture design, API assessment, and ETL requirements gathering during the Discovery & Design phase. • Develop and configure CMIC ERP API integration to establish reliable data exchange between the ERP system and the AWS platform. • Design and implement data pipelines using AWS Glue for ETL processing of subcontractor documents and ERP data. • Integrate Amazon Textract to extract structured data from insurance certificates, bonding letters, and financial documents. • Build and maintain data models to support AI-powered validation, risk profiling, and executive reporting. • Configure Amazon S3 data lake architecture to store and manage raw, processed, and curated data assets. • Implement AWS Lambda and AWS Step Functions to orchestrate data workflows and automated processing pipelines. • Develop and expose data through Amazon API Gateway to support application and dashboard consumption. • Ensure data quality, validation, and integrity across all integration points and pipeline outputs. • Conduct data integration testing and support user acceptance testing (UAT) for data-dependent features. • Collaborate with Full Stack, AI/ML, and DevOps team members to ensure seamless end-to-end data flows. • Contribute to knowledge transfer documentation, data pipeline runbooks, and operations guides.

Dreamix was founded 19 years ago by passionate IT students who wanted to create the dreamiest workplace where everyone is heard, works under transparent management, and lives up to their full potential. Now, many years later, we deliver software solutions for renowned companies from Germany, the UK, Switzerland, and Silicon Valley. We believe that the employer-employee relationship must be in the form of partnership, not transaction. We are committed to investing as much as possible in our employees and we expect the same from you. About the Role: We are looking for a skilled and motivated Lead Data Engineer to drive the design, implementation, and evolution of cloud-native data platforms on AWS. In this role, you will own the end-to-end architecture of data ingestion, transformation, and delivery pipelines — from heterogeneous source systems through to executive-facing BI dashboards. You will combine deep technical expertise with strong stakeholder engagement to ensure data solutions are robust, scalable, and aligned with business needs. Responsibilities: - Lead teams of data engineers and analytics professionals, providing technical direction and mentorship across the project lifecycle - Architect and implement cloud-native data platforms on AWS, designing schemas and ingestion pipelines that handle structured data from diverse sources including Excel feeds, legacy databases, and third-party systems - Design, develop, and maintain ETL/ELT pipelines using AWS Glue and Step Functions, ensuring reliable data transformation, validation, and quality enforcement at every stage - Own the infrastructure-as-code practice using Terraform — provisioning, versioning, and managing all cloud resources with full reproducibility and environment consistency - Deliver end-to-end reporting solutions through Power BI, translating complex data models into intuitive dashboards that provide stakeholders with actionable, near-real-time insights - Translate complex technical concepts and architectural decisions to non-technical stakeholders clearly and persuasively, facilitating informed decision-making at all levels - Establish and enforce best practices around data quality, pipeline monitoring, documentation, and incident response - Participate in pre-sales and discovery efforts, leveraging technical expertise to support scoping, estimation, and business development initiatives Requirements: - Bachelor's or Master's degree in Computer Science, Data Engineering, Information Systems, or a related field - 7+ years of experience in data engineering, cloud infrastructure, or platform development, with a demonstrated track record of delivering production-grade data solutions - Strong hands-on experience with AWS data services — particularly Glue, Step Functions, S3, RDS/Redshift, IAM, and CloudWatch - Proficiency in SQL and Python for data transformation, pipeline orchestration, and scripting - Solid experience with Terraform or equivalent IaC tooling for managing cloud infrastructure - Proven ability to design and optimize ETL/ELT pipelines for data ingestion from heterogeneous sources - Experience building dashboards and data models in Power BI (or equivalent BI tools such as Tableau or Looker) - Strong understanding of data modeling, schema design, and data warehousing concepts - Exceptional communication, presentation, and stakeholder management skills — comfortable leading technical discussions with engineering teams and presenting insights to C-level audiences alike - Strong leadership capabilities with experience mentoring engineers and driving best practices across teams Nice to Have: - Experience with additional AWS services such as Lambda, Athena, Lake Formation, or EventBridge - Familiarity with CI/CD pipelines for data infrastructure (e.g., GitHub Actions, CodePipeline) - Exposure to data governance, cataloging, or lineage tooling - Experience working in consulting or multi-client delivery environments What you’ll get: - A collaborative, knowledge-sharing culture built on transparency and mutual respect - Flexible working hours that allow you to balance your work and personal life - Unlimited home office to help you stay productive and focused - Opportunities for professional development, including certifications and training - Additional benefits for academic teaching and speaking engagements - Knowledge-sharing sessions where you can learn from our Dreamix team - Team and company-wide events that bring us together - Amazing week long summer office and winter office initiatives - Additional health insurance and dental allowance to ensure your well-being - Multisport card to encourage a healthy and active lifestyle - Office massages to help you relax and unwind If you find the mentioned above interesting, send us your CV! Only shortlisted candidates will be contacted. The confidentiality of all applications is assured! By applying for this job, you voluntarily agree and submit your personal information. Any personal data that you provide will be processed in strict confidentiality by Dreamix ltd. only for the purposes of selection and recruitment and will not be transferred to other data controllers unless required by law. It will be stored, processed, retrieved, and deleted in accordance with the GDPR.