Mercer Advisors · 5 hours ago
Data Engineer
United States
Full-time
Remote
Mid, Senior Level
$96K/yr - $113K/yr
5+ years expMercer Advisors is a leading independent financial advisory firm dedicated to simplifying and enhancing the financial lives of families across the U.S. They are seeking a Data Engineer to join their technology team, responsible for optimizing data architecture and improving data flow for cross-functional teams. The role involves creating data pipelines, maintaining data models, and collaborating with stakeholders to support their data infrastructure needs.
AdviceAsset ManagementBusiness DevelopmentFinancial ServicesInsuranceWealth Management
Responsibilities
Creating and maintaining optimal data pipeline architecture
Enterprise pipeline orchestration set up administration (AWS Glue, Airflow, Fivetran)
Assembling large, complex data sets that meet functional & non-functional business requirements
Identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
Building the infrastructure required for optimal extraction, transformation and loading of data from a wide variety of data sources using relevant technologies
Working with stakeholders to assist with data-related technical issues and support their data infrastructure needs
Securing the data within our environment
Working with our analytics experts to strive for greater functionality in our data systems
Building processes supporting data transformation, data structures, metadata, dependency, and workload management
Maintaining our data model
Other duties as assigned
Qualification
Required
Bachelor's degree in a relevant field is required
Minimum 5 years' experience in Data Engineering is required
Advanced working SQL knowledge and experience working with relational databases is required
Experience working with SQL Server is required
Experience working with Python for at least 3 years' is required
Experience building and optimizing data pipelines, architectures, and data sets is required
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement is required
Experience supporting and working with cross-functional teams in a dynamic environment
Preferred
Knowledge of Salesforce data structure is preferred
Knowledge of working in Azure is preferred
Benefits
Company Paid Basic Life & AD&D Insurance
Company Paid Short-Term and Long-Term Disability Insurance
Supplemental Life & AD&D; Short-Term Disability; Accident; Critical Illness; and Hospital Indemnity Insurance
Three medical plans offerings including two High Deductible Health Plans and a Traditional Co-Pay medical plan.
Health Savings Account (HSA) with company contributions on a per pay period basis if enrolled in either HDHP medical plan.
Two comprehensive Dental Plans
Vision Insurance Plan
Dependent Care Savings Account for child and dependent care.
14 Company Paid Holidays with a full week off at Thanksgiving.
Generous paid time off program for vacation and sick days
Employee Assistance Plan
Family Medical Leave
Paid Parental Leave (6 weeks)
Maternity benefits utilizing company paid STD, any supplemental STD, plus Parental Leave (6 weeks) to provide time for recovery, baby bonding, and enjoying your family time.
Adoption Assistance Reimbursement Program
Company Paid Concierge Services for you and your loved ones for the spectrum of caring needs for your aging parents, young children, life’s challenges and more.
401(k) Retirement Plan with both Traditional and Roth plans with per pay period match
Pet Insurance
Company
Mercer Advisors
Mercer Advisors is a full-service wealth management firm.
501-1000 employees
H1B Sponsorship
Mercer Advisors 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
2025 (2)
2024 (1)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Altas PartnersHarvest PartnersOak Hill Capital Partners
2023-06-06Private Equity
2023-02-28Private Equity
2019-09-17Private Equity
Leadership Team
Peter Ip
Senior Vice President and Relationship Manager
Recent News
2026-01-07
2026-01-07
Company data provided by crunchbase