Excel Expert with Business Analytics experience - ON SITE

Company and Role:

Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for an Excel expert with Business Analytics experience to join the eWarrants application team. This position requires a high level of collaboration, communication, and problem-solving skills, as well as expertise in data analysis and Excel.

Highlights and Benefits:

• On site in Columbus, Ohio with 20% travel within the state of Ohio
• W2 hourly pay rate up to $41hr or salaried equivalent
• Government environment
• Direct W2 hourly or salaried applicants only (no corp-to-corp subcontractors, third parties, or agencies)
• Paid time off and holidays for salaried employees
• 401K, billable bonus, and health, life, vision, dental and short-term disability insurance options for all
• DTS is a proud Women Business Enterprise (WBE) and Woman Owned Small Business (WOSB)!
• Check out our benefits and company information at !

Job Description:

We are hiring an experienced Excel expert with Business Analytics experience to work for us as our direct, W2 salaried or hourly employee to join our team. You will:

• Responsible for the functional data conversion effort for each criminal justice agency.
• Export the data from state-owned systems and provide to the consultant to use in comparison to the data owned and maintained by the local law enforcement entities.
• Collaborates directly with staff and law enforcement or court personnel across the state to research and resolve data issues.
• Become an eWarrants SME and assist existing team members in developing business process flows that support a court or law enforcement entity's unique way of doing business.
• Participate in the rollout of eWarrants including overseeing the entire data conversion effort and data readiness upon go live.
• Travel approximately 20% of the time throughout Ohio to work directly with law enforcement and court personnel in their local environments.
• Be highly skilled in the use of Excel for data manipulation using, but not limited to, the following Excel features:
  • Import of data through Power Queries
  • The development and use of pivot tables
  • Data manipulation through features such as TRIM, Dynamic Arrays and XLookup
  • Use of power pivots
  • Removal of duplicates by using Excel Remove Duplicates feature
  • Use of conditional statements
• Strong communication/leadership skills.
• Strong influence, collaboration, and negotiation experience.
• Ability to collaborate with supporting resources across business and/or functional lines.
• Excellent oral and written skills/possess strong meeting and work session facilitation skills.
• Ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
• Facilitate requirements gathering sessions with non-technical stakeholders without the onsite support of a project manager or technical expert.
• Maintain an understanding of Agile/Scrum methodology and actively participate in scrum ceremonies.
• Solid understanding of prioritization stemming from the elicitation of system and/or user requirements.
• Excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.

Required Skills and Experience:

• Minimum of 4 years as an advanced Excel user within the past eight (8) years.
• Minimum of 4 years in data conversion using Excel or similar tool.
• Minimum of 4 years as a Business Systems Analyst within the past eight (8) years.
• Minimum of 4 years experience eliciting and defining system and user requirements through observation, interviews, and analysis.
• Minimum of 4 years working directly with end-users to define requirements and provide technical advice and assistance in a large-scale environment.
• Minimum of 4 years translating customer needs into formal business requirements.
• Minimum of 3 years experience interviewing non-technical end users to determine and document current business process flows.
• Minimum of 2 years in Business Process Re-engineering.
• Minimum of 4 years experience using Visio to create business process flows including standard flowcharts and swim lane diagrams.
• Minimum of 3 years experience creating test conditions, test cases, and test scenarios.
• Minimum of 4 years experience analyzing end-user needs and conducting fit gap analysis.
• Documented experience as a technical Business Analyst from project initiation through completion on a minimum of two (2) software development or implementation projects requiring a minimum of two thousand (2,000) Full-time Equivalent (FTE) hours to complete.
• Documented experience using project management software () to develop and maintain a Work Breakdown Structure (WBS) on a minimum of two (2) projects.
• Minimum of 4 years experience using a business requirements tracking tool for recording and prioritization of business requirements.
• Documented experience in systems process and data mapping, requirements gathering, and analysis as well as proficiency in the creation of detailed documentation.
• Needs to show at least 1 experience with a large organization like ODPS.
• Must have a valid driver license issued by any US State; driver license must stay valid throughout length of employment.

Desired Skills and Experience:

• Prior experience in working with Criminal Justice and Law Enforcement entities.
• Knowledge of Agile Methodology and/or scrum practices
• Microsoft Azure DevOps and/or Jira or any other collaboration tool

Those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time.

Dedicated Tech Services, Inc. is an Equal Opportunity Employer