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 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. You’ll also work with our Data/Analytics team to plan, build, and maintain the reporting and analytics platform - this will be used both internally for strategic decision-making by NextCapital leadership and externally through an interface for partners to access relevant data, both operational and strategic.
The ideal candidate is results-driven, able to break down complex problems, uses prototypes to quickly test out possible solutions, and can learn new tools, languages, and DBMS’s on the fly.
WHAT YOU’LL DO
Serve as the NextCapital Data Architect, to provide oversight to our data activities.
- Review and modify the security/permissions implementation
- Implement review processes for schema changes
- Analyze loads and performance, and suggest solutions to bottlenecks
- Manage Data Architecture and Catalog for Snowflake Computing, MySQL, MS SQL Server, MongoDB, and other databases.
- Establish and contribute to documentation
- Provide guidance for new application features
- Suggest and work collaboratively to effect architectural improvements
- Design and work collaboratively to implement Metadata Management, Master Data Management and data element lineage traceability
- Refactor and work collaboratively to implement overall Data Management Lifecycle - Master Audit trail, backups, long term retention, DR/BC
- Consult on XML and JSON schema Architecture/Designs
- For the reporting/analytics platform:
- Review and provide feedback for our full and incremental load processes, which include the use of a third-party ETL/ELT/CDC utilities (Talend, Amazon Glue/Kinesis, FiveTran, and Streamsets are being evaluated), as well as custom solutions.
- Build/Update schemas within Snowflake Computing based on reporting, analytics, and data science requirements
- Provide assistance for creating models/objects within our Data Visualization software (Looker)
- Monitor and improve performance of pipelines, capacity loads and query times
by via developer jobs - Stack Overflow
No comments:
Post a Comment