Data Engineer

The Data Engineer implements data-centric solutions to complex business problems. This individual will work alongside a data architect and the data engineering team to expand and optimize data delivery architecture. Providing expertise in data warehousing and data delivery, this individual will work with cross-functional teams including marketing, analytics, operations, and software engineering to build data-aware systems and process flows across the enterprise.

Essential Duties and Responsibilities:

• Protect confidential company information.
• Assist business, technology, and support partners/stakeholders to deliver secure data solutions.
• Design, build, and maintain data delivery solutions in accordance with governing data architecture patterns.
• Model and assemble data sets that meet functional and technical business requirements.
• Implement infrastructure required to optimize ETL and ELT operations across a variety of data sources.
• Process file-based data extracts using data retrieval and management tools to provide timely loading of critical business data.
• Identify, design, and implement process improvements in data flows and data pipelines, focusing on automating data tasks.
• Integrate external systems with internal systems to ensure proper data flow between systems.
• Maintain an accurate and comprehensive inventory of data, data systems, and data storage.
• Communicate with non-technical stakeholders to determine technical solutions to business problems.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required:

• Expertise with relational databases.
• Advanced SQL proficiency.
• Experience working with data warehousing systems for large enterprises with both internal and customer facing applications, preferably with near real time transactional data.
• Expertise in creating and maintaining data structures in SQL.
• Experience structured and non-structured data paradigms, relational databases, data lake and data warehouse technologies, data vault and dimensional data models.
• Ability to define problems, collect data, establish facts, and draw valid conclusions.
• Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.
• Ability to conduct research into systems issues and products to determine integration requirements.
• Ability to communicate ideas in both technical and user-friendly language.
• Ability to work with IT operations to quickly come to resolution of open support requests
• Self-motivated and able to work within a project-based environment.
• Possesses strong oral and written communication skills, clearly and accurately communicating complex and/or technical information to both technical and nontechnical audiences.

Education and/or Experience:

• Bachelor’s Degree in MIS, Computer Science, or related field, or equivalent professional experience.
• Experience working in business intelligence and data warehousing environments.
• MS SQL Server, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS) required.
• Strong TSQL scripting abilities and understanding of complex stored procedures, views, data. aggregation/manipulation through table joins/queries, database design, normalization, and de-normalization techniques.
• Demonstrated experience in data extraction and manipulation and Bulk Loading ETL techniques.
• Industry experience working with large data sets.
• Proficiency in Electronic Data Interchange (EDI) is a plus.
• Experience with Microsoft PowerBI is a plus, experience with a business intelligence and reporting platform preferred.

Physical Demands:

• Must be able to constantly remain in a stationary position.
• The person in this position needs to occasionally move about inside the office to access file cabinets, office machinery, etc.
• Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and computer printer.
• Occasionally may require light lifting to 25 pounds.

Work Environment:

• Office environment.
• Occasional travel may be required.

This job description reflects management’s assignment of essential functions; and nothing in this herein restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

It is the policy of World Acceptance Corporation to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, World Acceptance Corporation will provide reasonable accommodations for qualified individuals with disabilities.