Business/Systems Analyst

Location: 100% remote




ETF has an immediate opening for a Business/Systems Analyst to participate in its Data Management Program. Data is one of its most valuable assets, and ETF strives to become a more data-literate and data-driven organization. This position works on a small, collaborative team using agile practices to deliver value to business partners. Strong analytical and problem-solving skills, critical thinking, and the ability to identify innovative solutions are essential.
The manager seeks reporting and data warehouse requirements development experience and source-to-target mapping. Candidates must be able to write SQL and have excellent oral and written communication skills. This is a true new need; the manager requested one top-qualified candidate per vendor.

Mandatory SKILLS

• Experience as a Business Analyst — 5+ years (RAW formal Required Skills list).
• Develop complex SQL — 5 years (RAW formal Required Skills list and Top Required Skills). Candidates MUST know SQL.
• Education: Bachelor's degree

• Security: Must satisfy the stated security requirement for a role with FTI access; the sources do not specify a clearance type or detailed screening standard.

• SQL capability; 5 years each in complex SQL, S2T/data integration, requirements/user stories, technical specifications, and root-cause/complex-data analysis;
• 2 years in testing/reconciliation/UAT;
• 5+ years as a Business Analyst. These come from R formal Required/Top Required.
• Excellent oral and written communication is a manager requirement.

Additional Top Required Skills from the RAW posting, also listed as Desired Experience in the client job description:

• Serve as a liaison between business and technical staff to design and implement efficient data integration processes; create and maintain source-to-target (S2T) documentation — 5 years.
• Gather requirements and develop user stories — 5 years.
• Translate business requirements into technical specifications — 5 years.
• Perform systems root cause analysis and analyze complex datasets to identify patterns, trends, and insights — 5 years.
• Plan and execute rigorous testing for system functionality, performance, and reliability; reconcile data and analyze results; conduct user acceptance testing and collaborate with stakeholders to resolve issues or defects — 2 years.

NICE TO HAVE SKILLS

• Experience with data quality tools and frameworks.
• Perform gap analysis and cost-benefit analysis.
• Mentor and train users on business and systems analysis methodology.
• Experience with business intelligence platforms.
• Experience with data governance, including security and privacy policies.
• Elicit and refine requirements for dashboards.
• Strong understanding of different types of data models.
• Create comprehensive documentation, including system requirements, design specifications, and user manuals; conduct training sessions and workshops on system functionality and best practices.
• Manage multiple concurrent projects and tasks.
• Strong interpersonal skills, including communication, mentoring, collaboration, and team building.

The first two items appear in the RAW formal Preferred Skills list; all ten appear in its Nice to Have list and in the client's Desired Experience section.

ADDITIONAL DETAILS

• ETF technologies: Jira, SharePoint, Teams, Alteryx, SSIS, SSRS, SSMS, Squirrel, SQL Server, Tableau, Semarchy, and Git & GitHub. These are listed as the technology environment; neither source assigns a mandatory tenure to individual products.

Candidate Evaluation — Prioritized Skill Baseline
1. Complex SQL development — Critical / Primary; weight 3. 5 years; R formal Required + Top Required and manager emphasis; C Desired Experience. Hands-on SQL is explicit and indispensable.
2. Source-to-target mapping and data integration analysis — Critical / Primary; weight 3. 5 years; R Top Required + manager emphasis; C Desired Experience. Includes business/technical liaison and maintained S2T documentation.
3. Reporting and data warehouse requirements development — Critical / Primary; weight 3. R manager emphasis; C Data Management Program context. No separate tenure specified.
4. Requirements elicitation and user stories — Critical / Primary; weight 3. 5 years; R Top Required; C Desired Experience.
5. Business requirements translation into technical specifications — Critical / Primary; weight 3. 5 years; R Top Required; C Desired Experience.
6. Systems root cause analysis and complex data analysis — Critical / Primary; weight 3. 5 years; R Top Required; C Desired Experience. Includes patterns, trends, and insights.
7. Data reconciliation, system testing, and user acceptance testing — Required / Supporting; weight 3. 2 years; R Top Required; C Desired Experience. Covers functionality, performance, reliability, and defect resolution.
8. Business analysis practice — Required / Supporting; weight 3. 5+ years; R formal Required. Evaluate breadth of BA responsibility without duplicating the specific deliverables scored above.
9. Oral and written communication and stakeholder collaboration — Critical / Primary; weight 3. R manager requires excellent communication; R Nice to Have and C Desired Experience also list interpersonal skills. Includes team building; no tenure specified.
10. Analytical problem solving and critical thinking — Required / Supporting; weight 3. R/C job description explicitly says must have; includes innovative solutions. No tenure specified.
11. Data quality tools and frameworks — Preferred / Differentiating; weight 1. R formal Preferred + Nice to Have; C Desired Experience.
12. Data modeling concepts — Preferred / Differentiating; weight 1. R Nice to Have; C Desired Experience. Understanding different data model types.
13. Business intelligence platforms — Preferred / Differentiating; weight 1. R Nice to Have; C Desired Experience.
14. Dashboard requirements elicitation and refinement — Preferred / Differentiating; weight 1. R Nice to Have; C Desired Experience. Keep dashboard-specific evidence distinct from general requirements.
15. Data governance, security, and privacy — Preferred / Differentiating; weight 1. R Nice to Have; C Desired Experience.
16. Gap analysis and cost-benefit analysis — Preferred / Differentiating; weight 1. R formal Preferred + Nice to Have; C Desired Experience.
17. User documentation, training, and mentoring — Preferred / Differentiating; weight 1. R Nice to Have; C Desired Experience. Includes user manuals, workshops, system best practices, and analysis methodology; technical specifications are covered above.
18. Concurrent project and task management — Preferred / Differentiating; weight 1. R Nice to Have; C Desired Experience.
19. Agile team delivery — Preferred / Differentiating; weight 1. R/C team context; inferred differentiator, not a formal required or preferred qualification.
20. ETF technology environment familiarity — Preferred / Differentiating; weight 1. R/C ETF Technologies: Jira, SharePoint, Teams, Alteryx, SSIS, SSRS, SSMS, Squirrel, SQL Server, Tableau, Semarchy, Git & GitHub. One environment-familiarity item; no individual product gate or separate product weights.
Source classification differences: The client labels all experience Desired, whereas the RAW elevates six areas to Top Required and separately lists Business Analyst experience and SQL as formal Required. Retain the RAW screening thresholds while preserving the client labels. Communication is a manager must-have despite appearing in the preferred interpersonal list. The VMS title differs from the client's Business/Systems Analyst title; both describe this requisition. No conflicting remote-work requirement was found.


Skill Equivalency Guidance

• Accept evidence of equivalent work outcomes and artifacts despite different job titles: field-level mapping, transformation rules, integration specifications, reporting requirements, reconciliation, test cases, and acceptance criteria.
• Equivalent database or analytics products can demonstrate transferable SQL, BI, data quality, modeling, or integration skills. Product familiarity does not substitute for demonstrated hands-on SQL or required experience thresholds.
• Neither source requires every listed ETF product. Assess tool transferability separately from direct environment familiarity; do not invent mandatory certifications or product-specific tenure.
• Use distinct evidence for overlapping skills and avoid counting one generic statement repeatedly. For grouped skills, record which components are supported and which remain unverified. Do not infer missing experience or silently waive a gate.