Optomi, in partnership with a leading Fortune 500 media and entertainment company, is seeking a Senior Data Engineer to join their team. The successful candidate will play a critical role in building a new Snowflake data platform, focusing on financial data ingestion and modeling. This role requires a deep understanding of Snowflake, advanced SQL skills, and experience with financial datasets. The candidate will collaborate with various teams to deliver high-quality solutions on schedule.
Job Requirements:
- 5+ years of experience as a Data Engineer
- The role is intended for a senior-level data engineer, not a junior or lightly experienced Snowflake resource.
- Hands-on experience delivering robust, maintainable data pipelines for complex enterprise environments.
- Expertise in Snowflake: Building data pipelines, Designing and structuring data object, Creating data marts.
- Expertise in advanced SQL for data transformation & modeling (e.g., window functions, CTEs).
- Python for ETL/ELT, automation, or analytics
- Experience with financial datasets AND industry
- Prior experience developing financial cost models (Financial planning, financial spend, cost allocation & recovery, etc.)
- Knowledge of financial, accounting, or technology operations systems and data such as SAP, Clarity, ServiceNow, Cognos
- Familiarity with workflow orchestration tools (DBT, Airflow, etc.).
- Strong communication skills
Job Responsibilities:
- Develop, automate, and maintain scalable data pipelines
- Partner with architects to develop robust data models
- Write performant SQL and Python code for cost allocation
- Collaborate with product managers, finance teams, and AI/ML engineers
- Implement reconciliation processes and IT controls