BI and Analytics Engineer

HackerRank; United States; Remote; USD 95,000 - 130,000; Full time

Job summary

HackerRank is seeking an Analytics Engineer to transform raw data into actionable insights by building scalable data models and ensuring data governance. The ideal candidate will have strong SQL and Python skills, experience with dbt, and effective collaboration abilities, contributing to high-impact projects in a mission-driven team.

Qualifications

• Experience with collaborative coding environments using Git-based workflows.
• Experience querying massive datasets using SQL, Hive, Spark.
• Proficiency in automating workflows.

Responsibilities

• Build and maintain scalable data models for analytics-ready datasets.
• Create and maintain data dictionaries and track data lineage.
• Collaborate with cross-functional teams to deliver high-quality datasets.

Skills

SQL

Python

Data Governance

Collaboration

Problem-solving

Education

2-4 years of experience in analytics engineering or a related field

Solid understanding of data modeling principles

Tools

dbt

Redshift

Apache Airflow

Spark

Job description

At HackerRank, we are on a mission to change the world to value skills over pedigree. We are a high-performing, mission-driven team that truly, madly, deeply cares about what we do. We don’t see velocity and quality as tradeoffs; both matter. If you take pride in high-impact work and thrive in a driven team, HackerRank is where you belong.

About the team:
Our BI & analytics team is driven by a clear mission to provide actionable insights for business growth.

• Recent Achievements: The team has powered the 2025H2 planning cycle centered on well-researched and relevant product adoption and revenue attribution metrics. Further, the GTM analytics team has made significant improvements in Revenue Reporting, Customer Journey, and other root cause analysis for the Self-serve channel, which was previously underserved analytically.
• Collaboration Style: Collaboration is at the heart of how we work. We seamlessly balance synchronous and asynchronous methods, enabling us to work cohesively as a team while respecting individual workflows. This approach fosters efficiency and inclusivity in tackling tasks together.

About the role:

As an Analytics Engineer, you will play a pivotal role in transforming raw data into actionable insights by building scalable data models and ensuring robust governance practices. You will collaborate with cross-functional teams to deliver high-quality datasets while supporting data governance initiatives such as maintaining data dictionaries, tracking lineage, and managing changes effectively.

What you’ll do:

• Data Engineering & Modeling

- Build and maintain scalable data models to transform raw data into analytics-ready datasets.
- Develop reusable SQL queries and modular pipelines using tools like dbt (Data Build Tool).
- Optimize database schema designs for performance and maintainability.

• Data Governance

- Create and maintain comprehensive data dictionaries with consistent naming conventions.
- Track data lineage to document how data flows through systems and assess the impact of changes.
- Implement change management protocols for updates to data models or pipelines, ensuring proper testing and communication with stakeholders.

• Collaboration & Stakeholder Management

- Partner with the Analytics team to understand requirements and translate them into technical solutions.
- Collaborate with Engineering teams on instrumentation and tracking improvements.
- Provide documentation and training on new datasets or processes to enable self-service analytics capabilities

You will thrive in this role if:

• Technical Skills

- Strong proficiency in SQL for writing scalable queries and advanced transformations (e.g., window functions).
- Hands-on experience with dbt for managing data transformations and testing frameworks.
- Proficiency in Python for automating workflows and managing dependencies.
- Familiarity with modern data warehouse platforms (e.g., Snowflake, BigQuery).

• Governance Expertise

- Experience maintaining data dictionaries and establishing consistent documentation practices.
- Knowledge of tools/processes for tracking data lineage across systems.
- Proven ability to implement and manage change management protocols for datasets or pipelines.

• Soft Skills

- Strong communication skills to translate technical concepts into business-friendly language.
- Ability to work collaboratively in cross-functional teams while managing competing priorities.
- Problem-solving mindset with a focus on delivering business-relevant insights.

What you bring:

• 2-4 years of experience in analytics engineering or a related field (data engineering or BI development).
• Solid understanding of data modeling principles and best practices for analytics use cases.
• Experience working in collaborative coding environments using Git-based workflows (e.g., code reviews, CI/CD pipelines)
• Experience with Spark, Spark Structured Streaming (Scala Spark)
• Experience with database technologies like Redshift or Trino
• Experience with ETL Design & Orchestration using platforms like Apache Airflow, MageAI etc is a big plus
• Experience querying massive datasets using Languages like SQL, Hive, Spark, Trino
• Experience with performance tuning complex data warehouses and queries.
• Able to solve problems of scale, performance, security, and reliability
• Self-driven, an initiative taker with good communication skills, and work with cross-functional teams

Want to learn more about HackerRank?Check outHackerRank.comto explore our products, solutions and resources, and dive into our story and missionhere.

HackerRank is a proud equal employment opportunity and affirmative action employer. We provide equal opportunity to everyone for employment based on individual performance and qualification. We never discriminate based on race, religion, national origin, gender identity or expression, sexual orientation, age, marital, veteran, or disability status. All your information will be kept confidential according to EEO guidelines.

Linkedin|X| Blog|Instagram|Life@HackerRank|

Notice to prospective HackerRank job applicants:

• Our Recruiters use @hackerrank.com email addresses.
• We never ask for payment or credit check information to apply, interview, or work here.