Reporting Solutions Engineer

The RoleWe are looking for a Reporting Solutions Engineer to join our fast-growing Technology team here at Wpromote. You will design data engineering solutions for enterprise clients across a variety of MarTech and AdTech platforms. You’ll plan how data needs to flow across each client’s MarTech stack so the data can be used in Polaris, our proprietary tech platform. You’ll build data models using BigQuery and dbt, designing them for use across reporting, apps, and media forecasting. You’ll also help create, maintain, and improve client reporting, innovating on our reporting offerings by designing data visualizations to answer critical business questions, and you’ll be embedded within the product development team, working with product managers to define requirements for our proprietary reporting platform. If you revel in data development challenges, love leveraging measurement solutions and technology to build reporting and insights solutions, and enjoy the challenge of learning new MarTech platforms, we’re looking for you to join our team.At Wpromote, we believe that great work is only possible with great people. Our goal is to build a better, more inclusive work environment and support our people at every stage of their careers by prioritizing a strong work-life balance through our policies and benefits listed below. As a Best Place to Work according to both Ad Age and Glassdoor and Adweek’s Fastest Growing Digital Agency, we are moving fast to expand our teams and bring new experts into the fold to keep pushing the boundaries of what’s possible in marketing.We offer:-Remote-first culture-Unlimited PTO-Extended Holiday break (Winter)-Flexible schedules-Work from anywhere options*-100% paid parental leave-401(k) matching-Medical, Dental, Vision, Life, Pet Insurance-Sponsored life insurance-Short Term Disability insurance and additional voluntary insurance-Annual Class Pass credits and more!The anticipated annual salary for this role will range from $105,000 - $128,000, based on consideration of a wide array of factors unique to each candidate, including but not limited to skill set, years and depth of experience, education and certifications, competitive benchmarks, scope of responsibility, market dynamics, geographic location, and respective state’s salary threshold for exempt employees. The total compensation package for this role will include benefits (listed above).*This position may be performed remotely in most states within the US, with some exclusions**While this role offers the flexibility to work remotely, we have office hubs in Los Angeles, Chicago, and New York, where you can join in on learning and development opportunities, fun events, take advantage of a space to work, and collaborate in person!***This position is not eligible for immigration sponsorshipImportant Notice: Beware of Job ScamsWpromote recruiting communications will only be sent through our official channels via wpromote.com email addresses. If you see a posting elsewhere that is not reflected on Wpromote.com/careers, it may be a fraudulent posting. We do not require payment or fees during the hiring process nor do we request sensitive information, such as Social Security numbers or payment details. Please safeguard yourself against possible scams and contact us if you encounter any suspicious activity.You Will BeGathering data source, data joining, data model, and data transformation requirements from stakeholders (clients and internal teams)Gathering and evaluating data visualization requirements in order to develop unique reporting and insights solutions/tools for cross-channel media measurementManaging and monitoring multiple data pipelines and ETL tasks related to multiple client data streamsAssisting in the creation of a reliable and scalable infrastructure for data model builds, data set QA, and data set outputsWorking with internal stakeholders to understand and then execute against data transformation, data model, and inbound/outbound data pipeline requirementsAssisting with the design of client data pipelines to flexibly and efficiently deploy data for new dashboards and apps within Polaris, our proprietary tech platformWorking with data engineers to validate data from multiple sources to provide an integrated, comprehensive overview of our digital marketing effortsCreating reporting dashboards in Google Data Studio and Google Looker, using best practices for visualizations and user experience, to communicate a compelling business storyGathering feedback on the dashboard to better understand its functionality and user experience, and documenting for product improvementsAssisting the engineering team in creating data requirements for future platform enhancementsIdentifying areas for improvement and propose potential solutions, building process documentation to assist in the scaling of all reporting effortsYou Must Have5+ years of experience in reporting, BI, or analytics engineeringExperience with SQL, database design,