About this role
Senior Data and Analytics Engineer
Sony Pictures Entertainment
ID90885
Data Engineer
Data Engineer Python
Data & AI
Python
Snowflake
dbt Cloud
Python
Full-time
- Argentina,
- Brazil,
- Colombia,
- Mexico,
- Guatemala
- LATAM,
- Argentina,
- Brazil,
- Colombia,
- Mexico,
- Guatemala
4+ years of experience
Experience (Filter):
3–5 years
Experience (Search):
Middle Senior
Remote
TECH STACK
Snowflake
dbt Cloud
Python
SQL
GitHub
New applications are currently paused
See details
About the role
We are looking for a Senior Data and Analytics Engineer to sit with business stakeholders and translate their needs into data transformation work using dbt and SQL.
The mandatory requirements are 4+ years of experience in data engineering or analytics engineering, expert-level Python and SQL skills, hands-on experience with dbt Cloud, strong proficiency with Snowflake and modern cloud data platforms and an upper-intermediate English level.
What you will do
- Project-Embedded Engineering: Deliver robust data features and pipelines directly within project teams, focusing on fast-paced, business-facing verticals like distribution. Accommodate rapid reprioritization in a process-light environment without being siloed in a fixed-scope pool.
- Complex Business Logic & Analytics: Translate complex business use cases into robust data models using dbt and SQL. Tackle rigorous business logic, such as aggregating revenue and performance data from platforms like Tubi, Roku, YouTube, and Amazon channels, and joining it with internal contracts.
- Modern Stack Utilization: Build and maintain scalable pipelines utilizing a technical stack that includes Snowflake cloud warehouse, dbt Cloud, GitHub, VS Code, and local Python. Transition project documentation from tribal knowledge into dbt catalogs.
- AI Tool Integration: Leverage AI tools within the development workflow, including GitHub Copilot, Microsoft Copilot, Snowflake Cortex, and dbt wizard features. Collaborate with technical leadership to uplevel the adoption of these tools within specific governance setups.
- Cross-Functional Collaboration: Partner effectively with product managers, data visualization leads, and strategic analysts to evaluate requests and deliver consumption-ready data. Collaborate directly with the existing Head of Architecture and Data Engineering on technical decisions and quality standards.
Must haves
- 4+ years of experience in data engineering or analytics engineering within a production environment.
- Expert-level Python and SQL skills.
- Extensive hands-on experience building transformation pipelines in dbt Cloud is strongly preferred.
- Strong proficiency with modern cloud data platforms, specifically Snowflake, as well as development tools like GitHub and VS Code.
- Proven ability to thrive in a process-light environment that operates more like a data science team than a highly tuned software engineering team.
- Strong communication skills to effectively collaborate with non-technical stakeholders and product managers during bi-weekly or monthly sprint planning.
- Upper-intermediate English level.
Nice to haves
- Industry Expertise: Deep domain expertise in the media and entertainment industry, specifically Hollywood studios.
- Specialized Knowledge: Hands-on experience with specific media data challenges, including title matching and metadata enrichment.
- AI Development: Familiarity with AI-driven development tools, such as Snowflake Cortex and GitHub Copilot, and an understanding of the governance and grants required to manage them.
Perks
- Growth without limits: build your skills through mentorship, internal TechTalks, challenging projects, and a dedicated annual learning budget
- Competitive compensation: get recognition that reflects your skills and impact, with regular performance and compensation reviews
- Flexibility: work 100% remotely with flexible hours that support focus, autonomy, and a healthy work rhythm
- Meaningful, modern projects: build impactful products using modern technologies alongside global teams and leading brands
- Collaborative culture: join a supportive environment with zero micromanagement where ideas are welcomed and contributions are recognized
- Well-being & support: access local well-being programs and people-focused support tailored to your location