Note: The job is a remote job and is open to candidates in USA. EP Wealth Advisors is a wealth management advisory firm serving predominantly high-net-worth individuals. The company is seeking a hands-on Data Engineer to build, operate, and improve a modern enterprise data platform using Snowflake, Microsoft Azure, Windmill, APIs, and internal business systems. The role focuses on reliable data pipelines, integrations, governance, quality, cloud engineering, and support for analytics and AI capabilities.
Responsibilities
- Design, build, test, deploy, and maintain scalable ELT/ETL pipelines that ingest and transform data from enterprise applications and external data providers into Snowflake
- Develop high-quality Snowflake data models, schemas, transformations, and reusable data engineering components supporting analytics, reporting, operational workflows, and AI use cases
- Build and maintain pipelines from source systems (Salesforce, Tamarac, API logs) into clean analytics layers
- Write and optimize complex SQL and Python-based data processing workloads
- Apply Snowflake engineering best practices for performance, scalability, security, reliability, and cost management
- Work with Snowflake capabilities such as tasks, streams, Snowpark, data sharing, automated ingestion, and related platform features as appropriate
- Diagnose and resolve data pipeline, query performance, data quality, and production reliability issues
- Develop and maintain data ingestion and orchestration workflows using Windmill and other appropriate integration technologies
- Integrate data from APIs, databases, files, SaaS platforms, custodians, and other enterprise data sources
- Build reusable ingestion patterns and frameworks rather than one-off integrations wherever practical
- Design pipelines with appropriate scheduling, dependency management, retries, error handling, logging, monitoring, and alerting
- Work with enterprise systems such as Salesforce and financial-services platforms supporting CRM, portfolio management, financial planning, custodial data, and related business processes
- Build and support data engineering solutions within the Microsoft Azure ecosystem
- Work with relevant Azure services for storage, identity and access management, secrets management, networking, monitoring, automation, and integration with Snowflake
- Implement secure authentication and service-to-service integration patterns
- Participate in CI/CD, source control, testing, deployment automation, and environment-management practices
- Partner with Security and Infrastructure teams to ensure cloud data solutions meet enterprise security and operational standards
- Implement automated data validation, reconciliation, testing, monitoring, and auditing to ensure data accuracy, completeness, timeliness, and reliability
- Build data pipelines that are observable and operationally supportable, with clear logging and failure recovery
- Support data lineage, metadata management, access controls, and enterprise data-governance practices
- Help establish trusted source-of-truth data sets and consistent business definitions across systems
- Apply appropriate data-security and access-control standards for sensitive financial and client information
- Identify, troubleshoot, and resolve data issues including data quality, integrity, latency, and security concerns; apply monitoring and operational best practices to keep pipelines reliable and performant
- Contribute to data quality and governance practices, including profiling datasets, defining quality rules, and establishing monitoring/remediation approaches
- Produce clear technical documentation covering pipelines, transformations, dependencies, data models, and operational procedures
- Use modern AI-assisted software-development tools to improve engineering productivity, code quality, testing, documentation, troubleshooting, and development velocity
- Apply AI responsibly when developing Python, SQL, integrations, and data-engineering solutions while adhering to security, privacy, and data-governance requirements
- Evaluate opportunities to leverage Azure and Snowflake AI capabilities where they provide practical value to data engineering, analytics, or enterprise workflows
- Exposure to or experience with AI/ML data pipelines, including RAG architectures, vector databases, or embeddings workflows
- Familiarity with agent-based systems, MCP integrations, or LLM-powered applications is a strong plus collaboration
- Partner closely with data analysts, application teams, architecture, security, compliance, and business stakeholders to translate data requirements into reliable technical solutions
- Collaborate with external technology and implementation partners when appropriate while helping EP develop strong internal data engineering capabilities
- Participate in technical design reviews, sprint planning, code reviews, architecture discussions, and production support
- Mentor other engineers and help establish pragmatic engineering standards and reusable patterns for the Data & AI Platforms organization
Skills
- 6+ years of professional data engineering or related software/data platform engineering experience
- 3+ years of meaningful hands-on experience developing production solutions with Snowflake
- Demonstrated experience designing and operating production-grade ELT/ETL pipelines
- Experience developing data integrations across multiple enterprise applications and data sources
- Experience operating data pipelines in production, including troubleshooting, monitoring, testing, and performance optimization
- Experience working within a cloud-based enterprise technology environment
- Advanced SQL, including complex transformations, data modeling, query tuning, and performance optimization
- Strong Python development skills for data processing, integrations, APIs, automation, and engineering utilities
- Strong hands-on knowledge of Snowflake architecture and engineering practices
- Experience with modern ELT/ETL and workflow orchestration technologies
- Experience integrating REST APIs, relational databases, SaaS applications, flat files, and other enterprise data sources
- Hands-on experience with Microsoft Azure and cloud-based data-platform integrations
- Experience using Git, automated testing, CI/CD, and modern software engineering practices
- Understanding of data quality, lineage, observability, metadata, security, and role-based access control
- Demonstrated use of AI-assisted development tools to improve engineering productivity and software quality
- Hands-on experience with Windmill for data integration, automation, or workflow orchestration
- Experience integrating Salesforce or other CRM platforms
- Experience working with financial-services, wealth-management, portfolio-management, custodial, or financial-planning data
- Experience with regulated data environments and controls for sensitive client or financial information
- Experience with Snowpark and other advanced Snowflake capabilities
- Familiarity with infrastructure-as-code, automated environment provisioning, and cloud DevOps practices
- Familiarity with Azure or Snowflake AI services and the use of LLMs within governed enterprise environments
Benefits
- 11 Paid Holidays + 2 Floating Holidays
- Paid Parental Leave
- Paid Volunteer Time
- Flexible Work Schedule
- Highly subsidized Health, Dental, and Vision Plans
- 401k Retirement Account with company match contributions
- Free Mental Health services, Life Insurance, Long & Short-Term Disability Insurance
- Flexible Spending Accounts and Health Savings Accounts
- Employee Financial Education
- Employee Educational Expense Reimbursement
- Employee Charitable Donations
- Employee Referral Incentives
- Employee Team Building Activities
- Employee Assistance Program
Company Overview