View all jobs

Business Analyst – extract, transform, load (ETL)

Beaverton, Oregon

Candidates MUST have 4+ years college degree / equivalent experience as Business Analyst, Data Analyst, Process Specialist, or other role where business functional requirements are captured and decomposed utilizing the extract, transform, load (ETL) concepts, tools, and practices.
Job Title: Business Analyst – extract, transform, load (ETL)
Duration: 1-year contract
Location: Beaverton, OR
Key Skills: Analyst ETL Project Integration Liaison Database Analysis, Business Analysis, Data Modeling MS Office Project Management Project Plans Remediation Software Development SQL Technical Requirements Technical Specifications Test Plans BI Architecture Budget Class Action Client Services
Desired Skills: MS Project BI tools like Tableau or Alteryx & nice to have experience in assessing applications via an RFI or RFP
Required Skills: MS EXCEL ETL Nice to have MS Project BI tools like Tableau /Alteryx and experience in assessing applications via an RFI or RFP
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.
Ability to communicate effectively, both verbally and in writing; able to adjust for intended audience. Fluent in English.
Job Description:
Develops action plans and processes, in coordination with management team, for integrating activities and optimizing department resources to meet major goals and objectives.
Facilitates or performs application support, problem solving, and issue resolution with internal and external resources.
Contributes and reviews recommendations for technical solutions.
Manages and/or contributes to the technical components of the RFP process.
Resolves issues and determines options for issue resolution and risk mitigation.
Defines and communicates requirements for technical environments and determines the technical scope for projects.
Provides technical estimates for project budget input to Senior/Project Manager.
Leads and owns engagements with software vendors to ensure that code and configuration requirements and deliverables are met. Enforces architecture, governance, security, and global process standards to system changes and deployments.
Coordinates compliance issue identification and remediation.
Collaborates with other teams on integration needs/design.
Contributes to database design and creates critical-path, high-risk, advanced technical designs.
Approves proof of concept efforts and reviews results.
Enforce client department’s architectural direction and ensure consistent technical approach within department.
Decide on engineering tools based on recommendations.
Allocate resources based on performance monitoring and tuning results.
Manage and enforce performance thresholds and standards.
Review and approve performance test results, recommendations, and tuning results.
Oversee and is responsible for the creation of test plans, test execution, and validation of test results.
Job Responsibilities:
  • 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 internal applications.
  • 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: Bachelor’s degree in Business or equivalent industry experience
Experience required for this job: 4 years of experience in ETL
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)
Sr.Net Developer

Share This Job

Powered by