Data Integration Engineer

🔥 14 hours ago

🇺🇸 United States – Remote

💵 $73.5k - $105.6k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

💻 Solutions Engineer

👻 Ghost score 1%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.Why this score:

• Open for 1 day.
• Jobs at this company usually fill in 96 days.

Apply Now

Find Similar Remote Jobs

D.A. Davidson Companies

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1935

💸 Finance

Finance • Investment Banking • Wealth Management

D. A. Davidson Companies is a comprehensive financial services company that offers a wide array of services to individual investors, corporations, and institutions. With a history of 88 years, they provide wealth management, equity capital markets, investment banking, and trust services. D. A. Davidson is committed to guiding clients through life's key financial moments with services like retirement planning, estate planning, education planning, and more. Additionally, they are involved in public finance, offering expertise in municipal advisory services, tribal financing, and fixed income capital markets. Renowned for their professional money management and advisory solutions, D. A. Davidson emphasizes personalized client service and strategic investment advice. Their investment advisors use a research-based approach to ensure client portfolios align with their financial goals. The firm's dedicated team is also involved in community empowerment initiatives nationwide, leveraging their extensive knowledge in various sectors to benefit the communities they serve.

📋 Description

• Design, develop, test, deploy, and support ETL/ELT processes and data integration solutions • Build and maintain data pipelines ingesting 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 • Implement controls ensuring 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 • 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 • Gather and interpret data requirements with business users • Partner with data architects and senior engineers on enterprise data initiatives • Deliver reliable, well-structured datasets to analysts and reporting teams • Participate in Agile planning, code reviews, testing, and continuous improvement activities

🎯 Requirements

• 3-5 years of experience in Data Engineering, Data Integration, or ETL development • Experience supporting production data integration environments • Experience with Microsoft cloud-based technologies in a hybrid architecture • Experience with cloud services (Microsoft Azure, AWS) • Advanced working TSQL knowledge and experience with relational databases, query authoring, stored procedure development, and end-to-end data pipeline development • Experience with ETL/ELT platforms such as SSIS, Azure Data Factory, and 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, and 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 • Familiarity with Agile work principles • Understanding of software and database development life cycle concepts • Awareness of information sensitivity regulations and data security and confidentiality best practices • Extensive experience with SQL syntax • Experience with Microsoft Fabric pipelines, notebooks, Lakehouse/Warehouse concepts, and Medallion architecture • Experience with web services and API integrations • Experience with Agile, DevOps, and DataOps methods and technologies • Experience working with vendors and third-party data integrations • MCSE/MCSA certifications preferred • Experience in financial services, banking, wealth management, brokerage, insurance, or other regulated industries preferred

🏖️ Benefits

• 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

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume