*******Not open to C2C******
Primary Responsibilities:
- Manage the flow of data from source to dashboards.
- Work with raw data, transforming it and building tests.
- Focus on data analytics and engineering.
- Daily Reporting: Reports to the manager on a day-to-day basis.
- Should have a deep understanding of how data infrastructure and processes are built within the company.
- Transform and document raw data after it has landed in the companies environment.
- Build and run tests to ensure data accuracy.
- Supervise and ensure the timely delivery of data engineering tasks.
- Coordinate with others who will be building dashboards.
Desired Experience:
- BigQuery: Experience in using BigQuery
- Composer: Familiarity with Composer for managing data workflows.
- SQL: Strong SQL skills for querying databases.
- SQL Templating: Experience with SQL templating tools like dbt (Data Build Tool) to create efficient, reusable queries.
- DB2 experience is a plus.
- Media industry experience is a plus, but not required.
- Proficiency indata modeling.
Project Support:
- Support projects from an engineering perspective.
- Manage budget commitments from suppliers related to media projects.
- Analyze financial data to collaborate with different teams for project completion.
- Aggregate and report data by brand or category (e.g., Dewalt).
Current Challenges:
- Poor data architecture.
- Previous dashboard management team has been let go.
- Need to focus on data analytics while supporting data engineering efforts.