VRGL | Data Engineer

About VRGLVRGL is a high-growth software and data analytics company serving the wealth management industry. Its products and services revolutionize the way RIAs and wealth managers attract, grow, and retain revenue through quantitatively assessing a client's current investment portfolio across five core investment pillars and providing relevant comparisons. This immediate transparency allows financial advisors, wealth managers and anyone with brokerage and custodial statements to instantly extract data and quantify what is and can happen in their current portfolio and what would happen with a transition of assets. Through VRGL's "5 Pillars," a financial advisor can quickly help a prospective client identify the advantage of a switch. No more steak dinners and golf outings over years to develop a relationship, go straight to the heart of your value add.Data EngineerAs a Data Engineer, you will be the cornerstone of VRGL's data operations. You will manage critical data pipelines, ensure data quality, and collaborate with internal teams to optimize our analytics infrastructure. This hands-on role requires expertise in data engineering, problem-solving, and collaboration with cross-functional teams.ResponsibilitiesData Integration and Management:Oversee and manage multiple data streams, including:FTP files from ICE and Morningstar.API calls to ICE Remote Plus and other fundamental data ternal scraping software for SEC EDGAR filings.Monitor and troubleshoot data ingestion pipelines to ensure seamless operations.Data Quality Assurance:Validate fund data from sources like Morningstar against the internal database and resolve mismatches.Ensure the accuracy and completeness of all records across data sources.Perform systematic checks on data integrity, addressing issues such as missing records or incorrect data ingestion.Pipeline and Workflow Optimization:Maintain and improve data pipelines, especially for high-volume streams like ICE market data.Ensure nightly risk calculation processes run smoothly for a database of 7M+ securities, encompassing bonds, stocks, and other asset classes.Build and refine processes to account for unique scenarios like distributions, splits, and corporate actions.Collaboration and Stakeholder Engagement:Act as the primary point of contact for all data-related issues, working closely with:Product teams to align data solutions with business goals.Analytics teams to support their modeling and analysis needs.Client Experience teams to address data complaints and ensure client satisfaction.Development teams for troubleshooting and improving data ingestion systems.Technical Proficiency:Use PostgreSQL and Snowflake to manage databases and optimize data storage and retrieval.Write and execute SQL queries for data analysis and troubleshooting.Implement dbt (Data Build Tool) to standardize and streamline data transformation workflows.Data Governance and Ownership:Take full ownership of data systems, ensuring all processes run efficiently and data is reliable.Regularly audit pipelines and proactively fix broken processes or suboptimal workflows.Maintain documentation of all data streams, processes, and troubleshooting steps for internal use.Scalability and Innovation:• Contribute to the scalability of data systems to handle increasing data volumes and new data sources as VRGL grows.• Stay up-to-date with industry trends and technologies, incorporating best practices into the organization's data strategy.Position RequirementsExperience and Skills:3+ years of experience as a Data Engineer or similar role.Experience with equity and fixed income markets data requiredExpertise in databases such as PostgreSQL and Snowflake.Strong SQL skills for data querying and troubleshooting.Experience with dbt or willingness to learn on the job.Familiarity with alternative investments like Private Equity and Hedge Funds is a plusSystematic thinker with a proactive problem-solving mindset.Preferred Skills:Knowledge of financial technologies and market data.Experience in a fast-paced startup or high-growth environment.Why VRGL?Join a collaborative team at the forefront of wealth management technology. Be part of an organization that values innovation, transparency, and impactful work.VRGL is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind: VRGL does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service or other non-merit factor.

Created: 2025-01-19