Business System Analyst (advanced SQL concept)

Job Title: Business System Analyst (advanced SQL concept)

Location: Phoenix, AZ

Employment Type: Full-time

Job Description:

Experience Required - 8+ years

Must Have Technical/Functional Skills

• BigQuery , SQL

Roles & Responsibilities

• Finance process analysis
• Perform data mapping and map gap analysis and develop source to target mapping documents for credit card data products
• Work with stakeholders within and outside of Finance to analyze and document their process requirements in terms of data, required transformations, and reporting/analytical output
• Participate in development of plans and strategies, best practices, and standards related to data management processes, data products, data security and programs
• Create features for ongoing sprints and manage a prioritized list of data requirements / user stories
• Document processing requirements, including data and transaction volumes, scalability, security and performance requirements

Solution Design:

• Work with Technology, Finance partners, source system owners, and other stakeholders to locate the data required by Finance and ensure the data architecture design supports Finances accounting, reporting and analytics requirements
• Document future state Finance processes for data acquisition, enrichment, provisioning, and reporting
• Identify opportunities to adopt innovative technologies

Build/Deployment:

• Work with Technology, Finance partners, source system owners, and other stakeholders, to deploy solutions across the appropriate Finance user base
• Build, test, and deploy solutions to acquire, enrich and provision the required data and ensure data integrity, accuracy, and completeness
• Perform data validation as part of Finance user testing as needed.
• Lead the creation and execution of systems integration and pre-user acceptance testing plans and test cases

Data Controls and Ongoing Production Support

• Design and build ongoing data process controls by collaborating with Technology and Data Governance as needed
• Investigate data anomalies and research ad-hoc data inquiries as part of ongoing production support