Softgic

Data Analyst – Reporting & Visualization 1861

Softgic Chihuahua City, Chihuahua, Mexico

IT Services and IT Consulting · 51-200 employees

19 h ago
data-analyst Mid (2-5 yrs) Full-time Mexico
Log in to apply, save this posting, or score it against your profile with AI.

About the role

Design, build, and maintain Power BI dashboards while developing Python scripts for data extraction and automation. Collaborate with the Data Architect to enhance Azure-based data pipelines and ensure data quality across the organization.

What they look for

Power BI DAX Data Modeling Python Pandas NumPy Azure Data Factory Azure SQL Database SQL Data Warehousing Dimensional Modeling Star Schema Snowflake Schema Data Pipelines Automation Data Visualization

Requirements

Requires 3+ years of experience in data analysis or business intelligence with strong proficiency in Power BI and Python. Candidates must have hands-on experience with Azure data services and a solid understanding of data warehousing principles.

Full description

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.

Requisitos

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

Similar roles