Senior Data Engineer
Apply NowCompany: DA Davidson & Co
Location: Great Falls, MT 59405
Description:
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:
Senior Data Engineer is responsible for expanding and optimizing our data and data pipeline architecture, as well as monitoring, troubleshooting and performance tuning data flows used in the collection, integration, and provisioning of data. This role requires experience building data pipelines and optimizing entire data systems as well as greenfield opportunities. This role works alongside other software development teams, database architects, data analysts and end users on complex data initiatives, and ensures our data delivery architecture is consistent with best practices. A Senior Data Engineer oversees the development of junior team members through mentorship, training, guidance, and direct management. A Senior Data Engineer contributes to data architecture and technology roadmaps to support strategic growth and team development. Preferred location Western states, Midwest, or remote.
Company Overview:
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, 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.
Qualifications:
7 or more years of Data Engineering experience in an oversight capacity
Extensive domain-specific experience in the Financial Services industry
Experience with Microsoft cloud-based technologies in a hybrid architecture
Advanced working TSQL knowledge and experience working with relational databases, query authoring, stored procedure development, end-to-end data pipeline development
Experience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvement
Strong analytic skills related to working with complex, multi-layered data pipelines and dependent datasets
Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management
Understanding of data modeling concepts like:
o Conceptual data modeling
o Logical data modeling
o Relational data modeling
o Dimensional and multi-dimensional data modeling
Understanding of meta-model and metadata management requirements
Specific skills include:
o Extensive experience with SQL-based syntax
o Extensive experience designing and implementing data structures and interfaces for applications and business processes
o Experience with relational database platforms: preferably MS SQLServer
o Experience with data pipeline tools such as: SSIS
o Experience using orchestration tools such as: ActiveBatch
o Experience with web services and API integrations
o Experience with scripting languages such as: Python and Powershell
o Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.
o Familiarity with data visualization technologies such as: Tableau, PowerBI
Job Responsibilities:
Design, implement and maintain a robust, efficient and compliant data pipeline architecture
Oversee and review the work of other engineers through peer reviews, code reviews and process reviews
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Research and analyze new technologies, methodologies and architectures for viability
Build and maintain a service-based architecture for the publication of consumable data and information objects
Work with data architects and data analysts to enhance and evolve the data environment
Work with Business and IT stakeholders to assist with data-related technical issues and support their data and information requirements
Define and develop frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secure
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 pay range for this role is $110,000 - 150,000. 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. Additional incentive compensation may be earned based on performance.
$110,000 - $150,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.
Summary:
Senior Data Engineer is responsible for expanding and optimizing our data and data pipeline architecture, as well as monitoring, troubleshooting and performance tuning data flows used in the collection, integration, and provisioning of data. This role requires experience building data pipelines and optimizing entire data systems as well as greenfield opportunities. This role works alongside other software development teams, database architects, data analysts and end users on complex data initiatives, and ensures our data delivery architecture is consistent with best practices. A Senior Data Engineer oversees the development of junior team members through mentorship, training, guidance, and direct management. A Senior Data Engineer contributes to data architecture and technology roadmaps to support strategic growth and team development. Preferred location Western states, Midwest, or remote.
Company Overview:
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, 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.
Qualifications:
7 or more years of Data Engineering experience in an oversight capacity
Extensive domain-specific experience in the Financial Services industry
Experience with Microsoft cloud-based technologies in a hybrid architecture
Advanced working TSQL knowledge and experience working with relational databases, query authoring, stored procedure development, end-to-end data pipeline development
Experience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvement
Strong analytic skills related to working with complex, multi-layered data pipelines and dependent datasets
Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management
Understanding of data modeling concepts like:
o Conceptual data modeling
o Logical data modeling
o Relational data modeling
o Dimensional and multi-dimensional data modeling
Understanding of meta-model and metadata management requirements
Specific skills include:
o Extensive experience with SQL-based syntax
o Extensive experience designing and implementing data structures and interfaces for applications and business processes
o Experience with relational database platforms: preferably MS SQLServer
o Experience with data pipeline tools such as: SSIS
o Experience using orchestration tools such as: ActiveBatch
o Experience with web services and API integrations
o Experience with scripting languages such as: Python and Powershell
o Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.
o Familiarity with data visualization technologies such as: Tableau, PowerBI
Job Responsibilities:
Design, implement and maintain a robust, efficient and compliant data pipeline architecture
Oversee and review the work of other engineers through peer reviews, code reviews and process reviews
Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
Research and analyze new technologies, methodologies and architectures for viability
Build and maintain a service-based architecture for the publication of consumable data and information objects
Work with data architects and data analysts to enhance and evolve the data environment
Work with Business and IT stakeholders to assist with data-related technical issues and support their data and information requirements
Define and develop frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secure
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 pay range for this role is $110,000 - 150,000. 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. Additional incentive compensation may be earned based on performance.
$110,000 - $150,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.