BI Developer II

Req ID: 407388 

BASIC PURPOSE: As a BI Developer II for Loves, the successful candidate will be responsible for the design and development of SSRS reports using the Microsoft suite of tools. Working under the BI Supervisor, the candidate will be responsible for developing state of the art, enterprise-class reporting solutions that are supportable and scalable.  The candidate must also demonstrate the ability to collaborate and effectively work with other IT and business teams throughout the planning, designing, testing, and implementation phases.  Strong communication skills are also required when dealing with internal and external parties, including vendors and business partners.

MAJOR RESPONSIBILITIES:

• Work with business units to refine requirements to enhancements and new report requests
• Work effectively within a team-oriented environment
• Maintain a customer-focused attitude
• Ensure design and development standards are current and being followed
• Ability to effectively manage multiple initiatives concurrently
• Create complex reporting solutions for multiple business areas
• Develop scalable solutions to meet business needs
• Design, implement, and maintain complex ETL processes using SSIS
• Create technical documentation
• Other duties assigned as needed

EDUCATION AND EXPERIENCE:

• Required Experience:
  • 5+ years of SQL Server Reporting Services (SSRS) experience in SSRS 2008R2 or later
  • 5+ years of SQL Server Integration Services (SSIS) experience
  • Power BI experience
  • Microsoft SQL Server 2012, 2016, 2019
  • Fundamental understanding of data warehousing concepts
  • Hands-on experience with Azure Dev Ops
  • Experience with job scheduling tools
• Preferred Experience:
  • Snowflake experience
  • Exposure to, and willingness to learn SAP Business Objects
  • Exposure to, and willingness to learn SAP Hana
  • Exposure to, and willingness to learn SAP BW
  • Hands-on experience with Azure DevOps
  • Agile project experience
• Education:
  • HS Diploma or equivalent required
  • Bachelor’s degree in Business with MIS or technology related degree (C.S.)

SKILLS AND PHYSICAL DEMANDS:

• Skills:
  • Ability to manage numerous competing demands in a fast-paced environment
  • Must be self-motivated and require minimal supervision with excellent problem-solving skills
  • Excellent verbal and written communication skills
  • Ability to think big and offer solutions that go beyond written requirements
  • Ability to develop detailed technical design documents based on requirements       
• Typical 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