Analytics Engineer II (Pricing & Sales)

About the position

The Analytics Engineer II assists in the design, development, maintenance, and continuous refinement of analytics and reporting solutions. This position is responsible for ETL processes, data warehouses, cubes, dashboards, and model deployment. The Analytics Engineer II stays up-to-date on the latest technology and implements proof-of-concepts to stay ahead of the technology demands of internal customers. They maintain system and tool documentation.

Responsibilities

• Maintains and troubleshoots pricing optimization algorithms and rules based pricing recommendations for new and existing customers
• Collaborates with internal customers, analysts, developers, data scientists, and database administrators
• Provides underlying data support for business metrics
• Writes ETL scripts using SQL Server Integration Services (SSIS) or similar tools to consume and process new data into the data warehouse
• Designs and builds automated processes that leverage Excel, SQL and VBA to facilitate data transfer across teams
• Designs dashboards and tools to allow users to consume and interact with data
• Implements in-database machine learning solutions using SQL Server and R/Python
• Ensures security and integrity across all data
• Troubleshoots and debugs issues
• Performs other job-related duties as assigned or apparent

Requirements

• Proficiency with relational databases and the ability to write SQL queries
• Proficiency with programming in R or Python in data science and/or engineering settings
• Proficiency with Excel and PowerBI
• Proficiency with source control (e.g. Github, SVN, Tortoise) in a multi-developer environment
• Master's degree
• 3 years of demonstrated experience working with relational databases in the context of developing ETL processes and implementing data and analytics solutions
• 3 years of experience maintaining databases and tools in a production environment including query performance tuning and proactive maintenance
• Experience with cloud computing environments (e.g. AWS)
• Demonstrated experience working with a formal software development methodology
• Experience developing and maintaining pricing optimization and rules based algorithms

Nice-to-haves

• Bachelor's Degree in an analytical field (Mathematics, Computer Science, Information Management, Statistics, Engineering)
• 3 years of experience with advanced programming in SQL and R or Python, deploying analytics models and tools in a production environment with relational databases

Benefits

• Comprehensive medical benefits coverage, dental plans and vision coverage
• Health care and dependent care spending accounts
• Short- and long-term disability
• Life insurance and accidental death & dismemberment insurance
• Employee and Family Assistance Program (EAP)
• Employee discount programs
• Retirement plan with a generous company match
• Employee Stock Purchase Plan (ESPP)