Arch Global Services (Philippines) Inc. Logo

Arch Global Services (Philippines) Inc.

Data Engineer Level II (Bench) - Snowflake, SQL (Nightshift)

Posted 9 Days Ago
In-Office or Remote
Hiring Remotely in Canada
Senior level
In-Office or Remote
Hiring Remotely in Canada
Senior level
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.
The summary above was generated by AI
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 Description

Schedule: 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

Qualifications

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

Additional Information

Bachelors Degree or any related field.

Similar Jobs

5 Hours Ago
Remote or Hybrid
Calgary, AB, CAN
Senior level
Senior level
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Hunt and close net-new enterprise accounts across Alberta, building executive relationships and value-based business cases. Drive pipeline via prospecting, partners, and events; lead complex sales cycles with Sales Engineers and Customer Success to deliver observability, security, cloud modernization, and AI-driven outcomes.
Top Skills: AiopsAWSAzureCloud MigrationCybersecurityDevOpsDynatraceGCPObservabilityPlatform Engineering
8 Hours Ago
Remote or Hybrid
Canada
Senior level
Senior level
Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Design, deploy, and operate enterprise network infrastructure across data centers and cloud (GCP, AWS, Azure). Manage VPCs, VPNs, BGP, F5 BIG-IP, hybrid connectivity, and observability. Build IaC and automation with Terraform, GitLab CI/CD, and Ansible. Maintain monitoring, documentation, and participate in on-call support for critical incidents.
Top Skills: AnsibleAWSAzureBgpCloud RouterCloudflareDnsF5 Big-IpFirewallsGCPGitlab Ci/CdHa VpnIp Address ManagementIpsec VpnLoad BalancingTerraformVpc
9 Hours Ago
Easy Apply
Remote
Canada
Easy Apply
Expert/Leader
Expert/Leader
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Lead high-impact reliability projects to improve resiliency, scalability, and deployment safety for thousands of services. Build secure configuration and secrets systems, improve canary-based release systems, partner with critical teams to reduce operational toil, drive observability and reliability best practices, participate in on-call rotations, and communicate architecture decisions to stakeholders.
Top Skills: AWSAzureDatadogGCPGenerative AiGoKibanaRubyTerraform

What you need to know about the Calgary Tech Scene

Employees can spend up to one-third of their life at work, so choosing the right company is crucial, not just for the job itself but for the company culture as well. While startups often offer dynamic culture and growth opportunities, large corporations provide benefits like career development and networking, especially appealing to recent graduates. Fortunately, Calgary stands out as a hub for both, recognized as one of Startup Genome's Top 100 Emerging Ecosystems, while also playing host to a number of multinational enterprises. In Calgary, job seekers can find a wide range of opportunities.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account