Apolis · 1 month ago
DBT Lead With Azure
Boston, MA
Full-time
Hybrid
Senior Level
$0/hr - $70/hrApolis is a company seeking a DBT Lead with Azure expertise. The role involves developing and optimizing DBT models, managing data workflows, and collaborating with various teams to ensure data integrity and quality.
ConsultingEnterprise ApplicationsEnterprise Resource Planning (ERP)Information TechnologyIT InfrastructureIT ManagementMobileSoftwareWeb Hosting
Responsibilities
Develop, maintain, and optimize DBT models, ensuring alignment with business and technical requirements
Configure and manage sources & sources. yml files to maintain data lineage and integrity
Utilize ref macros, custom macros, and materializations to develop reusable and modular pipelines
Implement pre-hooks and post-hooks for advanced transformations, auditing, and automated checks
Manage DBT Seeds for static data storage and integration into models
Work closely with Azure Data Factory (ADF) teams to integrate DBT workflows into data pipelines
Implement best practices for version control using Git & Azure DevOps, including branching strategies, pull requests, and CI/CD integration
Collaborate with data engineers, BI teams, and business stakeholders for data requirement gathering and solution delivery
Ensure data quality, scalability, and maintainability of all DBT models and artifacts
Work within Azure Cloud environment, ensuring understanding of RBAC roles & access controls
Qualification
Required
Strong knowledge of DBT basics, models, sources, and ref usage
Experience with DBT advanced concepts such as Macros, Materializations, Hooks
Hands-on experience with Azure Data Factory (ADF) or similar ETL/ELT orchestration tools
Familiarity with Git version control, Azure DevOps workflows, and CI/CD processes
Understanding of Azure Cloud fundamentals & RBAC for secure data access
Proficiency in SQL and data modeling concepts
Company
Apolis
Apolis is a IT consultancy that offers provides ERP solutions, hosting, assessment, web and mobile, IT staffing and IT workforce solutions.
Founded in 1996
501-1000 employees
H1B Sponsorship
Apolis has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (15)
2022 (15)
2021 (12)
2020 (122)
Funding
Current Stage
Late StageLeadership Team
Amar Shokeen
President/ CEO
Rita Shokeen
COO
Company data provided by crunchbase