Snowflake Engineer Job at Openkyber, North Carolina

  • Openkyber
  • North Carolina

Job Description

Title- :

Technical Business Analyst ( 2 Positions ) Location- Hybrid in Dallas, TX ( 3 days a week Onsite ) Duration- 6-12 Months ( W2/Hour Only ) VISA- USC/EAD Only

JD: 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 Skills:

SQL (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 Skills:

Experience in UAT planning, test case creation, execution, and defect management .

C. Reporting Skills:

Ability to reverse engineer reports, define KPIs, and validate reporting outputs.

D. Functional Expertise:

Fund accounting knowledge , including GL, TB, COA, and financial reporting.

E. Soft Skills:

Strong communication, stakeholder management, detail orientation, and ability to work across business and technology teams.

Key deliverables The key deliverables expected from the Business Analysts during the project include test cases, defect logs, report specifications, validation outputs, and reconciliation reports.

Testing and documentation process 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.

Data validation and reconciliation 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.

Defect management 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.

Training and onboarding 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.

Thanks & Regards OpenKyber

Address: 30 N Gould St., Ste N. Sheridan, WY 82801 Mob: +1 |Extn: 107 Web:-

We should not judge people by their peak of excellence; but by the distance they have traveled from the point where they started.

For applications and inquiries, contact:hirings@openkyber.com

Job Tags

3 days per week

Similar Jobs

Gpac

Food Quality and Safety Manager Job at Gpac

A growing, well-established food manufacturer is adding a Quality & Food Safety Manager to its plant leadership team. This role owns site-level food safety, quality assurance, and regulatory compliance programs, and will lead both direct and indirect QA staff. This is... 

Confidential

Accounts Payable Specialist Job at Confidential

 .... This role requires proficiency in data entry, familiarity with SAP for processing vendor...  ...reports. Verify invoices for proper coding, approvals, documentation, and compliance...  ...of experience: 1 year Experience level: Entry Level Randstad is a world leader... 

LTC Language Solutions

American Sign Language (ASL) Interpreter - Nashville, TN Job at LTC Language Solutions

 ...Description LTC Language Solutions is looking for skilled American Sign Language (ASL) Interpreters in the Nashville area. Here is what you get to do: Provide high-quality, in-person sign language interpretation at various client locations in and around Nashville... 

ESR Healthcare

Treasury Analyst Job at ESR Healthcare

 ...special projects as needed Requirements Bachelor's degree in Finance, Accounting, Economics, Statistics, or a related field MBA or other advanced degree preferred 3+ years of experience in financial analysis, treasury, FP&A, or corporate finance Advanced Excel... 

Aveanna Healthcare

Home Care Nurse (RN) Job at Aveanna Healthcare

 ...Join a Company That Puts People First! Registered Nurse RN We are one of the largest private duty nursing companies in the nation and growing! At Aveanna, were proud to foster a workplace culture that celebrates diversity, encourages connection, and supports our...