Title: Business System Analyst
Location: Hybrid, Troy, Michigan (Local DL To MI)
Duration: 6+ Months
MOI: Phone then Video
Visa: No H1B
Full education info in resume is must
LinkedIn is must
Experience Level 5-10 years
Skills & Job Responsibilities
- Works with businesses to identify ways to improve process execution and achieve strategy through the use of technology.
- Evaluates the overall business need and assists with design and implementation to ensure solutions achieve overall business objectives.
- Develops a roadmap for meeting the short-and-long term objectives.
- Acts as a primary member of the project team, overseeing and documenting decisions that occur throughout the project lifecycle.
- Elicits specific requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, use cases, scenarios, business process analysis and task and workflow analysis.
- Writes requirements and translates specifications to technical experts.
- Serves as the liaison between the customer community (internal and external customers) and the software development team through which requirements flow.
- Identifies potential technical problems before they occur and helps implement solutions by thoroughly validating all system changes relative to assigned work.
- Works with the business technology team as an advocate of the business unit supported.
- Critically evaluates information gathered from multiple sources, reconciles conflicts and distinguishes user requests from the underlying true need.
- Serves as the liaison between the data warehousing team and IT community banking team.
- Identifying the data patterns and trends from bank’s servicing systems that are available in Data Warehouse and propose solutions for the best use of these available data sets, using Informatica Cloud components.
- Develop various batch jobs using Informatica Cloud to automate the flow of data into Salesforce and apply data mining techniques on the unstructured data available in the Data Warehouse to identify meaning patterns and structure the data into Salesforce. Documents technical information, project information and develops training material. Writes and executes test scripts.
- Collaborates on tasks with project team members with clear deliverables and expected time frames.
- Follows up on progress of tasks.
- Maintains accountability for all items.
- Utilizing Data Integration component to create synchronization tasks and saved queries to run the batch jobs. Using mapping component, create mappings for the data migration to target Salesforce objects.
- Arranging schedules to the daily batch jobs in Informatica Cloud, Administrator component.
- Monitors progress of project and works to overcome challenges. Influences others to achieve project results.
- Escalates issues when necessary. Researching on the data architecture used in the data warehouse and decide if the new data components can increase the commercial banking system’s efficiency and effectiveness based on in-depth knowledge of digital systems and commercial banking process. Ensure compliance with applicable federal, state and local laws and regulations. Complete all required compliance training.
- Maintain knowledge of and adhere to Flagstar's internal compliance policies and procedures.
- Take responsibility to keep up to date with changing regulations and policies.
Job Requirements:
- Bachelor's Degree in Computer Science, Mathematics or related field plus 3+ years of Business Analyst experience working on moderate to complex IT Projects – OR - 10 years comparable work experience Salesforce, nCino and Informatica ETL experience is a must
- Experience collecting and documenting user stories, use cases business requirements and acceptance criteria across multiple process areas and disciplines including business process, controls, system requirements, data conversion, analytics, and reporting
- Experience refining user stories, use cases and detailed requirements in collaboration with IT developers
- Experience decomposing as-is and to-be correspondence that will be developed in modernized applications (including mapping to multiple source systems, inputs, outputs, and integration points)
- Experience identifying and documenting all regulatory and/or risk related requirements
- Demonstrated analytical skills and technical acumen: baseline knowledge of how software systems and application components work together, effective at communicating architectural and software development considerations
- Ability to think through workflows and the characteristics that make each workflow different Strong communication and partnership skills; able to collaborate through complex problems or challenge assumptions giving and receiving feedback respectfully to Business Product Owners and other development teams Ability to communicate verbally and in technical writing to all levels of the organization in a proactive, contextually appropriate manner Experience working on project teams, experience working in an Agile/Scrum environment is preferred
- Experience with agile ceremonies such as standups, story estimation, backlog grooming, sprint retrospective is preferred
- Ability to effectively work with employee and external partner resources, both on-shore and off-shore Demonstrated success working under pressure in a fast-paced, cross-functional environment
- Strong organizational skills Good understanding of relational databases, star schemas, data marts and data warehouses
- Experience writing queries (SQL and PL/SQL) using Toad or similar tool is preferred
- Good understanding of data modeling Experience using Visio, PowerPoint, Excel to document data models, work flows, user requirements, business logic, calculation rules and data mapping
- Experience with designing reports, dashboards, scorecards, and wireframes Some experience building, writing and executing test cases using technologies such as JIRA / Confluence (Selenium, LoadRunner, is a plus)
Thank You!
Udit Dabas| Sr. Technical Recruiter
D: 215-278-8860| E: udit.dabas@firstringsolutions.com
First Ring Solutions LLC | Philadelphia, PA 19102