Senior Analytics Engineer

This is a fully remote position, open to applicants in Brazil, +4 more countries.

📋 Description

• Oversee the development, implementation, and continuous enhancement of analytics solutions for clients.

• Design and create data platforms utilizing Microsoft Fabric.

• Manage Power BI implementations from start to finish.

• Set analytics governance standards for clients.

• Spearhead Infor Birst implementations, extensions, and ongoing support.

• Construct and sustain spaces, logical models, hierarchies, measures, and security filters for Infor CSD data.

• Expand and troubleshoot CSD dashboards and reports.

• Address data refresh, connector, and performance challenges.

• Profile data from Infor CSD and associated systems.

• Create dependable, low-impact extraction and ingestion processes.

• Maintain raw data for reprocessing and manage change capture and deletions.

• Ingest non-ERP data and align it with conformed dimensions.

• Resolve data inconsistencies during the ingestion process.

• Monitor solutions with failure alerts, row-count and freshness checks, and schema-drift detection.

• Document recovery procedures.

• Construct and maintain pipelines that convert ERP data into dimensional models.

• Write and optimize SQL queries.

• Implement incremental loads and ensure data quality checks.

• Assist clients using platforms like Phocas with data feeds, mapping, model design, and ERP integration.

• Provide guidance on platform suitability and maintenance costs.

• Utilize AI tools to enhance development, data profiling, documentation, and testing.

• Deliver conversational analytics and prepare semantic models for natural-language queries.

• Assess emerging AI analytics features.

• Translate distribution business requirements into data specifications and practical solutions.

• Generate technical documentation, runbooks, and handover materials.

• Train and support client power users in expanding analytics content.

• Develop reusable templates, models, and accelerators for future implementations.

⛳️ Requirements

• Over 10 years of experience in BI, analytics engineering, or data warehousing, including client-facing or multi-business-unit delivery.

• Proficient in Power BI, covering data modeling, advanced DAX, Power Query/M, performance tuning, deployment management, and row-level security.

• Practical experience with Microsoft Fabric, including lakehouses/warehouses, Dataflows Gen2, pipelines, and semantic models.

• Advanced SQL skills and query optimization for large transactional tables.

• Expertise in ETL/ELT design, including incremental loads, slowly changing dimensions, error management, and scheduling.

• Knowledge of dimensional modeling, including star schemas, fact tables, conformed dimensions, and data grain.

• Experience in extracting ERP data and reconciling reports with the system of record.

• Ability to translate vague business needs into technical designs and communicate them to non-technical stakeholders.

• Upper-Intermediate+ English proficiency for effective client communication.

• Strong documentation capabilities and experience in supporting production analytics solutions.

• Eagerness to learn and work with additional analytics platforms.

• Experience using AI tools in development and an interest in conversational analytics.

• Preferred: Strong knowledge of Azure data platform alongside Microsoft Fabric.

• Preferred: Practical skills in Infor Birst.

• Preferred: Familiarity with Infor CloudSuite Distribution, SX.e, or Infor ION/Data Lake and their underlying data structures.

• Preferred: Experience with Phocas or similar distribution-focused BI products.

• Preferred: Knowledge of wholesale distribution.

• Preferred: Experience with ERP-embedded analytics tools.

• Preferred: Skills in Python or Spark for data transformation; familiarity with Git and CI/CD for analytics assets.

• Preferred: Microsoft certifications (PL-300, DP-600, DP-700) or equivalent.

• Preferred: Experience in consulting, MSP, VAR, or ERP partner environments.

• Preferred: Knowledge of Power Automate, Power Apps, and Dataverse.

🏝️ Benefits

• Remote-first work arrangement.

• Collaborate with a global team of IT professionals across 55+ countries.

• Engage in complex, hands-on analytics projects.

• Opportunity to contribute to the development of a growing analytics practice.

• Work with Microsoft Fabric, Power BI, and Infor Birst.

• Ownership of complete BI solutions.

• Contractor engagement.