Data Engineer
Summary
Data Engineer at D.A. Davidson, an employee-owned financial services firm, who designs, builds, and optimizes enterprise data pipeline architecture and monitors and tunes data flows. Core stack includes T-SQL/SQL Server, Microsoft Fabric, SSIS/Azure Integration Services, ActiveBatch orchestration, and Python/PowerShell scripting.
Summary:
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.
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.
Qualifications:
• 5 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
• Experience facilitating calls to capture end-user requirements with technical and non-technical users
• 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 syntax
o Experience designing and implementing data structures and interfaces for applications and business processes
o Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
o Experience with relational database platforms: preferably MS SQL Server
o Experience with data pipeline tools such as: SSIS and Azure Integration Services
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.
• Commitment to maintain client confidentiality and data security
• Communicate in a clear and service-oriented manner; use appropriate, professional language and grammar to effectively exchange ideas and information
• Ability to proactively work with both external and internal clients; relate with others in a professional manner to accomplish work responsibilities and objectives
• Ability to maintain regular, predictable attendance
Job Responsibilities:
• Design, implement and maintain a robust, efficient and compliant data pipeline architecture
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• 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
• Work in an on-call rotation to monitor, troubleshoot and resolve data integration alerts and failures
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 $73,500 – $117,900 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.
Skills
As published by lever · 92 questions · 12 written answers
Basics
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, Other website
Short answers (51)
- First name
- Last name
- Street
- City
- State
- Zip Code
- Country
- Email Address
- Phone Number
- If yes, what was your last year of employment with the company? Type N/A if not applicable
- Institution Name
- Location of Institution (City, State, Country)
- Degree or Certification Earned
- Attendance Start Date (MM/YYYY)
- Attendence End Date (MM/YYYY or "Present" if still enrolled)
- 1. Employer Name
- Employer Phone Number
- Employer Location (City, State, Zip)
- Employment Start Date (MM/YYYY)
- Employment End Date (MM/YYYY)
- Job Title
- 2. Employer Name
- Employer Phone Number
- Employer Location (City, State, Zip)
- Employment Start Date (MM/YYYY)
- Employment End Date (MM/YYYY)
- Job Title
- 3. Employer Name
- Employer Phone Number
- Employer Location (City, State, Zip)
- Employment Start Date (MM/YYYY)
- Employment End Date (MM/YYYY)
- Job Title
- 4. Employer Name
- Employer Phone Number
- Employer Location (City, State, Zip)
- Employment Start Date (MM/YYYY)
- Employment End Date (MM/YYYY)
- Job Title
- 5. Employer Name
- Employer Phone Number
- Employer Location (City, State, Zip)
- Employment Start Date (MM/YYYY)
- Employment End Date (MM/YYYY)
- Job Title
- Reason for Leaving
- 1. Name
- Email Address
- Phone Number
- Email Address
- Phone Number
Pick from a list (28)
- Have you ever been employed by D.A. Davidson Companies?
- Have you previously applied for employment with D.A. Davidson Companies?
- Are you legally authorized to work in the United States without sponsorship?
- Will you now or in the future require D.A. Davidson Companies to commence ("sponsor") an immigration case to lawfully employ you in the United States (for example, H-1B or other employment-based immigration case)? This is sometimes called "sponsorship" for an employment-based visa status.
- Are you able to perform the essential functions of the position(s) for which you are applying with or without reasonable accommodations?
- Have you been convicted of, or pled guilty or nolo contendere (“no contest”) in a domestic, foreign, or military court to any felony in the past 10 years?
- Have you been convicted of, pled guilty or nolo contendere (“no contest”) in a domestic, foreign, or military court to a misdemeanor involving investments or investment-related business or any fraud, false statements or omissions, wrongful taking of property, bribery, perjury, forgery, counterfeiting, extortion, or conspiracy to commit any of these offenses in the past 10 years?
- IMPORTANT – PLEASE READ: If you are employed by D.A. Davidson Companies, securities industry regulations require that your fingerprints be submitted to the FBI. All criminal history, including arrests and charges that did not result in a conviction, and including arrests, charges or convictions that have been expunged, will be disclosed to D.A. Davidson Companies and reviewed by a limited number of people. In addition, FINRA may require you to submit documentation regarding the incident. Conviction of or “no contest” pleas to certain crimes in the last 10 years may disqualify you from working for D.A. Davidson Companies, even if you were a minor or if the record was sealed or expunged. If you have concerns or questions, please contact D.A. Davidson Companies’ Director of Human Capital at 1-800-332-5915 optional
- Are you presently licensed in the insurance or securities industry? If so, are the disclosures on your Form U-4 up to date?
- Have you ever been licensed in the insurance or securities industry?
- If you answered “Yes” to either licensing question above, have you ever been disciplined by a regulatory authority, or had a license suspended or revoked?
- If you are hired by D.A. Davidson Companies, do you acknowledge that you will be required, in accordance with firm policy and as a condition of employment, to move your securities accounts (limited exceptions for certain account types) to D.A. Davidson Companies within 60 days of your hire?
- Has a bonding company ever denied, paid out on, or revoked a bond for you?
- Do you have an unsatisfied judgements or liens against you?
- What is the highest level of education you have completed?
- Please provide your employment history below. If you have not had 5 employers, please fill what you can and write "N/A" for the remainder of your answers. If you have had more than 5 employers, please enter the 5 that are most recent.
- Is this your current employer?
- Is this your current employer?
- Is this your current employer?
- Is this your current employer?
- Is this your current employer?
- Please provide professional references below
- Relationship
- How long have you know this reference?
- Relationship
- How long have you know this reference?
- Under Maryland law, an employer may not require or demand, as a condition of employment, prospective employment, or continued employment, that an individual submit to or take a polygraph examination or similar test. An employer who violates this law is guilty of a misdemeanor and subject to a fine not exceeding $100. optional
- It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. optional
Written answers (12)
- Additional Training or Certifications optional
- Summarize the nature of the work performed & job responsibilities
- Reason for Leaving
- Summarize the nature of the work performed & job responsibilities
- Reason for Leaving
- Summarize the nature of the work performed & job responsibilities
- Reason for Leaving
- Summarize the nature of the work performed & job responsibilities
- Reason for Leaving
- Summarize the nature of the work performed & job responsibilities
- 2. Name
- Please list all employees of D.A. Davidson Companies with whom you are acquainted, and indicate whether you are related
Attachments (1)
- If you have a cover letter you would like to share with the hiring team, please do so here. optional