Data analyst in business intelligence

Affinity; United States; Hybrid; USD 75,000 - 110,000; Full time

Job summary

Affinity ищет опытного BI-аналитика для работы над проектами бизнес-аналитики в международной среде. Вы будете анализировать требования, проектировать семантические модели и работать над data layer, чтобы поддержать управленческие решения.

Требуется 4+ года опыта, знание SQL и BI-инструментов (Power BI/Tableau), а также умение переводить бизнес-требования в технические спецификации. Вакансия предполагает гибридный формат работы и международную среду.

Qualifications

• Высшее образование в области информационных технологий, систем и т.д.
• Опыт работы Data Analyst/BI Analyst более 4 лет.
• Свободное владение SQL для анализа и трансформации данных.
• Опыт моделирования данных: Star Schema, Snowflake Schema.
• Опыт работы с BI-инструментами Power BI/Tableau.
• Умение переводить бизнес-требования в модели данных и спецификации.
• Знание ETL-процессов и интеграции данных.
• Умение общаться и презентовать инсайты на русском языке.

Responsibilities

• Анализ, документирование и валидация требований в BI-проектах.
• Проектирование и развитие семантических моделей и структур данных.
• Сотрудничество с заинтересованными сторонами ради инсайтов и аналитических решений.
• Перевод функциональных требований в технические спецификации и правила трансформации.
• Обеспечение качества и целостности данных для аналитики.
• Участие и координация UAT-валидаций.
• Разработка и оптимизация наборов данных, метрик и аналитических моделей.

Skills

SQL

Dimensional modelling

Power BI

Tableau

Английский B2

Аналитика данных

Education

Бакалавр в ИТ/ИС/Математика

Плюсом: Data Engineering/Схожее

Tools

SQL Server

Snowflake

Job description

Описание:

Our mission is to be a meaningful part of our people’s careers. As we grow, so does our determination to offer the best experience to our employees and clients, and that is exactly what drives us. We are a Portuguese technology consulting company with offices in Lisbon, Porto and Óbidos and representatives in Brazil and Tunisia. With over 12 years of expertise in the market, we are now a community of around 400 people working on-site, remotely or in a hybrid context on projects in more than 20 countries.

Задачи:

• Analyze, document and validate business requirements within Business Intelligence projects
• Design and develop semantic models and data structures for reporting and analysis
• Collaborate with stakeholders to turn business needs into insights and analytical solutions
• Translate functional requirements into technical specifications, data models and transformation rules
• Ensure the quality, consistency and integrity of the data used in analyses
• Participate in and coordinate User Acceptance Testing (UAT) activities
• Develop and optimize datasets, metrics and analytical models to support decision-making
• Create functional and technical documentation associated with Business Intelligence solutions
• Provide support and training to users of analytical tools
• Contribute to the continuous improvement of reporting, modeling and data governance practices

Требования:

• Bachelor’s degree in Computer Engineering, Information Systems, Management, Mathematics, Statistics or a similar field
• More than 4 years of professional experience as a Data Analyst, BI Analyst or in similar roles
• Solid knowledge of SQL for data analysis, exploration and transformation
• Experience in dimensional modeling for Business Intelligence, namely Star Schema and/or Snowflake Schema
• Strong ability to analyze and interpret data from transactional systems and analytical platforms
• Experience building datasets, semantic models and analytical layers
• Experience with reporting and data visualization tools such as Power BI, Tableau or similar
• Ability to translate business requirements into data models and technical specifications
• Experience collaborating with technical teams, functional areas and business stakeholders
• Knowledge of ETL processes and data integration
• Excellent analytical skills, critical thinking and results orientation
• Good ability to communicate and present insights
• Knowledge of English (minimum B2)
• Affinity — Build close relationships and empathy with colleagues, clients and candidates (not just with technologies, languages and platforms)
• Team spirit and a good sense of humor
• Ambition — Want to do more and better. Willingness to exceed expectations and grow personally and professionally
• Action — The energy to make things happen. Show proactivity and initiative
• Learning — The willingness to grow individually and collectively and become an expert in the technology market
• Будет плюсом: Bachelor’s degree in Data Engineering, Computer Engineering or similar (preferred)

Условия:

• Take part in national and international projects at a company built on personal relationships, simplicity and efficiency, with a disruptive presence in the technology market
• Access a personalized career and training plan directly proportional to your performance and interests
• Be part of a welcoming environment built on trust, respect and informality
• Join our Affinity Communities (sports, technology, hobbies, etc.) and actively participate in social and environmental responsibility projects
• Take advantage of a range of benefits, partnerships, discounts, events and internal activities
• Beyond your professional satisfaction, we want to offer you memorable leisure and social opportunities worthy of an Affinity experience