Reporting Solutions Engineer

Design and implement data engineering and reporting solutions for MarTech/AdTech clients: build data models in BigQuery/dbt, manage ETL pipelines, create dashboards in Looker/Data Studio, validate integrations, and collaborate with product and engineering teams to scale reporting and analytics., We 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., * Gathering 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 measurement
• Managing and monitoring multiple data pipelines and ETL tasks related to multiple client data streams
• Assisting in the creation of a reliable and scalable infrastructure for data model builds, data set QA, and data set outputs
• Working with internal stakeholders to understand and then execute against data transformation, data model, and inbound/outbound data pipeline requirements
• Assisting with the design of client data pipelines to flexibly and efficiently deploy data for new dashboards and apps within Polaris, our proprietary tech platform
• Working with data engineers to validate data from multiple sources to provide an integrated, comprehensive overview of our digital marketing efforts
• Creating reporting dashboards in Google Data Studio and Google Looker, using best practices for visualizations and user experience, to communicate a compelling business story
• Gathering feedback on the dashboard to better understand its functionality and user experience, and documenting for product improvements
• Assisting the engineering team in creating data requirements for future platform enhancements
• Identifying areas for improvement and propose potential solutions, building process documentation to assist in the scaling of all reporting efforts, Applicants with disabilities may be entitled to reasonable accommodation under the terms of the Americans with Disabilities Act and certain state or local laws. A reasonable accommodation is a change in the way things are normally done which will ensure an equal employment opportunity without imposing undue hardship on Wpromote. This employer participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work, this employer is required to give you written instructions and an opportunity to contact Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin to resolve the issue before the employer can take any action against you, including terminating your employment. Employers can only use E-Verify once you have accepted a job offer and completed the Form I-9. For more information on E Verify, or if you believe that your employer has violated its E-Verify responsibilities, please contact DHS., Design, develop, and maintain scalable, secure Java/Spring-based services and integrations on cloud platforms. Implement CI/CD, troubleshoot production issues, contribute to architecture artifacts, analyze data for continuous improvement, and participate in engineering communities to drive resilient, high-quality software. Top Skills: AWSAws AthenaAws Ec2Aws EcsAws EksAws EmrAws EventbridgeAws KmsAws LambdaAws S3Aws SqsCi/CdCloudFormationJavaMicroservicesOraclePostgresRdbmsSpring BootSQLTerraform CrowdStrike

• 5+ years of experience in reporting, BI, or analytics engineering
• Experience with SQL, database design, and data manipulation methodologies
• Experience gathering requirements and delivering data visualizations in Looker (preferred) or Data Studio within an Advertising Agency or similar client environment
• Familiarity with Data Build Tools (dbt)
• Strong Google/Excel Sheets skills, preferably with appscripts experience
• Experience working with API calls for the purposes of gathering and storing large datasets (batch or streaming)
• Experience with at least one cloud platform (BigQuery, Snowflake, Redshift, etc.)
• Experience with at least one programming language (Python, R, AppScript, JavaScript, etc.), preferably JavaScript or Python
• Knowledge of database and data warehousing design and management
• Understanding of ETL process and data modeling experience using SQL
• Attention to detail with the ability to debug and troubleshoot code/queries
• A collaborative mentality with the ability to work independently
• General business and marketing data acumen including an understanding of common marketing goals, KPIs, and tactics
• Experience integrating and automating pipelines from multiple data sources
• Strong organizational skills with superior attention to detail with the ability to handle the balancing of multiple tasks and projects
• The desire to learn new tools, skills, and strategies and the initiative to take on new tasks
• Both an analytical and design mindset
• Strong written and verbal communication skills

Nice to Have

• Experience with digital analytics tools (Google Analytics, Adobe Analytics)
• Experience with Project Management Platforms (JIRA, Asana)
• Knowledge/experience in the digital marketing industry
• Curiosity to continuously learn more about digital marketing and marketing technology
• Experience in working with data from different ad platforms (Google, Facebook, Microsoft) and digital analytics tools (Google Analytics, Adobe Analytics)
• Data Integration Platforms: Funnel, Domo
• Data Visualization Platforms: Tableau, PowerBI
• Data Warehouses: BigQuery
• Project Management Platforms: Asana or similar experience

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 sponsorship Important Notice: Beware of Job Scams, 320K-370K Annually Senior level 320K-370K Annually Senior level Cloud * Computer Vision * Information Technology * Sales * Security * Cybersecurity The VP of Agentic Systems will lead data science research and development, focusing on AI systems to enhance cybersecurity operations, requiring strong leadership and collaboration across technical teams. Top Skills: Artificial IntelligenceBig DataCybersecurityMachine Learning

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

• Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
• Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
• Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
• Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
• Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
• Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute