Qualifications

• High School Diploma or equivalent

• Minimum of 5 years of developing MS SQL Server stored procedures, functions, tables, and view experience

• Experience working with a statistical programming language (R, Python or similar)

• Experience working with Qlik Talend software

• Knowledge of common unsupervised/supervised ML techniques

• Hands-on experience using source control tools and incident tracking software
• Working knowledge of all phases of the Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation
• Proficiency with Microsoft Office products
• Demonstrated ability to work and communicate well with coworkers and stakeholders
• The employee must occasionally lift and /or move up to 25 pounds
• Specific vision abilities required by this job include close vision, peripheral vision, depth perception and the ability to focus

Responsibilities

• The Data Engineer is responsible for assisting with end-to end data consumption, from loading the data into the data warehouse to leveraging statistical models built with that data to gather critical insights to accommodate business needs
• Perform analyses of structured and unstructured data to solve basic business problems utilizing advanced statistical techniques and mathematical analyses
• Document data gathering and processing and provides a detailed set of results and analytical metricsild, prototype, and deploy machine learning models in sandbox and production environments
• Assist with developing and maintaining end-to-end ETL data pipelines
• Develop SQL queries for data extraction from the data warehouse
• Participate in requirements gathering discussions and collect the appropriate level of detail required to and drive towards immediate technical results to solve client problems
• Design and develop data integration / transformation solutions
• Develop ad hoc SQL queries to support internal requests for data
• Create Entity Relationship Diagrams to design and document database solutions
• Design, develop, and maintain SQL Server databases, tables, indexes, stored procedures, views, and triggers
• Develop queries, views, and stored procedures to provide data to front end reporting solutions
• Optimize slow running queries, views, and stored procedures
• Troubleshoot and correct SQL Server performance issues
• Perform other related duties as assigned