Data Engineer - Mid

McNeil & Co.; Manila, Hinoba-an; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

Arch Global Services (Philippines) Inc. seeks a data engineering professional to manage data ingestion, governance and scalable ETL pipelines. You will design cloud-based solutions and collaborate with vendors to streamline data from top sources while ensuring quality and traceability.

Ideal candidates have strong Python/SQL skills, experience with Azure services and modern data platforms, and a collaborative, detail-oriented mindset suited to our Risk and Quantitative team.

Qualifications

• Familiar with script coding in Python and SQL.
• Experience with Azure Services, Azure Blob Storage, Snowflake and Databricks is a plus.
• Excellent organizational skills; able to work on own initiative and follow instructions.
• Comfortable tracing data flow and troubleshooting under time constraints.

Responsibilities

• Innovative Solutions: Design and implement cutting-edge data engineering solutions across Cloud, DevOps, and Data Engineering.
• Data Stewardship: Own data managed in-house from major vendors and external sources.
• Collaborative Onboarding: Partner with business units and IT to onboard new data sources.
• Process Enhancement: Develop and refine data ingestion with governance and control.
• Architectural Design: Design data storage and ETL processes for efficiency and scalability.
• Strategic Collaboration: Work with AIM's GSO partner on data ingestion tasks.
• Documentation: Maintain comprehensive documentation of data engineering processes.
• Quality Assurance: Create and execute test plans for data pipelines and systems.

Skills

Python

SQL

Data governance

Team player

Communication

Education

BS in Engineering, Computer Science, Information Technology, Data Analytics or equivalent

Tools

Azure Services

Azure Blob Storage

Snowflake

Databricks

Job description

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility.

Arch investment Management Ltd. (AIML), based in Bermuda, is a wholly owned subsidiary of Arch Capital Group Ltd., a leading insurance and reinsurance company. Arch Capital has investable assets of over $36 bn. Arch Investment Management manages Arch Capital and its subsidiaries' portfolios.

The continued growth of the company has created the need to fill a new position within our Risk and Quantitative team to help manage our data.

Responsibilities

• Innovative Solutions: Design and implement cutting-edge solutions across Cloud, DevOps, and Data Engineering to streamline our processes.
• Data Stewardship: Take ownership of all data managed in-house, sourced from top-tier vendors like BlackRock, Clearwater, Bloomberg, ICE, BONY, and external managers.
• Collaborative Onboarding: Partner with business units and IT together to onboard new data sources and enhance our ingestion processes.
• Process Enhancement: Continuously develop and refine data ingestion processes, emphasizing robust data governance and control mechanisms.
• Architectural Design: Play a pivotal role in designing our data storage systems and ETL processes to ensure efficiency and scalability.
• Strategic Collaboration: Work closely with AIM's GSO partner to oversee and improve manual or ad hoc data ingestion tasks.
• Comprehensive Documentation: Maintain detailed documentation of all data engineering processes and solutions to ensure clarity and continuity.
• Quality Assurance: Develop and execute rigorous test plans to guarantee the reliability and accuracy of our data pipelines and systems.

Required Skills / Experience

• Familiar with script coding in Python and SQL.
• Experience with Azure Services, Azure Blob Storage, Snowflake and Databrick is a plus.
• Well-functioning team player and strong oral and written communicatorExcellent organizational skills with the ability to work on own initiative and follow instructions.
• Comfortable with tracing data flow and troubleshooting issues under limited time restriction

Desired Skills / Experience. Education BS in Engineering, Computer Science, Information Technology degree, Data Analytics or equivalent

Do you like solving complex business problems, working with talented colleagues and have an innovative mindset? Arch may be a great fit for you.

10400 Arch Global Services (Philippines) Inc. Arch Capital Group Ltd. is a Bermuda-based specialty insurer that provides insurance, reinsurance and mortgage insurance on a worldwide basis. With a 20+-year track record of delivering results and a coveted position on the S&P 500 index, Arch is a great place to grow your career.

Attention Job Seekers: Arch Capital Group Ltd. (Arch) and its affiliates take your interest in working here very seriously. Please be vigilant to fraudulent activity if you receive a communication or email asking you to submit any personal information. Do not send money or pass any details to someone suggesting they can provide employment with Arch. You should only enter your information into our official career portal. Please know the following about our interviewing and hiring practices. We never make job offers without a formal, in person, interview process. We never ask you to send money of any kind.