Snowflake developer

CyberX Info System; Ottawa; On-site; CAD 110,000 - 140,000; Full time

Job summary

CyberX Info System is seeking a Snowflake Developer to design and optimize data architectures using Snowflake, with extensive AWS integration, data lake/data warehouse design, and governance considerations.

Responsibilities include implementing customer integrations, deploying updates, providing Level 2 support, and building automation to improve reliability and analytics within a finance-sector context.

Qualifications

• Minimum 5 years of Snowflake experience.
• Experience working with Indian finance industry.
• Ability to work with cross-functional teams including QA, Platform Delivery and DevOps.

Responsibilities

• Implement integrations requested by customers.
• Deploy updates and fixes.
• Provide Level 2 technical support.
• Build tools to reduce occurrences of errors and improve customer experience.
• Develop software to integrate with internal back-end systems.
• Perform root cause analysis for production errors.
• Investigate and resolve technical issues.
• Develop scripts to automate visualization.
• Design procedures for system troubleshooting and maintenance.

Skills

Snowflake

AWS

ETL

Data Modeling

Data Warehousing

Performance Tuning

CDC

Scripting

Cross-Functional Collaboration

Cloud Architecture

Tools

Snowpipe

AWS Glue

AWS Lambda

Active Directory

Data Governance Tools

Metadata Management

Job description

As a Snowflake Developer, you are expected to have below Technical skills:

• Cloud technologies (AWS data services, AWS Glue, AWS Lambda, Integration with Active directory, masking and encryption, Governance activities - Lineage, Catalog, classifications. Infrastructure setup in Snowflake)
• Experienced with multiple data-ingestion methods for loading data to Snowflake: Snowpipe, Glue, Copy Into for large volume of data as well as incremental data handling
• Sound knowledge of Snowflake Architecture, Design and Performance considerations
• Data lake and Data Warehouse Design and optimization
• ETL, Data Analysis, CDC
• Technical understanding of digital / customer experience layers:Been Leading and built at least 1-2 Projects on AWS cloud with Snowflake
• Strong experience in designing and building DWH, Data lake ETL based applications with scalability and performance
• Experience with CDC and metadata driven based processing
• Have build DWH models
• Hands on experience of architecting RDBMS and Snowflake databases - transactional as well as data-warehouse
• Strong knowledge of data structures, analytical algorithms, and designing for performance
• Good to understand the security and access controls on AWS
• Nice to understand Agile and Devops methodology for cloud deployment.

What You'll Do

• Implement integrations requested by customers
• Deploy updates and fixes
• Provide Level 2 technical support
• Build tools to reduce occurrences of errors and improve customer experience
• Develop software to integrate with internal back-end systems
• Perform root cause analysis for production errors
• Investigate and resolve technical issues
• Develop scripts to automate visualization
• Design procedures for system troubleshooting and maintenance

Expertise You'll Bring

• Experienced software professional with minimum 5 years of experience in Snowflake
• Working experience to work with Indian finance industry
• Work with cross functional teams including QA, Platform Delivery and DevOps
• Not afraid of refactoring existing system and guiding the team about same.
• Able to plan and deliver project deliverable on time with quality.
• Innovative Thinking
• Organization Commitment (hard working)
• Customer Focus/Orientation
• Able to communicate effectively with both technical and non-technical project stakeholders.