VBA Excel Expert- EU Citizen only

Neev; Den Haag; On-site; EUR 75,000 - 110,000; Full time

Job summary

Neev is seeking a seasoned IT professional in Den Haag (Netherlands) to drive software development, data processing and automation initiatives. You will design and implement data pipelines, dashboards and backend services within a glass-ceiling-friendly, multilingual environment.

The ideal candidate has 7+ years in IT, strong SQL Server/T-SQL/SSIS background, Python prowess, and experience with Power BI and containerized deployments.

Qualifications

• University degree in IT with 7 years IT experience.
• Degree in CS/IS/Engineering with software dev and data skills.
• At least 5 years of software development experience.
• Strong SQL Server, T-SQL, SSIS and data modelling knowledge.
• Proficiency in Python for automation and data tasks.
• Proficiency with VBA and automation scripting is a plus.
• Experience with full stack design and development.
• Proficiency in Power BI for modeling, dashboards and reporting.
• Knowledge of Docker; containerization and basic Kubernetes is an advantage.

Skills

Python programming

Power BI

C#/.NET

SQL Server

Git version control

Docker

Kubernetes

Azure DevOps

ETL / SSIS

Education

University Degree in IT

University degree in Computer Science / IS / Engineering

Tools

SSIS

Power Query

Neo4j

Docker

Kubernetes

Git

Azure DevOps

Job description

• University Degree in IT, combined with 7 years of relevant IT professional experience;
• University degree in Computer Science, Information Systems, Engineering, or a related technical field, with practical knowledge in software development, databases, and small-scale system design. A solid foundation in software and database development is required to support data pre-processing and automation of business activities;
• At least 5 years of professional experience in software development;
• At least 5 years of professional experience with Microsoft SQL Server (T-SQL, SSIS, schema design, stored procedures, performance tuning);
• Proficiency with Python and frameworks for web development, data manipulation and automation;
• Proficiency with VBA applications (Excel, Access) including VBA scripting for developing automation scripts, data import/export utilities, and pre-processing tools;
• Good knowledge of the design, documentation and development of full stack solutions;
• Proficiency with Microsoft Power BI (data modelling, DAX, dashboards, reporting) for providing advanced visualization and reporting capabilities to support operational analysis;
• Proficiency in ETL processes and data-preparation technologies, including tools such as SQL Server Integration Services (SSIS), Power Query and Neo4j data-import or ETL utilities;
• Good working knowledge of version control systems (e.g., Git);
• Good working knowledge of relational database development, with a focus on Microsoft SQL Server, including data modelling, schema design, T-SQL, stored procedures, functions and query optimisation;
• Good working knowledge of application security, authentication, and authorisation concepts, including OAuth 2.0 and OpenID Connect;
• Good knowledge of agile software development methodologies with practical experience using Azure DevOps for backlog management, planning, source control, CI/CD pipelines and work tracking;
• Good knowledge and display of prerequisites of working in a flexible environment including participation in multi-lingual meetings, ease of communication, exposure to an international/multi-cultural environment, etc;
• Good knowledge of preparing and maintaining technical documentation for developed solutions;
• Good working knowledge of containerisation using Docker. Familiarity with container orchestration tools such as Kubernetes is an advantage;
• Knowledge of Microsoft .NET (C#) and ASP.NET Core will be an asset;
• Good knowledge of using Linux shell and basic Linux concepts (e.g., users, groups, rights) will be an asset;
• Good knowledge of Elasticsearch for indexing and querying complex, large or unstructured datasets;
• Excellent command of the English language.