Description

Altran is the undisputed world leader in engineering and R&D services. The Group offers its customers a unique value proposition to meet their transformation and innovation challenges. Altran supports its customers, from concept to industrialization, to develop the products and services of tomorrow. Altran has been working for more than 35 years with major players in many sectors: Automotive, Aeronautics, Space, Defence & Naval, Rail, Infrastructure & Transport, Industry & Consumer Products, Life Sciences, Communications, Semiconductor & Electronics, Software & Internet, Finance & Public Sector. In 2019, Capgemini, and Altran announced a merger project in the context of a friendly tender offer to create a global leader in “Intelligent Industry”. Altran generated €3.2 billion in revenue in 2019, with more than 50.000 employees in more than 30 countries.

In the Portuguese market for more than 20 years, Altran Portugal has more than 2.600 employees and offices in Lisbon, Porto, and Fundão.

Project environment and Knowledge:

In a fast-growing international company, you will be responsible for BI projects analysis and implementation.

You must have :
• 6+ years in defining advanced Microsoft SQL -relational database designs, architecting complex enterprise data warehouses and business intelligence solutions concept through implementation and support,
• Proven expertise in dimensional data modeling, OLAP cube design, and data mart and data warehouse implementations based on star schema and top down or bottom up methodologies, on Microsoft SQL Server or Oracle database,
• Minimum 4 years in developing conceptual, logical and physical data models, data mapping, data dictionaries and metadata documents to implement data-driven business solutions,
• Demonstrated proficiency in performance and scalability best practices, data transformation, and data integration strategies using commercial ETL solutions
• Experience in handling and working with teams from different locations

Activities:

• Analyze functional and non-functional requirements to create technical designs, data models and data migration strategies to support implementation of data warehouse and data mart solutions

• Design, build, and maintain physical databases, dimensional data models, OLAP cubes, ETL layer design and data integration,

• Lead technical design and implementation of role-specific dashboards and ad-hoc reporting capabilities using rapid OBIE Business Intelligence tools

• Recommend improvements to enhance existing ETL processes and data integration methods to enable performance, throughput and overall scalability to future growth and business needs.

• Analyze data accuracy and relevance and ensure data integrity of reports

• Experience in handling and working with teams in different locations

Skills required:

• Good Knowledge of English (Mandatory)

• Proficient knowledge of MS SQL Server, relational and multidimensional modelling (minimum 6 yrs. experience)

• Proven expertise on Oracle Data Integrator v12 (minimum of 3-year continuous experience)

• Proven knowledge on Oracle Business Intelligence Enterprise Edition v12 (minimum of 1-year continuous experience)

• Good Knowledge of Oracle Hyperion Essbase 12c is a plus

• Good visualization knowledge and experience on any other presentation tools (Business Objects/Tableau/QlikView) is a plus

• Experience in working with multiple sources from in-house and cloud-based platforms

• Experience in working with SAP as source system and HANA is a plus

Offer:

• Integration in a solid and dynamic team;
• Participation in exciting and motivating projects;
• Career evolution;
• New challenges.

Apply:

Apply for this job opportunity on our website or by email to [email protected]