This position supports the Product and Technology Department by managing work associated with the support of organizational data systems.
Responsibilities

• Design, write, test, and debug database queries to extract, calculate or manipulate information to build KPI reports and dashboards
• Schedules and coordinates database maintenance activities including such items as database reorganizations and restructures to meet the business requirement from the business operation teams
• Monitors current Database/Data Warehouse performance, develops procedures/ETLs and improve the Database/Data Warehouse performance
• Assemble large, complex data sets that meet functional / non-functional business requirements
• Build and maintain the infrastructure required for optimal ETL process (extraction, transformation and loading of data) from a wide variety of data sources using SQL and AWS/Azure technologies
• Monitoring key product metrics and understanding root causes of changes in metrics
• Empower and assist operation and product teams through building key data sets and data-based recommendations
• Automating reports/Analysis and authoring pipelines via SQL/python based ETL framework
• Train junior members of the data engineering team

Professional Skills
These are the professional skills we would expect from an individual fully established in this role:

• Verbal Communication - Proficient
• Written Communication - Proficient
• Teamwork - Advanced
• Relationships - Proficient
• Learning Agility - Advanced
• Analysis - Expert

Role Specific Skills

• Database: Advanced in Relational (MySQL) and Non-Relational(MongoDB) Database
• Experience with relational SQL and NoSQL databases; strong knowledge of database systems in general (Foreign keys, indexes, basic DBA tasks)
• Understanding of Data Warehouse (RedShift/Azure DW)
• Understanding of ETL best practices and data engineering
• Python or other scripting languages
• Some experience with performance tuning and query optimization
• Experience with Data Lake is a plus
• Experience in large scale data processing using traditional and distributed systems like Hadoop, Spark, and Airflow is a plus

Qualifications
Minimum Qualifications

• Education: Bachelor or Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field - or commensurate experience
• Master's Degree preferred
• 2+ years of experience in relevant field for Senior Data Engineer I

Please note, this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities, and schedule may change at any time with or without notice.
SMS Assist is an Equal Opportunity Employer (EOE) that welcomes and encourages all applicants to apply regardless of age, race, color, religion, sex, sexual orientation, gender identify and/or expression, national origin, disability, veteran status, marital or parental status, ancestry, citizenship status, pregnancy or other reasons prohibited by law.
#LI-CA1
#LI-HYBRID