About the company

Consilio stands as the global leader in eDiscovery document review flexible legal talent and legal advisory & transformation consulting services. With its Consilio Complete suite of capabilities the company empowers multinational law firms and corporations using innovative software cost-effective managed services and deep legal and regulatory industry expertise.

Position Summary

We are seeking a highly analytical and detail-oriented Business Systems Analyst to support our enterprise data warehouse (SQL Server) payroll CRM HR and other enterprise applications. This role will bridge the gap between business needs and technical solutions ensuring data integrity process efficiency and successful delivery of technology initiatives.

Business Analysis & Requirements Gathering

• Collaborate with stakeholders to gather analyze and document business requirements.
• Translate business needs into detailed functional and technical specifications.
• Support the creation and maintenance of JIRA stories epics and tasks with clear acceptance criteria for development teams.

Data & Systems Analysis

• Perform data analysis using SQL to support business decisions and validate data warehouse outputs.
• Understand and document data flows between systems such as our payroll HR CRM and other platforms.
• Identify data quality issues and work with technical teams to resolve them.

Documentation & Communication

• Collaborate with the technical writer to create and maintain comprehensive documentation including: BRDs functional specs process flows and user guides.
• Facilitate meetings workshops and presentations to communicate findings and recommendations.

Project & Agile Support

• Act as a liaison between business users and technical teams throughout the project lifecycle.
• Participate in Agile ceremonies (stand-ups sprint planning retrospectives).
• Support UAT planning execution and defect tracking.

Continuous Improvement

• Identify opportunities to improve business processes and system functionality.
• Recommend enhancements based on data insights and stakeholder feedback.

Required Qualifications

• Bachelors degree in Business Information Systems Computer Science or related field.
• 3 years of experience as a Business Analyst in a technical environment.
• Strong SQL skills and experience working with SQL Server databases.
• Familiarity with payroll systems or similar HRIS/ERP platforms.
• Experience writing JIRA stories and managing Agile workflows.
• Excellent analytical problem-solving and communication skills.

Preferred Qualifications

• Experience with data warehousing concepts and ETL processes.
• Knowledge of reporting tools (e.g. Power BI Tableau).
• Understanding of payroll HR or financial business processes.
• Experience with Confluence or similar documentation tools.

Soft Skills

• Strong attention to detail and organizational skills.
• Ability to work independently and manage multiple priorities.
• Collaborative mindset with a proactive approach to problem-solving.

Why Join Us:

• Be part of a collaborative and innovative work environment.

• Opportunity for professional growth and development.

• Competitive salary and benefits package.

• Contribute to shaping the future of our software development processes.

Consilios True North Values

Excellence -We strive to make every client our advocate

Passion -We DO because we CARE.

Collaboration -We win together through teamwork and communication.

Agility -We flex adapt and embrace change.

People -We value respect and invest in our teammates.

Vision -We create clarity of purpose and a clear path forward.