Business Analyst - Data Engineering

Req ID: 415125

BASIC PURPOSE: Perform business analysis activities for the Data Engineering team, including requirements elicitation, tracking, clarification and communication, specification writing, recommending, and validating solutions. This position will focus on business analysis related to the delivery of trusted data to support multiple lines of business and cross-functional needs for the Love's Family of Companies.

MAJOR RESPONSIBILITIES/SKILLS:

• Analyze and document as-is and to-be processes, data and systems utilizing appropriate diagramming and documentation methodologies
• Elicit, communicate and manage requirements
• Working knowledge of business areas supported (data analysis process, data development process, etc.) to help identify and recommend system solutions
• Understand integration points between internal and external systems relevant to business processes and systems supported
• Understand and ensure that quality standards are met relevant to documentation and solution delivery - complete solution specifications and functional design documents, acceptance criteria in user stories and other forms of requirements documentation as needed
• Work with technical resources to deliver solutions, troubleshoot issues and identify opportunities for improvement, including error handling and monitoring
• Creation and execution of test plans and scripts in support of QA testing the solution delivery
• Perform root cause analysis of issues and recommend resolutions
• Work with senior team members and business leads to prioritize work
• Clearly communicate work status to business leads, manager, and other stakeholders
• Work on project delivery and support once solutions are in production
• Identify tasks and resources necessary to engage in delivery of solutions
• Identify error handling required to monitor solutions
• Identify trends and exceptions in processes and make recommendations for course of action
• Fundamental understanding of data warehousing principles
• Experience with various Data Management architectures like Data Warehouse, Data Lake, Data Hub, Data Vault and the supporting processes like Data Integration, Governance, and Metadata Management
• Experience working with large, heterogeneous datasets in building data pipelines and integrating datasets using traditional data integration technologies, including ETL/ELT, data replication/CDC, message-oriented data movement, and API-based data acquisition
• Responsible for the identification and qualification of source data to satisfy master and transactional data requirements for the target warehouse

EDUCATION AND EXPERIENCE:

• Required Experience:
  • Experience with cloud data warehouses, such as Snowflake
  • Experience writing and understanding complex SQL code
  • Experience working with DevOps capabilities like version control, automated builds, testing and release management using tools like Git
  • Experience with ETL tools

• Preferred Experience:
  • SQL Server 2012 experience a plus
  • SAP Hana experience a plus
  • Tableau experience a plus
  • Power BI experience a plus
  • R/Python experience a plus
  • Familiarity with replication software a plus

• Education:
  • HS Diploma or equivalent required
  • Bachelor's degree in Business with MIS or technology related degree
  • Must be eligible to work in the US without sponsorship

INTERPERSONAL SKILLS & CHARACTERISTICS

• Facilitation and communication skills, including ability to communicate according to audience
• Capable of thinking big picture and sorting through an ambiguous environment
• Ability to manage numerous competing demands in a fast-paced environment
• Demonstrates good judgement, sense of urgency and commitment to high standards of ethics, regulatory compliance, customer service and business integrity
• Required to be highly creative and collaborative
• Excellent verbal and written communication skills
• Ability to communicate clearly and concisely to various levels in the organization

PHYSICAL DEMANDS:

• Requires prolonged sitting, some bending and stooping.
• Occasional lifting up to 25 pounds.
• Manual dexterity sufficient to operate a computer keyboard and calculator.
• Requires normal range of hearing and vision

Job Function(s): Information Technology

Love's Travel Stops & Country Stores is the industry-leading travel stop network in the United States. For more than 55 years, we've provided customers with highway hospitality and "Clean Places, Friendly Faces." We're passionate about serving drivers with clean, modern facilities stocked with fuel, food and supplies. We offer meals from popular restaurant chains, trucking supplies, showers and everything needed to get back on the road quickly. The Love's Family of Companies includes:

• Gemini Motor Transport, one of the industry's safest trucking fleets
• Speedco, the light mechanical and trucking service specialists
• Musket, a rapidly growing, Houston-based commodities supplier and trader
• Trillium, a Houston-based alternative fuels expert

The Love's Experience

Love's was founded in 1964 on the values of integrity, customer focus, strong work ethic, innovation and perseverance. We are looking for these in every person we hire. No matter what job you do for Love's, your commitment to these values will not only continue our legacy of growth, it will also ensure your successful career.