We are Allvue Systems, the leading provider of software solutions for the Private Capital and Credit markets. Whether a client wants an end-to-end technology suite, or independently focused modules, Allvue helps eliminate the boundaries between systems, information, and people. We’re looking for ambitious, smart, and creative individuals to join our team and help our clients achieve their goals. Working at Allvue Systems means working with pioneers in the fintech industry. Our efforts are powered by innovative thinking and a desire to build adaptable financial software solutions that help our clients achieve even more. With our common goals of growth and innovation, whether you’re collaborating on a cutting-edge project or connecting over shared interests at an office happy hour, the passion is contagious. We want all of our team members to be open, accessible, curious and always learning. As a team, we take initiative, own outcomes, and have passion for what we do. With these pillars at the center of what we do, we strive for continuous improvement, excellent partnership and exceptional results. Come be a part of the team that’s revolutionizing the alternative investment industry. Define your own future with Allvue Systems!
The Opportunity
The Software Engineer IV is an advanced individual contributor responsible for designing, developing, and optimizing complex data engineering and business intelligence solutions that support critical business operations, reporting capabilities, and data-driven decision-making.
This role requires a strong combination of advanced technical expertise, business acumen, and the ability to understand how business processes, operational priorities, and data requirements intersect. The engineer is expected to look beyond stated technical requests to understand the underlying business problem, evaluate solution alternatives, and translate business context into scalable, reliable, and maintainable technical solutions.
Operating with a high degree of independence, the Software Engineer IV applies advanced engineering judgment to solve complex data integration, data warehousing, and business intelligence challenges. The role works closely with business and technology stakeholders to clarify ambiguous requirements, challenge assumptions, identify dependencies, and determine technical approaches that balance business objectives, system capabilities, and long-term sustainability.
The position owns complex solutions within the BI/ETL environment, contributes to the continuous improvement of the data platform, and influences technical approaches across collaborating teams. Success requires the ability to connect technical decisions to business outcomes while maintaining high standards for data quality, platform reliability, performance, and engineering excellence.
What You'll Do
Business Acumen, Requirements Translation & Solution Definition
- Develop and apply a strong understanding of business processes, operational workflows, key performance indicators, and reporting requirements to inform technical solution design and development.
- Partner with business stakeholders to understand the objectives and operational context underlying requests, translating complex or ambiguous business needs into clearly defined technical requirements and actionable solutions.
- Independently assess business challenges, identify gaps or inconsistencies in requirements, and challenge assumptions to ensure proposed solutions address underlying business needs rather than solely fulfilling initial requests.
- Evaluate business priorities, data dependencies, technical constraints, and downstream impacts to determine appropriate solution approaches.
- Translate business concepts, rules, and operational requirements into data models, transformation logic, integration processes, and reporting structures that support accurate and meaningful business information.
- Advise stakeholders on technical feasibility, solution alternatives, implementation tradeoffs, and potential business implications, enabling informed decisions.
- Anticipate how changes in business processes, data definitions, or reporting needs may affect existing solutions and recommend appropriate technical adaptations.
Advanced Software Engineering & Technical Solution Design
- Independently design, develop, optimize, and maintain complex data integration, data warehousing, and business intelligence solutions using Microsoft SQL Server, SSIS, SSAS, SSRS, and related technologies.
- Own the technical design and implementation of complex ETL processes, database objects, analytical structures, and data transformation workflows within the supported BI/ETL environment.
- Apply advanced SQL development techniques to design and optimize stored procedures, functions, views, and complex queries that support data integration, reporting, and analytical requirements.
- Design and enhance scalable data warehouse structures and analytical models that support evolving business needs, data integrity, and efficient information retrieval.
- Evaluate multiple technical approaches to complex engineering challenges, exercising independent judgment in selecting solutions based on performance, scalability, maintainability, reliability, and business impact.
- Develop, optimize, and maintain SSAS multidimensional solutions and supporting analytical structures to enable accurate and efficient reporting.
- Apply sound software engineering principles throughout the development lifecycle, including solution design, coding, testing, deployment, documentation, and ongoing optimization.
- Contribute to the evaluation and implementation of modern data technologies, integration capabilities, and development automation where they provide demonstrable technical or business value.
Complex Problem Solving, Data Quality & Platform Optimization
- Independently investigate and resolve complex data integration, reporting, performance, and system reliability issues requiring in-depth analysis across multiple technologies, data sources, or processes.
- Diagnose underlying causes of data inconsistencies, processing failures, and reporting defects, assessing their implications for business operations and decision-making.
- Develop sustainable solutions to recurring or complex technical problems, addressing root causes and minimizing downstream impacts.
- Analyze system performance, data processing efficiency, and integration dependencies to identify opportunities for optimization and improved reliability.
- Proactively identify technical risks, data quality concerns, and architectural limitations within the supported environment and recommend appropriate corrective actions.
- Contribute to the ongoing improvement of ETL frameworks, database performance, data validation processes, and reporting capabilities.
- Balance immediate business requirements with long-term platform maintainability when resolving technical issues or implementing enhancements.
- Support production stability through effective troubleshooting, incident resolution, documentation, and preventive improvements.
Cross-Functional Collaboration, Technical Advisory & Influence
- Serve as an advanced technical partner to business and technology stakeholders, bridging business objectives and software engineering capabilities.
- Collaborate across engineering, reporting, and business teams to evaluate technical dependencies, resolve complex requirements, and align solutions with shared business objectives.
- Influence technical solution approaches across collaborating teams by providing informed recommendations, evaluating alternatives, and communicating engineering considerations.
- Provide technical guidance to other engineers on complex SQL development, ETL design, data modeling, performance optimization, and reporting solutions.
- Participate in technical design discussions and solution reviews, applying advanced engineering judgment to improve solution quality and consistency.
- Communicate complex technical concepts, constraints, and recommendations in clear, business-relevant language to stakeholders with varying levels of technical expertise.
- Contribute to the development and adoption of engineering standards, reusable components, documentation practices, and knowledge-sharing initiatives.
- Build effective working relationships with stakeholders to promote a shared understanding of business needs, technical requirements, and solution outcomes.
Engineering Excellence, Innovation & Continuous Improvement
- Identify opportunities to improve development efficiency, solution quality, automation, and platform performance through modern engineering practices and technologies.
- Apply appropriate development standards, source control practices, testing methodologies, and deployment processes to ensure reliable and maintainable solutions.
- Contribute to CI/CD improvements and deployment automation using Azure DevOps, YAML pipelines, and related development tools.
- Evaluate emerging technologies, including Microsoft Fabric, modern integration services, and cloud data capabilities, for potential application within the existing technology environment.
- Leverage approved AI-assisted engineering tools to support development productivity, code quality, troubleshooting, and documentation while maintaining engineering, security, and data governance standards.
- Recommend practical improvements to data architecture, integration processes, and development practices based on observed technical limitations and evolving business requirements.
- Maintain awareness of relevant software engineering and data platform advancements and apply appropriate practices to improve the effectiveness of supported solutions.
What You'll Bring
- Advanced software engineering and analytical problem-solving capabilities, with demonstrated experience designing and delivering complex data engineering and business intelligence solutions.
- Strong business acumen, including the ability to understand business processes, operational objectives, performance measures, and the role of data in supporting business decisions.
- Demonstrated ability to translate ambiguous or complex business requirements into well-defined technical specifications, solution designs, and implementation approaches.
- Ability to independently evaluate complex technical problems, assess alternative solutions, and exercise sound judgment in determining appropriate engineering approaches.
- Strong understanding of the relationship between data architecture, business processes, reporting requirements, and downstream system dependencies.
- Demonstrated ability to identify underlying business needs, challenge assumptions constructively, and recommend solutions that address broader requirements.
- Ability to independently own complex technical assignments from requirements analysis through solution delivery, troubleshooting, and ongoing optimization.
- Strong analytical reasoning and attention to detail, particularly when investigating data quality, system performance, and integration issues.
- Ability to communicate technical recommendations, risks, and tradeoffs effectively to both technical and nontechnical stakeholders.
- Demonstrated ability to collaborate across teams, influence technical decisions, and provide guidance on complex engineering challenges without formal management authority.
- Strong organizational skills and the ability to balance competing priorities while maintaining solution quality and delivery commitments.
- Commitment to continuous improvement, engineering best practices, and the development of scalable, sustainable technical solutions.
Technical & Systems Proficiency
- Advanced proficiency required:
- Microsoft SQL Server, including advanced T-SQL development, stored procedures, functions, views, query optimization, and performance tuning.
- SQL Server Integration Services (SSIS), including the design, development, maintenance, and optimization of complex ETL processes.
- Data warehouse design principles, dimensional modeling, data integration, and analytical data structures.
- Relational database architecture, database programming, and data transformation methodologies.
- OLAP and OLTP concepts and their application in enterprise data environments.
- Complex data troubleshooting, root-cause analysis, and performance optimization.
- Software engineering principles, solution design, testing, deployment, and production support.
- Strong working knowledge required:
- SQL Server Analysis Services (SSAS), including multidimensional modeling, processing, and performance optimization.
- SQL Server Reporting Services (SSRS) and Power BI reporting solutions, including development, deployment, troubleshooting, and optimization.
- DAX and MDX concepts used in analytical and reporting environments.
- Visual Studio, SQL Server Management Studio, and Microsoft Power BI Desktop.
- Source control, automated testing, deployment processes, and software development lifecycle practices.
- Azure DevOps and CI/CD concepts, including YAML-based pipelines.
- Data validation techniques and approaches to ensuring reporting accuracy and consistency.
- Additional experience preferred:
- Biml for ETL development, automation, and maintainability.
- Microsoft Fabric and modern cloud-based data integration and analytics capabilities.
- Snowflake or comparable cloud data platforms.
- Node.js, TypeScript, YAML, and related integration technologies.
- Model Context Protocol (MCP) services or comparable modern integration capabilities.
- AI-assisted engineering tools such as GitHub Copilot, Cursor, Claude Code, or comparable platforms.
- Experience supporting data solutions used in finance, economics, operational analytics, or other business-critical reporting environments.
- Typically 8+ years of relevant professional experience with a bachelor's degree, or six or more years with a master's degree, or an equivalent combination of education and experience, consistent with the IC4/P4 level framework.
- Demonstrated experience designing, developing, and maintaining complex software engineering, data integration, or business intelligence solutions.
- Significant hands-on experience with Microsoft SQL Server and SSIS in enterprise data environments.
- Experience translating complex business requirements and operational context into technical solutions that support business processes and reporting needs.
- Demonstrated experience independently evaluating technical alternatives, solving complex engineering problems, and delivering maintainable solutions.
- Experience collaborating directly with business stakeholders and cross-functional technology teams to define requirements, evaluate solutions, and resolve technical challenges.
- Experience contributing to platform improvements, engineering standards, or technical guidance within a software engineering or data-focused environment.
- Experience with business-critical reporting systems, data warehouse environments, or enterprise analytical platforms preferred.
- Background knowledge in finance, economics, statistics, mathematics, or related business disciplines is advantageous.
Language Skills
- Strong written and verbal English communication skills.
- Ability to communicate complex technical concepts, solution alternatives, and engineering tradeoffs clearly to technical and nontechnical stakeholders.
- Ability to facilitate requirements discussions, clarify business needs, and document technical recommendations effectively.
- Ability to collaborate with cross-functional and geographically distributed teams.
AI Skills and Experience
- Demonstrated proficiency using AI-assisted software engineering tools, such as GitHub Copilot, Cursor, Claude Code, or comparable platforms, to enhance development efficiency, code quality, troubleshooting, and technical documentation.
- Ability to independently evaluate and apply AI-assisted development capabilities to complex software engineering, SQL development, ETL design, and data integration challenges.
- Experience leveraging AI tools to accelerate code development, refactoring, debugging, test creation, and performance optimization while maintaining accountability for technical accuracy, reliability, and maintainability.
- Ability to critically assess AI-generated outputs, identify inaccuracies or potential risks, and apply sound engineering judgment to validate solutions before implementation.
- Understanding of how AI capabilities can support business and technical problem-solving, including identifying opportunities to improve data workflows, automation, and engineering productivity.
- Ability to evaluate emerging AI technologies and recommend practical applications based on business needs, technical feasibility, and measurable value.
- Knowledge of responsible AI usage, including data security, confidentiality, intellectual property considerations, and compliance with organizational engineering standards.
- Ability to share effective AI-assisted development practices with peers and contribute to the adoption of AI-enabled engineering workflows within the team.
Education/Certifications
Bachelor's degree in Computer Science, Software Engineering, Information Technology, Mathematics, Statistics, or a related technical discipline, or equivalent practical experience.
EEOC Statement
Allvue Systems provides equal employment opportunities (EEO) for all employees and applicants for employment. We recognize the real value of bringing people together from diverse backgrounds, experiences and perspectives - we don’t just accept difference, we celebrate and support it. We are committed to advancing these efforts through our strategies to hire, promote, create and support a diverse and inclusive environment throughout our workforce and workplace. It is our policy to prohibit discrimination and harassment of any type without regard to race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law. In addition, Allvue will provide reasonable accommodations for qualified individuals with disabilities.