Data Analyst SQL Senior

👉 Summary
We are looking for a new GIGAnte to join our team as a Data Analyst SQL Senior.
Where you will have the opportunity to be part of a multidisciplinary team focused on a technology and managed-services platform designed to automate and optimize the buying and selling of local television advertising—with the goal of modernizing the traditional (linear) television market and adapting it to the pace of the digital landscape.

👉 What You'll Do

• Lead analytics initiatives from requirements gathering and data preparation through analysis, dashboard delivery, and recommendations.
• Define and maintain KPIs, metric definitions, and reporting standards aligned with business objectives.
• Investigate trends, segments, and customer or product behavior to identify opportunities and inform priorities.
• Build reusable analytical datasets and automate recurring analyses and reporting workflows.
• Ensure data accuracy and consistency through validation, reconciliation, and investigation of discrepancies.
• Partner with Product, Engineering, and Delivery teams to clarify needs, resolve dependencies, and address gaps in available information.
• Make technical decisions independently, explaining trade-offs and escalating significant risks.
• Review analytical deliverables, mentor colleagues, and improve documentation and reusable practices.
• Apply data privacy, access, and governance controls throughout the analytical lifecycle.

👉 We'll Expect You To Have

• Advanced SQL: Complex joins, CTEs, window functions, aggregations, query optimization, and execution plan analysis.
• Business Intelligence: Proficiency in Power BI, Tableau, or Looker (DAX, Power Query, LOD, LookML, connections, filters, drill-downs, and optimization).
• Data Modeling: Defining granularity, fact/dimension tables, relationships, and reusable semantic models.
• Python or R: Data cleaning, analysis, and visualization using pandas/NumPy (or equivalents), and the development of maintainable scripts.
• Statistical Analysis: Descriptive and inferential statistics, sampling, hypothesis testing, regression, bias detection, and correlation vs. causation.
• Analytical Methods: Exploratory data analysis, segmentation, cohort analysis, trend analysis, and identifying performance drivers.
• Data Quality: Validation (integrity, uniqueness, consistency), source reconciliation, and documentation of metrics and data lineage.
• Excel: Advanced formulas, pivot tables, lookups, and data preparation for ad hoc analysis.
  Data Platforms: ETL/ELT pipelines, data warehouses, update dependencies, latency, and the impact of schema changes.
• Development Practices: Git, peer review, reproducible analysis, and technical documentation.
• Security: Role-based access control, handling sensitive data, and the secure distribution of analytical results.

👉 What we offer
🚀 An exciting growth journey and a never-ending ambition to develop as a company 
❤️ A friendly, supportive and humble working culture where the team always comes first
🌱 Opportunities for professional development and personal growth
🙌 Passionate, high-performing and genuine colleagues
🧘🏻 We care about the important things: results and well-being
🌈 Referral Programm- Refer a colleague program: Enjoy an amazing reward if you recommend a friend or colleague to GIGA IT and they get hired
🏖️ 15 business days PTO and flexibility programm
📆 Local Holidays
🌎 Remote work - You can work from anywhere! 
👩🏻‍💻 Notebook 
🕔 Work hours: Monday to Friday, from 8 a.m. to 5 p.m.
💵 To be agreed

👉 About GIGA IT

We believe that our differential value lies in our human capital, building a long-lasting relationship beyond mere deliverables.

You will be part of a Latin American company with expert teams that can enrich your knowledge. Thanks to our flexible way of working, we leverage the talent of our collaborators located in different regions of the world.
Our core values are:

• Trustworthy: We build trusted and rightful relations towards our external and internal clients
• Adaptable: We are flexible to adapt ourselves to complex environments.
• Passionate: We love what we do.
• Committed: We commit to act with accountability and efficiency at every step of the way.

💡Do you feel this is an exciting challenge for you? Then, don't hesitate to apply. We're eager to meet you and grow together🚀