Responsibilities:
• Provide Business Intelligence (BI) and Data Warehousing (DW) solutions and support by leveraging project standards and leading analytics platforms
• Evaluate and define functional requirements for BI and DW solutions
• Define and build data integration processes to be used across the organization
• Build conceptual and logical data models for stakeholders and management
• Work directly with business leadership to understand data requirements; propose and develop solutions that enable effective decision-making and drives business objectives
• Prepare advanced project implementation plans which highlight major milestones and deliverables, leveraging standard methods and work planning tools
• Analyze and validate data accuracy of report results
• Analyze and interpret collected data; spotting trends; writing reports and recommendations for internal or external clients
• Recognize potential issues and risks during the analytics project implementation and suggest mitigation strategies
• Coach and mentor project team members in carrying out analytics project implementation activities
• Lead the preparation of high quality project deliverables that are valued by the business and present them in such a manner that they are easily understood by project stakeholders
• Interpret data presented in models, charts, and tables and transform it into a format that is useful to the business and promotes effective decision making
• Use statistical practices to analyze current and historical data to make predictions, identify risks, and opportunities enabling better decisions on planned/future events
• Identify improvements to the way in which analytics services an entire function
• Communicate and own the process of manipulating and merging large datasets
• Expert and key point of contact between the data analyst/data scientist and the project/functional analytics leads
• Perform other duties as assigned
Qualifications and Education Requirements:
• Master's degree in Information Systems, Computer Science, Engineering, or related field, or the equivalent combination of education, training and experience
• Expert skill in Microsoft Excel and Operation Data Integration (OLTP)
• Advanced skill in Microsoft SharePoint, Microsoft Azure, Informatica, MS Office Products, SQL
• Advanced understanding of multiple data related concepts and application of data mapping and building requirements
• Excellent communication skills; ability to communicate end to end data outcomes visually to all levels of the team hierarchy
• Proficient in Hadoop, Azure Data Catalog, Data Architecture, Apache Spark, ETL tools and techniques
• Proficient with data models, large datasets, business/technical requirements, data warehousing, statistical programming languages and libraries
• Proficient with data visualization tools such as Microsoft Power BI, Tableau; ability to manipulate raw data into effective visualization dashboards
• Working knowledge of various data structures and the ability to extract data from various data sources (such as Cognos, Informatica)
• Experience with warehousing, data cleaning, data pipelines and other analytical techniques required for data usage
• Ability to understand other projects or functional areas in order to consolidate analytical needs and processes
• Ability to understand the business problem and determine what aspects of it require optimization; articulate those aspects in a clear and concise manner
• Ability to define and analyze highly complex models that predict the probability of an outcome
• Ability to perform statistical analysis such as measures of central tendency, normal distribution, variance, standard deviation, basic tests, correlation, and regression techniques
• Skilled in managing the process between updating and maintaining data source systems and implementing data related requirements
• Novice in Python, Agile Frameworks (SAFE), Microsoft Databricks, Snowflake, Azure Data Factory, HDInsight, Hive (Apache), Cognos
Master's degree