Data Engineer - Remote

  • D.A. Davidson
  • Remote
  • Sep 19, 2022
Full time Data Engineering Information Technology

Job Description

Job Description

DA Davidson is looking for an energetic, creative Data Engineer to join our expanding team of analytics professionals. This role will be 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. Candidates should have experience building data pipelines and enjoy optimizing entire data systems as well as building them from the ground up. The Data Engineer will work alongside our software development teams, database architects, data analysts and end users on data initiatives, and will ensure our data delivery architecture is consistent with best practices. Candidates must be comfortable working in an Agile team in support of multiple teams, across various systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our growing portfolio of data initiatives.

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 adaptive culture, and encourage candid communication and productive collaboration across our 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.

Experience and Skills

Employee Growth, Job Qualifications, and Responsibilities

Growth
* 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
* D.A. Davidson maintains an Agile IT culture that with communities of practice and centers of excellence to broadly share knowledge and insights


Qualifications
* We are looking for a candidate with 3+ years of experience in a Data Engineering role, who has attained a degree in Computer Science, Information Systems, Business Intelligence or comparable work history
* Prior experience in the Financial Services industry is beneficial but not required
* A flexible, growth-based mindset focused on teamwork, collective project management and knowledge-forward collaboration
* 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 logical data modeling and data normalization
* Understanding of meta-model and metadata management requirements
* Specific skills include:
o Experience with relational and dimensional database modeling
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 cloud data services such as: Azure, AWS, Snowflake
o Familiarity with data visualization technologies such as: Tableau, PowerBI

Job Responsibilities
* Design, implement and maintain a robust, efficient and compliant data pipeline architecture
* Assemble data sets that meet functional business requirements
* Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
* Build the infrastructure required for optimal acquisition, transformation, and provisioning of data from a variety of data sources
* Build and maintain a service-based architecture for the publication of consumable data and information objects
* Work with data architects and data analysts to build analytics products that utilize the data pipelines to provide business-relevant information
* Work with Business and IT stakeholders to assist with data-related technical issues and support their data and information requirements
* Contribute to the development of frameworks 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