Senior Data Analyst

About Ironhack

Our mission is to be the most outcome-driven institution in the world! We’re a global marketplace for tech talent, where we offer tech bootcamps and partner with companies to impact the lives of our students in a meaningful way. We empower students to create a new career path in tech, get that next promotion, or start their own company.

Why join Ironhack?

Our culture is characterized by collaboration, which is the way we roll. We like to take on challenges with a smile on our face! We work in flat hierarchies with open communication. Join Ironhack and we guarantee a bootcamp-paced learning experience in a high-growth environment, where we can change the future of education together!

Our benefits

• Remote-friendly policy for Global Team employees
• 22 working days of holidays per year
• Flexi Fridays (6 hour workday)
• Enroll in our part-time courses for free: learn to code, design, or analyze data
• A mentor for the first three months of onboarding

About the role:

As a Data Analyst at Ironhack, you will play a crucial role in our data team, working alongside experienced professionals to leverage our data infrastructure that supports stakeholders and business needs. The role is based in Spain (we have campuses in Madrid and Barcelona).

You will join our Data Team, lead by our head of Product. You'll help ensure analytical and technical support to our global teams (such Marketing, Admissions, Consumer,..) and main stakeholders, as you'll help these global teams understand performance and develop improvement action plans.

Connecting business and data is crucial for success, so we count on you to make sure that both areas are present on day-to-day processes, analysis, OKRs, decision making, implementation and improvements.

You need to know that we have recently revamped our data stack, which is now based on the following technologies:

• ELT pipeline, scheduled multiple times a day
• Airflow (orchestrator), S3 (Data Lake), Snowflake (Data Warehouse), DBT (Data Modelling), Metabase (Data Visualization), other services.
• Data Sources: CRM (Salesforce), Marketing (Google, Meta, TikTok, Piwik, etc.), Google Sheets, multiple APIs.

Your key responsibilities will include:

• Utilizing SQL (Snowflake flavored) and DBT to ensure accurate and efficient data modeling
• Creating custom DBT models with tailored logic to meet specific business needs
• Developing and optimizing the overall data model architecture
• Collaborating with stakeholders to understand data requirements and deliver actionable insights. Be reactive and proactive
• Supporting research and development initiatives, including AI and new tools/services
• Working closely with the Engineering team to enhance our ELT pipeline and data sources and models
• Participating in data team meetings and sharing insights with colleagues

Requirements and qualifications

We are willing to find a mid to senior data analyst, with multiple years of experience in the field. To excel in this role, you should possess the following qualifications:

• At least 3 years of experience as a Data Analyst with a proven track record of successfully delivering business intelligence projects
• Strong proficiency in SQL with experience in data modeling and querying
• Hands-on experience with DBT for managing data transformations and models
• Solid understanding of data warehouse concepts and experience working with cloud-based data platforms (e.g., Snowflake).
• Familiarity with data pipelines (ELT) and workflow orchestration tools (e.g., Airflow)
• Proficiency in data visualization tools (e.g., Metabase, Tableau, Looker) to effectively communicate insights. Direct experience in Metabase is a plus
• Python skills to comprehend ELT logics and contribute to future machine learning projects
• Excellent problem-solving abilities and attention to detail
• Strong communication skills to collaborate with cross-functional teams and stakeholders
• Curiosity and a passion for staying up-to-date with the latest trends and technologies in data analytics
• We are an international team, and English is our official working language. You should be able to comfortably explain technical concepts, even if English is not your native language.

Bonus points:

• Experience working with Snowflake SQL and/or other programming languages (i.e.: Python)
• Proficiency in developing customized Machine Learning models
• Familiarity with AWS services such as S3 and CloudWatch
• Knowledge of Docker containers and their purposeComfortable with exploring and researching new technologies and services to enhance our daily operations
• Knowledge of the data model of cloud CRM platforms like Salesforce
• Prior experience in the education industry