Master Data Engineer
D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning more than 80 years. We are dedicated to conducting our business in accordance with the highest standards of integrity and ethics, and delivering outstanding service to our clients and each other. We support a friendly, open and supportive culture, and encourage candid communication and productive engagement that make our companies and each of us better. Just as we work to improve our clients’ financial well-being, we also work to strengthen local communities—and giving back is one of our core values. You can learn more about our company culture and impact in our latest annual report.
Summary:
The Master Data Engineer at D.A. Davidson will work across multiple business areas to identify and model master data elements as well as contribute to the development of strategies, solutions and processes for managing enterprise-wide data elements throughout the data lifecycle. Our Master Data initiative is focused on maximizing business outcomes by improving data quality, consistency, visibility, and accuracy. This role will collaborate closely with business Subject Matter Experts, Information Product Owners and IT team members to design and implement solutions enabling the creation, capture, storage and publication of centralized master data. As a member of the Data Operations team, the Master Data Architect will work alongside Data Engineers, Analytic Engineers, Database Administrators and Business Analysts, and will assist in the execution of a change management process and a governance model to ensure the master data repository structures & meta data definitions are accurate, consistently applied, and remain current over time. Master Data Engineer will also assist in evaluation of technologies in support of a larger enterprise data architecture program.
Company Overview:
D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning 90 years. We are dedicated to conducting our business in accordance with the highest standards of integrity and ethics, while delivering outstanding service to our clients and coworkers. We support a friendly, open and adaptive culture, and encourage candid communication and productive collaboration across throughout the firm. Just as we work to improve our clients and employees’ well-being, we also work to strengthen local communities—and giving back is one of our core values.
Employee Growth, Job Qualifications, and Responsibilities
• D.A. Davidson places significant importance on career growth and employee development
• Position includes opportunities to work with cloud strategies, branding, standards, and emerging technologies
• Numerous employee training programs that include tuition credit, conferences, technical certifications, field training, and broker-dealer series licensing
• This position includes working with a global workforce and subject matter experts across many IT and business domains
• Position offers employee ownership that includes profit sharing and access to ESOP programs
• Professional culture with healthy work / life balance, along with options and technology to support working remotely
• Agile training, mentoring, and adoption across IT
• D.A. Davidson maintains an IT culture that with communities of practice and centers of excellence to broadly share knowledge and insights.
Qualifications
• Prior experience within the Wealth Management industry is helpful, such as working with assets under management/administration, client households, custodian records, advisory programs, and master account records
• 3-5 years of experience in a related role (Data Warehousing, Data Governance, Content Management, Data Modeling, Data Architecture)
• Experience modeling and implementing master data management processes with quantifiable improvements
• Current working knowledge of master data management industry best practices (e.g. DAMA/EDM)
• Knowledge and experience in implementing and working with master data technologies
• Understanding of logical data modeling and data normalization
• Understanding of meta-model and metadata management requirements
• Ability to contribute across roles and technologies when necessary
• Experience with PowerBI, SQL Report Services, Tableau, or other data reporting tools is helpful
• Ability to work in a team environment that promotes collaboration, best practices, and follows Agile development methodologies
• Experience interpreting, modifying, and creating detailed business requirements and definitions as they relate to master data management and data stewardship
Job Responsibilities
• Work with business areas and IT professionals to define and standardize key data concepts (Clients, Householding, Products, Organization, etc.) to insure consistency and accuracy across the enterprise. Examples include:
o An Employee data model to organize employee data (employee master, employee locations, branch codes, office codes) into an organizational structure that enables data-driven security and permission management
o A Customer data model that incorporates concepts like client, account, household, proxy, etc. including customer hierarchies that can support aggregate reporting, consolidated mailings, account security and prestige programs
o A Product data model that consolidates product offerings into a standard product taxonomy that allows each LOB to report and manage products while providing the ability to aggregate and summarize across the entire portfolio
• Research and catalog business information requirements to standardize the use of third-party reports and data feeds
• Identify data variances and inconsistencies across the firm and develop common data models to reduce discrepancies and coordinate standardized uses of master data
• Evaluate opportunities to centralize the storage and maintenance of enterprise master data and coordinate the implementation a governed system of record
• Assist in the identification and standardization of data use across business units - FICM, ECM, TRUST, DIA, WM
• Reduce / Eliminate data storage and retention by identifying redundant and duplicate data elements throughout the environment, and modeling conformed master data structures
• Maintain set of metadata controls to ensure that data is consumable, systems of record are fit for purpose, and prioritization is given to mission-critical data
• Provide guidance to enhance Master Data Management processes as needed
• Proactively share Master Data best practices and expectations across various business groups, IT and senior leadership
• Facilitate the development and implementation of data quality standards, data protection standards and adoption requirements across the enterprise
• Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
What we offer:
Competitive salary plus excellent benefits and perks including, but not limited to:
•Medical, Dental and Vision
•Company 401(k)and ESOP contribution
•Generous sick, vacation, and maternity/parental leave
•Paid holidays
•Professional Development Opportunities
•Tuition Reimbursement ($15,000 lifetime cap)
•Discounted personal insurance including home, auto and recreational vehicles
•Charitable gift-matching program
•Davidson Day of Giving – Our tradition of positively impacting communities in which we live and work.
The potential base pay hiring range for this role is $123,000 to $185,000 annually. The compensation offered will be determined on a case-by-case basis considering a variety of factors including, but not limited to, the skills, relevant work experience, and geographic location of each specific candidate.
D.A. Davidson has been in business for 90 years! As an employee-owned company, our success is driven by our high standards of business ethics, integrity and the belief that our Associates are our most important assets. We hope you will consider joining us!
$123,000 - $185,000 a year
At D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
Please answer all questions carefully: incomplete or inaccurate answers may impact your potential employment. By clicking Submit Application, you declare that all statements in this application are truthful to the best of your knowledge. California applicants please see D.A. Davidson's California Resident Privacy Policy.
About the job
Apply for this position
Master Data Engineer
D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning more than 80 years. We are dedicated to conducting our business in accordance with the highest standards of integrity and ethics, and delivering outstanding service to our clients and each other. We support a friendly, open and supportive culture, and encourage candid communication and productive engagement that make our companies and each of us better. Just as we work to improve our clients’ financial well-being, we also work to strengthen local communities—and giving back is one of our core values. You can learn more about our company culture and impact in our latest annual report.
Summary:
The Master Data Engineer at D.A. Davidson will work across multiple business areas to identify and model master data elements as well as contribute to the development of strategies, solutions and processes for managing enterprise-wide data elements throughout the data lifecycle. Our Master Data initiative is focused on maximizing business outcomes by improving data quality, consistency, visibility, and accuracy. This role will collaborate closely with business Subject Matter Experts, Information Product Owners and IT team members to design and implement solutions enabling the creation, capture, storage and publication of centralized master data. As a member of the Data Operations team, the Master Data Architect will work alongside Data Engineers, Analytic Engineers, Database Administrators and Business Analysts, and will assist in the execution of a change management process and a governance model to ensure the master data repository structures & meta data definitions are accurate, consistently applied, and remain current over time. Master Data Engineer will also assist in evaluation of technologies in support of a larger enterprise data architecture program.
Company Overview:
D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning 90 years. We are dedicated to conducting our business in accordance with the highest standards of integrity and ethics, while delivering outstanding service to our clients and coworkers. We support a friendly, open and adaptive culture, and encourage candid communication and productive collaboration across throughout the firm. Just as we work to improve our clients and employees’ well-being, we also work to strengthen local communities—and giving back is one of our core values.
Employee Growth, Job Qualifications, and Responsibilities
• D.A. Davidson places significant importance on career growth and employee development
• Position includes opportunities to work with cloud strategies, branding, standards, and emerging technologies
• Numerous employee training programs that include tuition credit, conferences, technical certifications, field training, and broker-dealer series licensing
• This position includes working with a global workforce and subject matter experts across many IT and business domains
• Position offers employee ownership that includes profit sharing and access to ESOP programs
• Professional culture with healthy work / life balance, along with options and technology to support working remotely
• Agile training, mentoring, and adoption across IT
• D.A. Davidson maintains an IT culture that with communities of practice and centers of excellence to broadly share knowledge and insights.
Qualifications
• Prior experience within the Wealth Management industry is helpful, such as working with assets under management/administration, client households, custodian records, advisory programs, and master account records
• 3-5 years of experience in a related role (Data Warehousing, Data Governance, Content Management, Data Modeling, Data Architecture)
• Experience modeling and implementing master data management processes with quantifiable improvements
• Current working knowledge of master data management industry best practices (e.g. DAMA/EDM)
• Knowledge and experience in implementing and working with master data technologies
• Understanding of logical data modeling and data normalization
• Understanding of meta-model and metadata management requirements
• Ability to contribute across roles and technologies when necessary
• Experience with PowerBI, SQL Report Services, Tableau, or other data reporting tools is helpful
• Ability to work in a team environment that promotes collaboration, best practices, and follows Agile development methodologies
• Experience interpreting, modifying, and creating detailed business requirements and definitions as they relate to master data management and data stewardship
Job Responsibilities
• Work with business areas and IT professionals to define and standardize key data concepts (Clients, Householding, Products, Organization, etc.) to insure consistency and accuracy across the enterprise. Examples include:
o An Employee data model to organize employee data (employee master, employee locations, branch codes, office codes) into an organizational structure that enables data-driven security and permission management
o A Customer data model that incorporates concepts like client, account, household, proxy, etc. including customer hierarchies that can support aggregate reporting, consolidated mailings, account security and prestige programs
o A Product data model that consolidates product offerings into a standard product taxonomy that allows each LOB to report and manage products while providing the ability to aggregate and summarize across the entire portfolio
• Research and catalog business information requirements to standardize the use of third-party reports and data feeds
• Identify data variances and inconsistencies across the firm and develop common data models to reduce discrepancies and coordinate standardized uses of master data
• Evaluate opportunities to centralize the storage and maintenance of enterprise master data and coordinate the implementation a governed system of record
• Assist in the identification and standardization of data use across business units - FICM, ECM, TRUST, DIA, WM
• Reduce / Eliminate data storage and retention by identifying redundant and duplicate data elements throughout the environment, and modeling conformed master data structures
• Maintain set of metadata controls to ensure that data is consumable, systems of record are fit for purpose, and prioritization is given to mission-critical data
• Provide guidance to enhance Master Data Management processes as needed
• Proactively share Master Data best practices and expectations across various business groups, IT and senior leadership
• Facilitate the development and implementation of data quality standards, data protection standards and adoption requirements across the enterprise
• Define indicators of performance and quality metrics and ensure compliance with data related policies, standards, roles and responsibilities, and adoption requirements
What we offer:
Competitive salary plus excellent benefits and perks including, but not limited to:
•Medical, Dental and Vision
•Company 401(k)and ESOP contribution
•Generous sick, vacation, and maternity/parental leave
•Paid holidays
•Professional Development Opportunities
•Tuition Reimbursement ($15,000 lifetime cap)
•Discounted personal insurance including home, auto and recreational vehicles
•Charitable gift-matching program
•Davidson Day of Giving – Our tradition of positively impacting communities in which we live and work.
The potential base pay hiring range for this role is $123,000 to $185,000 annually. The compensation offered will be determined on a case-by-case basis considering a variety of factors including, but not limited to, the skills, relevant work experience, and geographic location of each specific candidate.
D.A. Davidson has been in business for 90 years! As an employee-owned company, our success is driven by our high standards of business ethics, integrity and the belief that our Associates are our most important assets. We hope you will consider joining us!
$123,000 - $185,000 a year
At D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.
We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
Please answer all questions carefully: incomplete or inaccurate answers may impact your potential employment. By clicking Submit Application, you declare that all statements in this application are truthful to the best of your knowledge. California applicants please see D.A. Davidson's California Resident Privacy Policy.