Associate BI & Analytics Engineer- Onsite Miami (no third parties) — Miami, FL

Associate BI & Analytics Engineer

Role overview

We are looking for a technically minded Associate BI & Analytics Engineer to join our data and analytics team.

This is an excellent opportunity for someone in the early stages of their career who has a strong foundation in SQL, Power BI, data modelling and an interest in Microsoft Fabric.

The role will involve working across the full analytics lifecycle, from understanding business requirements and querying data through to transforming and modelling datasets, developing data pipelines and delivering meaningful BI solutions.

You will work with technologies including Microsoft SQL Server, Power BI and Microsoft Fabric, gaining hands-on experience with modern data architecture, Lakehouses, Warehouses and data engineering processes.

Working alongside experienced members of the team, you will develop your technical capabilities across both business intelligence and analytics engineering.

Key responsibilities

Business Intelligence & Reporting

• Develop, enhance and maintain Power BI reports, dashboards and management information.

• Translate business requirements into meaningful reporting solutions and data visualisations.

• Develop DAX measures, calculations and transformations using Power Query.

• Build reusable semantic models and reporting datasets.

• Ensure reporting outputs are accurate, consistent and aligned with business requirements.

Data Development & Microsoft Fabric

• Write, maintain and optimise SQL queries to extract, transform and analyse data.

• Assist in developing and maintaining relational and dimensional data models.

• Work with Microsoft Fabric to develop and maintain modern data solutions.

• Gain practical experience working with Fabric Lakehouses, Data Warehouses and OneLake.

• Support the development and maintenance of data pipelines and Dataflows Gen2.

• Assist with data ingestion, transformation and orchestration processes.

• Work with SQL and, where appropriate, Python and Spark to transform and prepare data.

• Support the development of reliable and reusable datasets for analytics and reporting.

• Contribute to data quality, performance optimisation and continuous improvement initiatives.

Collaboration & Continuous Improvement

• Work with business stakeholders and technical teams to understand requirements and deliver appropriate data solutions.

• Investigate data issues and troubleshoot reporting and transformation discrepancies.

• Document data models, pipelines, reporting logic and technical processes.

• Identify opportunities to improve existing reporting and data processes.

• Continuously develop technical knowledge across Microsoft Fabric, Power BI and modern data technologies.

Skills and experience

Essential skills

• Good working knowledge of SQL, including joins, aggregations, CTEs and data manipulation.

• Experience developing reports and dashboards using Power BI.

• Understanding of data modelling principles, including relational databases and dimensional modelling.

• Familiarity with Power Query and DAX.

• Good understanding of data transformation and ETL/ELT concepts.

• Strong analytical, problem-solving and communication skills.

Desirable skills

• Exposure to Microsoft Fabric and its core components:

• OneLake

• Fabric Lakehouse

• Fabric Data Warehouse

• Data Pipelines

• Dataflows Gen2

• Semantic Models

• Experience with Microsoft SQL Server.

• Familiarity with Azure Data Factory and Azure DevOps.

• Exposure to Python, PySpark or Spark SQL.

• Understanding of data warehousing architecture and modern analytics platforms.

Education and experience

• Degree in Computer Science, Data Science, Information Systems, Mathematics or a related discipline, or equivalent practical experience.

• Ideally 1–3 years of experience in BI development, data analytics, SQL development or a related field.

• Demonstrable experience through commercial work, internships or personal projects using SQL and Power BI.

• Exposure to Microsoft Fabric would be advantageous, although a willingness and ability to learn the platform is equally important.