What are the responsibilities and job description for the Business System Analyst position at United Software Group?
Hope you are doing well.
Position : Business System Analyst
Location : Mount Laurel, NJ (Hybrid)
Duration : Fulltime
Job description :
Skills required : Data warehousing, data analysis, ETL, SQL, spark SQL, data mapping
Pyspark and data bricks
Experience in AML / Banking / Capital Market (Any banking domain)
Experience with Agile methodology - Plan, develop, test and deploy
Experience with SQL server management tools and writing queries, with large SQL data marts, relational database experience.
Profile data and prepare source to target mappings, map source data to the target tables for the multi hop architecture.
Closely working with data modelers, data engineers and architect and product owners to identify any discrepancies and get it resolved.
Strong knowledge of data extraction, design, load, and reporting solutions, strong ability to read SQL server SSIS packages, SQL stored procedures / functions and back trace views
Work in the team of data designer / developer to translate user and / or systems requirements into functional technical specifications.
Work with business stakeholders and other SMEs to assess current capabilities, understand high-level business requirements and apply technical background / understanding in the development of System Requirements Specification (SRS) documents.
Collaborate closely with Application Owners, Application Managers, and Solution Designers as the business / functional counterpart in solution identification and maintenance.
Support testing teams in translating requirements and use cases into test conditions and expected results for product, performance, user acceptance, and operational acceptance testing; participate in the testing of developed systems / solutions.
Act as a technical resource for business partners to ensure deliverables meet business and end-user requirements.
Identifying the source data / source tables as per project specific use case and get that ingested into source raw zone.
Raise Data access control requests and make source data available in analytical zone for data profiling and data analysis.
Understanding the existing codes and data bricks workflows and leverage that for our use case.
Thanks & Regards,
Ranjith Kumar Vemula
Account Manager
Phone : 614-588-8525 / 614-495-9222 Ext : 261 | Fax : 866-764-1148
Email ID : Ranjith.vemula@usgrpinc.com
