Publicis Sapient is looking for two Business Analysts to support business testing and validation, moving from Yardi-based reporting to a Snowflake reporting environment. The role involves creating and executing test cases, rebuilding reports, validating and reconciling data across systems, and working with stakeholders to ensure a smooth go-live with minimal defects and complete validation sign-offs.
A. Technical SkillsSQL (mandatory), exposure to Snowflake a plus. Python for data validation and automation (mandatory), familiarity with code-based BI tools (like Streamlit) preferred, or experience building BI tools using Power BI or Tableau. The more proficient in Excel the better.
B. Testing SkillsExperience in UAT planning, test case creation, execution, and defect management.
C. Reporting SkillsAbility to reverse engineer reports, define KPIs, and validate reporting outputs.
D. Functional ExpertiseFund accounting knowledge, including GL, TB, COA, and financial reporting.
E. Soft SkillsStrong communication, stakeholder management, detail orientation, and ability to work across business and technology teams.
Key deliverables expected from the Business Analysts during the project include test cases, defect logs, report specifications, validation outputs, and reconciliation reports.
Business Analysts will develop test cases and support user acceptance testing (UAT) execution. They will validate outputs across Yardi and Snowflake, track defects, and support business sign-off. The process includes analyzing existing Yardi reports, documenting logic, defining future-state Snowflake reporting requirements, and validating rebuilt reports. They will also perform reconciliation between Yardi, Investran, and Snowflake, validate trial balances, and report outputs. Documentation will include test cases, defect logs, report specifications, validation outputs, and reconciliation reports.
Business Analysts will need to access Yardi, Investran, and Snowflake systems for data validation and reconciliation. The criteria for success include successful testing completion, accurate report rebuilds, minimal defects at go-live, and complete validation sign-offs.
Defects will be tracked and managed through a structured process involving defect triage, retesting coordination, and maintaining detailed defect logs. This approach ensures that defects are identified, prioritized, and resolved efficiently during the testing phase.
Business Analysts will receive guidance and some training to familiarize themselves with the existing systems, such as Yardi, Snowflake, and Investran, to effectively perform their roles.
For applications and inquiries, contact:hirings@openkyber.com
...care. Oversee schedules. Lead our Team of Stylists. Job requirements: Cutting Position on Floor. Desire to create great salon culture. Good Communication. Compensation: $65,000-70,000 Come meet our Salon team and be one of the GREATS!! Call Ann to...
...presenting varying challenges and scope. Every experience is an opportunity to learn and grow. You... ...at the time of application. Winter internships typically occur during the spring... ...preceding the students final year of school. Summer internships typically take place during...
...provider is seeking professional translators to translate foreign medical documents. The ideal candidates will have excellent... ...and meeting deadlines. This contract position offers flexible work-from-home options. Candidates must have a BA/BS degree and 1-3 years of...
...Elevator Worker (1st Shift) - Creve Couer, ILThis is a full time, hourly position.Job Responsibilities:Dumping or loading trucksBarge deckhand dutiesOperate Power Industrial EquipmentAssist with grain handlingGeneral housekeeping dutiesGeneral maintenance, as neededJob...
...Job Title: Transaction Coordinator Location: Onsite daily Midtown, NYC Firm Overview: Newmark Group, Inc. (Nasdaq: NMRK), together with its subsidiaries (Newmark), is a world leading commercial real estate advisor and service provider to large institutional...