Senior Data Engineer

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