Professional Resource Group, LLC is a staffing agency specializing in technical and administrative professionals. They are seeking an Associate Business Systems Analyst who will be responsible for understanding case requirements and translating them into technical specifications for developers, ensuring data integrity throughout the lifecycle of class actions and similar matters.
Responsibilities:
- Understand the entire lifecycle of a class action or similar matter, determine what data is required based on functional requirements, and define how that data and business rules will translate to internal applications
- Develop and publish technical specifications, technical requirements, and other documentation, as required
- Design data mappings and transformations which will be used to drive ETL procedures
- Work with QC Analysts to design testing strategies and plans to ensure all outcomes are as expected
- Using tools such as Excel, Access, SQL Server, and others, directly query, assess, and analyze data to ensure requirements are being met
- Serve as liaison between Client Services (business) and Data Analysts (technical) teams to keep production work flowing smoothly
- Work with Technical Project Managers to ensure all required steps and actions are captured in project plans, and that project timelines seem reasonable
- Lead, conduct, or consult in user acceptance test exercises to ensure results are acceptable and meet requirements
- Follow prescribed software development standards, processes, procedures, methodologies, etc., according to departmental policies and conventions
- Interact and correspond professionally with team members, project management, clients, and other stakeholders
- Account for and accurately log time against project work
Requirements:
- Working knowledge of SQL - The candidate would ideally have enough familiarity to understand query logic, data structures, and work effectively with developers in a data-heavy environment, but does not need to be an expert. Pseudocode proficiency is also acceptable
- Requirements gathering and critical thinking - the ability to translate vague or sometimes complex business rules into clear, actionable technical requirements. The ideal candidate should be comfortable asking clarifying questions and identifying dependencies or edge cases early
- Communication and stakeholder management - the ability to explain technical concepts to non-technical stakeholders, confidence in pushing back diplomatically, comfort facilitating meetings and aligning multiple teams
- Attention to detail and process discipline - given the legal and compliance aspect of our work, we'd hope the candidate would be able to notice inconsistencies quickly, double-checks assumptions, writes requirements precisely
- Four-year college degree or equivalent industry experience
- Experience as Business Analyst, Data Analyst, Process Specialist, or other role where business functional requirements are captured and decomposed
- Proficient with MS Office tools, particularly Excel
- Experience with relational databases and ability to comprehend moderately complex SQL logic desired
- Ability to work in an environment with immediate deadlines and shifting priorities
- Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluent in English
- Basic understanding of data modeling and data organization desired
- Basic understanding of and experience with extract, transform, load (ETL) concepts, tools, and practices desired