Description
Work as a strategic partner with CDO team members and others to help facilitate data driven solutions. Through analysis and collaboration with business partners, creates standardized processes for the reporting team performance. Partners closely with the CDO’s development team to create data visualization views and summaries
Essential Functions:
• Develops, optimizes, and maintains queries in MS SQL Server Management Studio 2008/2012
• Demonstrated knowledge in Microsoft Excel, including but not limited to data transformation, functions/expressions, Macros.
• Creates advanced reporting and analysis through Tableau
• Creates ad-hoc analysis to analyze key business issues.
Business intelligence (BI) analysts help guide and improve the way that businesses' management staff foster collaboration within and between departments. Those who desire to work as a BI analyst should demonstrate a strong understanding of managerial and professional skill sets. BI analysts are generally tasked with collaborating with a team of cross-departmental managers, and are usually expected to be able to demonstrate excellent leadership capabilities. They should also be well versed in many different aspects of business administration.
Presentation skills are also a must as BI analysts are often expected to chair meetings discussing organizational data and future directions of the company. Analysts should also be prepared to lead seminars training new managers on different aspects of business intelligence. BI analysts should exhibit proficiency in many different Microsoft applications such as Word and Excel.
Experience in an ERP system such as Oracle or SAP is usually considered a plus. It is also expected that analysts will naturally demonstrate superior creative thinking and decision making abilities consistently in their work. Finally, analysts should be capable of working within a diverse, global workforce that is consumer oriented.
Tasks: Provide application analysis and data modeling design to collect data for centralized data warehouse. Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems. Proficient in the use of query and reporting analysis tools. Standardize data collection by developing methods for database design and validation reports.
Location: Fully Remote in Mexico
Duration: Possibility of extensions will be evaluated at year end
Shift Requirements: Business Hours US Eastern or Central Time Zone
Core Requirements:
- 5-10 years of experience
- Partners closely with the CDO’s development team to create data visualization views and summaries
- Develops, optimizes, and maintains queries in MS SQL Server Management Studio 2008/2012
- Creates advanced reporting and analysis through Tableau
- Through analysis and collaboration with business partners, creates standardized processes for the reporting team performance