Data Architect

Nextcapital Chicago , IL 60602

Posted 3 months ago

ABOUT US

NextCapital's Digital Advice Platform is a holistic service built around the investor, providing world-class advice at an affordable price. It is the only service that offers integrated planning, advice, and portfolio management capabilities. Because of the breadth of advice services, NextCapital serves a broad range of investor types, from the low-balance beginning investor to the sophisticated high net worth investor.

Learn more about NextCapital at www.themuse.com/companies/nextcapital

JOIN OUR TEAM

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. You'll 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.

WHAT YOU'LL DO

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

Requirements

WHO WE'RE LOOKING FOR

  • 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

Benefits

WHY YOU'LL LOVE IT

  • 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 FinTech's 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
lc_ad

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

Telephone And Data Systems Inc.

Posted 2 weeks ago

VIEW JOBS 8/3/2019 12:00:00 AM 2019-11-01T00:00 Overview TDS, a Fortune 1000 national communications company and voted as one of the Best Places to Work, has an exciting new opportunity for a Data Architect. If you are a driven individual, with excellent communication skills and a strong passion for data and analytics, come join our team! We would ideally like to fill this position in Wisconsin, Northern Illinois, Minnesota or Iowa. You can work out of a local office, work REMOTELY at HOME or any preferred combination. And, for the right candidate, we are potentially open to filling this position anywhere in the continental U.S. We are unable to provide sponsorship for this position and this is not a contract to hire role. Responsibilities The Data Architect designs, develops, and deploys architecture, standards and processes to improve the management of information and data throughout its lifecycle across the business intelligence workspace. The primary deliverable is the foundation, including processes and procedures, for the design of business-focused solutions and data repositories that provide consistent, relevant and reliable information for business analysis and decision making. The Data Architect also oversees and participates in the implementation of data architecture enhancements and projects, through all phases of the system development life cycle. Qualifications Required Qualifications: * Bachelor's degree in Information Technology or related field -OR- 4+ years equivalent combination of education and work experience * 8+ years IT related experience; including 5+ years data architecture related activities including data modeling, requirements and process mapping; data warehouse development and design; data governance, and/or data visualization development * 2+ years experience in process design which includes developing and leading the execution of process improvements and projects across business ecosystems * 2+ years application support experience using relational databases and tools; SAP experience a plus Other Qualifications: * Strong technical skills with Microsoft Office Suite (including Project, Visio, and Excel) * Knowledge of test planning, coordination and execution * Demonstrated ability to effectively communicate in technical and non-technical terms, at all levels, both within and outside the organization * Holistic and proactive approach towards change, process improvement, and execution of job responsibilities * Excellent analytical and problem solving abilities * Strong customer service skills which includes an in-depth understanding of customer business processes and needs * Ability to shape and execute strategy across the organization with a focus on quality and urgency * Proven ability to coach and mentor others * General Sarbanes-Oxley awareness; including the understanding that SOX has impact on the position and department functions #TDS provides wireless products and services; cable and wireline broadband, TV and voice services; and hosted and managed services nationwide through our U.S. Cellular®, TDS Telecom®, OneNeck IT Solutions®, BendBroadband and Suttle Straus® brands. We offer a competitive salary and total rewards package. To learn more about this position, or our company, please visit tdsinc.com. EEO Telephone And Data Systems Inc. Chicago IL

Data Architect

Nextcapital