ETL Developer
Santa Monica, CA

Job Description

Summary of Position:

Lionsgate is currently seeking an ETL developer responsible for developing extractions, transformations and data loads from external and internal data sources. Furthermore, the ETL developer must be an expert at migrating normalized, structured and semi-structured data into star, snowflake and other de-normalized data models. This means the developer needs to be able to read, analyze and digest what a business wants to accomplish with its data and develop the best possible ETL process around those goals. In addition, this position will be expected to deliver reporting architectures that pull data from the enterprise data warehouse into smaller report friendly data marts.

* Developing ETL logic with common coding languages like SQL, Java, Python, XML, C#, VB
* Developing Microsoft SSIS packages, including alerts data validation checks
* Developing ETL solution for incoming sFTP, CSV, Excel, XML and JSON data feeds
* Deploying ETL job workflow with reliable error/exception handling and rollback framework
* Developing star and snowflake DW dimensional models for landing incoming data
* Developing ETL code with proper metadata definitions, models, schedules, and maintenance
* Adapting ETL code to accommodate changes in source data and new business requirements
* Troubleshooting and solving complex technical and data problems
* Managing software upgrades, capacity planning and system performance tuning
* Performing unit testing, system integration testing and assist with user acceptance testing
* Documenting the ETL detailed design and test results as part of development cycle
* Prioritizing development & enhancement requests to align with corporate goals and business needs
* Using different data warehouse architecture techniques like ODS, DM, ROLAP and MOLAP
* Manages automation of file processing as well as all ETL processes within a job workflow
* Ensuring data quality throughout data governance and master data management
* Ensuring compliance with regulatory requirements such as PCI, HIPPA, and SOX
* Collaborating with various Lionsgate business units to define and execute data ETLs

Experience & Skills:

* Bachelor's degree in computer science and 3-5 years of experience developing data ETLs
* Masters in CS, stats or math a plus!
* Expert level experience with ETL development with Microsoft SSIS and SQL Server
* Strong background loading data from CSV, Excel, XML and JSON into DW
* Expert with MS SQL stored procedures, functions, indexing & SQL Server in-memory features
* Working knowledge of Hadoop (MapReduced), Apache SPARK, and columnar MPP
* Working knowledge of big data nosql, un-structured and semi-structured data
* SAP experience preferred - CRM, IPM, BW experience ideal
* DMP tagging of web and social media properties for marketing
* Ability to translate ideas and business requirements into fully functioning ETL workflows
* Strong experience with API development
* Strong experience with Java, a plus
* Experience working with Matillion ETL, a plus
* Experience with AWS technologies, a plusKnowledge of Home Entertainment, DMP Marketing and Sales and Planning, a plus

Lionsgate is an equal employment opportunity employer. All employees and applicants are evaluated on the basis of their qualifications, consistent with applicable state and federal laws, without regard to race, religious creed, color, national origin, ancestry, physical disability, mental disability, medical condition, marital status, covered veteran status, gender, sex, age, sexual orientation, genetic characteristic, or membership in any other class protected by applicable law. The employer will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and federal law.