Data Engineer Location:Hoover, AL, USA

Job Description:

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