Data engineer for enterprise reporting

Affinity; United States; Hybrid; USD 120,000 - 160,000; Full time

Benefits offered by this job

Карьерное обучение и развитие

Гибридный режим работы

Участие вAffinity Communities и волонт

Конкурентная компенсация

Job summary

Affinity ищет специалиста по данным для разработки и поддержки масштабируемых аналитических платформ. Вы будете строить конвейеры данных, моделировать данные и обеспечивать качество и доступность аналитических решений для клиентов по всему миру.

Ключевые задачи включают проектирование многомерных моделей, работу с инструментами Azure и Spark, а также сотрудничество с кросс‑функциональными командами для достижения бизнес‑целей.

Qualifications

• Опыт построения и поддержки современных платформ данных.
• Навыки разработки ETL/ELT конвейеров.
• Знание облачных архитектур обработки данных и моделирования.

Responsibilities

• Проектирование, построение и сопровождение масштабируемых конвейеров данных.
• Разработка и оптимизация аналитических моделей и семантических слоёв для корпоративной отчетности.
• Реализация многомерных моделей и схем звёздочек.
• Обеспечение качества данных, управления данными и соблюдения инженерных практик.
• Сотрудничество с командами по архитектуре и бизнес‑пользователями для дизайна решений.

Skills

ETL/ELT pipelines

Dimensional modelling

Cloud data architectures

Power BI / DAX

Data governance

Cross‑functional collaboration

Tools

Azure Data Factory

Microsoft Fabric

Apache Airflow

Azure Databricks

Apache Spark

Power BI

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’s exactly what drives us. We are a Portuguese technology consulting company with offices in Lisbon, Porto and Óbidos, and representations in Brazil and Tunisia. We have over 14 years of market expertise, and today we are a universe of around 400 people working on-site, remotely or in hybrid mode in projects across 20+ countries.

Задачи

• Design, build and maintain scalable data pipelines and transformation processes
• Develop and optimise analytical data models and semantic layers for enterprise reporting
• Implement dimensional models, including fact tables, dimensions and star schemas
• Improve data structures to support evolving business requirements and more detailed reporting
• Work with upstream data teams to ensure consistent, reliable and high-quality data integration
• Contribute to reporting, planning, budgeting and forecasting capabilities
• Optimise data models and pipelines for performance, scalability and maintainability
• Ensure data quality, governance and adherence to engineering best practices
• Collaborate with technical and business teams on solution design and architectural decisions

Требования

• Strong experience in building and maintaining modern data platforms
• Hands‑on experience developing ETL/ELT pipelines
• Knowledge of data orchestration technologies such as Azure Data Factory, Microsoft Fabric Pipelines, Apache Airflow, or equivalent solutions
• Experience with distributed data processing frameworks such as Apache Spark, Azure Databricks, or similar technologies
• Solid understanding of cloud‑based data processing and transformation architectures
• Strong knowledge of dimensional modelling, star schemas, and fact-and-dimension design
• Experience developing and optimising enterprise analytical models
• Ability to manage data relationships, granularity, and query performance
• Practical experience with Power BI semantic models, including DAX, security, relationships, and performance tuning
• Ability to solve complex data challenges and bridge the gap between data engineering and analytics
• Strong foundation in data engineering principles, semantic modelling, and scalable analytical solution development
• Business‑oriented mindset with the ability to understand stakeholder requirements and translate them into data solutions
• Experience working effectively with cross‑functional stakeholders
• Creating close and empathetic relationships with colleagues, clients and candidates (and not just with technologies, languages and platforms)
• Team spirit and good vibes; Wanting to do more and better
• A drive to exceed expectations and evolve personally and professionally; Energy to make things happen
• Showing proactiveness and initiative; Willingness to grow individually and collectively and to become an expert in the tech market
• Transparent and honest communication, always with constructive feedback

Будет плюсом:

• Exposure to integrated cloud analytics platforms and lakehouse architectures (preferred)
• Experience supporting financial reporting, budgeting, forecasting, or performance management (preferred)
• Familiarity with ERP-derived data and complex enterprise datasets (preferred)
• Knowledge of version control, CI/CD practices, Git, and Azure DevOps (preferred)
• Experience with Microsoft Fabric or comparable platforms such as Databricks, Azure Data Factory, Apache Spark, or AWS EMR (preferred)

Условия

• Taking part in national and international projects in a company based on personal relationships, simplicity and efficiency, with a disruptive approach to the tech market
• Accessing a career and training plan tailored to your performance and interests
• Being part of a welcoming, trustworthy, respectful and informal environment
• Joining our Affinity Communities (sports, tech, hobbies, etc.) and actively participating in social and environmental responsibility projects
• Taking advantage of a range of benefits, partnerships, discounts, events and internal dynamics
• Beyond your professional satisfaction, we want to offer you memorable moments of leisure and connection, worthy of an Affinity experience