Data Functional Analyst & BI Developer

Job Role:

The Data Functional Analyst & BI Developer plays a crucial role in developing data solutions (data warehouses and data marts) for the client through Keystone Solutions. This position requires regular interaction with business stakeholders to understand their needs and translate them into data and technical requirements. The successful candidate will have sufficient hands-on expertise with the Microsoft SQL Server BI technology stack, including knowledge of Power BI and Azure Databricks.

The Data Functional Analyst & BI Developer is part of the Data Office, a central organization providing data services across various client sectors. The role involves working within a Scrum team in close collaboration with the Proxy Product Owner and the Data Architect of the project.

Key Responsibilities:

• Facilitate and conduct interviews with end users to determine functional and non-functional requirements of BI solutions;
• Translate business needs into logical and physical data models with appropriate documentation;
• Collaborate with the Data Architect to translate requirements into functional and technical specifications;
• Design, build, deploy, and maintain BI solutions according to established standards (data integration, data warehouse, data marts) in accordance with functional and non-functional requirements (performance, data volume);
• Test the analytical solution, troubleshoot issues, and provide adequate maintenance and technical documentation;
• Create visualizations and reports for requested projects in Power BI or SSRS;
• Conduct prototype reviews and demos, including training on the data model for business users;
• Work with the Project Lead throughout the project lifecycle to ensure appropriate implementation in an agile and pragmatic approach.

Key Skills:

• Master's degree in Computer Science or equivalent;
• Minimum of 7 years of experience in data functional analysis and BI development within the Microsoft BI stack (including SSIS/SSAS);
• Minimum of 7 years of experience in data engineering with Azure Databricks, using Python;
• Ability to translate business requirements into functional and technical specifications;
• Strong experience in data modeling (both logical and physical modeling);
• Good experience in designing data warehouses (Kimball dimensional modeling);
• Very good knowledge of Microsoft SQL Server (from a development perspective), SQL queries, T-SQL;
• Very good knowledge of Python in a data engineering context;
• Good understanding of database management systems, online analytical processing (OLAP), and ETL frameworks;
• Experience with visualization and reporting tools such as Microsoft Power BI and SSRS;
• Experience in Master Data Management and Data Quality Management is a plus;
• Knowledge of the following tools is a plus: modeling tools (e.g., Enterprise Architect), Azure data analytics tools (Azure Data Factory, Databricks, etc.);
• Experience working in an agile project mode is a plus.

Profile:

• Strong conceptual thinking and technical skills;
• Proactive profile, a doer;
• Good communicator (proactive, not waiting for others, active listening, clear/precise/concisely);
• Analytical mindset with a pragmatic problem-solving approach;
• Ability to build relationships with business and data stakeholders, creating trust and buy-in;
• Ability to translate business needs into workable solutions;
• Team player with the capacity to work collaboratively within a cross-organizational framework;
• Persistence, stress resilience, and flexibility;
• Eager to learn and open-minded.

Job Summary:

As a Data Functional Analyst & BI Developer, you will be responsible for gathering business requirements, translating them into functional and technical specifications, defining the data model (logical and physical), and developing a BI solution utilizing the Microsoft stack (SSIS/SSAS) and/or Azure Databricks.

Keywords: Business requirements, data requirements, logical data modeling, physical data modeling, BI functional analysis, SQL Server, SSIS, SSAS, Power BI, T-SQL, Agile Scrum, Azure Databricks, Python.

We offer you an interesting job in the delivery of ICT and Data services that impact society, along with numerous benefits:

• A good work-life balance;
  • Flexible hours within a 40-hour work week (7:30 AM to 8:00 PM with fixed windows between 9:00 AM and 12:00 PM and 1:00 PM and 4:00 PM);
  • Possibility for teleworking;
  • Workspaces organized according to activities;
  • Easily accessible by public transport;
  • Parking for cars and bicycles in the building;
  • Individual lockers;
• Various self-development opportunities;
  • Training and learning possibilities (to be pursued outside working hours) through our e-academy self-training platform or via the Microsoft Enterprise Skills Initiative platform;
• Company restaurant.

If you are ready to tackle technical and strategic challenges in a dynamic consultancy environment, apply today at Keystone Solutions Career Portal.