Data Engineer

Why Work at Mercer Advisors?

For 40 years, Mercer Advisors has worked with families to help them amplify and simplify their financial lives. How? By integrating financial planning, investment management, tax, estate, insurance, and more, all managed by a single team. Today we proudly serve over 31,300 families in more than 90 cities across the U.S. Ranked the #1 RIA Firm in the nation by Barron’s, we are an independent, national fiduciary legally obligated to always act in the best interest of our clients.*

Mercer Advisors offers a distinct work environment that stands out in the financial industry. Our overall employee base and client-facing team are composed of 50% women, reflecting our commitment to diversity. We attract top talent from across the country, with no formal headquarters and flexible working arrangements, allowing us to assemble the best team possible.

Join us and be a part of a team dedicated to making a meaningful impact on the financial lives of families across the country.

* Mercer Advisors was ranked #1 for RIA firms with up to $70 billion in assets. The Barron’s top RIA ranking is based on a combination of metrics – including size, growth, service quality, technology, succession planning and others. No fee was paid for participation in the ranking, however, Mercer Advisors has paid a fee to Barron’s to use the ranking in marketing. Please see important information about the ranking criteria methodology here.

The Data Engineer will manage our Azure-based data warehouse, develop and maintain data pipelines, and implement a robust, scalable, and optimized end-state target data model. This role requires a strong foundation in data engineering principles, hands-on expertise with Azure and Python, and stakeholder collaboration to align technical solutions with business objectives.

Key Responsibilities

1. Data Platform Management
   • Oversee and maintain the Azure-based data warehouse, ensuring high availability, performance, and security.
   • Monitor and optimize data storage, retrieval, and processing within the platform.
2. Data Pipelines and Transformation
   • Design, build, and maintain data pipelines using Python, Azure Data Factory, or other Azure-native tools.
   • Ensure ETL/ELT processes are efficient, reliable, and scalable.
   • Troubleshoot and resolve data ingestion, transformation, and delivery issues.
3. Target Data Model Implementation
   • Develop and implement the end-state target data model to support analytics, reporting, and business intelligence needs.
   • Work with stakeholders to align data models with business requirements and ensure data accuracy and integrity.
4. Power BI Integration
   • Collaborate with analysts to understand how data is consumed in Power BI and design solutions that meet reporting and visualization needs.
   • Ensure data models are optimized for seamless integration with Power BI dashboards and reports.
5. Collaboration and Support
   • Partner with data analysts, scientists, and business teams to understand requirements and deliver data solutions.
   • Provide technical expertise and support for data-related projects and initiatives.
6. Continuous Improvement

• • Identify opportunities to improve data architecture, pipelines, and processes.
  • Stay updated on emerging data engineering trends and Azure capabilities.

Required Qualifications

• Education: Bachelor’s degree in computer science, Engineering, or a related field (Master’s preferred).
• Experience: 1-2 years in data engineering, with hands-on experience in:
• Azure Data Platform (Azure SQL Database, Azure Data Factory, Synapse Analytics, etc.)
• Python for data pipelines and transformation.
• Data modeling, schema design, and optimization.
• Understanding how data is consumed in Power BI and optimizing data models for reporting.
• Skills:
• Strong SQL expertise for querying and performance tuning.
• Familiarity with version control systems (e.g., Git).
• Knowledge of cloud-native architectures and best practices

Preferred Qualifications

• Experience in the financial services industry or familiarity with investment management concepts.
• Proficiency with CI/CD pipelines and DevOps practices in Azure.
• Exposure to machine learning pipelines and advanced analytics tools.
• Knowledge of data governance, security, and compliance standards.

Benefits:

Mercer Advisors offers a competitive and robust benefit package to our employees.   Our benefit programs are focused on meeting all of our employees and their eligible dependents health and welfare needs. We offer the following:

• 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

We are not accepting unsolicited resumes from agencies and/or search firms for this job posting.

Mercer Advisors provides equal employment opportunity to all applicants and employees without regard to age, color, disability, gender, marital status, national origin, race, religion, sexual orientation, gender identity and expression, physical or mental disability, genetic predisposition or carrier status, or any other characteristic protected by law in accordance with all applicable federal, state, and local laws. Mercer Advisors provides equal employment opportunity in all aspects of employment and employee relations, including recruitment, hiring, training and development, promotion, transfer, demotion, termination, layoff, compensation, benefits, and all other terms, conditions, and privileges of employment in accordance with applicable federal, state, and local laws.

If you are a resident of California, learn more about Mercer's California Consumer Privacy Policy here.