System Architect

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

Required Skills
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

Desired Skills
ETF Technologies
• Jira
• SharePoint
• Teams
• Alteryx
• SSIS
• SSRS
• SSMS
• Squirrel
• SQL Server
• Tableau
• Semarchy
• Git & github