Senior Analyst, Data Engineering

Senior Analyst

Our team is looking for a high-performing Senior Analyst who will be responsible for the design, development, implementation, and on-going support of a data driven software platform. The ideal candidate thrives in a fast-paced environment on multiple projects simultaneously, including both enhancements as well as new project development. The candidate must be a self-starter with a commitment to quality and professionalism and understands sense of urgency.

Responsibilities:

• Take provided requirements and identify any gaps to create a solution
• Database development including stored procedures, user defined functions, triggers and ETL packages
• Uphold quality standards and create monitoring tools to ensure high fidelity data
• Troubleshoot database issues, identify root causes, and implement optimal solutions
• Extract, transform, and load data from multiple data sources using languages and tools such as Python
• Develop, build, test, debug, monitor, and fix ETL and software processes in Python
• Serve as an escalation point for any issues that may arise
• Design testing requirements and prepare test plans and test modules
• Ability to follow implementation standards, develop documentation and transfer of knowledge

Qualifications:

• 2+ years' experience with ETL, databases, and Python
• Familiarity with cloud technologies such as Amazon Web Services (Redshift, S3, Glue, Lambda) or Databricks
• SQL programming skills (stored procedures, functions, etc.)
• Experience with Pyspark/Spark
• Experience with complex processing logic against large data sets
• Excellent data modelling skills and experience working with multiple datasets
• Possession of strong communication and presentation skills as well as an analytical mindset
• Problem solving and testing skills
• Familiarity with code versioning tools such as Git
• Strong organizational skills & attention to detail
• Possess a desire to work for a fast-paced, results-based company
• Experience managing multiple projects simultaneously
• Dedicated/entrepreneurial spirit with the ability to think outside of the box
• Desired, but not required:
• Experience with marketing data and digital media
• Experience with Business Intelligence software (Tableau, PowerBI)
• Experience and thorough understanding of a variety of APIs
• Experience supporting analytics and data science teams/tools (Pandas, R, Alteryx)