As a Business Analyst you will perform requirement gathering and analysis, data analysis, data mapping, functional design, quality assurance/Testing and documentation for ETL related projects. The individual will be working closely with ETL Leads, Solution Consultants and testing team.
Perform requirement gathering and analysis of applications and their business processes.
Performs analysis that is diverse and very complex and works independently under general direction (i.e. writing queries).
Perform Data Analysis, develop Data Mapping and Functional Solution Design documents for ETL projects.
Works with Development Team to ensure feasibility of design and clarify user requirements.
Capture business rules and build physical design document to meet user requirements.
Work with Data Modelers and DBA to create/update table structures.
Understand and Interpret Logical design document and Data Model diagrams to understand requirements to build physical design document.
Effectively communicate the functional design to developers and confirm the same with solution design team.
Develops test scenarios and scripts that match the business user's objectives to confirm system functions are met.
Work with Development and Testing team to support testing activities.
Qualifications:
Typically requires a minimum of 3-5 years of related experience or equivalent combination of education and experience.
High School Diploma Required
strong knowledge and experience in Foundation Systems (Membership System for CA regions)
Candidate must have hands on experience in Mainframe and Oracle technologies
Candidate must have strong knowledge and experience in interpreting user requirements and building Physical Solution Design Document.
Candidate must have good knowledge and experience in understanding logical mapping and data model to build Physical Design document.
strong knowledge and experience in Data Warehousing (ETL, Data Analysis, etc) concepts.
strong intuitive and analytical problem solving skills.
Good understanding on testing principles, concepts and tools. Advanced working knowledge of Testing, Business Analysis techniques and tools.
Should have ability to write and execute complex SQL Statements especially in Oracle Environments.
Expertise with Defect Management Tools preferably Mercury Tools preferred.
Good understanding and experience in writing test cases/plans, executing test cases & identifying defects.
Sound knowledge and experience in Oracle, and Mainframe systems.
Top 3-5 Daily Responsibilities:
Documenting design and data mapping for dashboards and reports
Building prototype dashboards in Tableau/Power BI/Excel
Document and create data summarization and or transformation tasks in Alteryx/Excel as needed for design
Top 3-5 Required Skills:
MS office suite, data mapping, business rule definition
Dashboard creation in in Tableau, Power BI or other tools
3MS Visio, MS project plan
Desired Skills:
Data Science skills, statistical modeling
PM in agile methodology
Predictive analytics
Soft Skills:
Good verbal, written communication skills
Collaborate well with distributed team structure
Work well under pressure
location: Burbank, California
job type: Contract
salary: $50.54 - 56.86 per hour
work hours: 8am to 5pm
education: High School
responsibilities:
As a Business Analyst you will perform requirement gathering and analysis, data analysis, data mapping, functional design, quality assurance/Testing and documentation for ETL related projects. The individual will be working closely with ETL Leads, Solution Consultants and testing team.
Perform requirement gathering and analysis of applications and their business processes.
Performs analysis that is diverse and very complex and works independently under general direction (i.e. writing queries).
Perform Data Analysis, develop Data Mapping and Functional Solution Design documents for ETL projects.
Works with Development Team to ensure feasibility of design and clarify user requirements.
Capture business rules and build physical design document to meet user requirements.
Work with Data Modelers and DBA to create/update table structures.
Understand and Interpret Logical design document and Data Model diagrams to understand requirements to build physical design document.
Effectively communicate the functional design to developers and confirm the same with solution design team.
Develops test scenarios and scripts that match the business user's objectives to confirm system functions are met.
Work with Development and Testing team to support testing activities.
Qualifications:
Typically requires a minimum of 3-5 years of related experience or equivalent combination of education and experience.
High School Diploma Required
strong knowledge and experience in Foundation Systems (Membership System for CA regions)
Candidate must have hands on experience in Mainframe and Oracle technologies
Candidate must have strong knowledge and experience in interpreting user requirements and building Physical Solution Design Document.
Candidate must have good knowledge and experience in understanding logical mapping and data model to build Physical Design document.
strong knowledge and experience in Data Warehousing (ETL, Data Analysis, etc) concepts.
strong intuitive and analytical problem solving skills.
Good understanding on testing principles, concepts and tools. Advanced working knowledge of Testing, Business Analysis techniques and tools.
Should have ability to write and execute complex SQL Statements especially in Oracle Environments.
Expertise with Defect Management Tools preferably Mercury Tools preferred.
Good understanding and experience in writing test cases/plans, executing test cases & identifying defects.
Sound knowledge and experience in Oracle, and Mainframe systems.
Top 3-5 Daily Responsibilities:
Documenting design and data mapping for dashboards and reports
Building prototype dashboards in Tableau/Power BI/Excel
Document and create data summarization and or transformation tasks in Alteryx/Excel as needed for design
Top 3-5 Required Skills:
MS office suite, data mapping, business rule definition
Dashboard creation in in Tableau, Power BI or other tools
3MS Visio, MS project plan
Desired Skills:
Data Science skills, statistical modeling
PM in agile methodology
Predictive analytics
Soft Skills:
Good verbal, written communication skills
Collaborate well with distributed team structure
Work well under pressure
qualifications:
Experience level: Experienced
Minimum 5 years of experience
Education: High School
skills:
Business Analysis
Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.
Qualified applicants in San Francisco with criminal histories will be considered for employment in accordance with the San Francisco Fair Chance Ordinance.
We will consider for employment all qualified Applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.
