Software Developer

Jobtailor; Deutschland; Vor Ort; EUR 95.000 - 130.000; Vollzeit

Zusammenfassung

Jobtailor in Germany seeks an experienced software engineer to develop and migrate data solutions. You will work with VBA, SQL Server, Python, and Power BI to build robust ETL pipelines and dashboards.

The role involves collaborating with multiple tech teams, documenting solutions, and ensuring secure, auditable implementations. The ideal candidate has 5+ years in software development, strong SQL Server expertise, and proficiency in full-stack development practices, SDLC, and multilingual

Qualifikationen

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of professional software development experience.
• Fluent English (B2 or higher).
• Extensive hands-on experience with Microsoft SQL Server (T-SQL, SSIS, schema design, stored procedures, performance tuning).
• Strong SDLC knowledge and full-stack solution design, documentation and development.
• Proficiency with Power BI (data modelling, DAX, dashboards).
• VBA experience in Excel/Access and automation scripting.
• ETL and data preprocessing, including SSIS, Power Query, and related tools.
• Python for web development, data manipulation, and automation.
• Knowledge of Git or TFS version control; SQL Server-related concepts; Elasticsearch basics.
• Experience with containers (Docker) and Kubernetes a plus.
• .NET (C#) and ASP.NET Core familiarity; Linux shell basics.
• CI/CD experience (Azure DevOps) and multilingual/intl collaboration.
• Good knowledge of agile software development methodologies
• Experience collaborating in multilingual and international environments
• Ability to create and maintain technical documentation for developed solutions
• Desirable: Knowledge of containers (Docker) and Kubernetes
• Knowledge of Microsoft .NET (C#) and ASP.NET Core
• Familiarity with Linux shell and concepts
• Knowledge of graph databases design and queries (Neo4j)
• Knowledge of CI/CD systems (e.g., Azure DevOps)

Aufgaben

• Write and debug complex VBA solutions in Microsoft Access and Excel.
• Contribute to migration of Access-based solutions to SQL Server.
• Use Python for web solutions and scripting.
• Perform ETL on complex datasets.
• Use Power BI to provide visualization and insights.
• Liaise with technical teams to push new features to production.
• Write and maintain technical documentation of the implemented solutions.
• Ensure secure coding practices, logging and auditing features.

Kenntnisse

communication

collaboration

documentation

flexibility

agile methodologies

Ausbildung

Bachelor's degree in Computer Science, Information Technology, or a related field

Tools

VBA

SQL Server

T-SQL

SSIS

Python

ETL

Power BI

DAX

Neo4j

Microsoft .NET

Elasticsearch

Linux

Git

Azure DevOps

Jobbeschreibung

Responsibilities

• Write and debug complex VBA solutions in Microsoft Access and Excel.
• Contribute to the migration of Access based solutions to SQL Server.
• Use Python for the development of web solutions and scripting.
• Perform ETL (enhance, transform, load) on complex datasets.
• Use Power BI to provide visualization and insights.
• Liaise with other technical Teams in order to push new features / changes to production.
• Write and maintain technical documentation of the solution implemented.
• Account for secure coding practices, as well as logging and auditing features.

Requirements

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Working knowledge of English: B2 level or higher
• At least 5 years of professional experience in software development
• Mandatory: At least 5 years of professional experience with Microsoft SQL Server (T-SQL, SSIS, schema design, stored procedures, performance tuning).
• Good knowledge of SDLC best practices
• 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 with VBA applications (Excel, Access) including VBA scripting for developing automation scripts, data import/export utilities, and pre-processing tools.
• Proficiency of ETL and data pre-processing frameworks (e.g., MS SQL Server SSIS, T-SQL, Power Query, Neo4j ETL tools).
• Proficiency with Python for web development, data manipulation and automation
• Knowledge of version control systems (e.g., Git, TFS)
• Good knowledge of relational databases, focusing on Microsoft SQL Server (schema design, procedural scripting, etc.)
• Good knowledge of Elasticsearch for indexing and querying complex, large or unstructured datasets
• Good knowledge of agile software development methodologies
• 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.
• Desirable: Knowledge of using containers (Docker) and container orchestrators (Kubernetes)
• Knowledge of Microsoft .NET (C#) and ASP.NET Core
• Good knowledge of using Linux shell and basic Linux concepts (e.g., users, groups, rights).
• Good Knowledge of graph databases design and queries (Neo4j)
• Good knowledge of CI / CD systems (e.g. Azure DevOps)

Hard Skills

• VBA
• SQL Server
• T-SQL
• SSIS
• Python
• ETL
• Power BI
• DAX
• Neo4j
• Microsoft .NET

Soft Skills

• communication
• collaboration
• documentation
• flexibility
• agile methodologies
• problem-solving
• technical writing
• interpersonal skills
• organizational skills
• adaptability