BI & ETL Developer

Dillard's, Inc.; Little Rock (AR); On-site; USD 85,000 - 120,000; Full time

Job summary

Dillard's, Inc. seeks an experienced BI & ETL Developer to create end-to-end BI solutions from data extraction through reporting delivery. Advanced SQL, Python or scripting languages are required, with strong collaboration and problem-solving skills.

Onsite work at Corporate Headquarters in Little Rock, AR is expected as part of a fast-paced BI team delivering timely, accurate data. The role emphasizes ETL design, data quality, and reporting, with opportunities to modernize ETL processes and

Qualifications

• 3+ years of experience in BI/ETL
• Experience with data integration and data warehousing
• Strong SQL, Python, and scripting skills

Responsibilities

• Gather business requirements and data needed to derive solutions
• Develop ETL processes to load data into the data warehouse using Datastage, KSH, Python, and SQL
• Design and Develop standard BI reports
• Write and implement data validations ensuring data and report accuracy
• Work with BI Technical Architects to tune SQL
• Perform ad hoc analysis for quick business decisions
• Contribute to peer code reviews and on-call rotations
• Participate in initiatives to maintain and improve foundational infrastructure
• Engage in ETL modernization efforts

Skills

Advanced SQL

Python scripting

KornShell

Collaboration

Communication

Critical thinking

BI concepts

Data warehousing

Tools

Datastage

KornShell

Python

SQL

Job description

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, is a critical thinker & problem solver, and has strong communication skills.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.

ROLES & RESPONSIBILITIES

• 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

REQUIRED SKILLS

• Authorization to work in the United States without sponsorship
• Ability to work onsite at Corporate Headquarters in Little Rock, AR
• 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

MINIMUM YEARS OF EXPERIENCE

• 3 Year s

DESIRED SKILLS

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

About Us

Dillard's was founded by William T. Dillard in 1938 in Nashville, Arkansas with an $8,000 investment in a hometown department store.Today, Dillard's, Inc. ranks among the nation's largest fashion retailers – operating 250 Dillard's locations and 32 clearance centers spanning29 states and an Internet store at www.dillards.com. The company focuses on delivering style, quality and value to its customers by offering premium fashionapparel, beauty and home collections from both national and exclusive brand sources. Dillard's complements this curated merchandise assortment with exceptional,client-focused customer care.