Database Analysis - Advisor II
Role details
Job location
Tech stack
Job description
DUTIES: Develop customized solutions within the platform to support critical business functions and meet project objectives, client requirements, and company goals. Collaborate with cross-functional teams to define, design and implement new business requirements. Communicate with project managers, clients, and other developers to design cohesive project strategies and ensure effective collaboration throughout all phases of development, testing and deployment. Work closely with frontend and service developers located globally to build or maintain applications. Lead the knowledge sharing sessions. Design and develop data model and physical database objects. Develop ETL processes to ingest data from multiple applications. Utilize secondary skills in database management to optimize database schemas; write efficient queries and procedures; ensure data integrity; and troubleshoot production issues and provide immediate resolution. Support Disaster recovery activities and troubleshoot deployment-related issues. Work closely with DevOps engineers and system engineers to ensure smooth and successful deployment of releases. Participate in code reviews, bug fixing, and performance optimization to ensure the highest level of quality and performance for our applications.
Requirements
REQUIREMENTS: Bachelor's degree in Computer Science, Engineering, Technology or a related field and 4 years in any job title involving Snowflake ETL development experience. Prior experience must include 4 years in the following: Working in merchant acquiring domain developing solutions for payment processing, settlement and commission calculations; Completing end-to-end software development lifecycles; Requirements definition and traceability; Working within cross-functional teams to develop software products; Estimating and planning software development, product requirements and business requirements; Collecting metrics and reporting on delivery of product and business requirements post-release to market; and Python Scripting for ETL. Prior experience must also include 2 years working with ETL tools including Qlik Replicate and AWS Glue.