The candidate will be responsible for providing data analytics and consulting services to help clients address critical business risks. The candidate will work collaboratively with other consulting practices to provide innovative, data-driven solutions to augment their subject matter expertise. The candidate will work on all aspects of the data analytics project lifecycle including data ETL, data validation, data exploration, developing data pipelines, as well as understanding critical business requirements and needs and operationalizing datasets for ongoing usage.
Tasks and responsibilities:
► Identify and extract relevant data from a wide variety of different datasets including (but not limited to), Enterprise Resource Planning, Financial, Accounting, incident and event monitoring, case management, system health, open source, etc.
► Perform extraction, transformation, load and validation of data
► Design automation tools for ETL and data validation
► Conduct data cleansing and standardization
► Identify and understand relationships between multiple data sources.
► Create and design data queries, procedures and reports to address client requests and project strategies.
► Create and maintain documentation of assumptions, methodologies, and information sources throughout the project lifecycle.
► 1-3 years working in consulting, finance, data sciences, or other relevant industry with an emphasis in analytics and complex problem-solving.
► Experience manipulating and analyzing large amounts of data and interpreting results.
► Knowledge and experience using analytics tools for data visualization, predictive modelling, data management, ETL, data aggregation and dynamic reporting.
► Experience working in a collaborative and team-oriented environment.
Qualifications and specialist skills:
► Bachelor’s degree or greater.
► Experience working with Microsoft SQL Server, SAP, Oracle, DB2, Microsoft Access and/or other database applications.
► Experience working in programming languages such as Python, SQL, C#/.NET, etc.
► Advanced knowledge and experience with MS Excel including modelling and data pivoting skills.
► Ability to leverage technology to solve problems.
► Knowledge and experience working in data visualization platforms such as Tableau or PowerBI.
► Excellent written and oral presentation skills to effectively communicate with diverse audiences of varying degrees of expertise.
► Ability to adapt to different clients, industry, and subject matters.
► Ability to work well under pressure and meet tight deadlines, while effectively juggling competing demands and evolving priorities
► Strong organizational, project management skills
► Ability to travel when requested.
► Nice to have: Fluency in either Spanish, Portuguese, or Chinese (Mandarin)