Arch Global Services (Philippines) Inc.
Jobs
Data Engineer Level II (Bench) - Snowflake, SQL (Nightshift)
Arch Global Services (Philippines) Inc.
Data Engineer Level II (Bench) - Snowflake, SQL (Nightshift)
Design, develop, and maintain ELT/ETL Snowflake data warehouse solutions; implement data standards, CI/CD, monitoring, and production support; collaborate with product, business, and vendors; mentor junior developers and improve data engineering practices.
Company Description
AGSI was incorporated in April 2016. We are committed to supporting the goals of Arch divisions through exceptional service delivery. We pride ourselves on maintaining flexibility and responsiveness to adapt to business unit and industry demands while focusing on sound project management. We are dedicated to growing and developing our employees as we build strong teams with strategic leadership.
Job DescriptionSchedule: Night Shift
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.
Job Responsibilities:
- 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
Required Skills:
- At least 5 years of Data engineering experience using ETL/ELT technologies
- 3+ years hands on experience with Snowflake
- 5+ years hands om experience in SQL
- Experience working with SSIS, SSRS, and Power BI
- 3+ years 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
Bachelors Degree or any related field.
Similar Jobs
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
Lead and develop a Canada Scaled Customer Success team to drive onboarding, adoption, expansion, and renewals via digital scale programs. Hire and coach CSMs, manage KPIs/OKRs, improve processes and tooling, collaborate cross-functionally, and escalate high-stakes customer moments to ensure measurable customer outcomes.
Top Skills:
CRMCs PlatformDigital Engagement ToolsGainsightProduct AnalyticsTotango
Big Data • Fintech • Mobile • Payments • Financial Services
Lead a team that defines and executes operations enablement strategy, delivering cross-functional programs to scale servicing operations. Own roadmaps, stakeholder governance, risk management, change management, training, knowledge management, and measurable outcomes in a regulated fintech environment.
Top Skills:
Ai-Enabled Knowledge ToolsDesign ThinkingLean Six SigmaProject Management
Cloud • Security • Software • Cybersecurity • Automation
Design and implement backend and real-time features in the GitLab monolith for portfolio planning at scale. Optimize PostgreSQL performance, evolve APIs (GraphQL/REST), build capacity planning and work-item hierarchies, create proofs of concept, maintain automated tests, support safe rollouts with feature flags and observability, mentor contributors, and participate in on-call and production troubleshooting.
Top Skills:
ClickhouseElasticsearchFeature FlagsGitlabGraphQLGraphql SubscriptionsPostgresPythonRestful ApisRubyRuby On Rails
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
