Data Integration Engineer

Dadavidson

Where
Remote (Western States or Midwest)
Pay
$74K to $106K a year

Posted 7 days ago· Checked live at Dadavidson just now

Live.Open on the employer's own site.

See how you score for this job

One sentence and your resume. We score it against what Dadavidson asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Dadavidson's own hiring page just now.
What is the job?
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.
What does it pay?
$74K to $106K a year, as the posting states.
Our verdict
Live. Open on the employer's own site.

What the job is

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.

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:

o SSIS

o Azure Data Factory

o 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:

o Extensive experience with SQL syntax

o Experience with Microsoft Fabric: pipelines, notebooks, Lakehouse/Warehouse concepts, and Medalion architecture

o Experience using orchestration tools such as: ActiveBatch

o Experience with web services and API integrations

o Experience with Agile, DevOps and DataOps methods and technologies: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.

o Experience working with vendors and 3rd party data integrations.

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.

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.