Job Purpose: The Enterprise Data Engineer will solution, build, and operate scalable, governed data pipelines and analytics-ready data products on the enterprise data platform. This role is a core contributor to our modern data architecture, leveraging Snowflake, ELT tools (Fivetran/Informatica/SSIS), dbt/SQL-driven transformations with medallion architecture patterns (Bronze / Silver / Gold) to deliver trusted, reusable data assets across the organization. This role will leverage strong hands-on experience with cloud data warehousing, SQL-based transformation frameworks (dbt and/or stored procedures), and production-grade data modeling, and partner in an environment that values automation, auditability, governance, and enterprise scale.
Job Duties: - Design, build, and maintain enterprise-grade ELT pipelines using Fivetran, Informatica or similar tool to ingest data from operational systems into Snowflake.
- Implement and operate a medallion architecture (Bronze, Silver, Gold) that supports data lineage, quality enforcement, and scalable consumption.
- Develop SQL-based transformations using dbt, Snowflake stored procedures, and views to standardize, conform, and enrich data.
- Create and maintain analytics-ready data models that support BI, reporting, and downstream data products.
- Embed data quality checks, audit columns, and metadata into pipelines to support traceability and compliance.
- Partner with data governance and security teams to implement role-based access controls, masking, and least-privilege access patterns in Snowflake.
- Monitor pipeline health, performance, and cost efficiency; proactively resolve failures and optimize workloads.
- Work closely with domain SMEs, analytics teams, and others to translate business requirements into scalable data solutions.
- Contribute to shared engineering standards, reusable frameworks, and documentation to improve consistency and delivery velocity.
- Support a data-product mindset, enabling teams to consume trusted data without rebuilding logic.
- Will perform special projects as assigned.
Education, Job Skills and Qualifications:- Bachelor's degree in Computer Science, Information Systems, Business Administration, or related field preferred.
- 5+ years of experience in data engineering, analytics engineering, or related roles.
- Strong proficiency in SQL for data transformation, modeling, and performance optimization.
- Experience with ELT/ETL tools such as Fivetran and/or Informatica.
- Experience working in regulated or enterprise environments (financial services, healthcare, etc.).
- Knowledge of cloud storage and integration patterns (e.g., Azure Blob, cloud landing zones).
- Experience with CI/CD for data pipelines and version control (Git-based workflows).
- Understanding of cost optimization strategies in Snowflake.
- Hands-on experience with Snowflake as a primary data warehouse.
- Practical experience implementing medallion or layered data architectures.
- Experience with dbt and/or Snowflake stored procedures for transformation orchestration.
- Familiarity with data quality concepts, pipeline monitoring, and production support.
- Exposure to data governance, metadata management, or lineage tooling.
- Ability to prioritize meeting project and strategic objectives deadlines.
- Team Player
Basic Qualifications:- 5+ years of experience in data engineering, analytics engineering, or related roles.
- Strong proficiency in SQL for data transformation, modeling, and performance optimization.
