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.
Ces entreprises recrutent aussi au poste de “Data / Business Intelligence”.
Voir toutes les offres