Commonwealth Financial Network

Data Engineer

Job Locations US-MA-Waltham
Job ID
# of Openings
Technology- Application Solutions


Do you—like us—have a natural willingness to dive in, solve problems, and get things done? Are you a strong data engineer? If so, then you may be just the person we are looking for to work as part of a team of data architects, data scientists, data engineers, BI analysts, and data analysts. We work closely with business analysts and business owners to architect, develop, implement, support, and troubleshoot Commonwealth’s data platforms, which includes various OLTP databases and the enterprise data warehouse and applications.


Our tight-knit Development team builds and maintains a large private website, COMMunity Link®, which helps more than 2,000 small business owners manage their daily lives. It is built primarily using Microsoft technologies, including .NET and SQL Server. We also have a public-facing site and mobile versions of our tools. Our development approach has always been Agile, and our team structure is based on Scrum.


Key responsibilities 

  • Building ETL processes for data warehouse and data hub to enable business users to self-service for various data analytics
  • Fulfilling data requests when the data elements are not yet built in the data warehouse
  • Building the schema and SQL code behind our complex suite of web-based applications
  • Creating workflows and transformations with SQL Server Integration Services
  • Ensuring that data is stored efficiently and can be retrieved quickly within our databases and servers that integrate as an ecosystem to serve our clients’ needs
  • Troubleshooting and tuning complex SQL statements and making recommendations on indexing strategies
  • Working on a variety of projects and systems, from big to small and complex to simple
  • Collaborating with a dynamic team of web developers, business analysts, and product owners to build the best applications in the financial industry
  • Performing code reviews, learning from your peers, and sharing your knowledge in a positive, friendly way

Core strengths 

  • 5–10+ years of experience
  • A solid understanding of relational modeling concepts
  • Ability to write, troubleshoot, and performance-tune stored procedures and ad hoc scripts
  • Experience with data warehousing
  • Experience working with MS Azure cloud a plus
  • Experience in the financial sector a plus

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


About Commonwealth—and Our Anything but Common® Culture 


Commonwealth Financial Network® is the largest privately held Registered Investment Adviser–independent broker/dealer in the U.S., with offices in Waltham, Massachusetts, and San Diego, California. Since 1979, we’ve been delivering indispensable service to independent financial professionals so they, in turn, can put their clients first. Our technology, research, resources, and support—plus a variety of affiliation models—deliver what today’s independent advisors need to thrive. 


That being said, we are a financial services company with a unique mission—one that encompasses purpose, vision, and core values in equal measure. Staying true to these guiding principles is the reason we are recognized so often and by so many for the quality of life we enjoy here. We believe it directly translates to a better experience for everyone: employees, advisors, clients, and our communities. 


Creating a supportive culture where everyone can thrive is a mission we take seriously. From professional development to comprehensive benefits, grassroots leadership opportunities, generous bonus and stock option incentive plans, opportunities to unwind and connect, and so much more, Commonwealth is not just a great place to work—it’s a place that, for many, feels like home. 


We care about your online safety as a prospective employee and encourage you to exercise caution when responding to job postings online. Commonwealth Financial Network 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 Financial Network is an equal opportunity employer that is committed to a diverse workforce. 


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed