Marquette GIS, Inc. affirms in policy and in practice that all employment decisions will be based on merit and business needs and not on race, color, citizenship status, national origin, ancestry, gender, sexual orientation, age, religion, creed, physical or mental disability, marital status, veteran status, political affiliation or any other factor protected by law.

Experienced Senior Project Manager for managing multiple complex IT Security projects/programs with strong communication skills. Follows project management industry practices such as the PMI’s framework. Works closely with project teams and sponsors.

Job Description:
This position is for a senior experienced project manager to lead multiple Information Technology (IT) programs/projects supporting DTMB – Chief Security Officer (CSO) organization. Projects/programs are primarily complex enterprise initiatives related to I T Security and Infrastructure as prioritized by State. Project manager’s role and responsibility includes, but is not limited to:
• Provide project management for project activities to ensure that the project is completed on time, within budget and within scope.
• Define project scope, duration, resources and cost, as well as the best course of action/approach to attain the project objectives.
• Provide project management for project scheduling, tracking, issue management, risk management, change management, and status reporting.
• Follow the State Unified Information Technology Environment (SUITE) Project Management Methodology (PMM) and System Engineering Methodology (SEM), based on Industry standard PMI framework and SEI’s CMMI framework.
• Utilize the State’s Project Portfolio Management (PPM) tool (Changepoint) on all projects.
• Plans and coordinates work with teams. Designs and implements project plans. Generally work with other IT managers and IT technical teams. Relies on experience and judgment to plan and accomplish goals.
• Acts as a program manager for large complex enterprise IT Security initiatives.
• Acts as a partner to other project managers performing Project Management Quality Assurance for their projects.
• Relies on experience and judgment to plan and accomplish goals. A significant degree of creativity and latitude is required. Works under limited supervision with considerable latitude for the use of initiative and independent judgment
• Self-directed and independent. Responsible for the coordination and completion of projects. Oversees all aspects of projects. Sets deadlines, assigns responsibilities, and monitors and summarizes progress of project. Prepares reports for upper management regarding status of project.
• Creates a structure and organization for the management of a complex environment with emphasis on quality, productivity, and consistency. Directs corrective actions in any area where performance falls below objectives.

20190130

Location: Des Moines, IA
Pay Rate: $24/hr w-2 with benefits
Duration: 9 months with extensions
Start Date: ASAP
Position ID: IA582182

The Trainer/Technical Writer (TTW) develops and maintains user and technical documentation and project process documentation for Application Teams, understands the user’s view of applications and /or technology and is able to put procedures in a logical sequence. The experienced TTW provides expertise on technical concepts of applications and /or user groups and structuring procedures in a logical sequence, due to a broad understanding of the applications. They ensure messages and terminology is consistent across all written materials, identifies, creates, revises, and maintains documentation and templates needed by the Application Teams. The TTW must be able to work in a team environment and have strong communication skills; both written and spoken.

This position requires 4 to 7 years of experience, relies on experience and judgment to plan and accomplish goals, performs a variety of complicated tasks, may lead and direct the work of others, may report directly to a project lead or manager, a wide degree of creativity and latitude is expected.

20190130

The Program Manager/Engagement Manager 2 (PREM2) will have technical and functional skills including Medicaid business, project management, and independent validation and verification (IV&V) expertise.

Candidate must be experienced in MMIS and/or Medicaid eligibility system projects, have working knowledge of HIPAA, and have provided IV&V services for similar-sized projects with similar complexities, inter-dependencies, and coordination requirements. Candidate will utilize industry standards and best practices in performing IV&V oversight and progress reporting activities.

Background on Projects that May Require IV&V Services
Program Integrity System Certification- beginning December 2018
Medicaid’s Program Integrity system has been in production since 2017 and requires CMS certification. It is anticipated that the certification will begin at the R3 Milestone Review. The backbone of the solution is Truven’s (now owned by IBM) DataProbe System®. IBM hosts the system with Iowa’s PI database in their secure, SSAE-16 compliant, national data center in Dallas, TX. The overall solution meets the CMS MECT Certification Checklist Requirements for Program Integrity System Functionality. The following implementation activities were carried out to implement a comprehensive program integrity solution for Iowa:

• Implement a Program Integrity Database – Build an analytic database with claims and other data sources useful to produce algorithms and models to identify fraud, waste and abuse in Iowa’s Medicaid Program.
• Develop Surveillance and Utilization Review System – Profiles by peer group that identify providers and service recipients who are statistical outliers on multiple parameters of cost, utilization, quality of care, and/or other metrics.
• Develop and implement custom analytics for Iowa – Custom algorithms developed to find fraud, waste and abuse for Iowa Medicaid Enterprise.
• Running Vulnerability Assessment – review of one to many years of data where Truven runs paid claims data through its Software as a Solution (SaaS) software, flagging claims that appear to be over-payments or billing errors and produce a report to prioritize the algorithm development.
• Develop and Implement Provider Surveillance Reports – Reports which provide Provider Risk Scores based on their inclusion or exclusion in eight data file.
• Validation of Encounter Data – Compare encounter data to historical FFS data by multiple measures to assess: validity, completeness and reasonableness.
• Implement an Investigatory Case Management System

20190130

The Candidate will perform Desktop and Help Desk support for the Iowa Department of Public Health Information Management Bureau.

The candidate will provide tier one help desk support with technical issues via phone, email and ticketing system. They will also provide network support for all users, this will include, but is not limited to, setting up new desktops/laptops. The Candidate will be provided trainings to staff on various software and computer hardware as needed. The Candidate will update Inventory of electronic equipment as needed. They will need to exercise sound judgment and escalate service requests and incidents as needed. Design, configure, and test computer hardware, networking software and operating system software. Approximately 25% of the department work offsite, Candidate must be proficient in working over the phone with users. The Department uses Google G-Suite, along with many of the Adobe products, a Candidate with knowledge in both areas would be an asset.

20190129

This project requires a proven track record in implementing software on a tight schedule.

The Office of Medical Cannabidiol at the Iowa Department of Public Health seeks an experienced IT project manager to facilitate the implementation of the medical cannabidiol IT patient registry and seed-to-sale tracking system. In May 2017, the Iowa Legislature passed HF524, which required IDPH to create a program to manage all medical cannabidiol production, transportation, and distribution from seed to sale. One component of this is an IT tracking system that will be used by manufacturers, dispensaries, laboratories, and state employees to track all aspects of medical cannabidiol production and sales in the state.

The IT project manager will work with the MCBD Program Director, IDPH stakeholders, and the software vendor to implement the IT tracking system on time and within scope. IDPH has already issued a competitive procurement process to select a vendor; the IT project manager will work with this vendor to successfully implement the selected solution. The IT project manager will manage the timeline, project plan, and budget to implement the software according to legislative timelines. The IT project manager will work to eliminate risks and barriers to success and communicate regularly with IDPH mCBD Program Director to ensure on time delivery of deliverables.

The Office of Medical Cannabidiol at the Iowa Department of Public Health seeks an experienced IT project manager to facilitate the implementation of the medical cannabidiol IT patient registry and seed-to-sale tracking system. In May 2017, the Iowa Legislature passed HF524, which required IDPH to create a program to manage all medical cannabidiol production, transportation, and distribution from seed to sale. One component of this is an IT tracking system that will be used by manufacturers, dispensaries, laboratories, and state employees to track all aspects of medical cannabidiol production and sales in the state.

The IT project manager will work with the MCBD Program Director, IDPH stakeholders, and the software vendor to implement the IT tracking system on time and within scope. IDPH has already issued a competitive procurement process to select a vendor; the IT project manager will work with this vendor to successfully implement the selected solution. The IT project manager will manage the timeline, project plan, and budget to implement the software according to legislative timelines. The IT project manager will work to eliminate risks and barriers to success and communicate regularly with IDPH mCBD Program Director to ensure on time delivery of deliverables.

20190129

The Cybersecurity Technical Policy Writer will be responsible for developing information security policies, reports, and content. This is a content writing position.

The layout and design aspects of this job are minimal. The ideal candidate will have some experience working in a software development or information technology field.

Job Responsibilities:
•Experience in researching, developing, writing, and editing cybersecurity policies, best practices, standards, processes and procedures
•Experience in research and analysis of information system issues and trends, and research and development in a technical discipline/field
•Working with consulting and security operations staff to optimize documented procedures
•Excellent written and verbal communication skills; strong organizational skills; research, analysis, and writing skills
•Strong interpersonal skills to effectively relate to agency and customer needs; ability to build working relationships with leaders and key stakeholders
•Proficiency with Microsoft Office
•Ability to work independently and as part of a team; ability to take initiative with minimal direction and to solve problems

Job Qualifications:
Mandatory Qualifications
•Minimum of 2 years technical writing experience
•A college degree
•Excellent written/technical communication skills with samples to prove it

Desirable Qualifications
•Experience with information security concepts, particularly around regulatory compliance (i.e., NIST 800-53, IRS 1075)
•Demonstrated ability to interface with subject matter experts to successfully gather information
•Demonstrated ability to understand and articulate complex security information
•Excellent interpersonal communication skills
•Professional, “can do” attitude
•Business friendly, collaborative and diplomatic
•Effective time and resource management skills

20190125

3rd SHIFT

PLEASE NOTE: Must be willing to work 3rd SHIFT Friday through Tuesday, 12 am-8:30 am after initial training period (training will last approximately 2 weeks and will run Tuesday through Saturday, 4pm – 12:30 am).

This position will be assisting with the OCIO Operators with the IA Department of Revenue systems.

Some duties will include the following in addition to the requirements listed in the skill area:

Monitor mainframe jobs
– Alert appropriate customers/programmers of potential problems.
– Report all job failures and other problems to Program Manager and assist with resolution.
– Report and coordinate resolution of all problems in the absence of Program Manager.
– Assist and provide support to Program Manager
– Knowledgeable in JCL

Reporting
– Distribute customer daily reports
– Maintain unique scheduling calendar
– Update all documentation (SOPs, logs etc)
– Provide statistics gathered from various sources

Printing output
– Print nightly output
– Print state warrants
– Deliver output

After hours help desk
– Answer phones
– Resolve issues
– Escalate to duty officer problems that cannot be resolved.

20190125

Job Description:
Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

•Designs, implements and supports data warehousing. Implements business rules via stored procedures, middleware, or other technologies. Defines user interfaces and functional specifications. Responsible for verifying accuracy of data, and the maintenance and support of the data warehouse. Knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, performance tuning. Demonstrated problem resolution skills with team of persons, and strong leadership with implementation team Experience in data warehouse design and data modeling (both relational and dimensional) and development and maintenance of multi-dimensional data models. Development experience in implementation of data warehousing utilizing RDBMS. Understanding of data warehouse Metadata concepts, tools and different data warehouse methodologies. Expertise in SQL and proficiency in database tuning techniques. Responsible for the ongoing architecture and design of the data warehouse, data mart, and reporting environments. Develop strategies for flexibility and scalability, and define the future technical architecture direction for the business intelligence reporting physical environment.
•Responsible for proper selection of appropriate hardware, software, tools and system lifecycle techniques for the different components of the end-to-end data warehouse architecture including ETL, metadata, data profiling software, database platform, performance monitoring, reporting and analytic tools. Defining and documenting the technical architecture of the data warehouse, including the physical components and their functionality. Setting or enforcing standards and overall architecture for data warehouse systems. Monitoring the data warehousing industry and assisting in establishing the organization’s data warehousing strategy and section of strategic warehousing tools and techniques. Ensuring compatibility of the different components of the DW architecture and ensuring alignment with broader IT strategies and goals. Ability to educate the project teams on the standards and architecture of each component of the data warehouse architecture. Very strong written and oral communication skills, including some presentation skills.

20190125

3rd Shift position needed

Due to the access and data involved, US Citizenship and completed drug screen is required.

This position is responsible for initiating Incidents for State of Michigan Critical Business Functions. Manages Medium, High, and Critical Incidents, including triage and assessment of impacted systems. Escalates Incidents to tier II for Major Incident investigation. Notifies and escalates to support teams using Standard Operating Procedure (SOP) 12. Sends Communications Matrix Notifications using SOP12-2 for High and Critical Incidents. Monitors server and network system monitoring tools and responds appropriately to alarms. Monitor the environmental equipment (Generators, UPS, PDU, Air Conditioning and buildings water supply) to ensure their proper operation. Complete documentation of how the problem/issue was uncovered, who it affected, and the steps taken up to and including the final solution. Monitor the security equipment and situations to ensure their proper operations and report all issues/irregularities to the proper organizations/persons. Track and monitor security concerns. Complete documentation of how the issue/irregularity was uncovered, who it affected, and the steps taken up to and including the final solution. Monitors system resources (e.g. processor, memory and input/output) to ensure that Service Level Agreement performance criteria are met and that system resources are not being over-utilized by one customer. Opens trouble tickets and assign to the appropriate support group. Grants physical access to hosting centers both locally and remotely. Administers established security policy for physical access to the (2) Hosting Centers. Executes programs and jobs on the mainframe computers utilizing an operator display terminal. Controls production utilizing Automated Scheduling Systems to ensure that jobs are completed in the time required by the customers. Responsible for tape library functions including pulling and hanging tapes for production, test batch processing, managing off-site storage and logging user input tapes as needed. Prepares and submits status reports detailing system operations. Reads, comprehends, and complies with email messages in timely basis. Uses communications tools appropriately to receive and disburse information. Answers and makes phone calls as necessary. Communicates statuses using tools such as trouble tickets, status boards, broadcast messages and status reports. Reviews the Change Management Forward Schedule of Change and updates Requests for Changes (RFC’s) as needed, when requested by the change builders.

20190125

The Help Desk Specialist is responsible for providing support to end users on a variety of issues. This position identifies, researches, and resolves technical problems. This position is governed by state and federal laws and agency policy.

TYPICAL FUNCTIONS
Responds to telephone calls, emails, and personnel requests for technical or informational support. Confers with clients by telephone or in person, in order to provide information about services, to take orders or cancel accounts, or to obtain details of complaints. Documents, tracks, and monitors the problem to ensure a timely resolution. Provides support to users on a variety of issues related to hardware, software, and peripheral equipment or agency related information. Enters systems commands and observes functioning to verify correct operations or errors. Utilizes technical manuals and conducts computer diagnostics to investigate and resolve reported problems. Evaluates and prioritizes requests for help and escalates high priority requests to appropriate staff members. Identifies, searches, and resolves technical problems or reported inquiries and complaints. Assists in the development of problem resolution procedures for new and existing computer systems. Performs other duties as assigned.

KNOWLEDGE, ABILITIES, AND SKILLS
Knowledge of problem recognition, research, isolation, and resolution steps. Knowledge of computer installations of new hardware and software. Knowledge of agency/institution specific program information, software, and hardware. Ability to communicate with clients, orally and in writing, to gather appropriate information, and process or escalate complaints and requests to the proper personnel. Ability to design and update computer problem resolution procedures.

MINIMUM QUALIFICATIONS
The formal education equivalent of an associate’s degree in computer science, mathematics, communications, or a related field; plus three years of experience in call center or communications support. OR Completion of technical training in computer science, data processing, communications or a related field acquired from a vocational, military or industrial setting; plus three years of experience in call center or communications support. Additional requirements determined by the agency for recruiting purposes require review and approval by the Office of Personnel Management. 

20190124

Cloud Security Architect reporting into the DTMB’s Michigan Cyber Security department with dotted line reporting relationship to DTMB’s Enterprise Architecture department. Responsible for the security architecture for Cloud, IaaS, tenant platforms.

Years of Experience:
7+ years of experience in security architecture
10+ years of experience in information security (engineering, analyst, incident response)
10+ years of experience working with computer systems
10+ years of experience working with network software and hardware, data or voice as well as experience with open and proprietary software and hardware

Job Description:
• Establish the target security/infrastructure architecture for security platforms.
• Acts as consultant and subject matter expert to leadership and project sponsor in defining the vision, objective and scope of major security related work projects and programs.
• Consults with project delivery teams and solution providers to implement security architecture frameworks and solutions.
• Consults and researches with vendor product specialists/sales, independent research organizations, on-site support engineers and fellow architects and administrators on best-fit technologies and also ensure compliance to department policies & standards and technology roadmap.
• Coordinate with Enterprise Architecture team for technology validation or suggestions for alternative solutions. If necessary, initiate Solution Assessments, Infrastructure Service Requests, and any applicable required documentation to implement the new technology.
• Advocates the use of emerging cyber security best practices, technologies, developing standards and procedures, promoting the usage of automated tools, developing strategies, and aligning practices with strategic initiatives.
• Authors requirements, including definition of dependencies on infrastructure consolidation efforts.
• Authors design related artifacts (Functional Design, System Design, Security Architecture)
• Produce architectural framework documents i.e., white papers, guidance documents, best practices, technical reports, etc.
• Performs security architecture and general security reviews for new infrastructure and system implementations
• Define Security/Information Assurance requirements (and dependencies).
• Specify key architectural aspects of the architecture view and identify other aspects that need definition.
• Project contributor representing security and participates in project plan development
• Provides project estimates based on past experience with security implementation-based projects and programs
• Leverage broad-based understanding of technology areas and end-to-end knowledge of current installations to craft architectural solutions or standards that can be applied across the enterprise.
• Operate within the context of the State of Michigan – State Unified IT Environment (SUITE) process methodology.
• Provide strategic and architectural support for cyber Security as a Subject Matter Expert.
• Provide support and subject matter expertise with respect to adherence to security controls (e.g. NIST 800, CIS, and related)
• Provide support and subject matter expertise with respect to adherence to Enterprise Architecture Frameworks (e.g. TOGAF or related)

A candidate with Consulting experience is desirable. Candidate must have technical know-how, strategic vision as it pertains to Security Architecture and capabilities. Candidate will need to represent the department as a Security Expert across the organization. We are looking for a candidate who has done this type of role in the past with proven results. Candidate must have worked in large, complex, challenging organizations.

20190122

IN-PERSON INTERVIEWS ONLY

Senior TSQL Developer with strong coding skills and extensive experience designing, developing and maintaining complex TSQL stored procedures, SSRS reports, and database schemas.

Project Detail:

Federal reporting requirements are changing after the first of the calendar year. These new reporting requirements will require modifications to existing, complex SQL stored procedures that generate data files for quarterly submission to the Rehabilitation Services Administration (RSA).
Several SSRS reports are near completion but require additional code modifications and testing to validate the accuracy of calculations and data presented on each report.

The person in this role will be working primarily with a Business Analyst and a Case Management Systems Project Manager. Much of the technical T-SQL programming and SSRS development will be the sole responsibility of this position. There are, however, staff that does have limited technical knowledge who will be able to assist with introducing the Case Management database and related stored procedures.
• Tools used will be Microsoft SQL Server 2008 R2, Microsoft Team Foundation Server 2017, Microsoft SQL Server Reporting Services 2008 R2, Microsoft SharePoint 2010.
• Day to day duties will include developing and maintaining T-SQL code and using SSRS to design and create new reports and maintain existing reports.
• There will be situations where database schema changes and additions will be necessary to satisfy the business rule requirements.
• Testing all approved changes before user acceptance testing will be required for all code additions and changes planned for migration to the production environment.

20190121

As a Senior Database Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to designing, developing, testing, and implementing database systems for the Michigan Department of Corrections (MDOC). This individual will be looked upon to provide technical support to other team members and evaluate new database solutions and technologies. Provide maintenance, support and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication, and database backup solutions.

General Summary of Duty 1:

