Data Engineer

Job Description:

The Job/What You'll Do:

Design, develop, and maintain the corporate data, enterprise data warehouse and business intelligence solutions within AssetMark. Deliver timely, accurate and actionable data critical to the business decision-making process. Facilitate the identification, analysis, development, manipulation of company data and information to gain knowledge of the factors that affect overall company performance. Provide continuous improvement efforts to enhance data transformation and manipulation performance while providing increased functionality and support to production information systems based on the business needs.

We can consider candidates for this position who are able to accommodate a hybrid work schedule and are close to our Encino, CA office.

Responsibilities:

Essential functions of the position include, but are not limited to:

• Work in a highly collaborative team environment following the Agile methodology to assist other department personnel in the successful accomplishment of strategic and divisional objectives. Take the necessary steps to ensure our customers' needs are met to the maximum extent possible in an accurate and timely manner. Perform hands on development and collaborate in the data management efforts including operational data support to provide a high level of data integrity, security and availability for internal and external customers.
• Establish and maintain a scalable, extensible and maintainable architecture for the enterprise data warehouse and business intelligence system. Summarize enterprise data into an intuitive analysis framework for understanding the current and future performance of the company. Provide the design, development, testing and maintenance of ETL processes, reporting and dashboards to support Association strategic objectives.
• Collaborate with other business unit leaders for various projects involving enterprise data. Ensure the appropriate capture and retention of enterprise data. Work with Business Analysts to translate various business needs into warehousing, analytics, reporting, and dash-boarding requirements.
• Provide expertise to achieve system integration through database design, including data and dimensional modeling, logical and physical table design, complex queries, stored procedures and triggers, data transformation, aggregation and enterprise application integration.
• Contribute towards the development and implementation of data warehouse and business intelligence standards and best practices.
• Support the analytical needs of business units by researching and analyzing data from various sources and incorporate data into existing processes and systems as needed by using expert level understanding of how data, technology and data work together to serve our customers.
• Conduct analysis on datasets, including efficient extraction, manipulation, and analysis of complex datasets. Analyze data and information in innovative ways to assist with strategic decisions and optimize process efficiencies. Ensure all necessary data elements are available for model building and strategy analysis.
• Research emerging technologies, trends and benchmark data to make recommendations to improve customer experience, architecture, processes and tools.

Knowledge, Skills & Abilities:

• Experience working with backend languages such as Python.
• Strong computer literacy and proficiency in data manipulation and reporting tools with demonstrated highly skilled knowledge of SQL and Excel.
• Strong analytical, data mining, data modeling, and data management skills and judgment to analyze, evaluate, and develop solutions to complex problems.
• Good understanding about database and data warehouse development, including replication, staging, ETL, stored procedures, partitioning, change data capture, triggers, scheduling tools.
• Clear understanding of how the resources work and integrate with cloud and on-prem.
• Creative and critical thinking ability; excellent troubleshooting and problem-solving skills.
• Self-motivated and driven to produce quality products.
• Ability to work effectively in a collaborative team environment and effectively demonstrate team building attitude and skills.
• Demonstrated ability to be flexible and perform a variety of roles such as developer, analyst and tester.
• Ability to work independently and manage multiple tasks effectively.
• Write clean, efficient and maintainable code for unit tests.
• Maintain and improve existing unit test suites and framework
• Experience with AI/ML technologies is a plus.
• Excellent written, verbal and presentation skills.

Education & Experience:

• Bachelor’s degree in computer science or engineering
• Experience with a variety of industry standards regarding Microsoft database development concepts, best practices, and procedures.
• Experience with financial services industry is a plus.

Compensation: The Base Salary range for this position is between $75,000-$95,000.

This information reflects a base salary range that AssetMark reasonably expects to pay for the position based on a number of factors which may include job-related knowledge, skills, education, experience, and actual work location. This position will also be eligible for additional variable incentive compensation and competitive benefits.

Candidates must be legally authorized to work in the US to be considered. We are unable to provide visa sponsorship for this position.

#LI-hybrid

#LI-TN1

Who We Are & What We Offer:

AssetMark’s mission is centered around helping financial advisors make a difference in the lives of their clients. To help them do that, we aim to provide advisors with holistic support. We offer compelling technology that facilitates a better client experience, consulting services that ensure advisors’ businesses are running at their best and a comprehensive suite of investment solutions. AssetMark’s platform empowers advisors to provide the highest level of service possible to their clients.

AssetMark’s culture is driven by our mission and connected by our values; Heart, Integrity, Excellence and Respect. You will join a team that lives these values every day by doing the best and what is right in all we do and encouraging different ideas for continual success and innovation. Additionally, we offer a wide range of benefits to meet the needs of our team members and their families.

• Flex Time Off or Paid Time/Sick Time Off
• 401K – 6% Employer Match
• Medical, Dental, Vision – HDHP or PPO
• HSA – Employer contribution (HDHP only)
• Volunteer Time Off
• Career Development / Recognition
• Fitness Reimbursement
• Hybrid Work Schedule

As an Equal Opportunity Employer, AssetMark is committed to building a diverse and inclusive workplace where everyone feels valued.