Remote ETL Salesforce Business Systems Analyst

Company: Murtech Consulting
Location: Garland
Posted on: June 23, 2022

Job Description:

Job Title: Remote ETL Salesforce Business Systems Analyst - Contract to Hire - Must be US Citizen or Greencard HolderPosition Location: 100% REMOTE - EST HoursThis is a technical role - must have experience with testing -Salesforce Business Systems Analysts are responsible for providing support to technical professionals regarding a variety of administrative, systems, and business operations problems, and participation in related Salesforce system development projects of moderate to typically, complex nature.-Responsibilities may include: determining and defining system specifications, process improvement, quality assurance, less experienced team member mentoring, interaction with customers and technical staff, and higher emphasis on business need solutioning (i.e. converting legacy systems/business processes into efficient and effective requirements to be constructed within the Salesforce system).-The Salesforce Business Analyst takes a lead role in communicating effectively with management, steering committees, project sponsors, and subject matter/technical experts and promotes a culture of performance excellence.-Requires strong interpersonal and communication skills, ability to convey the benefits of Salesforce as a tool to increase the level of business/customer knowledge of salesforce tools to enable better outcomes for our customers' expectations.-Salesforce Business Analysts should have the ability to listen to customer needs (via conversations about a current legacy system or requested enhancement) and convert them into Salesforce features they can then convey to the customer to help shape our customers expectations. Once customers understand the changes, the Analyst is expected to document and implement via configuration or development the changes requested per the customer.-Project Management methodologies - must include an understanding of Agile release (Kanban or sprint) and demonstrate experience as a team member working within this methodology. Experience in creating, owning, prioritizing, or grooming of User Stories, Features or Epics via a Scrum/Agile system (Agility for example) to deliver on time and in scope features to the customer is preferred.-Team member must be able to convey a level of Salesforce configuration or Development experience and knowledge to operate in a fast-paced environment. Knowledge/Experience should be at or near a level at which Salesforce Admin Certification questions come easy for this individual to assess.Job Responsibilities:--- Ensure compliance with Data Security mandates--- Attend data conversion meetings, review products, ensure all data anomalies are addressed before migration to the new system and that reconciliation between systems, ledgers, etc. are completed.--- Support the Data Management lead in the oversight and review of all data management plans and artifacts.--- Review Component legacy system data and ensure an accurate understanding of the data elements, structures, and quality is recorded.--- Setup staging environments for data cleansing and conversion activities.--- Assist Components in preparing for migration of legacy data into a new integrated financial, procurement, and asset management system such as executing mock data conversions and cutover activities.--- Support Departmental and Component level Business Intelligence (BI) and Data Warehouse (DW) efforts in conjunction with third-party BI/DW offerings.--- Participate in data migration from legacy systems to SaaS system.--- Analyze data and data models in collaboration with developers.--- Participate in database design with the technical team as needed.--- Facilitate client-facing requirement confirmation and design work sessions.--- Create use case, supplemental specification, and interface specification documents.--- Design system screen layouts.--- Prepare test cases for system testing and user acceptance testing.--- Conduct integration testing and system testing.--- Write SQL queries in Microsoft SQL Server to procure test data, and perform database testing using SQL queries.--- Prepare documentation for system end users and technical system operation manuals.--- Provide required support for the technical team.--- Work with limited supervision and against tight deadlines.--- Prepare technical specifications and documentation for Alteryx workflows supporting BI reports--- Perform end to end Data validationRequired Skills:--- 2 - 6 years of professional experience working in a Business Analyst role for the design, development, and implementation of large-scale solutions.--- Experience evaluating business requirements and working with subject matter experts (SME) and technical analysts (TA) to translate into a functional design.--- Proven ability to develop task plans, manage time effectively across simultaneous project activities, and meet target deadlines.--- 2+ years of related experience with Alteryx HIGHLY PREFERRED--- Hands-on skills and experience in Alteryx Designer, Alteryx Server, and the tools with Alteryx such as Predictive, Parsing, and Transforms HIGHLY PREFERRED--- Experience on similar tools like: Informatica, Talend Pentaho data extraction and manipulation tools. --- 4+ years writing SQL queries against any RDBMS with query optimization. --- Strong analytical, problem solving, and troubleshooting abilities --- Good understanding of unit testing, software change management, and software release management--- Good understanding the star schema and data models in the existing data warehouse.--- Drives assigned tasks to completion within target deadlines.--- Approaches tasks in an analytical manner and focuses on defining a solution to the root need of the task.--- Excellent communication skills (written and verbal) to clearly articulate technical solutions to non-technical staff.--- Experience in facilitating meetings and presenting to technical and non-technical staff.--- A collaborative mindset with the ability to work in team environment, but also self-motivated to produce results with minimal direction.--- Ability to form working relationships with groups of people from varied backgrounds, experience, and education levels.

Keywords: Murtech Consulting, Garland , Remote ETL Salesforce Business Systems Analyst , Sales , Garland, Texas