As a senior level information technology programmer/analyst, uses advanced principles and procedures of systems design methodology, structured systems design and automated data processing techniques for new and existing complex computer applications.

Individual tasks related to the duty:

– Research, draft and recommend database standards and policies.
– Coordinate with vendor support to address technical issues that could not be resolved in-house.
– Participate in the planning process to match emerging technologies with future business needs.
– Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
– Calculate disk space requirements for existing and/or new installations and growth based on changing business requirements.
– Measure and/or forecast current capacity, gauge the growth of capacity over time, and factor in the anticipated capacity requirements to determine whether the existing infrastructure can sustain the anticipated workload.
– Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.
– Research, analyze, and determine appropriate hardware changes to support future application and database needs. Report recommendations to appropriate DBA specialist and/or technical services.
– Review results of database integrity checks. Resolve identified issues.
– Design appropriate strategy to reorganize database objects to release unused space or repair fragmentation.
– Install database management software in any environment
– Install database patches and service packs in any environment.
– Provide maintenance, support and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication solutions, and database backup solutions.
– Review, install, analyze and implement security patches to be applied to remain Payment Cared Industry (PCI) compliant, vendor compliant, and Michigan Cyber Security compliant.
– Designs the security model based on set standards. Create database user accounts and schemas in production environments based on defined and approved forms and procedures.
– Define/design roles and profiles.
– Recommend standard password security policies.
– Implement data encryption.
– Design, configure, and initiate auditing with appropriate options as needed.
– Create and deploy new database in development and test environments.
– Ensures and validates the integrity and quality of the scripts to be promoted to any of the environments.
– Provide guidance to systems analysts, based on documented standards, in creating and modifying application specific
database objects.
– Perform Data Export/Import/Load and data transformations between databases in production environments.
– Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.
– Analyze and resolve database space utilization in production environments. Analyze and resolve issues with database
integrity in development, test, and production environments.
– Design and implement database backup solutions based on the business needs which include: configuration, testing,
implementation, modification, automation and monitoring of the backup and recovery solution as needed; troubleshoot
and resolve more complex backup issues. Work with the Enterprise Backup and Recovery (EBUR) team to design and
implement backup policy using available technology.
– Perform database restorations and point in time recovery to avoid data loss and meet service levels objectives.
– Perform troubleshooting of performance issues and provide required solution.
– Analyze databases for optimal performance and investigate poorly performing SQL statements and offending database sessions. Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods. Document tuning procedures.
– Perform thorough analysis and investigation to resolve locking conflicts. (For example: Locking conflicts can be shared or exclusive. Shared involve multiple users accessing the data or table at the same time. Exclusive is when only one user or process can access the data at a time. Locking conflicts can also be at different levels and an incorrect resolution can use corruption or loss of data.)
– Analyze and resolve issues related to undo/redo/transaction log configuration and sizing in development, test and production environments.
– Analyze and resolve server generated and threshold-based alerts. Perform resolution for the alert causes and provide recommendations for setting up appropriate alert thresholds.
– Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performances.
– Monitor database jobs and scheduled processes, perform troubleshooting and provide resolution for any issues with jobs/processes as necessary. Document solution and provide root cause analysis.
– Agrees to follow all policy, standards and procedures of DTMB.

General Summary of Duty 2:

Database Storage and Capacity Planning: Monitor current space usage and contention. Do capacity planning for future expansions of current application data and new application needs.

Monitor and maintain the supported relational database management systems software and server environments. Provide required support for service requests, change management, and coverage during business hours.

Assist with internal System Support Team projects and research and reporting.

Individual tasks related to the duty:

– Recommend the procurement of new memory, CPUs and servers when necessary.
– Monitor database backups, schedule jobs, performance, capacities (space, memory), error logs, event logs, and general activity on the SQL servers.
– Monitor usage of all databases to identify and assist in resolution of problems with database access, index fragmentation, and processing or response times.
– Monitor supported relational database management systems security logs and report any inappropriate activity.
– Provide technical advice and guidance to application development staff on SQL syntax and the development of database objects such as stored procedures, indexes, and triggers.
– Work cooperatively with other System Support Team staff to provide required coverage for database services.
– Monitor Remedy and Service Requests to resolve requests per System Support Team Guidelines.
– Use prescribed Change Management practices to complete application database object modifications, manage SQL user IDs and privileges, and ensure separation of test, QA, and production environments.
– Assist application developers in defining database requirements for application system projects or enhancements.
– Keep current on database industry trends and future database software features for supported relational database management systems.
– Provide status reports as requested by management.
– Update Activity Monitoring and other tools as required with appropriate information.
– Provide metrics, logs and reports as requested by management.
– Assist in the development and documentation of database procedures, standards, best practices and change management processes.
– Monitor and enforce existing database standards and best practices, or report exceptions to Support Team Management.

20190121

The Senior Business Analyst/Consultant serves as the communication bridge between non-technical business users and technical solution developers. They has a depth of knowledge in business analysis processes including knowledge of facilitation, methodology, tools, and techniques. They are responsible for analyzing the raw data gathered by the project team, then applying the appropriate tools and techniques to create meaningful results. This individual is an active participant in aspects of department assessment, visioning, and reengineering, they rely on experience and judgment to plan and accomplish goals, they independently perform a variety of complicated tasks, such as identifying and documenting business requirements, they may lead and direct the work of others, and they may report directly to a project lead or manager. A wide degree of creativity and latitude is expected.

Position Description:

• Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. Familiar with industry standard (including Legacy, Core, and Emerging technologies), business process mapping, and reengineering. Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc. Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.

• Prepare and document Functional and Technical Specifications for reporting and data warehouse work. Assist with business warehouse/intelligence support and enhancements. Develops RFPs. Assist in deployment and management of end-user reporting tools and platforms. Work with IT and business project teams to understand reporting and data warehousing requirements and propose solutions. Document and provide knowledge transfer to the rest of the Enterprise Reporting Team for all solutions.

• Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Familiar with relational database concepts, and client-server concepts. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a project manager. A wide degree of creativity and latitude is expected.

The Senior Business Analyst/Consultant must have the following experience, skills and expertise:

Experience Required:
a. Bachelor’s degree in area of specialty and 10 or more years of experience in the field or in a related area
b. Documented experience in facilitating requirements gathering sessions for systems implementations
c. Documented experience in requirements gathering sessions and writing EPICS and User Stories for systems implementations
d. Documented experience in creating various project artifacts, such as product and sprint backlogs (user stories), requirements specifications and traceability, and functional and technical specifications
e. Documented experience in the development of Functional design documents.
f. Experience in Agile and Iterative development
g. Experience working with Application Lifecycle Management (ALM) tools, such as TFS or similar
h. A minimum of 8 years of experience in verbal and written communication with clients and technical staff in English.

Skills Required:
a. Strong analytical and problem solving skills
b. Detail oriented and able to quickly absorb and apply key aspects of the projects
c. Able to function effectively in a fast paced work environment
d. Ability to train end user on software solutions
e. Able to handle multiple priorities
f. Able to deliver against deadlines with reasonable accuracy
g. Good interpersonal skills; ability to work independently as well as part of a team
h. Excellent verbal and written communication skills
I. Able to effectively deal successfully with a large variety of management personnel and users
j. Capability of giving attention to detail while still understanding and dealing with the global aspects of the project

Description of the requested work, including deliverables and knowledge transfer
The scope-of–work is to serve as a Senior Business Analyst/Consultant for various MDOT projects; the scope-of-work includes the following:

a. Facilitate requirements meetings
b. Create product and sprint backlogs, identify development tasks, and create test plans/cases
c. Document business requirements, functional and technical specifications, and test cases
d. Track and Trace deliverables, route for review as needed and tabulate feedback
e. Connect data mapping pieces to produce end to end conversion schematic
f. Provide methodologies and tracking for Test Cases
g. Post documents to SharePoint
h. Conduct research to identify detailed requirements pertaining to interfaces and other key aspects of the project.
i. Assist in the creation of presentation materials
j. Other duties as required

20180121