Reporting/ETL Developer (Consulting sphere)

Our client is an American company that provides a technical platform for business analysis, investment advice and training.

Project Description

The Business Intelligence Analyst will be responsible for working with stakeholders to identify and define key performance metrics (KPIs) and translate them into actionable reports and dashboards. This role is also responsible for data discovery, ad hoc analysis, building analytic models and star schema design, as well as data transformation and loading of the data warehouse through ETL and ELT technologies and methodologies. Last, this role will have the opportunity to build analytic and predictive models to influence improved business performance.

You will have an opportunity to use the latest cloud technology platforms in Data Warehouses, BI Tools, ETL Tools, etc. In addition to using the latest cloud tools, you will learn marketing from a world class marketing organization.

Responsibilities

• Identify business needs and define KPIs by collaborating with end users, stakeholders and technology.
• Identify and understand source data systems and become an expert of data sources and flows.
• Identify and develop all mappings and data movement within the S&A Holding’s eco-system.
• Build and maintain data visualizations, reports and dashboards using Looker or Tableau.
• Build and maintain analytic and predictive models to assist various business units in identifying improvements in marketing or sales.
• Work directly with end-users for requirements gathering, training, on-boarding.
• Review, assess current state and identify improvement opportunities and best practice.
• Perform other tasks as needed within the broader Data and BI teams. Examples include, ETL, and ELT, building and maintaining analytic and predictive models, and troubleshoot database performance issues.

Technologies:

SQL

Snowflake database

Looker

ETL/ELT

Job Requirements

• 3+ years working with BI tools (such as Looker, Tableau, Business Objects, Cognos, MicroStrategy, etc.).
• Proficiency in either Tableau or Looker.
• Proficiency in creating and analyzing complex SQL queries.
• BS/BA in Computer Science, Information Systems, or related field.
• ETL or API experience will be a plus.
• Experience in a cloud-based environment preferred.
• Marketing and/or SAAS analytics experience, including Direct Marketing, Ad-Tech, or similar experiences.
• Experience with Salesforce, Salesforce Marketing Cloud or Zuora will be a plus.
• Upper-Intermediate English.

What Do We Offer

• 100+ technical and non-technical trainings to develop and expand your horizons;
• Internal meetings and conferences (we like sharing our expertise);
• English courses;
• Free medical insurance;
• Remote work option;
• 15 sick days fully compensated;
• Team sports activities, and corporate events;
• GYM compensation;
• 18 business days of paid vacation;