Commonwealth Financial Network

Enterprise Data Architect

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


Are you interested in turning your broad experience with data management disciplines into a role that will allow you to work across multiple projects? As an enterprise data architect, your main responsibility will be building a first-class data platform that provides data analytics and enables artificial intelligence across the company.


Reporting to the director of data architecture and business intelligence, you will have the opportunity to implement data governance platforms, create data catalogs, and use your coding and systems skills to maintain SQL databases. In this role, you will work independently, as well as be part of an Agile team.


Key responsibilities

  • Analyzing the current data flows of various systems (software components, technologies, business processes) and incorporating this knowledge into a data governance platform
  • Creating the future data architecture/platform and generating data management artifacts, including data models, dictionaries, catalogs, and flows; ETL source-to-target mappings; and testing use cases
  • Implementing data governance platforms and providing a systematic process and framework to access and share data across various business units within the company
  • Enforcing data management best practices, standards, policies, and rules across different functional areas
  • Developing conceptual, logical, and physical data models based on business requirements to support various applications
  • Creating and maintaining the enterprise data catalog/dictionary
  • Performing the role of data steward for the platform
  • Participating in data warehouse implementation, including data model design, ETL process coding, and data archiving and recovery
  • Evaluating and recommending emerging technologies for data management, storage, and analytics
  • Developing and maintaining data warehouse ETL processes to solve complex data problems, including performance, scalability, security, and integration issues

Core strengths

  • Experience with data model design (conceptual, logical, physical) and strong knowledge of relational databases, SQL, and columnar databases
  • Ability to communicate across all levels of the organization and work with diverse project teams
  • Experience and knowledge in migrating code, database changes, and data sets through the various stages of the development life cycle
  • Coding and system skills to maintain SQL databases, SSIS, SSRS, packages, agent jobs, stored procedures, and linked servers
  • Ability to work independently with minimal supervision, including the organization and prioritization of tasks to meet deadlines and goals
  • Excellent interpersonal skills, accountability, written and verbal communication skills, and time management
  • Comfortable working in a collaborative team environment and Agile methodologies

Additional skills and knowledge

  • Bachelor’s degree in computer science, engineering, or related field
  • A minimum of 5 years of data management experience within a large company
  • Hands-on experience with database technologies and visualization tools (e.g., SQL, NoSQL, Oracle, Hadoop, Teradata, Power BI)
  • Experience with enterprise data management solutions and platforms, including MDM, data governance, metadata management, ETL, data quality management, and data warehouse
  • Experience with Team Foundation Server (TFS) preferred

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