Data Analytics Consultant ( Data Engineer) #1655

POSITION SUMMARY    Responsible for working on the Data Team to ensure that client provided data is reviewed, imported, transformed, and quality controlled into specifically requested data warehouses for ongoing projects and services. Additionally responsible for new programming/updates to developed tools related to increasing efficiencies in data management for both the receipt and deprecation of data along with those designed to assist other Data Analytics and Predictive Analytics Consultant resources in managing their processes.  Additional duties include implementation and ongoing managed services, training, and other billable professional offerings to new and existing customers. Responsible for managing services utilizing advanced data mining and analytics to leverage ML products. Utilize Business Intelligence tools to create client reporting deliverables, schedule walkthroughs with clients, review completed reports with their staff, and provide additional recommendations. Define and deliver innovative analytics solutions to consulting clients.   To perform this job successfully, an individual must be able to perform each essential function satisfactorily, with or without accommodation. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.   ESSENTIAL FUNCTIONS AND RESPONSIBILITIES:    ·         Responsible for working with client-delivered data files to import into data warehouses across all Data Analytics active databases. ·         Work with the Data Team Manager to monitor import scheduling and meet deadlines for uploads to accommodate Analytics projects across all teams. ·         Execute quality assurance measures with existing tools and continue to expand the overall library as reasonably identified and required. ·         Responsible for working with development tools to create new or update existing tools for use in data management as assigned by the manager. ·         Responsible for the creation of Reveal Pro reports and managing other report assignments.  ·         Responsible for managing primary communications, attending to the data collection process, and overseeing main deliverables for assigned clients as Relationship Lead.  ·         Translate quantitative analysis into transformative business strategies and actionable recommendations. ·         Perform exploratory data analysis by deep diving into the data, utilizing data mining, dashboards, data modeling, and simulations to develop project deliverables as needed with ongoing training. ·         Ensure adherence to set standards in the successful delivery of results based on scope of work. Participate in the internal processes of knowledge sharing and product/service innovation. ·         Participate in cross-training and professional development with internal team members.    QUALIFICATIONS:     ·         Bachelor’s Degree in ISDS/MIS, Computer Science, Statistics, Economics, Analytics, Data Science, Finance or Mathematics. ·         Experience in  developing, monitoring and maintaining data pipelines through ETL, ELT. Knowledge of data quality and unit testing on all stages of data pipeline is required. ·         Expert/Advanced level skills with MS SQL and writing advanced T-SQL with 2 – 3 years of experience are required. ·         Expert/Advanced level skill with Python programming language with 2 – 3 years of experience is required.  ·         Knowledge of MS Power BI reporting with one year of experience ·         Must be able to multi-task and be very detail-oriented ·         Team-work attitude, flexibility, and ability to manage different phases of a project  ·         Strong communication and presentation skills Preferred: ·         Advanced Degree in applicable discipline ·         Knowledge of US regulations regarding lending practices ·         Market experience preferred-consulting, financial services