[Hiring] Data Warehouse Reporting/SQL Business Analyst @Sundial Software

Role Description

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.

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.

Qualifications

• Candidates MUST know SQL for this position
• Strong analytical and problem-solving skills
• Ability to think critically and identify innovative solutions

Requirements

• 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
• Perform gap analysis and cost benefit analysis
• Mentor and train 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
• Elicit and refine requirements for dashboards
• Strong understanding of different types of data models
• 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
• Strong interpersonal skills including communication, mentoring, collaborating, and team building

Benefits

• Remote work option available (100% remote)
• No WI residency required; open to nationwide candidates

Company Description

• Department of Employee Trust Funds (ETF)
• Focus on data management and becoming a data-driven organization
• Collaborative team using agile practices