Analytics Engineer

Summary

Join TechnologyAdvice as an Analytics Engineer and data modeler, transforming source data into standardized reporting assets to enhance business performance and connect technology buyers and sellers. You will design data schemas, create and maintain semantic layers in reporting workflows, and collaborate with various teams to ensure standardized reporting. Responsibilities include building production data products for predictive models and customer experiences, addressing data quality issues, and developing governed production workflows. Success requires effective collaboration, a deep understanding of business data, a positive attitude, attention to detail, and adaptability. This role offers the opportunity to make significant contributions and share your ideas within a supportive environment. The position is located in India and is a contract position.

Requirements

• Bachelor's or Master's degree in a relevant field such as Computer Science, Information Systems, Data Science or a related discipline
• 4-6 years of experience in data engineering, analytics engineering, data modeling, data architecture or data science, preferably in a digital business
• Understanding of best practices for designing modular and reusable data structures (e.g. star and snowflake schemas) and implementing conceptual and logical data models
• Advanced SQL techniques for data transformation, querying, and optimization
• Experience working within cloud-based data environments such as Snowflake, Redshift, or BigQuery and managing database procedures and functions
• Knowledge of data transformation frameworks and data lineage best practices
• Experience building, maintaining, and optimizing ETL/ELT pipelines, using modern tools like dbt, Dagster, Airflow, or similar
• Familiarity with version control, CI/CD, and modern development workflows
• Experience applying AI to improve work quality and the efficiency of the data model development process
• Ability to collaborate cross-functionally with data analysts, engineers, and business stakeholders to understand data needs and translate them into scalable models

Responsibilities

• Own the full lifecycle of data model development, including ideation, prototyping, implementation, refactoring, and deprecation of outdated assets
• Develop and maintain semantic data models that serve as the source-of-truth for data customers across the organization
• Build common dimension tables to support enterprise reporting use cases and improve data model consistency and maintainability
• Document and translate business requirements into data complex models that cover enterprise reporting needs, including marketing attribution and revenue recognition
• Standardize data nomenclature and data type conventions and transform legacy data objects to standardized models
• Partner with engineering, business intelligence, data science, and other teams to ensure alignment on development priorities and data solutions
• Build workflows that maximize the efficiency of data processes while maintaining high standards of data quality, data usability, and performance
• Adhere to best practices related to metadata management and metadata reporting
• Develop subject matter expertise in specific business areas and data domains, and help educate customers regarding the correct utilization of data objects
• Build and maintain production data products that serve as building blocks for business intelligence reporting, predictive data models, and product-led development initiatives
• Create and maintain data lineage documentation to improve transparency and auditability of data transformations and dependencies
• Implement automated data validation and testing frameworks to ensure data model integrity and trustworthiness
• Manage quality assurance workstreams and drive adoption of appropriate incident management frameworks for enterprise reporting
• Partner with data engineering to optimize data transformations and scheduled procedures for cost, performance, and reporting schedules
• Work directly with business intelligence analysts to enforce the adoption of relevant data models and capture reporting requirements for data model development
• Partner with upstream data owners to identify opportunities to improve downstream reporting capabilities, reduce model complexity, and increase data coverage
• Participate in agile development processes, including sprint planning, retrospectives, and iterative delivery of data products
• Understand stakeholder business objectives and how data and analytics solutions can help internal customers meet their goals
• Identify opportunities for data acquisition or data integration projects to improve the value of enterprise data assets

Preferred Qualifications

• Knowledge of data governance principles, data quality standards, and regulatory compliance (e.g., GDPR, CCPA) is a plus
• Expertise in scripting and automation with experience in object-oriented programming and building scalable frameworks is a plus
• Experience building production dashboards using tools such as Tableau, Power BI, or Looker is a plus
• Strong attention to detail and a passion for staying updated with industry trends and emerging data management and data transformation technologies
• Agile professional who excels in a fast-paced environment and thrives on continuously pivoting strategies to drive business needs forward