Implement and Monitor ELT Pipelines: Design, develop, and maintain scalable ELT workflows using Azure Data Factory, Fivetran, and dbt. Proactively monitor pipeline health and troubleshoot issues to ensure reliable data delivery.
Data Modeling and Collaboration: Partner with data analysts to understand business needs and translate them into efficient, well-documented data models using dbt. Continuously refine models to support evolving analytic requirements.
Analytics Platform Optimization: Manage and optimize the Lantern Analytic Platform by monitoring query performance, implementing data partitioning strategies, and refining data models to enhance speed and efficiency.
Requirements
Bachelors degree in computer science or related field
3-5 years of experience with reporting and analytics
Proven experience with ELT tools such as Azure Data Factory, Fivetran, and dbt
Strong SQL skills and understanding of data warehousing concepts
Experience with performance tuning and data model optimization
Ability to collaborate effectively with cross-functional teams
Familiarity with cloud data platforms (e.g., Azure, Snowflake, BigQuery) is a plus
Benefits
Medical Insurance
Dental Insurance
Vision Insurance
Short & Long Term Disability
Life Insurance
401k with company match
Paid Time Off
Paid Parental Leave
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ELT workflowsAzure Data FactoryFivetrandbtSQLdata modelingperformance tuningdata warehousingdata partitioningdata model optimization