08-05-2023
Junior Data Analytics Consultant
The Business Intelligence & Analytics team aims to ensure that organizations can get more value from their data and become truly data-driven. We implement end-to-end business intelligence solutions, taking advantage of our technological partnerships with Microsoft, Tableau and Hitachi where we specialize. To ensure excellent results, we always work closely with customers, realizing their business and requirements and increasing the positive impact.
YOUR ROLE
As a Junior Data Analytics Consultant, you will play a critical role as a strategic advisor to analyse, suggest and project better business rules and processes. You will be in charge of developing, deploying, and maintaining Business Intelligence systems and interfaces. Those include data modelling tools, queries, data visualisation and interactive dashboards. You will also be responsible for designing Data Warehouse systems used to accommodate all relevant data to be presented on those reporting tools.
Your daily activities will include:
- Translating business rules into clear and systematic technical/functional requirements
- Identifying the correct Metrics and KPI that match business needs
- Identifying relevant data sources to produce the correct calculations of all necessary Metrics / KPIs
- Performing data warehouse data models design and modelling according to established standards
- Designing and developing performing and scalable ETL processes considering every relevant stage (staging, cleansing, etc.)
- Developing reports and dashboards based on business requirements
- Performing quality assurance checks over the entire Data Warehouse and Reporting infrastructures as well as their security
// Stacks: Microsoft or Tableau or Pentaho
SKILLS YOU NEED TO HAVE
- MSc / BSc in Information Systems Management, Business IT or Engineering in general
- Experience in relational normalised and non-normalised data models design and implementation
- Experience with SQL
- Experience in database management tools such as MS SQL Server, MySQL or PostgreSQL
- Responsibility and organisation
- Team player and problem-solving skills
- Sound communication skills (written and spoken)
- English proficiency
// Will be a nice plus if you have:
- Knowledge of shell scripting
- Knowledge of Java programming or Python
- Experience in using Eclipse, Maven, Jenkins, GIT, JIRA or equivalent tools
// Learn more about Business Intelligence area:
Filipe Santos, Data Analytics Engineer
@Xpand IT
Working at Xpand IT is an enthusiastic adventure. You’ll find both professional and personal growth. At the same time, you’ll have the opportunity of meeting friendly people that stick by your side whenever you need them.
