Business Intelligence & ETL Developer

Dillards • Little Rock, AR

1d • Onsite

About The Position

Dillard’s is seeking an experienced, highly motivated Business Intelligence & ETL Developer to develop end-to-end business intelligence solutions, including data extraction, modeling, loading, and delivery of business reporting solutions. The role is part of the Business Intelligence team, which provides data and business reports to partners across Dillard’s. The team’s 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, including H-1B, TN, or STEM OPT sponsorship, is not available.

Requirements

• Strong troubleshooting and diagnostic skills.
• Advanced SQL skills.
• Proactively seek opportunities for improvement and make constructive suggestions for changes to existing processes or procedures.
• Remain current with emerging industry best practices.
• Work effectively in a collaborative team environment.
• Be a highly motivated self-starter with good communication skills.
• Be a critical thinker.
• Have working knowledge of business intelligence concepts and data warehousing methodologies and best practices.
• Have 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 provide business users with one-off answers for immediate decisions.
• Contribute to peer code reviews and on-call rotations.
• Participate in department-wide initiatives to maintain and improve foundational infrastructure.
• Engage in the modernization of ETL processes.

What This Job Offers

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