Michigan Veterans Jobs

Mobile michigan-jobbank Logo

Job Information

TriMas Corporation Senior Systems Analyst in Bloomfield Hills, Michigan

40 hrs/wk (OT as required); 8am-5pm M-F; Review, analyze and evaluate business systems and user needs to ensure financial and other information systems are meeting the objectives of TriMas’ business strategies and reporting requirements; Interact with various stakeholders including senior managers to gather business requirements and understand business processes; Specify, create and implement technical architecture; Create project artefacts including System Requirement Specification(SRS), High Level Design, Technical Design, Security and Implementation Plan; Project leadership and supervision of third party consultants as required; Provide direct support to the Director of IT as well as support divisional and home office users relative to their use of TriMas’ information systems; Analyze, design, and maintain systems and application software using DOTNET CORE 2.0, .NET 4.0/4.5 (C#.NET & ASP.NET), MVC, Angular JS 5.0/6.0, REST API; Perform required software upgrades and apply patches; Assist in project management and vendor resource supervision for various IT projects; Develop and manage Enterprise Database using MS SQL Server 2008/2012/2016; Work with SQL server Fail Over clustering and Availability Groups; Perform SQL Server database backup/restore, maintenance and user management; Write database queries using SQL; Design and development of SQL stored procedures, functions using T-SQL; Schedule and manage SQL jobs using SQL Server Agent; Create data transformation packages to load data from various data sources to populate data-warehouse using SQL Server Integration Services (SSIS); Performance tuning of applications including Database, Business and User Interface layers; Develop SQL Server Reporting Services (SSRS) and deploy them onto Report Server/SharePoint Portal; Design Dashboards using Power BI and host them onto Power BI Cloud services; Develop and maintain cubes, dimensions, measures, KPIs using SQL Server Analysis Services (SSAS); Design, develop, test SharePoint 2010/2013 custom sites with webpages, Lists, Libraries, content types, web parts and Workflows and deploy SharePoint objects using PowerShell; Configure and set up security in SharePoint and administer SharePoint services using PowerShell and SharePoint Central Administration; Work with Accounting/ERP software Dynamics GP 2010 and its eco systems SmartConnect, FastPath and Management Reporter; Work with project artefact versioning, task and release management tools such as Team Foundation Server (TFS) and Azure DevOps; Provide training to users on processes and IT systems; and Utilize Waterfall and Agile Scrum project development methodologies