{"schemaVersion":"jobsearcher.job.v1","id":"4aa93b4d46f3c11b1259891e","url":"https://jobsearcher.com/jobs/4aa93b4d46f3c11b1259891e","canonicalUrl":"https://jobsearcher.com/jobs/4aa93b4d46f3c11b1259891e","title":"Senior Data Engineer","description":"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, 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.\r\nSummary: This Senior Data Engineer will be a member of the Agile team responsible for D.A. Davidson's flagship Client Access web and mobile applications. As a member of the team, responsibilities will include troubleshooting, expanding and optimizing the existing data integrations and architecture. Additionally, the role will be involved in refactoring and migrating legacy structures and code into cloud and service-based architectures. This individual will work as part of a dedicated product team in conjunction with other software development teams, database architects, business analysts and end users. A Senior Data Engineer collaborates on specific solution designs as well as broader data architecture and technology roadmaps to support strategic growth and team development.\r\nCompany 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.\r\nQualifications\r\nCommitment to maintain client confidentiality and data security\r\nCommunicate in a clear and service-oriented manner; use appropriate, professional language and grammar to effectively exchange ideas and information\r\nAbility to proactively work with both external and internal clients; relate with others in a professional manner to accomplish work responsibilities and objectives\r\nAbility to maintain regular, predictable attendance\r\n7 or more years of Data Engineering experience in an oversight capacity\r\nExtensive domain-specific experience in the Financial Services industry\r\nExperience with Microsoft cloud-based technologies in a hybrid architecture\r\nRDBMS expertise with Microsoft SQL Server (on prem and Azure SQL): advanced T SQL, query design, execution plans, index strategies (clustered/non clustered, filtered, included columns), partitioning, statistics, and concurrency/isolation level\r\nData modeling mastery: 3NF normalization, strategic denormalization for read models, star/snowflake schemas, surrogate vs. natural keys, referential integrity, and temporal tables for auditing/history\r\nExperience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvement\r\nExperience designing and implementing API-oriented schemas for web and mobile application performance and optimization\r\nHolistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management\r\nUnderstanding of meta-model and metadata management requirements\r\nSecurity and governance experience: RBAC, least privilege, secrets management, PII handling, encryption at rest/in transit, row level security, auditing, and compliance (e.g., SOC2, HIPAA, GDPR)\r\nSpecific skills include\r\nExtensive experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture\r\nExperience with Azure DevOps: CI/CD pipelines for AIS and Fabric assets\r\nETL/ELT and data movement: SSIS/ADF/Azure Data Factory or modern pipelines (dbt, Airflow), CDC/change tracking, bulk load (BCP, BULK INSERT), and data quality checks Experience designing metadata-driven and reusable integration patterns\r\nExperience with API Management (APIM): API design, security (OAuth/JWT), policies, and versioning\r\nExperience in reverse-engineering, refactoring and migrating legacy applications\r\nExperience with Service Bus / Event Grid design patterns: asynchronous and event-driven integrations\r\nExperience with scripting languages such as: Python\r\nExperience with MDM concepts (golden record, survivorship, matching, data quality)\r\nJob Responsibilities\r\nDesign, implement and maintain a robust, efficient and compliant application data repository and integration architecture.\r\nWork with Business and IT stakeholders to assist with data-related technical issues and provide application support.\r\nCoordinate, direct and oversee the work of third-party engineers through solution design reviews, code reviews and process reviews.\r\nIdentify, design, and implement internal process improvements like, automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.\r\nResearch and analyze new technologies, methodologies and architectures for viability.\r\nBuild and maintain a service-based architecture for web and mobile applications.\r\nWork independently within a scrum delivery team, with oversight from domain and enterprise architects, in support of business-critical applications.\r\nContribute to the development of frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secure.\r\nImplement telemetry indicators to monitor performance, quality metrics to track accuracy and access controls to ensure compliance.\r\nWhat we offer\r\nCompetitive salary plus excellent benefits and perks including, but not limited to:\r\nMedical, Dental and Vision\r\nCompany 401(k)and ESOP contribution\r\nGenerous sick, vacation, and maternity/parental leave\r\nPaid holidays\r\nProfessional Development Opportunities\r\nTuition Reimbursement ($15,000 lifetime cap)\r\nDiscounted personal insurance including home, auto and recreational vehicles\r\nCharitable gift-matching program\r\nDavidson Day of Giving – Our tradition of positively impacting communities in which we live and work.\r\nThe potential base pay hiring range for this role is $120,000 – $126,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.\r\nAt D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.\r\nWe 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.\r\nACKNOWLEDGMENT\r\nPlease answer all questions carefully. By submitting this application for employment, I certify that all of the above information is true and complete and I understand that any falsification or omission of information made by me may disqualify me from further consideration for employment or, if hired, may result in my termination of my employment at any time during the period of my employment, regardless of the amount of time that has passed. California applicants, please see D.A. Davidson's California Resident Privacy Policy.\r\nJ-18808-Ljbffr","company":"Socket","rawCompany":"socket","city":"Midwest","state":"WY","isRemote":false,"isActive":false,"createdAt":"2026-08-08T01:49:47.562Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Senior Data Engineer","description":"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, 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.\r\nSummary: This Senior Data Engineer will be a member of the Agile team responsible for D.A. Davidson's flagship Client Access web and mobile applications. As a member of the team, responsibilities will include troubleshooting, expanding and optimizing the existing data integrations and architecture. Additionally, the role will be involved in refactoring and migrating legacy structures and code into cloud and service-based architectures. This individual will work as part of a dedicated product team in conjunction with other software development teams, database architects, business analysts and end users. A Senior Data Engineer collaborates on specific solution designs as well as broader data architecture and technology roadmaps to support strategic growth and team development.\r\nCompany 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.\r\nQualifications\r\nCommitment to maintain client confidentiality and data security\r\nCommunicate in a clear and service-oriented manner; use appropriate, professional language and grammar to effectively exchange ideas and information\r\nAbility to proactively work with both external and internal clients; relate with others in a professional manner to accomplish work responsibilities and objectives\r\nAbility to maintain regular, predictable attendance\r\n7 or more years of Data Engineering experience in an oversight capacity\r\nExtensive domain-specific experience in the Financial Services industry\r\nExperience with Microsoft cloud-based technologies in a hybrid architecture\r\nRDBMS expertise with Microsoft SQL Server (on prem and Azure SQL): advanced T SQL, query design, execution plans, index strategies (clustered/non clustered, filtered, included columns), partitioning, statistics, and concurrency/isolation level\r\nData modeling mastery: 3NF normalization, strategic denormalization for read models, star/snowflake schemas, surrogate vs. natural keys, referential integrity, and temporal tables for auditing/history\r\nExperience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvement\r\nExperience designing and implementing API-oriented schemas for web and mobile application performance and optimization\r\nHolistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload management\r\nUnderstanding of meta-model and metadata management requirements\r\nSecurity and governance experience: RBAC, least privilege, secrets management, PII handling, encryption at rest/in transit, row level security, auditing, and compliance (e.g., SOC2, HIPAA, GDPR)\r\nSpecific skills include\r\nExtensive experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture\r\nExperience with Azure DevOps: CI/CD pipelines for AIS and Fabric assets\r\nETL/ELT and data movement: SSIS/ADF/Azure Data Factory or modern pipelines (dbt, Airflow), CDC/change tracking, bulk load (BCP, BULK INSERT), and data quality checks Experience designing metadata-driven and reusable integration patterns\r\nExperience with API Management (APIM): API design, security (OAuth/JWT), policies, and versioning\r\nExperience in reverse-engineering, refactoring and migrating legacy applications\r\nExperience with Service Bus / Event Grid design patterns: asynchronous and event-driven integrations\r\nExperience with scripting languages such as: Python\r\nExperience with MDM concepts (golden record, survivorship, matching, data quality)\r\nJob Responsibilities\r\nDesign, implement and maintain a robust, efficient and compliant application data repository and integration architecture.\r\nWork with Business and IT stakeholders to assist with data-related technical issues and provide application support.\r\nCoordinate, direct and oversee the work of third-party engineers through solution design reviews, code reviews and process reviews.\r\nIdentify, design, and implement internal process improvements like, automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability.\r\nResearch and analyze new technologies, methodologies and architectures for viability.\r\nBuild and maintain a service-based architecture for web and mobile applications.\r\nWork independently within a scrum delivery team, with oversight from domain and enterprise architects, in support of business-critical applications.\r\nContribute to the development of frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secure.\r\nImplement telemetry indicators to monitor performance, quality metrics to track accuracy and access controls to ensure compliance.\r\nWhat we offer\r\nCompetitive salary plus excellent benefits and perks including, but not limited to:\r\nMedical, Dental and Vision\r\nCompany 401(k)and ESOP contribution\r\nGenerous sick, vacation, and maternity/parental leave\r\nPaid holidays\r\nProfessional Development Opportunities\r\nTuition Reimbursement ($15,000 lifetime cap)\r\nDiscounted personal insurance including home, auto and recreational vehicles\r\nCharitable gift-matching program\r\nDavidson Day of Giving – Our tradition of positively impacting communities in which we live and work.\r\nThe potential base pay hiring range for this role is $120,000 – $126,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.\r\nAt D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.\r\nWe 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.\r\nACKNOWLEDGMENT\r\nPlease answer all questions carefully. By submitting this application for employment, I certify that all of the above information is true and complete and I understand that any falsification or omission of information made by me may disqualify me from further consideration for employment or, if hired, may result in my termination of my employment at any time during the period of my employment, regardless of the amount of time that has passed. California applicants, please see D.A. Davidson's California Resident Privacy Policy.\r\nJ-18808-Ljbffr","datePosted":"2026-08-08T01:49:47.562Z","dateModified":"2026-08-08T01:49:47.562Z","hiringOrganization":{"@type":"Organization","name":"Socket","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Midwest","addressRegion":"WY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"4aa93b4d46f3c11b1259891e"},"url":"https://jobsearcher.com/jobs/4aa93b4d46f3c11b1259891e"}}