Business Data Analyst (ETL / SQL)

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)
Unable to Provide Sponsorship

Skills

Agile
Database
Health Care
Business Analytics
Extract
Transform
Load
Business Analysis
SQL
Requirements Elicitation
Software Development Methodology

Job Details

6-12+ Month Contract Position

Location - Rosemont, IL (hybrid - onsite 1 day a week)

The Business Analyst enables change by working with our Business to define their needs and working with our Central Technology Services teams to recommend solutions. The Business Analyst is responsible for collecting and documenting business and technical requirements from various business and technical teams and provides written functional requirements for various technology teams.

The primary responsibilities of this role include working with stakeholders across business and technical teams to discover and document requirements, build and manage the product backlog, and successfully participate and lead agile projects through their respective life cycles. The Business Analyst must be comfortable managing and driving the requirements-gathering phase of technology projects and creating the necessary deliverables to support development and quality assurance efforts. The Business Analyst will also be needed to sometimes provide second-tier technology applications support and application reporting.

Responsibilities:

  • Collaborate with technology teams to gather, document and analyze business requirements related to data integration and transformation needs
  • Support the design and validation of ETL workflows, ensuring data accuracy, quality and business alignment
  • Work closely with developers and quality analysts to translate business needs into technical specifications
  • Work with the Business to identify requirements and think critically about what will make it successful; write user stories that effectively communicate the Business requirements and that are easily consumed by software development teams.
  • Attend and lead Business stakeholder meetings; provide project status reporting to management; assist with testing scenarios and validate results.
  • Create deliverables such as business process flows, technical workflows and data mappings to effectively communicate design strategies and detailed interaction behaviors.
  • Assist in preparing and delivering client presentations.
  • Advocate on behalf of Business to IT, and advocate on behalf of IT to Business.
  • Become a Subject Matter Expert on a variety of packages and custom business applications including User Experience best practices.
  • Go beyond just reading and understanding information, to making sense of it, and finding patterns for improvement.
  • Support business applications. Troubleshoot and resolve applications issues.

REQUIRED QUALIFICATIONS

  • 7+ years of prior experience as a Business Analyst or other IT role, such as support or development.
  • BA / BS in IT, statistics, computer science, mathematics, information management, business or a related field or equivalent experience.
  • Hands on experience with ETL tools such as Informatica, Microsoft SSIS
  • Moderate to Advanced SQL knowledge
  • Skilled at defining and documenting business and functional requirements for ongoing system enhancement initiatives in agile software development environments.
  • Experience writing clear acceptance criteria to a testable level.
  • Firm understanding of relational databases, database structures and design, and data management.
  • Experience leading or participating in all Agile meetings including sprint planning, sprint grooming, review, demo, stand-up, and retrospective sessions.
  • Experience in all phases of product, software, and testing lifecycles.
  • Microsoft Office experience: Word for documentation, Excel for data handling, Visio for process explanation, PowerPoint for presentation and Outlook for email. Any experience with AzureDevops would be great
  • Strong investigative, analytical skills.
  • Interpersonal communication skills with the ability to work independently or as part of a team with both the Business and technology staff.

PREFERRED QUALIFICATIONS

  • 1+ years of programming experience in any language, i.e., Python, Java, JavaScript, C, C++
  • 3+ years of experience on a business team interfacing with IT.
  • 3+ years of experience in healthcare.
  • Ability to become a Subject Matter Expert on various healthcare, insurance, pension, and/or payroll technology systems.
  • Experience working on different project types, such as off-the-shelf, new development, enhancements projects.
  • General knowledge of databases, applications, system interfaces, and operating systems.
  • Experience creating reports for business users, especially via SSRS or similar tools.
  • Knowledgeable in SDLC, Agile and/or Waterfall methodologies.

The anticipated hourly rate range for this position is ($60-70/hr), during the contract period. Actual hourly rate will be based on a variety of factors including relevant experience, knowledge, skills and other factors permitted by law. A range of medical, dental, retirement and/or other benefits are available after a waiting period

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.