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 EngineerThe 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 analyticsExperience with financial datasets AND industryPrior 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, CognosFamiliarity with workflow orchestration tools (DBT, Airflow, etc.).Strong communication skillsJob Responsibilities: Develop, automate, and maintain scalable data pipelinesPartner with architects to develop robust data modelsWrite performant SQL and Python code for cost allocationCollaborate with product managers, finance teams, and AI/ML engineersImplement reconciliation processes and IT controls