Dohrn Transfer is a leading Midwest LTL Carrier providing less-than-truckload, truckload, and value-added services throughout our 10-state service area. Join our team and become a part of our new growth and bright future! We offer competitive salary and a great benefit package in an exciting, rewarding industry.

Dohrn is seeking a Full Time Data Analyst at our corporate office in Rock Island, IL.

Hours: Monday-Friday, 8am-5pm

Salary starts at $70,000/year and is based on experience

Benefits: Health / Vision / Dental insurance, 401k matching, life insurance, short/long term disability and more.

Purpose:

This position is responsible for the development and support of custom reports using MS SQL Server Reporting Services and Tableau. As well as, developing and maintaining ETL pipelines to prepare data for analysis and reporting. Functions include planning, designing, coding, testing and deploying of custom reports to internal and external customers.

ESSENTIAL FUNCTIONS:

• Develop and support many reports using MS SQL Server Reporting Services and Tableau
• Manage multiple reporting requests in a deadline-driven environment
• Analyze, evaluate and interpret data from key systems
• Responsible for regularly scheduled reports (daily, weekly, monthly) for internal/external customers
• Build and support ETL workflows using SQL Server Integration Services (SSIS) and Python
• Responsible for regularly scheduled reports (daily, weekly, monthly) for internal/external customers
• Ability to react to change quickly and handle other essential tasks as assigned

OTHER DUTIES:

• Attend and actively participate in team and department meetings
• Timely submissions of status reports and project documentation
• Drafting support documentation (knowledge base articles)
• React to change productively and handle other tasks as assigned

MINIMUM REQUIREMENTS:

• High School completion or equivalent
• Valid Driver License
• Proficiency in SQL
• Experience using MS SQL Server (2017 and above) or equivalent
• Working knowledge of Microsoft SQL Server Reporting Services and Tableau or similar
• Working knowledge of Visual Studio and Report Builder
• Hands-on experience with SSIS and Python for data transformation
• Two-year technical degree preferred or equivalent work experience can be acceptable
• 1 to 3 years data reporting experience
• Strong interpersonal, written and verbal communication skills
• Strong problem solving and analytical skills
• Ability to work on tasks independently and within a team environment
• Punctuality and excellent attendance

WORKING CONDITIONS/PHYSICAL REQUIREMENTS:

• Weekend and night hours may be occasionally required
• Primarily sedentary work. Sedentary work involves sitting most of the time; May be occasionally required to exert up to 10 pounds of force and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects
• The office/cubical environment is generally favorable; Lighting and temperature are adequate, and there are minimal hazardous or unpleasant conditions caused by noise, dust, etc; Environment includes co-workers talking on the phone within close proximity
• Visual Acuity including regular use of items including a computer screen or monitor.
• Manual dexterity is regularly required including fingering, grasping, and typing; manual dexterity includes repetitive motion of the wrists, hands, and fingers
• Talking and hearing required to communicate with and listen to others to share or receive information as there are multiple regular meetings; May be occasionally exposed to noise including telephone, office machinery, and conversations of others
• This is an in-office role

Dohrn Transfer Company, LLC is an Equal Employment Opportunity (EEO) employer and welcomes all qualified applicants. Applicants will receive fair and impartial consideration without regard to race, color, religion, age, sex, sexual orientation, gender, gender identity or expression, national origin, geographic background, physical and/or mental disability, protected veteran status, or any other classification protected by applicable law.