Senior Data Engineer

Balsam International is looking for a Senior Data Engineer who will be responsible for designing and developing robust scalable data warehousing solutions. This role reports to the Senior Manager of Data Engineering and focuses on building data solutions aligned with business requirements. Responsibilities include the retrieval transformation storage and delivery of data while adhering to established standards and best practices coding and providing production support for the enterprise data warehouse. Our ideal candidate is a skilled data wrangler who enjoys building data solutions from the ground up and optimizing their performance.

What youll be doing:

Data Architecture & Infrastructure Development

• Design and implement robust scalable and high-performance data solutions using Snowflake dbt and Python.
• Be accountable for building and maintaining the organizations data infrastructure.
• Champion the data warehouse by creating denormalized data foundation layers and normalized data marts.
• Work on all aspects of the data warehouse/BI environment including architecture design development automation caching and performance tuning.
• Build infrastructure for optimal extraction transformation and loading (ETL) of data from various sources using SQL and cloud data platforms like Snowflake.
• Define strategies to capture all data sources and assess the impact of business process changes on data inputs.

Data Platform Management & Optimization

• Lead the migration of existing data platforms to Snowflake ensuring minimal disruption to business operations.
• Manage the full lifecycle of data within Snowflake from ingestion and storage to analytics and reporting.
• Conduct performance tuning and troubleshooting of the Snowflake environment to ensure optimal efficiency.
• Identify design and implement internal process improvements such as re-architecting for scalability optimizing data delivery and automating manual processes.

Cross-functional Collaboration & Stakeholder Support

• Collaborate with systems analysts and cross-functional partners to understand data requirements.
• Work with stakeholders including Executive Product Data and Design teams to support data infrastructure needs and resolve data-related technical issues.

Innovation & Continuous Improvement

• Continually explore emerging technologies such as Big Data Artificial Intelligence Generative AI Machine Learning and Predictive Data Modeling to enhance data capabilities.

Performs other duties that may be assigned from time to time.

What were looking for:

• 8 years of professional experience in the data engineering field
• Hands-on polyglot programming expertise - hands-on current Python experience is a must-have
• Marketing channel data automation pipeline monitoring and data delivery is strongly preferred
• Extensive experience in designing developing Snowflake Cloud Data Platform
• Proficiency in multi-cloud platform like AWS Azure and/or GCP
• Proficiency in designing and implementing data pipelines using diverse data sources including databases APIs external data providers and streaming sources
• Demonstrated history of designing efficient data models using Medallion Architecture
• Deep understanding and experience with relational (SQL Server Oracle Postgres and MySQL) and NoSQL databases
• Experience building and supporting REST APIs for both inbound and outbound data workflows
• Proficiency and solid grasp of distributed system concepts to design scalable and fault tolerant data architectures
• Excellent critical thinking to perform root cause analysis on external and internal processes and data to identify opportunities for improvement and answer questions
• Excellent analytic skills associated with working on structured and unstructured datasets
• Ability to build processes that support data transformation workload management data structures dependency and metadata
• Ability to build and optimize data sets big data data pipelines and architectures
• Ability to understand and tell the story embedded in the data at the core of our business
• Ability to communicate with non-technical audience from a variety of business functions
• Strong knowledge of coding standards best practices and data governance
• Demonstrated AI literacy enabling effective understanding interaction and critical evaluation of AI technologies and applications across diverse business functions

Location: The Senior Data Engineer position is a remote working position for Balsam International Unlimited Philippine ROHQ in Manila. Team members in the Philippines are located within Metro Manila Bataan Batangas Bulacan Cavite Laguna Pampanga Rizal and Tarlac areas only.

Our must-haves:

• Must attend occasional in-person meetings.
• Must have a fast reliable DSL Fiber or Broadband connection (not mobile or broadband stick) as the primary internet connection with a minimum actual speed of 50MBPS.

Note: An online assessment will also be part of the recruitment process.

Status: This is a full-time permanent position with benefits.

Hardware Provision: Company-issued Laptop will be provided on your first day.

At Balsam International we strive to offer a competitive compensation and benefits package. For permanent full-time team members this includes:

• Government-mandated Benefits (SSS PAG-IBIG PhilHealth)
• 13th Month Pay
• Paid Leaves. We use time off to rest go on vacation or just sleep in! Our paid time off is flexible to our needs.
• Internet Subsidy. With internet allowance we are set up for success.
• Healthcare Coverage ( 2 dependents). We worry less about rising medical costs with flexible quality healthcare benefits.
• Maternity Paternity and Solo Parent Benefit. We make sure parents are supported while they navigate work and family life.
• Continuous Learning and Professional Development Benefit. Our professional and personal development are fully supported. Whether it be online courses workshops or books!
• Mental Health Support. We manage work and lifes challenges through Mental Health Day breaks 24/7 professional counselling and curated webinars.
• Company Incentive. An additional cash-based perk for all our Brandits based on companys performance.
• Meeting and Team Building Allowance. Happy tummies make our meetings more fun and productive!
• Shutdown Week. We can spend more time on things that matter with an additional one-week paid time off on top of paid leaves.
• Volunteer Time Off. With two paid days off we are able to volunteer for advocacies we believe in.
• Bereavement Leave. We get additional paid leaves when a loved one passes to grieve and provide immediate support to our families.

Remote Work :

Yes

Employment Type :

Full-time