Big Data Analyst

Job Description

<p><b>Sailun Tire Americas – Big Data / Business Intelligence Analyst</b></p><p><br></p><p><b>Position Reporting To</b> – BI Manager</p><p><br></p><p><b>Summary/Objective</b></p><p>The Big Data / BI Analyst is responsible for integrating data from multiple, designing enterprise-level models, integrating, cleansing, transforming, and analyzing data, developing dashboards and reports.</p><p><br></p><p><b>Essential Functions </b></p><ul><li>Leverage Big Data and BI and Analytics platforms to design, build, deploy and maintain Big Data and BI solutions (e.g. tabular models, reporting tools, data integration solutions)</li><li>Debug, monitor and troubleshoot BI solutions</li><li>Maintain and support data analytics platforms </li><li>Create tools to store data (e.g. relational database, tabular models)</li><li>Evaluate and improve existing BI systems</li><li>Collaborate with local and headquarter teams to integrate systems</li><li>Develop and execute database queries and stored procedures</li><li>Analyze and cleanse data</li><li>Conduct unit testing and troubleshooting</li><li>Effectively present BI solutions to end users and stakeholders and provide training</li><li>Optimize and enhance business intelligence processes and systems to help make better decisions</li><li>Lead requirements gathering and review sessions</li><li>Translate business needs to technical specifications</li><li>Develop and update technical and user documentation</li></ul><p><br></p><p><b>Skills and Qualifications</b></p><p>Proficiency in SQL languages, such as T-SQL and MySQL. Proficiency in SSIS, Data Warehouse modelling, and skilled in data quality assurance and data governance.</p><p>Proficiency in Apache Doris Massively Parallel Processing (MPP), Apache Impala.</p><p>Proficiency in Microsoft SQL Server Data Warehouses and Data Marts.</p><p>Strong knowledge of data warehouse design principles (e.g. dimensional modeling) and data mining. </p><p>In-depth understanding of database management systems, SSAS Tabular models and ETL (Extract, Transform, Load) framework, DAX language.</p><p>Understanding Big Data related technology architecture, such as Hadoop, Hive, and Impala.</p><p>Knowledge of Enterprise ERP (such as Navision, SAP), its functions and business modules interconnection.</p><p>Excellent communicator, able to communicate effectively with business and technical groups.</p><p>Ability to operate effectively in a team environment and independently.</p><p><br></p><p><b>Required Education and Experience</b></p><ul><li>BSc/BA/Diploma in Computer Science, Information Technology, Engineering or related field</li><li>Minimum 1-2 years’ experience as a BI Developer/Analyst or Data Scientist and proficiency in Power BI and related tools and languages (DAX, SSRS).</li><li>Experience in BI analytical and visualization tools (e.g. Microsoft Power BI, Tableau, PowerPivot) and Excel</li><li>Proficiency in SQL queries and procedures, SQL Server Integration Services (SSIS), data analysis, validation, data cleansing tools and processes</li><li>Fluency in Mandarin language is an asset</li></ul><p></p>