PROJECT INFORMATION: 

  • Industry: Energy Sector
  • Type of contract: B2B
  • Location: remote (willingness to be in Gliwice/Katowice office +-2x per month would be appreciated)
  • Salary range:  rate 160 for up to 7 years (regular) and 10+ years of experience (senior) up to 180 PLN / net + VAT

 

You will be working on the development of financial solutions within the CASA Team, focusing on financial analytics. The project is named "White Ravens" and is based on Microsoft and Azure technologies, involving data collection, modeling, and reporting processes. One of the primary tasks will also include the migration of the CASA Cloud application to the VIT Reporting package.

 

Tasks and Responsibilities:

  • Development of the Procurement KPI Dashboard within the CASA Cloud infrastructure.
  • Integration of a new SharePoint data source and preparation of the model for the integration of other source-based KPIs within the Power BI Dashboard model.
  • Development of T-SQL code in the Snowflake DBT cloud infrastructure.

 

Duration and Requirements of the Assignment:

The expected duration of the assignment extends until the end of 2023 to align with the extension scheme used in the team at the end of each year and at the end of June. The work is remote, and the worker has the freedom to determine their working hours and location.

 

Interview Process:

 

You will be interviewed by the receiving project team, with participation from the Scrum Master and the Hiring Manager.

 

Management and Supervision:

You will participate in project meetings within the Scrum framework. Supervision will focus on the output of deliverables and communication skills since they will be part of the Scrum team, defined as a unity in the Scrum framework we are using.

 

Competencies:

  • Expertise in SQL (preferably T-SQL).
  • Creating ETL pipelines (working with data sources with 500+ million rows per table).
  • Optimizing existing logic (improving joins, using hints, options, etc.).
  • Resolving issues in existing logic.
  • Experience in Analysis Service Tabular models.
  • Building data models according to best practices.
  • Leveraging the DAX language to create multiple measures.
  • Practical knowledge of Data Warehousing.
  • Ideally, practical knowledge of Inman or any other data warehouse design approach.

 

Nice to have:

  • Experience in Snowflake or similar cloud solutions.
  • Basic knowledge of GIT (branching, merging, rebasing).
  • Experience with Azure DevOps or any other work-tracking service.
  • CI/CD basics (practical knowledge of building CI/CD pipeline is a plus)( Working with debt or similar is even better).

 

Education & Specialization:

  • Engineer.

 

Other Characteristics:

  • Consulting skills.
  • Independent worker capable of working and consulting with customers.
  • Proficiency in English, upper intermediate to proficient.

 

WE OFFER:

  • Constant support for our recruitment during the recruitment process and during cooperation.
  • Attractive prizes in the B2B model, based on the experience and experience.
  • Co-financing of care costs (Medicover) and the Multisport card.
  • Occasional, company integration meetings.
  • Mobile application - quick reporting of working time, quick access to new offers.