Data Integration Engineer

D.A. Davidson

Midwest (WY)

On-site

USD 74,000 - 106,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, Dental and Vision
Company 401(k) and ESOP contribution
Sick, vacation, and maternity/parental
Paid holidays
Professional Development Opportunities
Tuition Reimbursement ($15,000)
Discounted personal insurance (home, 

Charitable gift-matching program
Davidson Day of Giving

Job summary

D.A. Davidson Companies is an independent, employee-owned firm with a long history of integrity and client service.

The Data Integration Engineer will design, build, and optimize data pipelines and integration services across internal systems, APIs, and external data sources in a regulated financial services setting. The role focuses on scalable ETL/ELT processes, data governance, and production operations while collaborating with architects and engineers on enterprise data initiatives.

Qualifications

  • 3-5 years of experience in Data Engineering, Data Integration, or ETL development.
  • Experience in financial services, banking, wealth management, brokerage, insurance, or other regulated industries preferred.
  • Experience supporting production data integration environments.
  • Experience with Microsoft cloud technologies in a hybrid architecture.
  • Experience with cloud services (Microsoft Azure, AWS); MCSE/MCSA certifications preferred.
  • Advanced working T-SQL knowledge and experience with relational databases, query authoring, stored procedure development, and end-to-end data pipelines.
  • Experience with ETL/ELT platforms such as SSIS, Azure Data Factory, Microsoft Fabric Data Pipelines.
  • Experience with API and file-based integrations.
  • Experience with relational database platforms, preferably Microsoft SQL Server.
  • Experience with scripting languages such as Python, PowerShell, DiamondPlate.
  • Experience with orchestration platforms such as ActiveBatch or equivalent scheduling tools.
  • Familiarity with Git, CI/CD, DevOps, and DataOps practices.
  • Understanding of dimensional modeling, data warehousing, and data governance principles.
  • Knowledge of database security, backup and recovery, and performance monitoring standards
  • Familiar with Agile work principles.
  • Satisfactory written and oral communication skills.
  • Understanding of software and database development life cycle concepts.
  • Awareness of information sensitivity regulations and best-practices regarding data security and confidentiality.
  • Specific skills include: Extensive experience with SQL syntax
  • Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
  • Experience using orchestration tools such as: ActiveBatch
  • Experience with web services and API integrations
  • Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.
  • Experience working with vendors and 3rd party data integrations.

Responsibilities

  • Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions.
  • Build and maintain data pipelines that ingest information from internal applications, vendors, APIs, and third-party financial systems.
  • Develop reusable integration frameworks and patterns to improve scalability and maintainability.
  • Support batch, near real-time, and event-driven data integration architectures.
  • Troubleshoot and resolve data flow, performance, and reliability issues.

Skills

SQL syntax
Python
PowerShell
ETL/ELT development
Data integration
Agile / DevOps
Data governance
Dimensional modeling
CI/CD
DataOps

Tools

Azure Data Factory
Microsoft Fabric Data Pipelines
SSIS
ActiveBatch
Git
CI/CD tooling
Microsoft SQL Server
REST APIs
Azure
AWS

Job 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.

Summary/Function

The Data Integration Engineer is responsible for designing, developing, supporting, and optimizing enterprise data integration solutions that enable the movement, transformation, and delivery of data across business systems. This role contributes to the development of scalable data pipelines, ETL/ELT processes, API integrations, and data services that support operational, regulatory, and analytical workloads within a financial services environment.

Qualifications
  • 3-5 years of experience in Data Engineering, Data Integration, or ETL development.
  • Experience working in financial services, banking, wealth management, brokerage, insurance, or other regulated industries preferred.
  • Experience supporting production data integration environments.
  • Experience with Microsoft cloud-based technologies in a hybrid architecture
  • Experience with cloud services (Microsoft Azure, AWS); MCSE/MCSA certifications preferred.
  • Advanced working TSQL knowledge and experience working with relational databases, query authoring, stored procedure development, end-to-end data pipeline development
  • Experience with ETL/ELT platforms such as:
    • SSIS
    • Azure Data Factory
    • Microsoft Fabric Data Pipelines
  • Experience with API and file-based integrations.
  • Experience with relational database platforms, preferably Microsoft SQL Server.
  • Experience with scripting languages such as Python, PowerShell, DiamondPlate.
  • Experience with orchestration platforms such as ActiveBatch or equivalent scheduling tools.
  • Familiarity with Git, CI/CD, DevOps, and DataOps practices.
  • Understanding of dimensional modeling, data warehousing, and data governance principles.
  • Knowledge of database security, backup and recovery, and performance monitoring standards
  • Familiar with Agile work principles.
  • Satisfactory written and oral communication skills.
  • Understanding of software and database development life cycle concepts.
  • Awareness of information sensitivity regulations and best-practices regarding data security and confidentiality.
  • Specific skills include:
    • Extensive experience with SQL syntax
    • Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture
    • Experience using orchestration tools such as: ActiveBatch
    • Experience with web services and API integrations
    • Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.
    • Experience working with vendors and 3rd party data integrations.
Job Responsibilities
Data Integration & Engineering
  • Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions.
  • Build and maintain data pipelines that ingest information from internal applications, vendors, APIs, and third-party financial systems.
  • Develop reusable integration frameworks and patterns to improve scalability and maintainability.
  • Support batch, near real-time, and event-driven data integration architectures.
  • Troubleshoot and resolve data flow, performance, and reliability issues.
Data Quality & Governance
  • Implement controls to ensure data accuracy, completeness, and consistency.
  • Support data lineage, metadata management, and data governance initiatives.
  • Participate in regulatory and audit-related data validation efforts.
  • Assist in developing standards for secure and compliant data movement.
Platform & Operations
  • Monitor production workflows and respond to operational issues.
  • Tune SQL queries, integration jobs, and data pipelines for performance.
  • Participate in release, deployment, and change management processes.
  • Maintain documentation for integration processes, data mappings, and technical designs.
Collaboration
  • Work with business users to gather and interpret data requirements.
  • Partner with data architects and senior engineers on enterprise data initiatives.
  • Support analysts and reporting teams by delivering reliable and well-structured datasets.
  • Participate in Agile planning, code reviews, testing, and continuous improvement activities.
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 to $105,600 yearly. 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.

$73,500 - $105,600 a year

D.A. Davidson has been in business for 90 years! As an employee-owned company, our success is driven by our high standards of business ethics, integrity and the belief that our Associates are our most important assets. We hope you will consider joining us!

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.

ACKNOWLEDGMENT

Please 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Integration Engineer
Data Integration Engineer

D.A. Davidson • United States

Remote
USD 74,000 - 106,000
Medical/Dental/Vision
401(k) & ESOP
Paid holidays
+5
Data Engineer - Remote
Data Engineer - Remote

Make Choteau Home • Montana

Remote
USD 74,000 - 118,000
Medical, Dental and Vision
401(k) and ESOP contribution
Generous leave
Data Engineer
Data Engineer

D.A. Davidson • Midwest (WY)

On-site
USD 74,000 - 118,000
Medical, Dental and Vision
401(k) and ESOP contribution
Sick, vacation, and parental leave
+6
Data Engineer
Data Engineer

D.A. Davidson Companies • Tualatin (OR)

On-site
USD 74,000 - 118,000
Medical, Dental and Vision
Company 401(k) and ESOP contribution
Generous sick, vacation, and maternity
+6
Data Engineer
Data Engineer

D.A. Davidson • United States

Remote
USD 74,000 - 118,000
Medical/Dental/Vision
401(k) and ESOP
Paid holidays
+4
Data Engineer
Data Engineer

D.A. Davidson • Portland (OR)

On-site
USD 74,000 - 118,000
Medical, Dental and Vision
Company 401(k) and ESOP contribution
Generous sick, vacation, and maternity
+6
Client Associate
Client Associate

D.A. Davidson Companies • Gillette (WY)

On-site
USD 40,000 - 60,000
Medical, Dental and Vision
401(k) and ESOP contribution
Generous sick, vacation, and parental leave
+2
Investment Solutions Consultant
Investment Solutions Consultant

D.A. Davidson • United States

Remote
USD 89,000 - 122,000
Health benefits
401(k) + ESOP
Paid leave
+6
Desktop Solutions Group Specialist
Desktop Solutions Group Specialist

D.A. Davidson • United States

Hybrid
USD 44,000 - 52,000
Medical, Dental and Vision
Company 401(k) and ESOP contribution
Generous sick, vacation, and maternity
+6
Investment Solutions Consultant
Investment Solutions Consultant

D.A. Davidson Companies • Nashville (TN)

On-site
USD 89,000 - 122,000
Medical, Dental and Vision
Company 401(k)and ESOP contribution
Generous sick, vacation, and maternity
+6