Senior Data Engineer, Snowflake
Data Ideology, LLC
AirflowAWSAzureCloudETLGoogle Cloud PlatformInformaticaPythonSQL
Job Level
Senior
Tech Stack
AirflowAzureCloudETLInformaticaPostgresPythonSQL
About the role
- Build and optimize ETL/ELT pipelines for ingesting data from PSA, RMM, and monitoring tools
- Use tools like Airflow, dbt, and Fivetran to develop scalable workflows
- Implement normalization and integration logic across MSP platforms (ConnectWise, Kaseya, Datto, N-able)
- Help scale and maintain cloud-based data infrastructure (Azure)
- Contribute to CI/CD for data workflows and align with DevOps best practices
- Improve performance through data partitioning, syncing, and storage tuning
- Create and maintain well-documented dimensional and normalized data models
- Align data schemas and transformations with product and business logic
- Power dashboards, bots, and analytics through reliable backend design
- Implement Data Quality Indicators (DQIs) and monitor pipeline reliability
- Support access control, data auditing, and compliance with SOC 2, GDPR, and CCPA
- Maintain clear documentation of schemas, lineage, and transformation logic
- Help define metadata standards and contribute to the central data catalog
- Collaborate with Data Analysts, Developers, and Customer Teams to translate business needs
- Act as a subject matter expert on data models and platform integrations
- Mentor junior team members and promote clean code, modular design, and performance best practices
Requirements
- Bachelor’s or Master’s in Computer Science, Data Engineering, or related field
- 4+ years in hands-on data engineering or backend data roles
- Deep SQL knowledge and PostgreSQL performance tuning
- Strong Python skills for data manipulation and scripting
- Experience with modern data stack: Airflow, dbt, Fivetran, Informatica, etc.
- Cloud experience (Azure) and CI/CD pipelines for data
- Strong grasp of ETL/ELT pipelines, orchestration, and data modeling
- Experience with MSP tool data (e.g., ConnectWise, Kaseya, Datto) is a big plus
- Understanding of data governance and regulatory compliance frameworks (SOC 2, GDPR, CCPA)
- Willing to attend occasional once-a-month on-site department or leadership meetings
- Willingness to provide own WFH equipment and install Automate Agent for security (application requirements)
- Excellent written and verbal English communication (nice to have)
