We are seeking an energetic and motivated Junior SQL Developer to join our Business Intelligence team. The ideal candidate will have a strong foundation in SQL Server, .NET, and know financial principles. 
You will be part of the team developing and maintaining a Business Intelligence Enterprise Datawarehouse and the associated reporting application, delivered for decision-makers, using mainly data from our Financial Information Systems. 
We want you to understand the data model we have, analyse and communicate findings, as well as build queries and processes for automating reports or data loading. 
This is the opportunity to combine your passion for SQL with the excitement of Finance.

Role overview

Creating queries, functions, and stored procedures; establishing and monitoring ETL processes; troubleshooting and resolving production issues; optimising database performance; creating, executing, and resolving data quality validation processes; interacting and linking various data file formats (e.g. flatfile,.csv, Excel) and producing reports aligned with the business needs.

Collaboration skills are essential to this role.

What will I be doing?

The list of tasks involves:

• Data Mapping: using standard governance, create datapoint linkages between externally sourced data and the BI Enterprise Datawarehouse

• Database Maintenance: design, develop, test, optimise and maintain all database objects such as tables, views, and stored procedures

• Data migration: use your financial skills to migrate financial data for Mergers & Acquisitions.

• Participate in the migration of SQL databases to the Cloud

• Coding & implementation of new features: using standard SQL language, .NET, HTML/CSS, and C#,  write code for ETL processes, data promotion across servers, create views and reports, and execute quality and validation checks, as well as other needs.

• Assist with platform maintenance and issue resolution and job monitoring: Help with ticket resolutions, monitor production runs to ensure expected performance, address break-fix issues, and implement needed changes to optimise performance. Troubleshoot, test, and debug core products to ensure optimisation and stability.

• Data Validation: create data quality and validation checks, generate and document exceptions, and implement corrective modifications

• Data Archiving: execute standardized archival processes to maintain optimal database operations

• Ad-hoc SQL queries to extract data from Financial Information Systems

In addition you will have permanent activities:

• Participate as an active member of the scrum team, providing input to team velocity and sprint events.

• Collaborate with the testing team based in India to ensure the accuracy and reliability of developments

• Contribute to database tuning and query optimization efforts

• Participate in customer design conference calls and meetings

• Other duties as assigned by team leadership

What do I need to bring with me?

Technical Skills:

• Experience with MSSQL Server, SQL. Knowledge of creating and maintaining tables, views and stored procedures. Keeping objects and schemas consistent across multiple databases and servers.

• Experience with .NET, HTML/CSS, and optionally C# and DAX

• Understanding of financial principles, including revenue recognition, gross margin, intercompany transactions and profit and loss

• Experience integrating data from various data sources and file types

• Experience writing and fixing code that is clear, well commented, easily understood and maintained

• Working knowledge of visualization applications (MS PowerBI)

• Understand design principles behind scalable applications

• Optional - experience with financial job migrations

• Optional - Exposure to Cloud technologies and SQL migration to the Cloud, Snowflake, Fabrics

• Optional - working experience with database tuning and query optimization

Soft Skills:

•  Good English - Good communication and interpersonal skills 

• Strong analytical, problem solving and troubleshooting skills

•  Ability to work independently and as part of a team

•  Detail-oriented and quality-focused

•  Prepared to work in a self-managed, collaborative, and remote environment.

•  Ability to deliver quality work under pressure and tight schedule 

•  Willingness to learn

Qualifications:

• Master’s degree in Accounting with some IT, or, conversely Computer Science, Information Systems, with some Finance

• Preferred 1 year experience

• Experience in a (corporate) financial department preferred

If you do not have all of the above but a great deal, still apply.

What is in it for me?

• An international and innovative work environment, working on a BI platform that is used by decision-makers across the company.

• Develop and maintain reports that provide insights into our financial data.

• Collaborate with other BI developers and analysts to improve our reporting capabilities.

• We will dedicate a Buddy for you to better navigate in your first weeks and you will have the opportunity to learn and grow in your career.