Database and ETL Administrator (Remote)

Information Technology Boston, MA Philadelphia, Pennsylvania


Description

About the Role:

WorkReduce is looking for a remote, database administrator who has extensive experience with Tableau and creating dashboards that provide meaningful insights. The ideal candidate has experience in building, administering, and deploying an ETL process along with a background in marketing/ad tech. The database administrator will be responsible for building the database infrastructure behind our client’s reporting system and recommending improvements and modifications, including design, architecture, and support of new and existing data flows for media partners and 3rd party providers. 

About WorkReduce

We are the largest technology-enabled services provider for media buying. We serve brands and agencies as a distributed team of media and technology experts operating through the WorkReduce platform. Our mission is to improve our clients’ lives and businesses. We are committed to providing employment that pays well, expands access to jobs and training, and makes a difference. We hire people who share our values of transparency, inclusivity, dedication, and fairness.

WorkReduce is a dynamic company of remote workers dedicated to supporting each other in providing a high level of service to our clients.  Our clients rely on us to help execute programmatic marketing campaigns, campaign analytics, and related tasks. Although we don’t work in the same location, we value each other and maintain a cohesive culture that enables everyone to do their best work. 

 

What you’ll do:

  • Replicate and improve the Tableau dashboards of WorkReduce clients
  • Create dashboards and reports on Tableau based on the data pipeline
  • Develop optimal data pipeline architecture and systems and ingest data into our data warehouse along with providing frameworks and services for operating on that data to create reports for clients
  • Analyze, debug and correct issues with data pipelines
  • Maintain relationships with external data providers to better integrate and troubleshoot vendor data integrations. Document the data gathering and reporting process. 

What we’re looking for:

  • Tableau and SQL Admin experience required
  • Experience with MySQL, Microsoft SQL Server, and SSIS
  • Experience with ETL tools such as Talend, CloverETL, Pentaho or other ETL tools
  • Ability to create scripts or stored procedures to manipulate and combine data from different data sources

WorkReduce provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.