MS BI / A&M Developer / ETL Engineer

Overall Purpose Of The Job

This is a Microsoft Business Intelligence Software Engineer role largely responsible for providing data analytics insights to the organization.

Key Responsibilities

Gather business requirements from Clients or Business Analysts

Design & Develop data warehouse solutions based on requirements

Maintain a high standard of delivery quality

Innovate and look for new solutions/components

Build POCs to demonstrate new usage and present them to a senior audience

Elaborate project documentation (Design documents, deployment guide, …)

Maintenance of existing BI projects, reports, dashboards, and ETL processes

Build strong relationships with stakeholders to understand business challenges and opportunities.

Identify issues, gather information from various sources, and translate essential business needs into technical specifications that are used as reference for data product design.

Automate processes

Deliver improvements to Data Warehouse, data marts, reports, dashboards

Spearhead detailed data analysis and modeling

Required Skills and Knowledge

4+ Years of Experience in Microsoft Business Intelligence (MSBI), SSIS, Ab Initio or other ETL tools

Technical

Expertise in Microsoft SQL Server

Expertise in writing complex SQL queries and performance optimization

Expertise in Data Warehouses design, data modeling, and semantic layer definition

Expertise in SSIS building and optimizing

Expertise in SSAS

Expertise using PowerBI and SSRS

Experience in writing MDX queries, DAX queries

Experience of using Visual Studio TFS

Possess superior organization skills to be able to manage end-to-end data product development with production development, conducting system integration/user acceptance testing, etc

Be a steward of good data practices - robust documentation (i.e.: metadata), versioning, play booking, processes, and knowledge sharing.

Ability to work with the team to support the maintenance of data platforms

Nice to have

Exposure to other data visualization tools (Tableau, Qlik)

Exposure to data analytics, and data science (Python, Spark, etc.)

Exposure to Cloud Architecture (AWS/Azure)

Exposure to development on .Net (4.5 to 4.8)

Exposure to Data virtualization

Innovation:

Develop a good working knowledge of available technology capabilities and how and where to deploy them.

Evaluate potential technical solutions and make recommendations to resolve business problems.

Required Competencies

Proactive style of working

Strong communication (written, and verbal) and organizational skills

Strong desire to keep abreast of emerging technologies

Team player mindset

Understanding and respect of cultural diversity

Required Work Experience

4+ years’ experience in Microsoft Business Intelligence (MSBI)

Required Qualifications

Computer Science/Engineering or a related discipline

Required Languages

Excellent written and spoken English

Travel / Rotation Requirements

N/A

International SOS is an equal opportunity employer and does not discriminate against employees or job applicants on the basis of race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws.