Data Architect

Nextcapital Chicago , IL 60603

Posted 3 days ago


NextCapital is the leader in enterprise digital advice. NextCapital partners with world-class institutions to deliver personalized planning and managed accounts to individual investors, whether theyre saving for retirement in a 401(k) or IRA or investing in a taxable brokerage account. Our open-architecture digital advice solution provides better outcomes for our partners and individual investors by offering integrated account aggregation, analytics, planning and portfolio management, and customizable advice methodology and fiduciary roles.

Learn more about NextCapital at


We're looking for an organized and highly motivated Data Architect to join our team. You will work with our Data/Analytics team to plan, build, and maintain the reporting and analytics platform. This is being used internally for strategic decision-making by NextCapital leadership and will be used externally through an interface for partners to access relevant data, both operational and strategic. Youll also work closely with our designers and developers to ensure that the database structures for the NextCapital Digital Advice Platform are correctly designed for current and future needs.

The ideal candidate is results-driven, hands-on, able to break down complex problems, uses prototypes to quickly test out possible solutions, and can learn new tools on the fly.


Serve as the NextCapital Data Architect and begin to establish a Data practice area within the organization.

  • Design logical and physical data models within our data warehouse (Snowflake) based on reporting, analytics, and data science requirements
  • Provide assistance for creating models/objects within our Data Visualization software (Looker)
  • Review and provide feedback for our full and incremental load processes, which include the use of a third-party ELT tool (FiveTran)
  • Develop a global data security/permissions solution
  • Analyze loads and performance, and suggest solutions to bottlenecks
  • Manage data architecture and catalog for Snowflake and our main MySQL application database. Also be familiar with our other data sources (MS SQL Server, MongoDB, and others)
  • Implement review processes for schema changes and database migrations (working with the Ruby on Rails application teams)
  • Establish and contribute to documentation
  • Provide guidance for new application features
  • Suggest and work collaboratively to implement architectural improvements
  • Design and work collaboratively to implement metadata management, master data management and data element lineage traceability
  • Refactor and work collaboratively to improve our overall data management lifecycle - backups, long term retention, disaster recovery
  • Help the organization move to a robust, zero downtime deployment strategy



  • 8+ years of database architecture, design, and implementation experience
  • 4+ years of recent experience with ETL/ELT, Data Warehousing, and Reporting/Analytics
  • Experience with general database administration
  • Superior SQL skills
  • Superior scripting/coding skills
  • Demonstrable ability to learn and become productive on new platforms and tools quickly
  • You are a team player, able to work with coworkers in the product and technology areas, as well as upper management
  • You have strong communication skills and can convince people to buy into your vision
  • You are constantly learning, driven to understand the data content of what other product areas produce, and give your opinion on how best to expose it to internal and external audiences
  • You are adept at figuring out how to adjust solutions to meet an expected timeline

At this time, NextCapital will not sponsor a new applicant for employment authorization for this position.



  • Disrupt the financial advice industry by bringing affordable, easy to use financial tools to millions of people
  • Enjoy a laid back work environment & learn from FinTechs best & brightest
  • Receive great benefits like stock options, 401(k) match, and employer contributions to health, dental and vision coverage
  • Join a fast growing company where you can have a real impact on the company's future
  • Participate in company-sponsored cornhole leagues, wine tastings, fantasy football leagues, hackathons and other fun events
  • Enjoy a newly built out office on Michigan Avenue with a view of Millennium Park and Lake Michigan.
  • Sip locally roasted coffee, kombucha, or craft beer at your modular sitting/standing desk
icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Architect

Prominence Advisors

Posted 1 week ago

VIEW JOBS 10/7/2021 12:00:00 AM 2022-01-05T00:00 <p>Prominence is looking for a data architect with broad experience with the SQL Server platform to help us build and deploy data integration solutions in partnership with some of the nation’s leading healthcare providers. Our ideal candidate has the ability to work at the data level to transform the raw sources into meaningful and actionable information, at the software level to build and tune systems that perform well under heavy loads, and at the architectural level to design frameworks that can scale both in size and scope. More important than experience with any particular technology or platform, however, is the demonstrated desire and ability to tackle new and unfamiliar technical challenges.</p><p>There is no relocation required for this position and candidates are required to have a suitable home office to operate out of when not traveling to the customer site.</p> <p><br></p><p><strong>Requirements</strong></p><p><strong>Desired Skills</strong> <strong>Required</strong></p> <ul> <li>Deep knowledge of relational data modeling</li> <li>Experience with the SQL Server platform as a SQL developer</li> <li>Ability to write, debug and tune data transformations </li> <li>Ability to think at an architectural level in creating, growing, maintaining, and documenting scalable systems</li> </ul> <p><strong>Strongly Preferred</strong></p> <ul> <li>Healthcare industry knowledge and experience</li> <li>C#, VB or general programming experience</li> <li>Knowledge of SQL Server hardware and software configuration best practices</li> <li>Experience with reporting tools such as Tableau, QlikView, Qlik Sense</li> <li>Experience with cloud-bases services (AWS, Azure)</li> </ul> <p><strong>Bonus Skills</strong></p> <ul> <li>Experience working with source control software (git, svn, TFS)</li> <li>Experience working with or integrating with big data platforms</li> </ul><p><strong>Benefits</strong></p><p>Prominence is dedicated to hiring the best and brightest minds in healthcare and maintaining a culture that rewards our employees for following their passion. We’ve won Modern Healthcare’s Best Places to Work Award and have been voted to Chicago’s 101 Best and Brightest companies list three years running. Our most recent designation is being named in the top 10 by Consulting magazine as one of the Best Small Firm to Work For.</p> Prominence Advisors Chicago IL

Data Architect