Database Architect

Are you curious, motivated, and forward-thinking? At FIS you’ll have the opportunity to work on some of the most challenging and relevant issues in financial services and technology. Our talented people empower us, and we believe in being part of a team that is open, collaborative, entrepreneurial, passionate and above all fun.

About the team:

Our award-winning FIS Asset Finance solution enables financial institutions around the globe to quantify and mitigate risk, manage capital and the liquidity buffer, and apply risk-adjusted performance measures throughout the organization to optimize their risk-return profile. We foster a friendly atmosphere in the team, which is filled with intelligent and experienced people who are ready to share their knowledge. Open communication is an important part of our team, and we recognize and accept all new ideas and insights. Our stack is based on C# and Kendo UI web-based applications with a fast track to a cloud-based solution forming a part of our core system.

What you will be doing:

We are looking for a professional who is passionate about technologies and has strong analytical skills to take on the following challenges in the Asset Finance team:

• Improving system performance by conducting tests, troubleshooting and integrating new elements
• Optimizing new and current database systems
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling).
• Experience with data security and data access controls and design in Snowflake.
• Proficiency in complex SQL, Scripting, performance tuning and database optimization techniques.
• Must have expertise in Azure Platform as a Service (PAAS) model and its integration with Snowflake to load/unload data.
• Implement cloud-based Enterprise data warehouse solutions with multiple data platforms along with Snowflake and NoSQL environment to build data movement strategy.
• Lead in Developing Project requirements for end-to-end Data integration process using ETL for Structured, semi-structured and Unstructured Data.
• Make necessary on-going updates to modeling principles, processes, solutions, and best practices to ensure that the Snowflake is aligned with business needs of the environment.
• Act as Data domain expert in a collaborative environment to provide demonstrated understanding of data management best practices and patterns.

What you bring:

• 7+ years of experience in implementing data management solutions
• In-depth knowledge of queries for SQL & NoSQL databases, familiarity with SQL Server, Oracle and DB sharding, and hands-on experience adjusting database collections and shards to reach peak performance
• Expertise in Snowflake concepts like setting up Resource monitors, RBAC controls, scalable virtual warehouse, SQL performance tuning, zero copy clone, time travel and automating them.
• Experience in handling semi-structured data (JSON, XML), columnar PARQUET using the VARIANT attribute in Snowflake.
• Experience in Migration processes to Snowflake from on-premises database environment.
• Experience in designing and building manual or auto ingestion data pipeline using Snowpipe.
• Experience in Cloud technologies such as Azure – S3/EBS/EFS, Storage Queues, Serverless functions, Synapse Analytics, Azure SQL
• Ensure data security and compliance
• Bachelor’s degree in Computer Science or related field

What we offer you:

• A work environment built on collaboration, flexibility and respect
• Competitive salary and attractive range of benefits designed to help support your lifestyle and wellbeing (including private healthcare, 27 days of vacation, work from home – 2 days per week, etc.)
• Varied and challenging work to help you grow your technical skillset