JobCubby JobCubby
Sign up
Dillards

Business Intelligence & ETL Developer

Dillards Little Rock, Arkansas, United States

Retail · 10,001+ employees

6 h ago
business-intelligence Mid (2-5 yrs) Full-time United States
Create a free account to apply — email only, no card. You can also save this posting or score it against your profile with AI.

Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.

About the role

Develop end-to-end business intelligence solutions including data extraction, modeling, and loading. Create and implement ETL processes and standard BI reports to support business decision-making.

What they look for

SQL Python Kornshell ETL Data warehousing Business intelligence Data modeling Datastage Reporting Data validation Troubleshooting Diagnostic skills IBM Cognos Data analysis Technical architecture

Requirements

Requires advanced SQL skills and proficiency in Python, Kornshell, or other scripting languages. Candidates must have a working knowledge of business intelligence concepts and data warehousing methodologies.

Full description

THE OPPORTUNITY

Dillard’s is seeking an experienced, highly-motivated Business Intelligence & ETL Developer to contribute to our business goals by developing end-to-end BI solutions from data extraction, modeling, and loading to delivery of business reporting solutions. To succeed in this role, you must have advanced SQL skills and be proficient in Python, Kornshell, or other scripting languages. You must also be a self-starter who enjoys working collaboratively and has strong communication skills.

THE TEAM

This role is on our Business Intelligence (BI) team which is responsible for the data and delivery of business reports to many partners within Dillard’s. These reports are a critical part of our business, and we rely on BI to provide accurate and timely data. The work is fast-paced and never dull. Working on this team will allow you to explore many areas of the business.

WHAT YOU WILL DO

  • Gather business requirements, and identify data needed to derive solutions successfully
  • Develop ETL processes to load data into the data warehouse, using Datastage, KSH, Python, & SQL
  • Design and Develop standard BI reports
  • Write and implement data validations and be accountable to the cleanliness & accuracy of the data and report outputs
  • Work with BI Technical Architects to tune SQL
  • Perform ad hoc analysis when business users need a one-off answer to make an immediate decision
  • 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

THE MUST-HAVES

  • Strong troubleshooting and diagnostic skills
  • Advanced SQL skills
  • Proactively seek opportunities for improvement and make constructive suggestions for change to existing processes or procedures
  • Remain at the forefront of emerging industry best practices
  • Work well in a collaborative team environment
  • Highly motivated self-starter with good communication skills
  • Critical thinker
  • Have a working knowledge of Business Intelligence concepts and Data Warehousing methodologies and best practices
  • Experience programming in Python, Korn shell, or other scripting languages

THE NICE-TO-HAVES

  • IBM Cognos Experience
  • Have exposure to InfoSphere DataStage or a similar ETL tool
  • Experience with data warehouse platforms

Location & Hours: This is a full-time, on-site position located at our Little Rock, Arkansas headquarters. A high level of attendance is required as an essential function of this position.

No immigration sponsorship (ex. H-1B, TN, STEM OPT) is available for this position

Similar roles