Tegra118 Wealth Solutions, Inc.
Database Engineer
hace 2 días
Warren
Job Description InvestCloud is looking for a practical, detail-focused Data Engineer with a passion for financial data and a desire to grow into a hands-on Data Architect role. This is a great opportunity for someone early in their data career who enjoys working with real-world investment data, learning from experienced architects, and helping build the foundation for next-generation wealth technology. You’ll work on data pipelines, optimize SQL queries, model data for performance and scale, and gain exposure to both transactional systems and analytical workflows in the US wealth space. What does a Great Data Engineer do You’ll partner with engineers, product managers, and data architects to design, build, and maintain clean, scalable, and reliable data domains that power key digital experiences in wealth management. If you’re energized by structured data, interested in how trades, accounts, and positions come together behind the scenes—and want to sharpen your skills with modern cloud tools—this is your path. Principal Responsibilities • Design and maintain SQL-based schemas and pipelines for ingesting, transforming, and exposing wealth-related data (accounts, positions, transactions, performance)., • Support structured and unstructured data across file-based, relational, and NoSQL storage solutions—from raw landing zones to curated data marts., • Write efficient, well-structured SQL queries and scripts for ETL/ELT jobs, data validation, and data modeling., • Assist in building out data access layers that support APIs, reports, dashboards, and performance analytics., • Collaborate with data architects and engineers to implement data modeling and management best practices., • Work with QA and product teams to ensure data accuracy, completeness, and business alignment., • Contribute to data documentation and internal knowledge sharing to improve onboarding and reduce confusion. Preferred Skills & Experience, • 8+ years of experience in data engineering and/or ETL-focused roles., • Strong SQL skills and familiarity with relational databases (e.g., Oracle, Postgres, SQL Server, Snowflake)., • Solid understanding of data modeling and management principles, including data cataloging, dictionaries, canonicals, normalization, indexing, and performance tuning., • Interest in or exposure to US Wealth Management data, especially trades, positions, custodians, or portfolio accounting systems., • Eagerness to learn, collaborate, and grow your technical skills in a production environment. Preferred Qualifications, • Experience in the wealth or asset management industry., • Familiarity with financial data domains or vendors (e.g., custodians, CRMs, performance systems)., • Exposure to data pipeline tools (e.g., dbt, Airflow, Talend) and scripting languages (e.g., Python, Shell)., • Understanding of file-based formats (e.g., Parquet, JSON, CSV) and batch ingestion patterns., • Experience working in Agile/Scrum environments with tools such as Jira, Confluence, and Git.What Sets You Apart, • You care deeply about data lifecycle, quality, structure, maintainability, supportability, and traceability—not just getting the job done, but getting it right., • You’re curious about the business side of wealth data—why something is modeled a certain way and how it will be used. InvestCloud, a global leader in wealth technology, aspires to enable a smarter financial future. Driving the digital transformation of the wealth management industry, the company serves a broad array of clients globally, including Wealth and Asset Managers, Wirehouses, Banks, RIAs, and Insurers. In terms of scale, the company’s clients represent more than 40 percent of the $132 trillion of total assets globally. As a leader in delivering personalization and scale across advisory programs, including unified managed accounts (UMA) and separately managed accounts (SMA), the company is committed to the success of its clients. By equipping and enabling advisors and their clients with connected technology, enhanced intelligence, and inspired experiences, InvestCloud delivers leading digital wealth management and financial planning solutions, complemented by a dynamic data warehouse, which scale across the complete wealth continuum. In 2024, InvestCloud was named CNBC World’s Top Fintech Company, a proof point of the company’s commitment to innovation and client success. Headquartered in the United States, InvestCloud serves clients around the world. For more information, visit InvestCloud.com. Our Value • Client Connected, • Human Centered, • Technology Forward, • Respect + Integrity Invest Cloud is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law #LI-HJ1