Senior Data Engineer

Senior Data EngineerNew York, New York, United States Or refer someoneJob Title: Senior Data Engineer Location: Remote (US)Salary 125K-155K + 12% bonusExperience- 5-8 yearsNo. of open roles 1Responsibilities:Design and build robust, scalable data transformation pipelines using SQL, DBT, and Jinja templatingDevelop and maintain data architecture and standards for Data Integration and Data Warehousing projects using DBT and Amazon RedshiftCollaborate with cross-functional teams to gather requirements and deliver dimensional data models that serve as a single source of truthOwn the full stack of data modeling in DBT to empower analysts, data scientists, and BI engineersEnhance and maintain the analytics codebase, including DBT models, SQL scripts, and ERD documentationEnsure data quality, governance alignment, and operational readiness of data pipelinesApply software engineering best practices such as version control, CI/CD, and code reviewsOptimize SQL queries for performance, scalability, and maintainability across large datasetsImplement best practices for SQL performance tuning, including partitioning, clustering, and materialized viewsBuild and manage infrastructure as code using AWS CDK for scalable and repeatable deployments. Integrate and automate deployment workflows using AWS CodeCommit, CodePipeline, and related DevOps toolsSupport Agile development processes and collaborate with offshore teamsRequired Qualifications:Bachelors or Masters (preferred) degree in a quantitative or technical field such as Statistics, Mathematics, Computer Science, Information Technology, Computer Engineering or equivalent5+ years of experience in data engineering and analytics on modern data platforms3+ years extensive experience with DBT or similar data transformation tools, including building complex & maintainable DBT models and developing DBT packages/macrosDeep familiarity with dimensional modeling/data warehousing concepts and expertise in designing, implementing, operating, and extending enterprise dimensional modelsUnderstand change data capture conceptsExperience working with AWS Services (Lambda, Step Functions, MWAA, Glue, Redshift)Hands-on experience with AWS CDK, CodeCommit, and CodePipeline for infrastructure automation and CI/CDPython proficiency or general knowledge of Jinja templating in Python and/or PySparkAgile experience and willingness to work with extended offshore teams and assist with design and code reviews with customerA great teammate and self-starter, strong detail orientation is critical in this role.