Lead Data Engineer

Company: Cash Store
Location: Irving
Posted on: January 15, 2022

Job Description:

Reporting to the Head of Data Engineering, the Lead Data Engineer (Data Engineer IV) is an integral part of the team that is maintaining and operating the Data Warehouse and BI reports. This hands-on leadership position is responsible for ETL activities using Microsoft SSIS/SQL, reporting (SSRS), and analytics (SSAS). This person will also be responsible for developing a working knowledge of Cottonwood's business model and database structures to effectively support the existing platform while working to implement new solutions. This position is based at our Administrative Office (HQ) in Irving (Las Colinas), Texas.Key ResponsibilitiesDesign, write, test, and deploy code for data engineering solutions Participated in design and code review sessions Analyze data, highlight trends, resolve issues, and produce findings Develop technical documentation of processes and infrastructure Support requirements gathering sessions with business stakeholders to understand business and technical requirements Quickly assess a situation then develop and implement effective solutions Proficient in developing and executing test plans including unit and regression testing Troubleshoot problems in the data environment tune for performance optimization Support all aspects of the data System Development Life Cycle (SDLC) Participate in the production support rotation monitoring jobs and scheduled tasks to intervene if issues arise Onboard and mentor other data engineers on the teamRequirementsBachelor's Degree or equivalent Military/other experience At least 5 years of advanced experience in designing, developing data solutions utilizing Microsoft technologies (SSRS/SSIS) Experience with implementing and supporting Kimball data warehousing methodology Knowledge of Relational and Dimensional data modeling Proficient in the use of advanced level T-SQL for developing complex stored procedures, triggers, tables, functions, indexes, etc. Advanced knowledge of Lambda Architecture, Hot (Realtime), and Cold (Batch) Paths Experience with cloud-based data solutions Provide excellent customer service with strong interpersonal, verbal, and written communication and team collaboration skills Local (Dallas/Fort Worth area) candidates only - no relocation Must be currently authorized to work in the United States without sponsorship and not require sponsorship in the futurePreferred QualificationsAt least 2 years of experience in cloud Data warehouse environment using Azure technologies like Synapse, Data factory, Event Hubs Knowledge of Big Data technologies such as the Hadoop ecosystem Experience creating PowerShell script Familiarity with SQL Server Analysis Services (SSAS) Experience developing and/or administering data visualization tools such as Tableau, QlikView, or Power BI Knowledge of Database Administration for Microsoft SQL Server in an Enterprise environment Data science experience using Python machine learning, R statistical modeling, or Data Mining techniques is a plus Previous development experience using an Agile methodology Financial or retail industry experience is a plusCompensationAnnual salary of $126,000BenefitsMedical, dental, and vision Voluntary life/ AD&D Short-term & long-term disability 401K with company match Paid vacation, holidays, and sick time Paid maternity, paternity, bereavement, extended medical leave, and jury duty Corporate discount program on "personal cell phone accounts" with select providers Corporate discount program on Microsoft 365 "Home Use Program" Business casual work environmentAbout Cottonwood
Founded in 1996, Cottonwood Financial is one of the largest privately held retail consumer finance companies in the United States. Headquartered in Irving (Las Colinas), Texas, we have 275+ company-owned locations, under our Cash Store brand, across the country. Through this national brick-and-mortar footprint, we provide best-in-class customer service and offer an innovative mix of financial products and services to our customers. We are profitable, have a healthy balance sheet, and are positioned to grow.We have been named multiple times to the Inc. 5000 list of America's fastest-growing private companies, as well as to the Dallas 100 list of the fastest-growing private companies in North Texas.Cottonwood Financial is proud to be an equal opportunity employer.Recommended SkillsAdministrationAgile MethodologyApache HadoopArchitectureBig DataCloud ComputingJob SnapshotEmployee TypeFull-TimeLocationIrving, TXJob TypeEngineeringExperienceNot SpecifiedDate Posted01/09/2022Job ID2021-1995

Keywords: Cash Store, Irving , Lead Data Engineer, Engineering , Irving, Texas