Senior Data Integration Engineer

Overview

Whether you’re looking for a high-energy, inclusive atmosphere and a company that understands the importance of work/life balance, Commonwealth is your match! From generous bonus and 401(k) programs to tuition reimbursement and flexible work schedules, Commonwealth is focused on helping its employees thrive in an environment suited to their needs. On top of all that, the Technology department offers a hybrid work schedule, so you’ll be able to work from home for part of the week!

 

We’re looking for a senior data integration engineer to join our ranks. This role is responsible for data integration, data collection, and establishing data integration architecture standards. The ideal candidate will also support lake house architecture and many data integration applications that support our Commonwealth business solutions.

 

Key Responsibilities

• Develop and support large-scale data sets and pipelines to ingest, move, transform, and integrate data
• Generate insights and advanced analytics reports across Commonwealth business groups
• Conduct data exploration, enrichment, and support feature engineering, in data science, data visualization, and business process improvement initiatives
• Interface with business-aligned IT teams to design, build, and launch efficient and reliable data pipelines to move and transform data
• Meet with application teams to understand requirements and recommend high-level direction and approach to upcoming projects
• Ensure the availability, performance, scalability, and security of production environments
• Troubleshoot systems and solve problems

Core Strengths and Skills

• 7+ years’ experience in ELT and real time integration with APIs using various data integration tools
• Experience with data modeling, data warehousing, data integration, and data governance tools
• Experience creating and managing data pipelines and data sets using Databricks
• Experience with data lakehouse architecture using (i.e. Spark, Kafka, Spark & Kafka Streaming, Python, FiveTran, etc.)
• Experience with Azure cloud, Azure Data factory, Azure Event Hubs, and serverless solutions
• Knowledge of integrating with MDM (Reltio or similar)
• Proficiency in SQL and experience with relational databases, NoSQL and graph databases
• Knowledge of BI Tools like PowerBIand Tableau
• Strong communication skills with both technical and non-technical clients

Have we piqued your curiosity? Can you see yourself thriving in this opportunity? Let’s introduce ourselves. 

 

Picture Yourself Here  

At Commonwealth, we believe in a better world. We hold ourselves and each other to higher standards. We take care of one another. That’s why we invest in you—we encourage employee growth both in your career and education; we are building out a robust diversity, equity, and inclusion program; we offer incredible health care benefits; and we find plenty of occasions to celebrate. What’s not to love? 

 

We are always striving to be better, and we are looking for employees who share that same mindset. Better people, better coworkers, better leaders, better creators. Bring your best work and your full self to the table, and we will do the same. Together, we can build a better future for our advisors, their clients, our company, and you. 

  

About Commonwealth  

Commonwealth Financial Network, Member FINRA/SIPC, a Registered Investment Adviser, provides a suite of business solutions that empowers more than 2,000 independent financial advisors nationwide. Privately held since 1979, the firm has headquarters in Waltham, Massachusetts, and San Diego, California.  

  

Turning our advisors into raving fans starts by doing the same for our employees. We foster an environment of excellence, growth, rewards, and fun in equal measure, which has earned us 43 Best Place to Work awards.   

  

The Fine Print  

We care about your online safety as a prospective employee and encourage you to exercise caution when responding to job postings online. Commonwealth will never ask potential hiring candidates to pay or transfer funds as a precondition of interviews or employment, nor will we authorize recruiters or agents to do so on our behalf.  

  

Commonwealth is an equal opportunity employer, making intentional efforts to source talent from all backgrounds.   

Min

USD $125,000.00/Yr.

Max

USD $150,000.00/Yr.