Analytics Engineer - Centralized Data Mart

About the Role

We are seeking a skilled and detail-oriented Analytics Engineer to design, build, and maintain a centralized data mart that empowers data-driven decision-making across our organization. You will play a crucial role in bridging data engineering and analytics by transforming raw data into well-modeled, accessible, and reliable data assets for business intelligence, reporting, and advanced analytics.

Key Responsibilities:

• Design, develop, and maintain a centralized data mart to serve as the single source of truth for reporting and analytics.
• Work closely with data engineers to integrate data from multiple sources into clean, governed, and scalable models.
• Transform and model data using modern data transformation tools (e.g., dbt, Spark SQL, BigQuery SQL).
• Define and implement data modeling standards and best practices to ensure consistency, reusability, and documentation across data assets.
• Collaborate with analysts, data scientists, and business stakeholders to understand reporting and analytical needs and translate them into efficient data structures.
• Ensure data quality through rigorous validation, testing, and monitoring.
• Contribute to establishing data governance frameworks, including metadata management, data lineage, and access controls.
• Troubleshoot data issues and provide ongoing support to ensure the reliability and performance of the centralized data mart.
• Optimize queries through tuning, query plan analysis, and distributed computing best practices.

Qualifications:

• Bachelors or Masters degree in Computer Science, Data Engineering, Analytics, or a related field.
• 3+ years of experience in analytics engineering, data engineering, or BI engineering.
• Solid experience in designing and implementing data models for analytics use cases.
• Strong SQL skills and proficiency in data modeling (dimensional modeling, star/snowflake schemas).
• Experience with data transformation tools such as dbt or equivalent frameworks.
• Familiarity with modern data warehousing platforms (e.g., Snowflake, BigQuery, Redshift).
• Experience with orchestration tools (e.g., Airflow, Prefect) and version control (e.g., Git) is a plus.
• Understanding of data governance concepts including data quality, lineage, and documentation.
• Strong analytical and problem-solving skills with a business-oriented mindset.
• Excellent communication skills and ability to collaborate across technical and non-technical teams.