The KSOM Finance Department is seeking a SQL Business Intelligence/Web Developer to join its team.
This position will be responsible for:
Integration of data from multiple data sources on a regular basis.
Design and implement supporting database objects: fact & dimension tables, staging areas and data integration packages with validation plans for all stages
Design and implement changes to Microsoft Analysis services Tabular cube and reports with validation plans
Developing new user-facing features for reporting.
In collaboration with business partners, design and implement reports in Microsoft Sql Server Reporting Services, Power BI, Power Pivot and Excel, with corresponding validation plans.
Developing new user-facing features for data entry.
Design and implement supporting database objects
Optimization of applications for maximum speed, scalability and security
Successful Candidates Must Demonstrate:
5 years of Microsoft Sql Server design and architecture experience for data warehouse and data marts using Microsoft Sql Server, Analysis services (Tabular/Dax) and Integration services (SSIS)
5 years of Microsoft Sql Server programming for scalable and secure application and reporting support, including examination of query plans; designing and implementing appropriate indexing or partitions strategies for scalability; design and implementation of stored procedures, functions (UDFs), triggers, parsing of XML & JSON data structures; design, implementation and testing of application and object level security, row level filtering security
5 years of Microsoft Analysis Services (SSAS Tabular) design and architecture experience for reporting using star or snowflake schemas, slowly changing dimensions, normalized and denormalized dimensions.
5 years of reporting with Microsoft Reporting Services (SSRS) with DAX, Excel and Power BI
3 years of designing, implementing and maintaining Master data with Microsoft Master Data Services and appropriate EIM processes
Required Documents to Upload:
Minimum Education: Bachelor's degree, Combined work experience and education as equivalentMinimum Experience: 3 years, Combined education/experience as substitute for minimum experienceMinimum Field of Expertise: Sound knowledge of programming and documentation procedures, programming methods, program flow charts and operator instructions. Knowledge of one or more appropriate computer languages. Competent to work independently on complex programming activities.
USC’s Viterbi School of Engineering has been one of the economic engines in Southern California and a vital hub in the California economy. The technical innovations and ideas generated by the Viterbi faculty and research community have resulted in countless innovations, many becoming the foundations for new companies, products and services. The thousands of students graduating each year bring new ideas and vitality to companies in California and beyond. With an annual research budget exceeding $205M each year, more than 46 research centers and institutes, more than 180 faculty members, 7,800 students and over 60,000 impassioned alumni world-wide, the Viterbi School is addressing some of the world’s great challenges.