The Role
Business Systems Analyst supporting a data management program. Acts as a liaison between business and technical teams, develops complex SQL, source-to-target mappings, requirements, user stories, technical specifications, data analyses, testing plans, reconciliations, and user acceptance testing. The role also supports data quality, governance, dashboards, documentation, training, and concurrent projects.
Summary Generated by Built In
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.
THIS IS A TRUE NEW NEED. The manager requested a bid limit of 1 to see only the top qualified candidate from each vendor.
Top Required Skills & Years of Experience:
• Candidates MUST know SQL for this position
• Serve 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
• Develop complex SQL - 5 years
• Gather requirements and develop user stories – 5 years
• Translate business requirements into technical specifications – 5 years
• Perform root cause analysis for systems and perform data analysis with complex datasets to identify patterns, trends, and insights – 5 years
• 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. – 2 years
Nice to Have (Preferred) Skills:
• Performing gap analysis and cost benefit analysis
• Mentoring and training users on business and systems analysis methodology
• Experience with data quality tools and frameworks
• Experience with business intelligence platforms
• Experience with data governance including security and privacy policies
• Eliciting and refining requirements for dashboards
• Strong understanding of different types of data models
• Creating 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.
• Managing multiple, concurrent projects and tasks
• Having strong interpersonal skills including communication, mentoring, collaborating, and team building
Interview Process: remote via MS Teams
Duration: 6/30/2027, likely to extend
Onsite or Remote? No WI residency required. Open to nationwide candidates. This position can work 100% remote.
Job Description
We have an immediate opening at the Department of Employee Trust Funds (ETF) 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.
Desired Experience
• 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 collaborate with
stakeholders to resolve any issues or defects. – 2 years
• Performing gap analysis and cost benefit analysis
• Mentoring and training users on business and systems analysis methodology
• Experience with data quality tools and frameworks
• Experience with business intelligence platforms
• Experience with data governance including security and privacy policies
• Eliciting and refining requirements for dashboards
• Strong understanding of different types of data models
• Creating 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.
• Managing multiple, concurrent projects and tasks
• Having strong interpersonal skills including communication, mentoring, collaborating, and team building
ETF Technologies
• Jira
• SharePoint
• Teams
• Alteryx
• SSIS
• SSRS
• SSMS
• Squirrel
• SQL Server
• Tableau
• Semarchy
• Git & github
RequirementsRequired Skills
Skill Type
Skill Name
CertificationEducationLicenseOtherSkill
Experience as a Business Analyst - 5+ years
CertificationEducationLicenseOtherSkill
Develop complex SQL - 5 years
Skill Type
Skill Name
CertificationEducationLicenseOtherSkill
Experience with data quality tools and frameworks
CertificationEducationLicenseOtherSkill
Performing gap analysis and cost benefit analysis
Skills Required
- At least 5 years of experience as a Business Analyst
- Must be proficient in SQL
- At least 5 years creating and maintaining source-to-target documentation and designing data integration processes
- At least 5 years developing complex SQL
- At least 5 years gathering requirements and developing user stories
- At least 5 years translating business requirements into technical specifications
- At least 5 years performing systems root cause analysis and complex data analysis
- At least 2 years planning and executing testing, data reconciliation, and user acceptance testing
- Excellent oral and written communication skills
- Experience performing gap analysis and cost-benefit analysis
- Experience mentoring and training users on business and systems analysis methodology
- Experience with data quality tools and frameworks
- Experience with business intelligence platforms
- Experience with data governance, security, and privacy policies
- Experience eliciting and refining dashboard requirements
- Strong understanding of data models
- Experience creating system requirements, design specifications, user manuals, and training materials
- Experience managing multiple concurrent projects and tasks
- Strong interpersonal, collaboration, mentoring, and team-building skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Novalink Solutions LLC is a global consulting, engineering, and AI product development company specializing in information technology and telecommunications. They provide AI-powered products, automation platforms, intelligent workflow systems, IT consulting, managed engineering, and staff augmentation services.
