Data Analyst – Reporting & Visualization 1861

Softgic S.; Chihuahua; On-site; MXN 240,000 - 420,000; Full time

Job summary

Softgic S. in Chihuahua, MX is seeking a Data Analyst - Reporting & Visualization to transform complex data into clear dashboards and reports to support strategic decisions.

You will work with the Data Architect in an Azure-based data ecosystem, delivering robust and visually compelling solutions with a focus on data quality and usability.

Qualifications

• 3+ years of experience in a Data Analyst, BI, or similar role.
• Strong Power BI proficiency including DAX and data modeling.
• Expertise in Python for data wrangling and transformation.
• Experience with Azure Data Factory and Azure SQL Database.
• Solid SQL skills: queries, optimization, and schema design.
• Knowledge of data warehousing and dimensional modeling concepts.
• Ability to communicate findings to non-technical stakeholders.
• Attention to detail with clean, well-documented work.

Responsibilities

• Design, build, and maintain Power BI dashboards across business areas.
• Develop Python scripts for data extraction, transformation, and automation.
• Collaborate with Data Architect to enhance Azure Data Factory pipelines.
• Query and manage data in Azure SQL Database with focus on performance.
• Apply data warehousing and dimensional modeling principles.
• Translate business needs into end-to-end reporting specifications.
• Document data sources, transformations, and report logic.
• Identify data quality issues and resolve with upstream teams.
• Adhere to data governance and organizational policies.

Skills

Power BI

DAX

Data modeling

Dashboard dev

Report publishing

Python

Pandas

NumPy

Azure Data Factory

Azure SQL DB

SQL queries

Query optimization

Schema design

Data warehouse

Dimensional modeling

Stakeholder comms

Tools

Azure Synapse Analytics

Databricks

Git

Medallion Architecture

Job description

Chihuahua, Mexico

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.
  

Requirements

• 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.