Mercer Advisors is a fee-only, independent RIA whose purpose is helping our clients achieve Economic Freedom. Established in 1985 as one of the nation's first fee-only financial planning firms, we have a rich legacy of operating exclusively as a fiduciary. We need talented, motivated people like you who can add to the growth of our business and culture.
We are looking for a savvy Data Engineer to join our growing technology team in Denver. The Data Engineer will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams.
Essential Job Functions for the Data Engineer will include:
* Creating and maintaining optimal data pipeline architecture * 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 including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs * Keeping our data separated and secure within Heroku * Working with data and analytics experts to strive for greater functionality in our data systems * Building processes supporting data transformation, data structures, metadata, dependency and workload management * Other duties as assigned
* Bachelor's degree required * Minimum 4 years' experience in Data Engineering required * Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases required * Experience building and optimizing data pipelines, architectures and data sets * Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement * Excellent project management and organizational skills * Experience supporting and working with cross-functional teams in a dynamic environment * Required Skills: * SQL (mysql, postgres), Data warehousing (Snowflake, Redshift) * Managing Tableau infrastructure * Knowledge of AWS and Saas * Understanding how to keep data safe and secure
Working Conditions: Professional office environment. Working inside. Standing and sitting. Will be assigned to a workstation. No heavy lifting over 25 lbs.
Benefits: We can offer you an exciting, fast-paced working environment, and the opportunity to play a vital role in our growth. Mercer Advisors is an equal opportunity employer offering a competitive salary and benefits package
We are not accepting unsolicited resumes from agencies and/or search firms for this job posting.
Let your dream job find you.
Sign up to start matching with top companies. It’s fast and free.