OptiMine Software is an industry-leading marketing analytics software company focused on marketing measurement and optimization, helping companies understand the full contributions and performance of their marketing and advertising investments. Our clients are some of the largest advertisers and best known brands in the world, and they use our incredibly sophisticated software-as-a-service platform to drive marketing lift and ROI.
We are growing our team to serve our ever-expanding client base. As a part of that expansion, we are looking for a top quality Data ETL Specialist to join our team.
The Data ETL Specialist serves as a core team member in routine operations, drives the data onboarding process for client marketing campaign and sales data, and is responsible for executing OptiMine’s critical data processes:
- Execute OptiMine’s extract, transform, and load (ETL) components and process flow for client-specific projects
- Validate and QA large inbound client data sets
- Evaluate client data load/change requests and recommended actions in partnership with technical project management and account management resources
- Collaborate across multiple teams to translate/recommend/develop solutions to specific data requests
- Perform ad hoc SQL queries and data exports
The ideal candidate will have:
- Ability to work in a collaborative environment focused on team results and client success
- Self-motivation with demonstrated thoroughness, follow-up, and attention to detail
- Strong interpersonal and communication skills, including the ability to effectively communicate technical details to various stakeholders
- Ability to set priorities and make adjustments to reach goals across multiple projects
Skills and experience:
- 2-5 years of experience in technical role handling large data sets
- Degree in Computer Science, Information Science, Mathematics, Statistics, or equivalent technical background
- Understanding of data warehousing methodology and ETL best practices
- Experience writing and troubleshooting T-SQL queries