Description :
- Candidate must have 4- 8 years of experience in Analytics, Business Intelligence (BI), or Data Engineering, preferably from Growing Startups or Product-based companies.
- Candidate should have strong hands-on expertise in SQL, capable of writing clean and optimized queries with a deep understanding of Data Warehousing concepts including Star Schema, Fact / Dimension models, Slowly Changing Dimensions (SCD), ETL / ELT processes, and MPP Databases (Redshift / BigQuery or similar).
- Candidate must have hands-on experience with dbt for data transformations and building scalable data pipelines / DAGs for batch processing of large datasets (millions of rows).
- Candidate should be proficient in Python with a strong understanding of data modeling, semantic layer design, and cloud data tools such as Amazon Athena, Redshift, or BigQuery.
- Candidate must have experience working with analytics or logging platforms, along with strong dashboarding and reporting skills using Looker or Tableau.
- Candidate should have proficiency in Git and CI / CD workflows, and hands-on experience in Agile product teams with excellent documentation and communication skills.
Job Summary :
As an Analytics Engineer, you will play a critical role in shaping the data infrastructure, data strategy, and analytical framework for the organizations Data & Analytics division. This position requires a blend of engineering expertise and analytical acumen someone who not only knows how to extract value from big data but also understands how to design robust data models and semantic layers that enable scalable, self-service analytics across the organization.
You will be responsible for end-to-end project ownership, from understanding data requirements to planning and implementing comprehensive data solutions encompassing data pipelines, storage models, and visualizations. Working cross-functionally with product, engineering, and business teams, you will ensure that all analytical systems are accurate, reliable, and capable of supporting data-driven decision-making.
This role is ideal for someone who enjoys solving complex data challenges, thrives in a fast-paced environment, and is passionate about enabling others through clean, accessible, and well-structured data systems.
What You Will Do :
Design and Develop Data Models :
Architect and implement robust data models that support flexible querying and enable scalable data visualization. Design star schemas and well-structured datasets to facilitate efficient analytics and reporting.Collaborate with Stakeholders :
Partner closely with product managers, analysts, and engineering teams to understand business goals and translate them into analytical and engineering requirements. Build solutions that help stakeholders derive actionable insights from data.Automate and Optimize Workflows :
Drive automation initiatives that streamline data preparation and reduce manual effort. Focus on building reusable frameworks and pipelines that increase team productivity and allow analysts to spend more time on insights rather than data wrangling.Implement Data Pipelines and Transformations :
Use modern data transformation tools like dbt to design scalable, automated, and maintainable data pipelines. Ensure efficient data movement, transformation, and loading (ETL / ELT) into analytical systems.Maintain Data Quality and Consistency :
Create processes for detecting and resolving data anomalies. Implement systematic solutions for identifying errors, alerting relevant teams, and performing root cause analysis to ensure data reliability.Develop and Maintain Dashboards :
Build insightful, interactive, and visually appealing dashboards using BI tools such as Looker or Tableau. Ensure dashboards are intuitive, easy to maintain, and empower non-technical stakeholders to make informed decisions.Advance Data Governance and Standards :
Establish best practices for analytics development, data governance, and version control. Ensure adherence to data engineering and modeling standards to maintain consistency across the organizations analytical infrastructure.Support New Product and Feature Launches :
Collaborate proactively with product and engineering teams to prepare data pipelines for new product features. Guarantee that data is properly captured, structured, and validated prior to launch.Explore and Innovate :
Constantly explore new technologies, methodologies, and analytical approaches to enhance the data ecosystem. Use creative and experimental methods to solve complex analytical and engineering challenges.What You Bring :
Educational Background :
Bachelors degree in Engineering, Computer Science, or a related field.Professional Experience :
4- 8 years of hands-on experience in Data Engineering, Business Intelligence, or Analytics Engineering, ideally within digital or tech-driven organizations.Technical Proficiency :
SQL Expertise :
Ability to write clean, efficient, and optimized SQL code. Deep understanding of data warehousing concepts, including star schemas, slowly changing dimensions, and ELT / ETL workflows.Data Modeling and Pipelines :
Proven experience designing and maintaining complex data pipelines and transformations using tools like dbt.Programming Skills :
Proficiency in at least one general-purpose programming language such as Python, Java, or Go, with a good grasp of data structures, algorithms, and serialization formats.BI and Visualization Tools :
Advanced experience in building dashboards and reports using Looker or Tableau, ensuring data is both accessible and actionable.Cloud and Analytics Tools :
Familiarity with modern data platforms such as AWS Athena, Redshift, Google BigQuery, or Splunk.Version Control and CI / CD :
Proficiency with Git (or similar tools) and exposure to CI / CD best practices for maintaining production-grade data systems.Project Management and Collaboration :
Ability to manage multiple data initiatives simultaneously, ensuring timely delivery and high-quality output. Experience working within Agile frameworks to manage workflows and sprints efficiently.Analytical and Problem-Solving Skills :
Demonstrated ability to handle ambiguous data challenges, apply structured thinking, and design scalable solutions. Strong attention to detail when working with large, complex datasets.Communication and Documentation :
Excellent verbal and written communication skills. Proven ability to document data processes, communicate technical details to non-technical stakeholders, and foster alignment across teams.Domain Experience (Preferred) :
Previous experience working with digital products, streaming platforms, or subscription-based services is a strong plus, as it provides familiarity with user engagement metrics and real-time data ecosystems.(ref : hirist.tech)