Business Systems Analyst - EDW

Job Description

The role is for a Lead Business Systems Analyst in an Enterprise Data Warehouse (EDW) environment. The role involves developing solutions that enable the business to leverage data as a key asset. The Lead Business Systems Analyst will work with business units to understand needs, document technical requirements, and manage the product backlog. Key technologies used include Snowflake, DataStage, Python/PySpark, Infogix, and Tableau.

• Serve as a liaison and knowledge source for stakeholders, the product owner, and team members.
• Operate within an Agile framework to develop Features and User Stories with the team.
• Collaborate with the Agile team, Product Owner, and business stakeholders to gather and facilitate requirements, including documenting source-to-target data mappings.
• Work with the Product Owner and other subject matter experts to refine Epics, leading to the creation of Features and User-Stories.
• Facilitate backlog refinement sessions to detail user stories, define acceptance criteria, and establish story points with team members.
• Participate in the identification, quantification, and mitigation of project risks and issues.
• Work with Application Business Systems Analysts to identify and escalate impediments to the Scrum Master.

Requirements

• A Bachelor's Degree is required.
• 7+ years of experience as a Business Systems Analyst in a Data Warehouse environment is required.
• 3+ years of experience using SQL to create ad-hoc queries and analyze data is required.
• 5+ years of experience in the financial services or banking industry.
• 5+ years of experience with Snowflake and AWS S3.
• 5+ years of experience with data modeling activities in Erwin or other modeling tools.
• 5+ years of experience with enterprise data warehousing best practices and standards.
• 5+ years of data mapping experience, creating source-to-target mappings.
• Strong organizational, analytical, and problem-solving skills.
• Ability to effectively prioritize and execute tasks while handling multiple projects.
• Excellent verbal and written communication skills.
• Experience leading other Business Systems Analysts on a project team.

Benefits

Everforth Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Everforth Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Everforth Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Everforth Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our ‘Welcome Packet’ as well, which an Everforth Apex team member can provide.

About the Role

This is a hybrid role. The candidate will need to be located in Columbus, Ohio, and is expected to work in the office a minimum of four days each week.

Pay

Pay: 60-70/hr W2 contract

Schedule

This is a hybrid role. The candidate will need to be located in Columbus, Ohio, and is expected to work in the office a minimum of four days each week.