Previous Job
Previous
Business Analyst
Ref No.: 18-68387
Location: Sanra Clara, California
Experience Level: 8 Years
Start Date: 09/18/2018
Role Business Analyst
Mandatory Technical Skills Skills:
*7 + years work related experience. Advanced degree in Computer Science, Applied Statistics, Mathematics, Engineering or Operations Research.
* Strong analytical skills /critical thinking and attention to details.
• Proficient in SQL BI, and good in SQL programming and MDX queries
• Proficient on working on oData API call, JSON, XML
• Experienced in working with huge datasets - data validation, data cleansing and data transformations
• Proficient in SQL BI, and good in SQL programming, Power BI
• Fluent BI Analytics (SSAS, SSRS, SSIS) & Tabular CUBE
• SQL Query Optimization
• Performance monitoring and optimization, Good Troubleshooting skills
• Knowledge of SQL Master Data Services
• Ability to understand vast amounts of data, identify and fix data issues
• Ability to design and develop database architecture
• Experience in building and maintaining enterprise level SSIS packages and Data Pull
• Ability to thrive in a fast-paced, dynamic business environment
Responsibilities:
• Understand business problem, extract/analyze data, provide insights & recommendations, build scorecards & dashboards to report findings.
• Independently Extract, manipulate and analyse data
• Generate the Business Insights & give recommendation
• Quality check own and others work
• Leverage DB/SQL/ Excel, PPT, HTML, R, SSRS, Power BI, Info graphics
* Identify and analyze large data sets for data quality, data sufficiency and data integrity etc. to support business decisions.
* Develop, create, implement new database query, reports, and analyzing and improving existing reports and queries.
Desirable Technical Skills * Proven experience in database design, data modeling, SQL server, T-SQL, query optimization, common DW principles and ETL development a plus including SSAS, SSRS, SSIS.
* Experience with related technologies such as JSON, XML, XSL, IIS, WCF are a plus.
Mandatory Functional Skills • Ability to work independently or to manage a virtual team that will research innovative solutions to challenging business problems
• Ability to collaborate with partners and drive analytic projects end to end,
• Superior communication skills, both verbal and written
• Attention to detail and data accuracy
Work Location Redmond, WA