Job Title: Business Data Analyst SQL, Hadoop, Big Data, Hive, Nifi/DatastageLocation: Toronto, ON (3 days a week hybrid)Requirements and responsibilitiesWhat you’ll doWorking with the Project teams, business stakeholders, technical SMEs,, Data Insights on a growing portfolio of interactive dashboards across many product teamsCreate recent datasets and sophisticated dashboardsUnderstand the data and business processes across all applicaitons, all data domainsWhat you’ll bringMust HaveExpert in SQL, Hadoop, Big Data, Hive, NifiStrong experience in Azure Data Services analysis, BI AnalysisAbility to analyse the construction of existing reports and reverse engineer table relationships etcStrong knowledge of the Retail Domain and experience with various stages of data warehouse projects, including data extraction, cleansing, aggregation, validation, transformation, and loading.Exp in using Data Stage components such as Sequential File, Join, Sort, Merge, Lookup, Transformer, Remove Duplicates, Copy, Filter, Funnel, Dataset, Change Data Capture,



and Aggregator.Strong at database commands (DDL and DML) and data warehousing implementations models.Hands on exp with the Hadoop ecosystem, including HDFS, Hive, Sqoop, Ni Fi, and YARN.Familiar with Mainframe ESP for job scheduling.Understanding of branched development – dev, qa, prod etcPassionate about data and it’s potentialAn organized and self-starter approach to accomplish responsible work itemsStrong communication skills with the ability to present complex messages and stories both IT and BusinessBusiness and data analysis skills to gather requirements and translate to technical requirementsBe self driven and can multi-task and work on multiple projects at the same time under tight deadlinesAbility to navigate ambiguity and simplify complex scenarios with keen business acumenExperience of analyzing Lobs, data bases, writing scripts.Experience of connecting to additional sources such as Azure, My Sql#J-18808-Ljbffr

📌 Business Data Analyst (Toronto)
🏢 MethodHub
📍 Toronto