Technical Business Analyst

Technical Business Analyst

Location: Dallas, TX (Onsite 3 days per week)
Duration: 8 10 Months
Interview: Virtual round

Ideal Candidate Profile

• Must be local with DL copy
• LinkedIn with location (before 2022)
• Recent or recent second project must be at the current location

Job Summary

Our client is seeking an experienced Technical Business Analyst to support business testing, data validation, and reporting activities for a project transitioning from Yardi-based reporting to a Snowflake-driven reporting environment. The ideal candidate will have strong SQL and Python skills, experience with UAT, financial reporting, and data reconciliation across multiple systems. The role involves analyzing existing reports, documenting reporting logic, developing and executing test cases, validating rebuilt reports, and collaborating with business and technology teams to ensure a successful go-live with minimal defects.

Required Skills and Qualifications

• Strong hands-on experience with SQL for data analysis, validation, and reconciliation.
• Practical experience using Python for data validation and automation.
• Exposure to Snowflake is preferred.
• Experience with UAT planning, test case creation, execution, and defect management.
• Experience with reporting tools such as Power BI, Tableau, or Streamlit.
• Strong proficiency in Microsoft Excel for data analysis and reconciliation.
• Ability to reverse engineer reports, define KPIs, and validate reporting outputs.
• Knowledge of fund accounting and financial reporting concepts, including GL, TB, COA, and financial statements.
• Experience with Yardi and/or Investran is preferred.
• Excellent communication, analytical, documentation, and stakeholder management skills.
• Ability to work effectively with both business and technical teams.

Key Deliverables

The candidate will be responsible for delivering test cases, test execution results, defect logs, report specifications, data validation outputs, reconciliation reports, and UAT sign-off documentation. Success will be measured by accurate report reconstruction, successful testing completion, reliable data reconciliation across systems, minimal defects at go-live, and complete business validation sign-offs.