System Analyst - Michigan US - Hybrid*

Lansing, Michigan
Prestige Development Group – Recruitment Process Outsourcing /
Full-Time /
Hybrid
The Technical Systems Analyst will perform a combination of both Business Analyst duties working with technical staff and business stakeholders, along with SQL data analysis using a relational database management system (SQL Server).Work with and serve as liaison between management and business units within the department, external stakeholders, developers, QA analysts, DBA, and scrum master to identify and analyze opportunities for improving processes, data, and business systems. Serves as the communication bridge between non-technical business users and technical solution developers. The Technical Systems Analyst has a depth of knowledge in business analysis and design processes including knowledge of methodology, tools, and techniques. This individual will also have extensive database experience and is an active participant in aspects of department assessment, visioning, and reengineering.

Job Duties
- Lead BA efforts, gathering requirements and reviewing for completeness.
- Oversee developers in development of system in accordance with defined business requirements.
- Lead the transition of software features into technical requirements, such as features, epics, and stories.
- Validate data and troubleshoot within relational databases using SQL queries.
- Analyze and recommend solutions for Web and mobile applications
- Analyze business practices and processes to determine best practice strategies to ensure maximum effectiveness and efficiency.
- Assist with strategic planning, including applications integration and application upgrade strategy
- Assist in the development and implementation of solutions from business requirements.
- Participate in technology test plan development and execution.
- Understand and coordinate a product backlog, releases of the system, and all its dependencies.
- Work with and serve as liaison between management and business units within the department, external stakeholders, developers, QA analysts, and scrum master to identify and analyze opportunities for improving processes and business systems
- Conduct research, analyze, and document system requirements and business rules, and create user stories.
- Identify, communicate, and decompose business requirements into small, estimated, functional, user stories that fit within single iteration.
- Prioritize sequence stories to maximize business value delivered while maintaining a sustainable pace for the team.
- Work with Product Management Team to ensure vision, goals, and objectives are established and achieved.
- Make critical decisions regarding functionality and priority for the team with a focus on delivering value.
- Provide client support during UAT, if requested.
- Teach, learn, and perform in a high energy, agile environment with dynamic job responsibilities and priorities.
- Collaborate with multiple teams in troubleshooting complex technical or non-technical issues.

Requirements
10 years:
- T-SQL
- Experience designing and proposing solutions to business needs
- Experience with system testing and data analysis, which includes creating and running SQL Queries to validate system results. 
- Ability to effectively communicate with technical and non-technical stakeholders. 
- Strong analytical and problem-solving skills, with the ability to think creatively and strategically. 
- Experience engaging in business process analysis, understanding the customer's business process requirements, and capable of translating those business requirements into business and technical documentation and specifications.

Desired Skills
- 5 years:Experience documenting requirements in the form of user stories and acceptance cirteria.
- Experience developing and maintaining technical documentation.
- Experience supporting User Interface (UI) and database validation activities by documenting test plans and test scenarios, identifying and creating test data, executing test cases and test scenarios, identifying defects and performing defect management.
- 2 years: C# or other programming language
- Azure DevOps
- SQL Server Reporting Services
- SQL Server Integration ServicesPowerBI

Minimum Education 
Bachelor's Degree

Location 
Local and Non-local candidates can apply. MUST BE WILLING TO RELOCATE
Position is a hybrid schedule with 2 days a week in office REQUIRED.

Working hours: Monday-Friday, approximately 8:00 a.m. to 5:00 p.m.  (flexible scheduling is possible)

Additional Requirements
Must be authorized to work in the United States; We are unable to offer sponsorships at this time
Must undergo a background check and drug screening for employment.

Employment Terms
This is a W2 position
40 hrs per week
HYBRID schedule - 2 days a week in office

About US. We are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

Benefits
We understand a comprehensive benefits package is crucial to employment satisfaction.
We offer medical, dental and vision coverage options for all employees. 
$90,000 - $140,000 a year