Data Engineer II (Bench)

Arch Global Services (Philippines) Inc.; Quezon City; On-site; PHP 1,800,000 - 3,000,000; Full time

Job summary

Arch Global Services (Philippines) Inc. is seeking an experienced Data Engineer to join our product team in a fast-paced environment. You will develop and maintain ELT/ETL data warehouse solutions, automate data processes, and collaborate with partners to implement product changes.

You will mentor offshore developers, uphold data engineering best practices, and support production environments while leveraging Snowflake, Python, and BI tools like Power BI in an Azure context.

Qualifications

• Bachelor's degree in computer science, MIS or related field required.
• 8+ years in data engineering with ETL/ELT.
• Experience with Snowflake and BI tools like Power BI.
• Experience in insurance/reinsurance domain is a plus.

Responsibilities

• Develop and maintain ELT/ETL data warehouse solutions.
• Automate data processes with minimal human intervention.
• Collaborate with tech and business partners to implement changes.
• Produce design and unit test documents as required.
• Mentor offshore developers and drive data engineering best practices.

Skills

SQL

Mentoring

Analytical thinking

Collaboration

Data engineering best practices

Education

Bachelors in CS/MIS

Tools

IICS

Informatica

StreamSets

DBT

Python

Databricks

Snowflake

ADF

SSIS

SSRS

Power BI

Azure

Job description

Arch Global Services offers competitive pay and a comprehensive benefits package. Additionally, Arch is committed to helping its associates create what's next by providing access to a variety of programs supporting your professional development and a culture that encourages innovation, collaboration and professional growth. We seek talent that thinks innovatively, values collaboration and will go the extra mile to serve our customers and develop our company.We also have a little fun along the way, check out our Holiday Party.

Data Engineer will work closely with the rest of the product team and business peers to effectively execute Data project initiatives. This person should be able to deliver in a fast-paced and deadline-driven environment. Along with development, candidate will be responsible for maintenance of the data applications and would be expected to automate the processes with no or minimal human intervention.

• Strong SQL
• Development and maintenance of ELT snowflake data warehouse solutions
• Collaborate with internal and external technology and business partners to implement product changes
• Produce detail design and unit test documents, as required
• Critically analyze business requirements, architect and implement Data solutions
• Define, develop and maintain standards and processes to ensure effective ETL solution
• Production maintenance
• Work closely with product manager to develop and execute action plans to address gaps
• Recommend innovations that enhance and/or provide a competitive advantage to the organization
• Communicate effectively with both the business and technical teams
• Mentor junior offshore developers to accomplish results
• Build and continuously improve data engineering best practices

• Min 8 years of Data engineering experience using ETL/ELT technologies
• 6+ years ETL/ELT experience working with IICS, Informatica, StreamSets, DBT, Python, Data bricks, Snowflake and ADF or equivalent technologies
• 1 year hands on experience with Snowflake
• Experience working with SSIS, SSRS, and Power BI
• 1 year hands on experience working in an Azure environment.
• Experience working in insurance or reinsurance industry is highly desirable
• 3+ years hands on experience with agile methodologies
• Experience with Data warehouse/ data lake/ data hub modeling
• Experience working with external data feed to enrich internal data- desired
• 3+ years hands on experience with data standardization/conformance/transformation process
• Solid understanding of MDM and reference data
• 3+ years hands on experience with CI/CD process, especially in data engineering
• Experience working in SOX and SOC-2 compliant environment
• Experience with automated monitoring of data loads
• Support of production environment
• Strong understanding of technologies utilized in the industry and the ability to see their impact as well as enhancement management and product lifecycle development
• Knowledge of source code version control systems such as Git including branching/merging, resolving code conflicts, and 3-way and baseless merges
• Relevant experience working with 3rd party vendors to deliver results

• Bachelor's degree in computer science, MIS or related field required