Data Engineer

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. Perform data load, data extraction. 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. Python for building and redefining data pipelines is required. Education and/or Experience: Bachelor’s Degree in MIS, Computer Science, or related field, or equivalent professional experience. Minimum 4 years of designing and implementing Data engineering solution. Hands on experience with building productionized data ingestion and processing pipelines. Experience working in business intelligence and data warehousing environments. MS SQL Server, Integration Services (SSIS) 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. Experience with Snowflake. Experience using Python. Industry experience working with large data sets. Experience with Microsoft PowerBI or any BI visualization tool is a plus. Familiarity with Dev OPS, Airflow and DBT is a plus. 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. For over 50 years, World Finance has been helping customers focus less on the unexpected expenses of life, and more on what makes life so sweet. In doing so, we offer personal installment loans that suit the specific needs of our customers while simultaneously delivering outstanding customer service and we are always looking for great people to join our team. Located in 16 states, our network of branches work to provide good to the communities around them. World Finance was recently recognized as a Top Workplace and we are looking forward for new Team Members to join us and be a part of the continuous growth!