Senior Analytics Engineers

Equação IT is a company focused on boosting technology and solid solutions through our expert consultants leading a high perspective and adding value to our customers with the purpose of providing optimization and business growth to our partners.

We are looking for a Senior Analytics Engineers with the following requirements

Responsibilities:
• Model and transform data into consistent analytical structures.
• Build and optimize ELT pipelines and quality tests.
• Ensure clear documentation (business rules, lineage, transformation logic).
• Monitor datasets, quality, SLAs, and performance.
• Support DS/BI/ML with reliable data and semantic layers.
• Collaborate closely with DE/DS/MLE/PO for integrated and value-driven deliveries.

Required Qualifications to be successful at this role:
Technical Skills:
• Advanced Data Modeling and Architecture: Expertise in star schema, dimensional modeling, medallion architecture, schema evolution management, and semantic layer design.
• Large Scale Semantic Layer & Data Model Optimization: Building and optimizing large-scale models, ensuring performance, consistency, and governance.
• Pipeline Orchestration and Automation: Experience with ETL/ELT tools like Azure Data Factory, Apache Airflow, Microsoft Fabric, Databricks Workflows.
• SQL Expertise & Performance Engineering: Proficiency in query tuning, partitioning, clustering, and handling large volumes of data with scalable SQL.
• Advanced Transformations with Python/Spark: Expertise in using PySpark, Spark SQL, and structured Python for advanced data transformations.
• CI/CD and Versioning for Data Pipelines: Experience with implementing CI/CD pipelines, version control, and DevOps best practices for data.
• Data Quality Frameworks & Observability: Rule definition, automated data validation, end-to-end monitoring, and observability.
• Data Governance, Cataloging, and Lineage: Practical use of tools like Microsoft Purview or Unity Catalog for governance, cataloging, and lineage tracing.
• BI Modeling and Performance: Advanced semantic modeling in Power BI, DAX optimization, and efficient analytical model design.
• Cloud Data Warehousing and Technical Architecture: Hands-on experience with platforms like BigQuery, Snowflake, Synapse, Delta Lake, ADLS, and Redshift; understanding system interdependencies.

Soft Skills:
• Ability to clearly align and bridge the needs of business, Business Intelligence, Data Science, and Data Engineering teams, transforming requests into actionable technical requirements.
• Supports the growth of junior profiles through guidance and functional reviews while promoting collective improvement in the team's output quality.
• Demonstrates accountability for delivering high-quality, consistent, and stable models and analyses while sustaining team trust and reliability.
• Tackles ambiguous issues with a structured approach, identifies root causes, and proposes scalable and effective solutions to mitigate them.
• Easily adapts to shifting priorities, efficiently generates workload plans, and proactively communicates risks to maintain smooth operations.

Senior Analytics Engineer:
• Professional Experience: Minimum 5+ years in data analytics environments with a proven record of architecting and deploying production-grade analytical solutions.

Mid Analytics Engineer:
• Professional Experience: Minimum 3+ years in data analytics environments with hands-on contribution to reliable data solutions.

Other Requirements:
• Educational Background: A degree in Data Science, Computer Science, Analytics, Machine Learning, or a related domain.
• Language Skills: Proficiency in English at a minimum B2 level or higher.

• Duration: Long Term Contract.
• Location: Lisbon - Work model: 2 days per week in the office and 3 days at home.