Latest news

Microsoft Data and Analytics Consultant

Job opportunity Microsoft Data and Analytics Consultant Xpand IT

Microsoft Data and Analytics Consultant

Business intelligence & Analytics aims to develop software solutions that help business decision makers to make better decisions based on historical and recent data. BI teams develop and use tools that access and analyze data sets (through Extraction, Transform and Load operations) and present analytical findings in reports, maps, graphs, charts and dashboards to provide users with detailed intelligence about the state of the business.

At Xpand IT we develop Business Intelligence Software solutions for various sectors of activity: Energy, Telecommunications, Automotive and Transport, using, among other tecnhologies, the Microsoft stack for complex ETL chains and Power BI to create dashboards and state-of-the-art reports.


As a Microsoft Data and Analytics Consultant at Xpand IT you will play a critical role in translating business requirements into relevant metrics and indicators and from there develop and mantain an end-to-end Business Intelligence solution. You will apply specific knowledge of modeling and data storage (star schema, snowflake, etc), use advanced data transformation tools, as well as visualization tools to create reports and dashboards.

Your daily activities will include:

  • Translate business rules into clear and systematic technical / functional requirements
  • Identify the correct Metrics and KPI that match business needs
  • Identify the relevant data sources to produce the correct calculations of all necessary Metrics / KPIs
  • Perform data warehouse data models design and modelling according to established standards
  • Design and develop performant and scalable ETL processes considering all relevant stages (staging, cleansing, etc).
  • Develop reports and dashboards based on business requirements
  • Perform quality assurance checks over the whole Data Warehouse and Reporting infrastructures as well as their security

// Stacks: Microsoft Azure

Microsoft Data and Analytics Consultant Azure
Microsoft Data and Analytics Consultant Databricks


  • MSc / BSc in Information Systems Management or Engineering in general
  • At least 2 years of professional experience in designing and implementing standardized and denormalized relational data models
  • At least 1 year of professional experience in developing data solutions in Microsoft Azure with Data Factory, Databricks, Azure SQL, Azure Synapse or other Microsoft Cloud Services.
  • At least 2 years of professional experience with database management tools like MS SQL Server, MySQL or PostgreSQL,
  • Responsibility and organization
  • Strong communication skills (written and spoken), team player and problem solving skills
  • English proficiency (written and spoken)

// Will be a nice plus if you have: 

  • Knowledge in PowerBI and SSAS.
  • Knowledge in Shell Scripting
  • Knowledge of Java programming
  • Knowledge in Eclipse, Maven, Jenkins, GIT, JIRA or equivalent tools

// Learn more about Business Intelligence area: 

Apply here

At Xpand IT I have the opportunity to apply my recent skills on SQL Server Analysis Services and Azure Data Factory as well on Microsoft BI suite to effectively improve our clients’ day-to-day. Here I am encouraged to study and present solutions, new technologies and ideas that better fit our clients’ needs.

Rodrigo Silva, Data and Analytics Consultant @Xpand IT
Microsoft Data and Analytics Consultant Xpand IT

Videos that tell you the whole story

Xpand IT: You Have to Live it!

Summer Trip

Be an Xpander

Life at Xpand IT

XTech Community


Sara GodinhoMicrosoft Data and Analytics Consultant


Want to get amazing Big Data, Business Intelligence, Middleware
Mobile articles & news directly from our experts?
Subscribe to our blogs now.