SQL/SAS Developer

GENERAL INFORMATION:

Industry: IT

Location: 100% remote

Rate: 160-180 PLN/h

Form of cooperation: B2B

Start: ASAP

PROJECT DESCRIPTION:

Employees in public institutions expect to receive the right salary at the right time, and it is our responsibility to ensure that this happens. Payroll is complex, so high quality in our solutions and in our deliveries is important to ensure high customer satisfaction. The Data & BI Team contributes to creating the best data foundation to help our customers make the right decisions.

All data is extracted from our various source systems, and it ends up in DB2 or Oracle tables. We collect it all together in our Data Warehouse, where we process and structure the data so that it can be presented either on sd.dk/sddw (SAS) or via our IBM-Cognos solution that reads data from our MSSQL server.

RESPONSIBILITIES:

• Operation/monitoring of data flow to DW and BI primarily decentralized, but also Host.
• 3rd-level technical support (customer inquiries that our colleagues in support need help with).
• Bug fixing from DataInput to DataOutput.
• Update security/service packs/hot fixes on our MS Server and SAS installation.
• Troubleshooting/Data Detective.
• Analysis and task description in connection with new customer requirements/tasks.
• Development on and of our existing platform and technology stack.
• Data strategy - where are we going in the long term.
• Management and maintenance of a platform with great complexity.
• Ensure high quality in the solution through reviews and testing.

REQUIREMENTS:

• Primary competencies in the position:
• Strong analytical skills
• Microsoft SQL Server
• SSIS
• SQL Performance
• fluency in English, both spoken and written
• Secondary competencies in the position:
• Visual Studio
• TFS/GIT
• SAS backend
• Linux
• Oracle queries
• Database: Oracle and DB2
• DB2 queries AQT
• Understanding of Data architecture, concepts such as Fact/Dimensions, Star schema and Snowflake.