Senior Data Warehouse Analyst

Responsibilities Through data analysis and application review, as well as knowledge transfer from existing team members, quickly gain a deep understanding of business processes and source application data used to support the reporting and analytics for various departments within Universal Brand Development Partner with internal team members to understand and document user data requirements as they relate to new reporting requests, using this knowledge to develop functional requirements for new database structures and interfaces (ETL) Evaluate all new incoming data sources, profiling for data type and content, and ensuring that feeds meet established standards for format and transmission protocols. Work with the ETL development lead and our data architecturesupport team to implement new structures or modify existing ones, providing meaningful input to data modeling discussions as well as ETL design and development. Participate in designing, testing, and implementing system changes specifically related to these new and modified data structures,working withboth onshore and offshore technical teams Design responsibilities include creating detailed documentation of data models and ETL logic, and general oversight of the development process Testing responsibilities include developing and executing use cases that cover both functional data requirements as well as source data validation Work closely with other application support teams to keep track of any changes that might affect data warehouse feeds, whether due to scheduling/timing or frequency of delivery, unexpected change in record counts, or of course structural changes to the incoming data that might cause a break in the regular process. Work with our ETL development team lead to recognize and implement opportunities for automation, performance improvements, scheduling improvements, etc. Monitor ongoing development efforts and provide regular progress reporting of current activities to IT and business teams Qualifications/Requirements Basic Qualifications Strong BI/DW technical analysis skills, including ability to read and interpret data models and entity relationship diagrams, as well as to read, write, and analyze complex SQL statements and their output Must have a minimum 3 years of recent hands-on experience with Teradata and Oracle database platforms and tools to analyze them (SQL Assistant, SQLDeveloper, etc.) Working knowledge of the Informatica toolset for ETL development, ideally with some hands-on experience Solid knowledge of data modeling concepts such as referential integrity, application-enforced integrity, data dependencies between source applications Prior experienceworking with centralized infrastructure teams for data architecture and database platform support Ability to organize and lead design sessions for all phases of database development, including data source review, data modeling, ETL design and logic Proven experience authoring functional requirements, as well as providing oversight, review, and final approval of technical specifications for database and ETL objects. Strong familiarity with scheduling/automation tools such as Control-M Experience with UNIX Experience with Microsoft data analysis tools such as Excel and Access The successful candidate will have strong experience in at least one of the following business disciplines: Retail Analytics, Contract Management, Product Development and Approval Systems, Finance/Accounting (SAP preferred) Bachelor's degree in Information Technology, Computer Science, or Computer-related degree Minimum 5 years of experience with data warehousing and business intelligence Minimum 5 years of experience with all phases of a software development lifecycle Minimum 3 years of experience in a data or business analyst role for a medium to large scale BI implementation Eligibility Requirements Must be willing to work in Universal City, CA Must have unrestricted work authorization to work in the United States Must be 18 years or older Desired Characteristics Media / Entertainment background Some retailexperience a plus Good understanding of BI tools, MicroStrategy a plus Familiarity with Teradata, Oracle is a must Ability to work independently and in a team environment Experience with offshore development model 44859BR
Salary Range: NA
Minimum Qualification
Less than 5 years

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.