Quick overview
Job description
TECHNOGEN, Inc. is a Proven Leader in providing full IT Services, Software Development and Solutions for 15 years.
TECHNOGEN is a Small & Woman Owned Minority Business with GSA Advantage Certification. We have offices in VA; MD & Offshore development centers in India. We have successfully executed 100+ projects for clients ranging from small business and non-profits to Fortune 50 companies and federal, state and local agencies.
Role: DBT Engineer with Airflow & SQL
Location: Oaks, PA (Hybrid-3 days onsite in a week)
Responsiblities:
Develop and maintain DBT models, macros, and SQL scripts to transform data within Snowflake.
Optimize data models, design star/snowflake schemas, manage warehouse performance, and implement clustering/materialized views.
Create scalable ELT/ETL pipelines to ingest and transform data from diverse sources.Write modular, testable SQL code using version control and manage DBT project structures.Implement data quality checks, automated tests, anomaly detection, and data security, including RBAC, masking, and row-level access in Snowflake.
Basic Qualifications: (what are the skills required to this job with minimum years of experience on each)
5+ years of experience with DBT and Hands-on experience developing with dbt.
3+ years of experience with Python development
3+ years of experience with Airflow development3+ years of experience with Snowflake and Strong SQL proficiency.Good handle on Datawarehouse concepts.
Education: Bachelor's degree in Computer Science, Data Engineering, or a related field
Similar jobs
- DW

DevSecOps EngineerRecently posted Auto Apply
Dark Wolf Solutions · Colorado Springs · Hybrid 🇺🇸
SAFeGitAWS+12EngineeringSalary not listed - RH

Crowdstrike Falcom EngineerRecently posted
Robert Half · Eden Prairie, MN · Hybrid 🇺🇸
EngineeringSalary not listed - AI

Systems Engineering Program Manager, Autonomous AirpowerRecently posted Auto Apply
Anduril Industries · Costa Mesa · Hybrid 🇺🇸
Talent AcquisitionComplianceComputer Vision+6Engineering$191k - $254k/yr - AT

Controls Engineer – Energy SystemsRecently posted Auto Apply
ALTEN Technology USA · Berkley CA / Denver CO / Greensboro NC / Troy MI / Dallas TX · Hybrid 🇺🇸
MATLABGitRobotics+5Engineering$90k/yr - SD

Engineer Shadow AIRecently posted
Stanley David and Associates · United States · Hybrid 🇺🇸
Generative AIEngineeringSalary not listed - OE

Analog Bench Testing EngineerRecently posted
OSI Engineering, Inc. · Irvine, CA · On-site 🇺🇸
Data AnalysisEngineering$60 - $75/hr - HI
DevSecOps EngineerRecently posted
Hirex · Orlando, FL · On-site 🇺🇸
EngineeringSalary not listed - CI

Systems Engineering & Technical Assistance (SETA) Analyst - UAS/UAV AnalysisRecently posted
CACI International, Inc. · Charlottesville, VA · Hybrid 🇺🇸
Project ManagementEngineering$82.1k - $172.4k/yr - ST

GM Paint Process EngineerRecently posted
Sovereign Technologies · Arlington, TX · Hybrid 🇺🇸
RoboticsEngineeringSalary not listed - AE

Chief Systems Engineering Lead - PAE Advanced Concepts with Security ClearanceRecently posted
Aerospace Corporation · Chantilly, VA · Remote 🇺🇸
Project ManagementEngineering$165.3k - $247.9k/yr - BA

Zero Trust C2C EngineerRecently posted
Booz Allen Hamilton · Arlington, VA · On-site 🇺🇸
Engineering$86.8k - $198k/yr - BA

Digital Twin Simulation EngineerRecently posted
Booz Allen Hamilton · Beavercreek, OH · On-site 🇺🇸
ScrumConfluenceJira+1Engineering$86.8k - $198k/yr
