Data Architect and Developer

Posted on: September 24, 2018

Job Summary:

Do you love Data? Do you want to create awesome Data Solutions? Does Analytics, Artificial Intelligence (AI)/Machine Learning (ML) excite you? Do you want to work with cutting edge technologies in a fast-paced FinTech environment, where your work is highly visible? If you answered yes to all questions then we would love to hear from you.

NEPC is looking for a Data Architect/Developer to support our Digital Strategy initiatives encompassing enterprise data management, Analytics, Reporting, AI/ML, and Visualizations to fundamentally change how employees and clients engage with data. This role will be responsible for analyzing & documenting requirements by studying system capabilities and business functions, constructing specifications, and designing new in-house and third-party systems and data solutions. They will also conduct testing, document procedures, and serve as a subject matter expert for process improvements, troubleshooting and system upgrades.

The right candidate should have experience in implementing change with technology and processes, operating strategically and tactically with a focus on delivering meaningful business solutions. Candidates should be able see big picture and understand granular details and should be able to describe in detail their specific roles on projects that affected data management processes, analytic capabilities, content management, dashboards and/or reporting with a specific emphasis on what changes stakeholders experienced as a result of these projects. Candidates should also have a passion for investment services and FinTech.


Bachelor’s degree in Information Systems or Computer Science; an advanced degree is not required, but is preferred. High degree of computer proficiency – especially Microsoft products. Possesses business acumen and knowledge of business process and project management, as well as ability to initiate process change. Ability to work independently, as well as collaboratively is required. Project Management experience for medium/large system implementation efforts preferred.  Must be exceptionally effective at collecting and documenting requirements. Must have domain knowledge in investment services and considerable knowledge of relational databases, analytics, and the design and development of efficient data integration solutions.

Highly skilled with a majority of the following: SQL Server, T-SQL, ETL tools (SSIS preferred), report writing (SSRS preferred), data modeling (ERwin), and scripting languages (Python – preferred, Javascript, Java, Powershell, VBA, Vbscript, JSON), JMS messaging or other messaging technology. Experience with R preferred.

  • Knowledge of NEPC systems is a plus (e.g., Denodo, Spotfire, Dynamics365, MSCRM, M-Files, Confluence, Adaptive, InvestorForce, Morningstar Direct, M-Files, Planview PPM etc.).

  • The ability to handle multiple projects and work streams independently, proactively, and collaboratively is required.

  • Strong problem solving and analytical skills and attention to detail.

  • Experience with web API integrations (SOAP & RESTful endpoints), and user interface design is a plus.

  • Data Management, Report Writing, Data Modeling, Data Architecture.

 Skills: Systems Requirements Definition, Systems Documentation, Software Lifecycle Development Process, Agile methodology, Microsoft Database and Developer products, Information Analysis, Project Management, Release Management, Software Maintenance Process, Written Communication, Promoting Process Improvement, software development experience with any language, Web development experience desired.

To apply: click here

 Company Background:


NEPC, LLC is an employee-owned, full service investment consulting firm based in Boston, Massachusetts.  NEPC was founded in 1986 and now has approximately 240 employees and over 300 clients.  We provide a variety of consulting services such as asset allocation, performance measurement, policy formulation, and manager search.  Our clients include defined benefit, defined contribution, endowments, foundations, trusts, public, corporate, Taft-Hartley, health & welfare, high-net worth, insurance and private plans.  NEPC’s mission is to help our clients build successful investment programs, using diverse and proven strategies to enhance returns while minimizing risk.  We’re a fun (but demanding) company with excellent working conditions and a very supportive team-oriented environment.                 

NEPC is an Affirmative Action/Equal Opportunity Employer


Boston, Massachusetts

Experience Level

5-10 years of experience

More Job Openings