Software Engineer - SQL, Data warehouse, ETL

Caring. Connecting. Growing together.

Primary Responsibilities:

• Develop and Test Data pipelines to Extract, load and transform data into cloud based Datawarehouse Snowflake
• Develop and Test Complex SQL queries, ETL Jobs, Reports/Dashboards to meet business requirements and data needs
• GitHub Copilot usage in software development. Promote AI-first mindset in product development
• Collaborate with cross-functional teams to improve code quality, development practices, Quality Assurance practices and processes
• Maintain development standards and Quality Assurance best practices and release operations
• Troubleshoot and debug complex technical issues
• Conduct code reviews and provide constructive feedback
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regard to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• Bachelor's degree in a related field (or equivalent demonstrated experience) or master's degree with at least 2+ years of professional experience in software development on Datawarehouse related projects
• Professional Experience : 2+ years of professional experience on developing and delivering Datawarehouse projects
• AI-Powered Solutions Development - Experience in developing and deploying AI-powered solutions using no-code, low-code, and advanced platforms, translating business needs into scalable solutions
• Good understanding of Database concepts
• Able to create Complex SQL queries, ETL Jobs to meet downstream consumer data needs
• Prepare data as part of an ETL or ELT process and perform transform-load in cloud based Datawarehouse
• Dimensional Data Modelling and Semantic layer building for DWH, Reporting and Analytics
• Solid programming and algorithmic skills
• Technical Skills
  • Solid knowledge of:
  • SQL
  • Datawarehouse
  • ETL
  • Database concepts
  • Reporting and Analytics
  • Cloud platform
  • Agile methodologies
• Familiar with:
  • Cloud based Datawarehouse (Preferred Snowflake)
  • Cloud based Reporting/Analytics platform (Preferred Looker)
  • ETL and Integration tools (Preferred Snaplogic)
  • Ansible and Jenkins for CICD
  • Cloud platform (Preferred Azure)
  • AI technologies

#gen