W2 - BUSINESS ANALYST/CONSULTANT IV - (SQL, SOURCE-TO-TARGET MAPPING, DATA WAREHOUSE) - Remote Job at Tanson Corp, Wisconsin

MlFxVm45aXdoblZIa3BpWTl4dFhmTWgvUmc9PQ==
  • Tanson Corp
  • Wisconsin

Job Description

Business Analyst/Consultant IV

Work Arrangement: 100% Remote

Location: Nationwide candidates accepted

Contract Duration: Through June 30, 2027, likely to extend

Interview Process: Remote via Microsoft Teams

Position Overview

We have an immediate opening for a Business/Systems Analyst to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This position will work on a small, collaborative team that uses agile practices to deliver value to our business partners. This position must have strong analytical and problem-solving skills with the ability to think critically and identify innovative solutions.

The manager is looking for a Business Systems Analyst with reporting and data warehouse requirements development experience and source to target mapping. This individual MUST also be able to write SQL and must have excellent oral and written communication skills.

Key Responsibilities
  • Serve as a liaison between the business and technical staff to design and implement efficient data integration processes.
  • Create and maintain source to target (S2T) documentation.
  • Develop complex SQL.
  • Gather requirements and develop user stories.
  • Translate business requirements into technical specifications.
  • Perform root cause analysis for systems and perform data analysis with complex datasets to identify patterns, trends, and insights.
  • Plan and execute rigorous testing procedures to ensure system functionality, performance, and reliability.
  • Perform data reconciliation and analysis of results.
  • Conduct user acceptance testing and collaborate with stakeholders to resolve any issues or defects.
  • Perform gap analysis and cost benefit analysis.
  • Mentor and train users on business and systems analysis methodology.
  • Elicit and refine requirements for dashboards.
  • Create comprehensive documentation, including system requirements, design specifications, and user manuals.
  • Conduct training sessions and workshops to educate end-users on system functionalities and best practices.
  • Manage multiple, concurrent projects and tasks.
Required Skills & Experience
  • Candidates MUST know SQL for this position.
  • Serving as a liaison between the business and technical staff to design and implement efficient data integration processes. Creating and maintaining source to target (S2T) documentation 5 years .
  • Developing complex SQL 5 years .
  • Gathering requirements and developing user stories 5 years .
  • Translating business requirements into technical specifications 5 years .
  • Performing root cause analysis for systems and performing data analysis with complex datasets to identify patterns, trends, and insights 5 years .
  • Planning and executing rigorous testing procedures to ensure system functionality, performance, and reliability. Performing data reconciliation and analysis of results. Conducting user acceptance testing and collaborating with stakeholders to resolve any issues or defects 2 years .
  • Strong oral and written communication skills.
Preferred Skills
  • Experience with data quality tools and frameworks.
  • Experience with business intelligence platforms.
  • Experience with data governance including security and privacy policies.
  • Strong understanding of different types of data models.
  • Having strong interpersonal skills including communication, mentoring, collaborating, and team building.
  • Experience managing multiple concurrent projects and tasks.

Technologies and Tools

  • Jira

  • SharePoint

  • Microsoft Teams

  • Alteryx

  • SSIS

  • SSRS

  • SSMS

  • Squirrel

  • SQL Server

  • Tableau

  • Semarchy

  • Git and GitHub

Pay rate: $40/hr/W2

Job Tags

Contract work, Immediate start, Remote work

Similar Jobs

Human Capital Resources and Concepts

Data Analyst - Human Resources / Workforce Analytics Job at Human Capital Resources and Concepts

 ...Position Overview Human Capital Resources and Concepts (HCRC) is seeking a Data Analyst Human Resources / Workforce Analytics to support one of our Federal Clients. The Data Analyst will provide recurring and ad hoc human capital data analysis, reporting, metrics... 

Florida Crystals Corporation

Tractor Trailer Operator Job at Florida Crystals Corporation

 ...sugarcane fiber to generate eco-friendly energy that powers its sugar operations. Florida Crystals owns one of the largest Regenerative Organic...  ...tractortrailer trucks to transport freight, materials, or equipment between facilities, distribution centers, or customer... 

Success Academy Charter Schools

Network Technical Theater Supervisor Job at Success Academy Charter Schools

 ...architect for set design and production quality, ensuring a professional and cohesive aesthetic across the network. Reporting to the Theater Program Manager, this individual will balance high-level network strategy with hands-on instruction and event production. This is a... 

WS Development

Design Manager Job at WS Development

 ...developers in the country. We seek a teammate with a passion for design who can help WS create places where people want to be, someone...  ...s primary focus will provide design leadership and project management within cross-functional teams including Development, Construction... 

wadetrim

Entry Level Civil/Environmental Engineer - #3078 Job at wadetrim

 ...Program, Sustainability Program, and Wellness Program. Position Description: We are looking for an Entry Level Civil/Environmental Engineer to join our Industrial Commercial Energy Team to improve infrastructure in our Taylor office. Candidates must possess a...