BI Developer/Analyst

Orange
Sos del Rey Católico, Spain
5 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Sos del Rey Católico, Spain

Tech stack

Agile Methodologies
Data analysis
Business Logic
JIRA
Cloud Computing
Information Systems
Data Integrity
ETL
Data Transformation
Data Security
Data Warehousing
Dimensional Modeling
Python
Microsoft SQL Server
NumPy
Scrum
Systems Development Life Cycle
Power BI
SQL Stored Procedures
SQL Databases
SQL Server Integration Services
SQL Server Analysis Services
T-SQL
Data Processing
System Availability
Snowflake
Powerquery
Pandas
Information Technology

Job description

We are seeking a skilled BI Developer to manage our end-to-end data lifecycle. This role is critical as we maintain our robust on-premises Microsoft BI stack while strategically transitioning our reporting capabilities to Power BI Service (Cloud).

You will be responsible for everything from Data Warehouse design and ETL development to the creation of high-impact visualizations.

What You'll Be Doing

  • Design, develop, and maintain robust ETL processes using SSIS and T-SQL to integrate data from various offline sources into the Data Warehouse.
  • Configure and manage On-premises Data Gateways to ensure seamless, secure data flow between local SQL Servers and Power BI Service.
  • Build and optimize relational and dimensional data models (Star/Snowflake schemas) to support performant reporting and enterprise-level data integrity.
  • Create interactive dashboards in Power BI, utilizing advanced DAX for complex business logic and Power Query (M) for data transformation.
  • Monitor and tune long-running SQL queries and Power BI dataset refreshes to ensure high availability and rapid response times.
  • Collaborate with stakeholders to translate business requirements into technical specifications, providing actionable insights through data exploration and visualization.

Requirements

Do you have experience in T-SQL?, * BSc in Computer Science, Information Systems, or a related technical field.

  • 3+ years of experience with MS SQL Server (2016 minimum), including advanced Stored Procedures, Views, and indexing strategies.
  • Strong hands-on experience with the Microsoft BI Stack (specifically SSIS and SSAS).
  • Deep understanding of Power BI Desktop and Power BI Service, including workspace management, security (RLS), and app publishing.
  • Proficiency in writing complex Data Analysis Expressions (DAX) and Power Query scripts.
  • Solid understanding of dimensional modeling, data warehousing concepts, and the SDLC.
  • Experience with Python for data manipulation (Pandas/NumPy) or automation tasks is a plus
  • Ability to perform root-cause analysis on data discrepancies and logic gaps.
  • Fluent in English with the ability to explain complex data concepts to non-technical business users.
  • Comfortable working in an Agile environment (Scrum/Kanban/SAFe) and managing tasks via Jira.

Benefits & conditions

  • Performance Bonuses- based on your results & the company's
  • Loyalty Bonuses, if you extend your stay
  • Electronic Meal Tickets
  • Medical & Life insurance for you - facilities for your family, too
  • Professional GSM subscription
  • Personal GSM subscription, also [because we believe in communication!]
  • Special grants on Smartphones & devices; discounts for Orange products & services
  • Development Platforms - Orange Learning, Trainings, Career Counselling, Coaching & Career plan mentoring
  • Wellbeing Programs - we support your Zen

Orange Services is about bringing together people and technology.

Come & work for a #TopEmployer company. You could be part of an organization where great colleagues and team spirit support your professional development.

Apply and let's have a remote-talk.

At Orange, you can.

We encourage all candidate profiles, regardless of gender, age, race, citizenship, ethnicity, color, language, religion, social origin, genetic traits, sexual orientation, permanent or temporary disability, nationality, political choice, social category or social origins, situation or family responsibility, belonging to a disadvantaged category, membership or trade union activity.

Apply for this position