[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning 90 years. 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, focusing on optimizing data integrations and architecture.ResponsibilitiesDesign, implement and maintain a robust, efficient and compliant application data repository and integration architectureWork with Business and IT stakeholders to assist with data-related technical issues and provide application supportCoordinate, direct and oversee the work of third-party engineers through solution design reviews, code reviews and process reviewsIdentify, design, and implement internal process improvements like, automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalabilityResearch and analyze new technologies, methodologies and architectures for viabilityBuild and maintain a service-based architecture for web and mobile applicationsWork independently within a scrum delivery team, with oversight from domain and enterprise architects, in support of business-critical applicationsContribute to the development of frameworks, guidelines, best practices and examples to ensure data structures and integration processes are accurate, compliant and secureImplement telemetry indicators to monitor performance, quality metrics to track accuracy and access controls to ensure complianceSkillsCommitment to maintain client confidentiality and data securityCommunicate in a clear and service-oriented manner; use appropriate, professional language and grammar to effectively exchange ideas and informationAbility to proactively work with both external and internal clients; relate with others in a professional manner to accomplish work responsibilities and objectivesAbility to maintain regular, predictable attendance7 or more years of Data Engineering experience in an oversight capacityExtensive domain-specific experience in the Financial Services industryExperience with Microsoft cloud-based technologies in a hybrid architectureRDBMS 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 levelData modeling mastery: 3NF normalization, strategic denormalization for read models, star/snowflake schemas, surrogate vs. natural keys, referential integrity, and temporal tables for auditing/historyExperience performing operational analysis on internal and external data and processes to uncover failure points and identify opportunities for improvementExperience designing and implementing API-oriented schemas for web and mobile application performance and optimizationHolistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance and workload managementUnderstanding of meta-model and metadata management requirementsSecurity 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)Extensive experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architectureExperience with Azure DevOps: CI/CD pipelines for AIS and Fabric assetsETL/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 patternsExperience with API Management (APIM): API design, security (OAuth/JWT), policies, and versioningExperience in reverse-engineering, refactoring and migrating legacy applicationsExperience with Service Bus / Event Grid design patterns: asynchronous and event-driven integrationsExperience with scripting languages such as: PythonExperience with MDM concepts (golden record, survivorship, matching, data quality)BenefitsMedical, Dental and VisionCompany 401(k)and ESOP contributionGenerous sick, vacation, and maternity/parental leavePaid holidaysProfessional Development OpportunitiesTuition Reimbursement ($15,000 lifetime cap)Discounted personal insurance including home, auto and recreational vehiclesCharitable gift-matching programDavidson Day of Giving - Our tradition of positively impacting communities in which we live and workCompany OverviewAt D.A. It was founded in 1935, and is headquartered in Great Falls, Montana, US, with a workforce of 1001-5000 employees. Its website is http://dadavidson.com.