New Age Data Modeler

We are seeking a New Age Data Engineer/Modeler to join our data engineering team and help build modern, scalable, and maintainable data transformation pipelines. If interested, kindly reply back with your updated resume and contact info. Duration: 6 months Contract (possibilities of Extension) Location: Sunnyvale, CA (100% remote) Summary: This role combines deep SQL expertise with hands-on experience in DBT (Data Build Tool) and orchestration platforms like Apache Airflow to design, implement, and maintain reliable data models that power analytics and decision-making across the organization. Key Responsibilities • Design, develop, and maintain modular SQL transformations using dbt to create scalable, high-quality data models. • Consolidate and stitch together multiple SQL sources into unified, reliable outputs.Integrate and orchestrate dbt workflows within Apache Airflow to ensure smooth, automated data pipelines.Apply software engineering best practices (version control, testing, CI/CD) to data modeling and transformation processes. • Collaborate with analytics, product, and engineering teams to understand data requirements and translate them into efficient dbt models. • Leverage dbt’s built-in documentation, testing, and lineage capabilities to improve transparency and governance.Optimize data models for performance, scalability, and reusability, ensuring consistency across the data platform.Drive adoption of modern data stack tools and methodologies within the data organization. Required Skills and Experience: • Strong proficiency in SQL with hands-on experience creating complex queries and transformations. Proven expertise in dbt (Data Build Tool) for modular data modeling, testing, documentation, and version control.Familiarity with Apache Airflow or similar orchestration tools for scheduling and dependency management. • Experience with cloud-based data warehouses (Snowflake, BigQuery, Redshift, or similar).Solid understanding of data modeling concepts (star/snowflake schemas, normalization, incremental models). • Knowledge of software engineering practices such as Git-based workflows, CI/CD, and testing frameworks. • Strong problem-solving skills with the ability to work independently as well as cross-functionally. Preferred Qualifications • Bachelor s degree in Data Analytics, Computer Science, Business, or a related field (or equivalent experience) • Exposure to analytics engineering or modern data stack environments. • Experience consolidating multiple disparate SQL sources into a unified data model. • Familiarity with data governance, lineage, and observability tools.Strong communication skills for collaborating with technical and non-technical stakeholders. We are an Equal Opportunity Employer