logo

View all jobs

Business Systems Analyst – SQL, Excel, BI

Beaverton, OR
Candidates MUST have work experience as a Data/Business Systems Analyst and/or Process Specialist; no remote work, person is expected to be on campus when reopened.

Job Title: Business Systems Analyst – SQL, Excel, BI
Duration: 6 months (contract)
Location: Beaverton, Oregon

Required Skills: ETL, Data Modeling, Microsoft Excel, Operations, SQL, SQL Queries, Documentation, Integration Testing, Understanding of Technical Design/Prototypes, UAT/Usability, Wireframes/User interface
Nice to Have:  Applications assessment via an RFI or RFP, MS Project, Tableau/Alteryx BI tools

Job Description:
The purpose of this request is to procure Data/Business Systems Analysis and Project Specialization services for our direct client; Candidate must understand the entire lifecycle of a class action or similar matter, determine what data is required based on functional requirements, and define how that data and business rules will translate to client’s internal applications.
  • 5+ years’ experience as Business Analyst, Data Analyst, Process Specialist, or other role where business functional requirements are captured and decomposed.
  • Proficient with MS Office tools, particularly Excel.
  • Experience with relational databases and ability to comprehend moderately complex SQL logic desired.
  • Basic understanding of data modeling and data organization desired.
  • Basic understanding of and experience with extract, transform, load (ETL) concepts, tools, and practices desired.
  • Ability to work in an environment with immediate deadlines and shifting priorities.


Job Responsibilities:
Develop and publish technical specifications, technical requirements, and other documentation, as required.
Design data mappings and transformations which will be used to drive ETL procedures.
Work with QC Analysts to design testing strategies and plans to ensure all outcomes are as expected.
Using tools such as Excel, Access, SQL Server, and others, directly query, assess, and analyze data to ensure requirements are being met.
Serve as liaison between Client Services (business) and Data Analysts (technical) teams to keep production work flowing smoothly.
Work with Technical Project Managers to ensure all required steps and actions are captured in project plans, and that project timelines seem reasonable.
Lead, conduct, or consult in user acceptance test exercises to ensure results are acceptable and meet requirements.
Follow prescribed software development standards, processes, procedures, methodologies, etc., according to departmental policies and conventions.
Interact and correspond professionally with team members, project management, clients, and other stakeholders.
Account for and accurately log time against project work.

Education and Qualifications Required:
Degrees required for this job: Four-year college degree or equivalent industry experience.
Years of experience required for this job: 5+ years’ experience as Business Analyst, Data Analyst, Process Specialist, or other role where business functional requirements are captured and decomposed. Proficient with MS Office tools, particularly Excel. Experience with relational databases and ability to comprehend moderately complex SQL logic desired. Basic understanding of data modeling and data organization desired. Basic understanding of and experience with extract, transform, load (ETL) concepts, tools, and practices desired. Ability to work in an environment with immediate deadlines and shifting priorities.

Soft skills for this job:
Communication skills both verbal and written

Email your resume to: usjobs@mavensoft.com
To learn more about Mavensoft visit us online at http://www.mavensoft.com/


 

More Openings

ASP.NET Developers (4-6 yrs)
JAVA DEVELOPERS
Sr.Net Developer

Share This Job

Powered by