Technical Business Analyst ( ETL / SQL )

IT Associates; Illinois; Remote; USD 60,000 - 80,000; Full time

Job summary

A leading company in the healthcare sector is looking for a Technical Business Analyst with strong ETL and SQL skills. The position offers remote work with occasional office meetings and involves a long-term contract opportunity. Ideal candidates will have a solid background in business analytics and data management, ready to contribute to various projects and support the healthcare technology needs.

Benefits

Medical insurance

Vision insurance

Flexible work hours

Qualifications

• 7+ years of experience as a Business Analyst or in IT.
• Hands-on experience with ETL tools and SQL knowledge required.

Responsibilities

• Gather, document and analyze business requirements for data integration.
• Support design and validation of ETL workflows ensuring data quality.

Skills

Analytical skills

Interpersonal communication

Problem-solving

Education

BA / BS in IT, statistics, computer science, mathematics or related field

Tools

ETL tools (Informatica, Microsoft SSIS)

Microsoft Office (Word, Excel, Visio, PowerPoint)

Job description

Technical Business Analyst ( ETL / SQL )

Technical Business Analyst ( ETL / SQL )

1 day ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from IT Associates

Sr Recruiter I Director - Technology Staffing & Talent Acquisition I MBA

Technical Business Analyst - ETL / Solid SQL / beginner skills in any programming language

• Client is in Rosemont, IL . Healthcare Insurance Provider /claims processing
• LONG term CONTRACT ( ongoing .. no limits . There is option for hire down the line )
• REMOTE mostly ( with the ability to come to the office occasionally for team meetings )
• Key responsibilities - 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

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

• 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.

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.

The anticipated hourly rate range for this position is ($60-70), 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

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  Hospitals and Health Care and Insurance

Referrals increase your chances of interviewing at IT Associates by 2x

Inferred from the description for this job

Medical insurance

Vision insurance

Get notified when a new job is posted.

Sign in to set job alerts for “Technical Business Analyst” roles.

IT Business Analyst, Associate Experience

Chicago, IL $60,000.00-$68,000.00 16 hours ago

Senior Business Data Analyst, Member Experience Reporting

Sustainability Business Analyst (Hybrid)

Chicago, IL $120,000.00-$150,000.00 2 weeks ago

Joliet, IL $120,000.00-$150,000.00 2 weeks ago

Business Audit - Senior Analyst (Illinois and Florida Residents Only)

Senior Business Tax Analyst - Work From Home

Illinois, United States $78,288.00-$117,432.00 3 weeks ago

Senior Business Tax Analyst- Work From Home - 3+ Yrs Paid Tax Experience Required

Chicago, IL $82,256.00-$125,000.00 2 weeks ago

Chicago, IL $130,000.00-$135,000.00 1 week ago

Springfield, IL $54,300.00-$145,860.00 23 hours ago

ServiceNow Knowledge Management Product Owner -REMOTE

Illinois, United States $120,000.00-$222,600.00 2 weeks ago

EDW Sr. Healthcare Technical Analyst (32542)

Springfield, IL $46,988.00-$112,200.00 1 week ago

HR IT Analyst – Workday Configuration (Absence & Compensation)

Salesforce Support Engineer - Techno- functional Consultant

Business Tax Analyst- Work From Home - 3+ Yrs Paid Tax Experience Required

Chicago, IL $90,000.00-$125,000.00 1 month ago

Illinois, United States $83,250.00-$90,000.00 4 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.