Data Analyst – Reporting & Visualization 1861

Softgic; Chihuahua; Presencial; MXN 312.000 - 456.000; Jornada completa

Descripción de la vacante

Softgic is seeking a Data Analyst – Reporting & Visualization to transform complex datasets into actionable dashboards and reports that support strategic and operational decisions.

You will work with the Data Architect in a Microsoft Azure-based data ecosystem, delivering robust and visually compelling reporting solutions while ensuring data quality, accuracy, and clarity for non-technical stakeholders.

Formación

• Experience designing and delivering Power BI dashboards and reports across multiple business areas.
• Strong Python skills for data wrangling, ETL, and automation.
• Ability to translate business requirements into clear reporting specifications and end‑to‑end solutions.
• Proven data modeling and data warehousing understanding, including dimensional modeling concepts.

Responsabilidades

• Design, build, and maintain Power BI dashboards and reports across multiple business areas.
• Develop and maintain Python scripts for data extraction, transformation, and automation.
• Partner with Data Architect to build and enhance data pipelines and integration workflows using Azure Data Factory.
• Query and manage data within Azure SQL Database, ensuring accuracy, reliability, and performance.
• Apply data warehousing and dimensional modeling principles (Star/Snowflake) to reporting solutions.
• Translate business requirements into reporting specifications and deliver end-to-end solutions.
• Document data sources, transformations, and report logic for maintainability.
• Identify data quality issues and work with upstream teams to resolve them.
• Ensure governance and adherence to organizational data policies.

Conocimientos

Power BI expertise

Python scripting

Data visualization storytelling

Stakeholder communication

Attention to detail

Herramientas

Azure Data Factory

Azure SQL Database

Azure Synapse Analytics

Databricks

Git

Pandas

NumPy

Descripción del empleo

We are looking for a Data Analyst – Reporting & Visualization to transform complex datasets into clear, actionable dashboards and reports that support strategic and operational business decisions.

Reporting directly to the Data Architect, this role will work across the organization’s Microsoft Azure-based data ecosystem, partnering with business and technical stakeholders to deliver reporting solutions that are both technically robust and visually compelling.

This position is ideal for someone who cares equally about data quality, accuracy, and consistency and the usability and impact of the dashboards they create.

Key Responsibilities

• Design, build, and maintain Power BI dashboards and reports across multiple business areas.
  
• Develop and maintain Python scripts for data extraction, transformation, and automation.
  
• Partner with the Data Architect to build and enhance data pipelines and integration workflows using Azure Data Factory.
  
• Query and manage data within Azure SQL Database, ensuring accuracy, reliability, and performance.
  
• Apply data warehouse and dimensional modeling principles, including Star Schema and Snowflake Schema.
  
• Translate business requirements into reporting specifications and deliver solutions end-to-end.
  
• Document data sources, transformations, business rules, and report logic to ensure maintainability and knowledge sharing.
  
• Identify data quality issues and collaborate with upstream teams to resolve them.
  
• Follow organizational policies, procedures, and applicable data governance requirements.
  
• Perform other related duties as assigned.
  
• 3+ years of experience in a Data Analyst, Business Intelligence, or similar role.
  
• Strong proficiency in Power BI, including:
  • DAX
    
  • Data modeling
    
  • Dashboard and report development
    
  • Report publishing
    
• Solid Python skills, particularly for data wrangling and transformation using Pandas, NumPy, or similar libraries.
  
• Hands-on experience with Azure Data Factory, including building and monitoring data pipelines.
  
• Working knowledge of Azure SQL Database, including:
  • SQL queries
    
  • Query optimization
    
  • Schema design
    
  • Data access patterns
    
• Strong understanding of Data Warehousing and Dimensional Modeling concepts.
  
• Ability to communicate technical findings clearly to non-technical stakeholders.
  
• Strong attention to detail with a focus on clean, accurate, and well-documented work.
  

Preferred Qualifications

• Experience with Azure Synapse Analytics or Databricks.
  
• Familiarity with Git and version control practices.
  
• Exposure to Medallion Architecture (Bronze / Silver / Gold) or similar layered data architectures.