JOB SUMMARY: Assist in building an automated data process for combining different data sources and prepping data for media measurement modeling. The associate data engineer will collaborate in developing code, prep data (structured and unstructured) and setup business rules for analysis and modeling that meets standardization requirements and focuses on efficiency, scalability and reproducibility. The associate data engineer will also help define, optimize and automate data and process strategy using a variety of techniques for media measurement.
Collaborate on building ETLs, data pipelines, API’s and automate data preparation jobs for analysis and modeling for media measurement projects.
Utilize data prep guidelines in accordance to standards and serve as a subject matter expert in data engineering.
Engage with internal/external partners to gather requirements and collaborate with technology engineers, architects and data scientists to help leader in designing a robust analytical solution.
Assist in producing deliverables and identify opportunities to shape robust data processes and analytical measurement capabilities that inform and inspire internal stakeholders and decision makers.
Understands and actively participates in Environmental, Health & Safety responsibilities by following established UO policy, procedures, training and team member involvement activities.
Performs other duties as assigned.
EDUCATION: Bachelor’s degree in Computer Science/Engineering/Data Science or in a relevant applied quantitative field is required.
2+ years of experience in PL/SQL, Database design and knowledge of Postgres extensions, relational databases and Cloud infrastructures.
Strong familiarity with manipulating and mining data to transform business decisions that impact the bottom line.
Individual contributor, this role is responsible for the implementation and management of data engineering practices that incorporate media activity, sales, brand metrics, industry indicators and website activity in partnership with Cross Channel Attribution stakeholders, to enhance and automate processes for Marketing Attribution and Forecasting initiatives.
Required Capabilities – Associate Data Engineer
2+ years of experience in PL/SQL, database design and knowledge of Postgres extensions
Ability to create ETL tools, optimize queries and advanced SQL scripting in PostgreSQL, SQL Server and Snowflake
Knowledge of AWS services and tools: Amazon S3, Amazon EC2, Amazon Redshift or others
Familiarity and knowledge of Big Data platforms and architecture: Hadoop, Spark, cloud tools, and other distributed processing frameworks.
Experience in automating jobs, ability to leverage command line utilities and able to support API builds on premise and cloud environments
Ability to develop code to prep data (structured and unstructured) and conduct feature engineering and business rules for analysis and modeling, meeting standardization requirements and focused on efficiency, scalability and reproducibility.
Experience defining, documenting and developing best practices, processes and standards related to data engineering for advanced analytics purpose
Preferred Capabilities – Associate Data Engineer
Understanding of machine learning algorithms and ability to work with data scientists in deployment and maintenance of production level models
Your talent, skills and experience will be rewarded with a competitive compensation package.
Universal is not accepting unsolicited assistance from search firms for this employment opportunity. All resumes submitted by search firms to any employee at Universal Orlando via-email, the Internet or in any form and/or method without a valid written Statement of Work in place for this position from Universal Orlando HR/Recruitment will be deemed the sole property of Universal Orlando. No fee will be paid in the event the candidate is hired by Universal Orlando as a result of the referral or through other means.