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
|
