Business Intelligence & ETL Developer

Dillards • Little Rock, AR

17h • Onsite

About The Position

Dillard’s is seeking an experienced, highly motivated Business Intelligence & ETL Developer to contribute to business goals by developing end-to-end business intelligence solutions, from data extraction, modeling, and loading through delivery of business reporting solutions. This role is part of the Business Intelligence team, which provides data and business reports to partners across the company. The reports support business decisions and require accurate, timely data. The work is fast-paced and offers exposure to many areas of the business.

The position is full-time and on-site at Dillard’s headquarters in Little Rock, Arkansas. A high level of attendance is an essential function of the role. Immigration sponsorship is not available.

Requirements

• Strong troubleshooting and diagnostic skills.
• Advanced SQL skills.
• Proactively seek improvement opportunities and make constructive suggestions for changes to existing processes or procedures.
• Stay current with emerging industry best practices.
• Work effectively in a collaborative team environment.
• Be a highly motivated self-starter with good communication skills.
• Demonstrate critical-thinking skills.
• Working knowledge of business intelligence concepts and data warehousing methodologies and best practices.
• Experience programming in Python, Kornshell, or other scripting languages.

Nice To Haves

• IBM Cognos experience.
• Exposure to InfoSphere DataStage or a similar ETL tool.
• Experience with data warehouse platforms.

Responsibilities

• Gather business requirements and identify the data needed to develop successful solutions.
• Develop ETL processes to load data into the data warehouse using DataStage, Kornshell, Python, and SQL.
• Design and develop standard business intelligence reports.
• Write and implement data validations and ensure the cleanliness and accuracy of data and report outputs.
• Work with BI Technical Architects to tune SQL.
• Perform ad hoc analysis to answer one-off business questions and support immediate decisions.
• Contribute to peer code reviews and on-call rotations.
• Participate in department-wide initiatives to maintain and improve foundational infrastructure.
• Engage in modernizing ETL processes.

What This Job Offers

• Job Type: Full-time
• Education Level: No Education Listed