Job Specifications
Are you passionate about transforming data into actionable insights? We’re on the lookout for a Contract Data Engineer to support a Media Ad Sales initiative. You'll collaborate with the Decision Science and Science teams to design and maintain data systems that optimize sales performance. Key responsibilities include monitoring data pipelines, validating reports, developing ETL/ELT processes, designing database schemas, and ensuring data quality. You will handle tasks such as data acquisition, source-to-target mapping, scripting validations, and producing datasets for models and visualizations. Proficiency in SQL, Python, Docker, GitLab, Airflow, Lambda, Snowflake, and PostgreSQL is essential. Join us to drive impactful data solutions in a fast-paced environment.
Basic Qualifications
3+ years of experience with Python and SQL, primarily for pipeline maintenance and some development work.
Proven experience using Python, SQL, and cloud storage (such as AWS S3)
Experience with developing in a multi-environment (Dev, QA, Prod, etc.) and DevOps procedures for code deployment/promotion.
Understanding of relational database design and proficiency in utilizing a database such as PostgreSQL or Snowflake.
Preferred Qualifications
Experience working with large datasets and big data technologies, preferably cloud-based, such as Snowflake, Databricks, or similar.
Knowledgeable on cloud architecture and product offerings, preferably AWS.
Experience managing and deploying code using a source control product such as GitLab/GitHub.
Experience leveraging containerization technologies such as Docker or Kubernetes.
Hands-on knowledge of job scheduling software like Apache Airflow or UC4.
Required Education
STEM BA Degree.
Benefits
401(k).
Dental Insurance.
Health insurance.
Vision insurance.
We are an equal-opportunity employer and value diversity, equality, inclusion, and respect for people.
The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.
Additional Responsibilities
Participate in OP monthly team meetings and participate in team-building efforts.
Contribute to OP technical discussions, peer reviews, etc.
Contribute content and collaborate via the OP-Wiki/Knowledge Base.
Provide status reports to OP Account Management as requested.
About Us
At OP, we help you harness the power of technology for maximum impact. A technology consulting and solutions company, we offer advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields including AI, cyber security, enterprise architecture, and beyond. For nearly two decades, we’ve been challenging the status quo of the consulting industry, serving up fresh, ingenious thinking through a radically lean structure. Together, this strategy delivers unprecedented performance at an unparalleled pace for faster results that propel your business forward.
About the Company
OP is one of the fastest-growing technology consulting and solutions companies in the U.S. We offer advisory and managed services, innovative platforms, and staffing solutions to help clients harness the power of technology for maximum impact. With broad and deep industry expertise, we deliver solutions across AI, cybersecurity, enterprise architecture, and beyond.
We don't just consult--we challenge the norms of consulting. Our approach pairs out-of-the-box thinking with a radically lean model for faster, smarter, and more...
Know more