US, US, CA - San Diego
Minimum Level of Education Required: Bachelors Degree
Percentage of Travel: Up to 10%
Location: CA - San Diego
Now is the perfect time to join a growing company with an extremely noble cause. At NuVasive, you will not only help to drive business value, but actually see its impact. As part of NuVasive’s IT organization, you will be joining the best IT business in the spine industry. In IT, we are in a unique position which allows us to positively impact patients’ lives. As a part of our team, you will truly make a difference in someone’s life.This is an exciting opportunity to showcase your Data Warehousing & ETL expertise and help grow and mature the enterprise data warehouse. This position will help design, develop and provide operational support for ETL projects and activities. He or She will also be required to work with functional analysts, end users and other BI team members to design ETL solutions, convert user requirements and functional specs to technical designs and mentor BI team to use best practice ETL designs. Other responsibilities may include gathering BI / reporting requirements, development and maintenance of BI Reports, models and Cubes as needed.
ESSENTIAL DUTIES AND RESPONSIBILITIES include the following. Other duties may be assigned.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Technical design, development, testing, documentation of Data Warehouse / ETL projects
Perform data profiling and logical / physical data modelling to build new ETL designs and solutions
Develop, implement and deploy ETL solutions to update data warehouse and datamarts
Maintain quality control, document technical specs and unit testing to ensure accuracy and quality of BI data
Troubleshoot, debug and diagnose ETL issues
Provide production support and work with other IT team members and end users to resolve data refresh issues – provide off hours operational support as needed
Have the ability to work with users, BI and ERP teams to get ETL solutions developed and implemented
Performance tuning and enhancement of SQL and ETL processes and prepare related technical documentation
Meet with functional analysts and /or end users to gather/ clarify requirements as needed to complete BI/ DW projects
Participate in ad-hoc BI/ DW projects as required
Develop and enhance BI reports, models and Cubes and provide support as needed
Work with Offshore team to coordinate development work and operational support
Keep abreast of latest ETL technologies and plan effective use
Help build solutions pertaining to Predictive analytics and/or Big data
Communicate very clearly and professionally with users, peers, and all levels of management. The communication forms include written and verbal methods
Adhere to the processes and work policies defined by management
EDUCATION and/or EXPERIENCE
Bachelor's degree (B.S.) from four-year college or university. Understanding of ERP business processes, data warehouse and BI concepts and ability to apply educational and practical experience to improvise business intelligence applications and provide simplified and standardized solutions to achieve the business objectives.
More than 7 years in ETL:
Expert knowledge of data warehouse architecture
Expertise in dimensional modeling, star schema designs including best practices for use of indexes, partitioning, and data loading.
Advanced experience in SQL, writing Stored procedures and tuning SQL, preferably using MS SQL Server.
Strong experience with Informatica Powercenter.
Experience developing software applications as part of a team, employing practical and effective software design concepts.
Well versed with database administration tasks and working with DBAs to monitor and resolve SQL / ETL issues and performance tuning
Experience in trouble shooting data warehouse refresh issues and BI reports data validation with source systems.
Independent problems solving skills.
Strong interpersonal and communication skills and ability to interact positively with peer groups within IT / BI teams and management.
Open to learn and acquire new skills.
Preferred experience with Informatica Cloud
Preferred experience in Tableau, Cognos or other BI applications
Preferred with experience working in the SAP ECC, SAP B1 or other ERP applications
Preferred with experience in Big Data and/ or use of Predictive tools (eg SPSS, R)