CommerceIQ | Jobs | Data Analyst – II | BigDataKB.com | 03-02-22

โ€”

by

Job Location: Bangalore/Bengaluru

Role Expectations

  • We are looking for a Data Analyst with a highly entrepreneurial mindset that can Support various departments, including marketing and sales, in reaching their goals through data reporting.
  • The role is cantered around Data and an ideal candidate will be responsible for Extracting Data, Running Batch Jobs and developing ETL pipelines.
  • You will be expected to perform the following role at CommerceIQ –

Coordination and Delivery of Data for Reporting

  • Strong Expertise in SQL & Data Warehousing concepts is required
  • Ability to review data and classify the tables/measures functions by using multiple queries, views and procedures. Removing corrupted data and fixing coding errors and related problems.
  • Writing SQL scripts, queries, and stored procedures to extract data from multiple sources. Comfortable with SQL concepts like Joins, Triggers, Stored Proc, Window Functions etc.
  • Modelling techniques and tools in analysing and specifying data structure in large and/or complex data sets would be an advantage.
  • Implements best practices in data management to ensure the integrity of the data, the quality of data processes and delivers analyzable or analyzed data to a variety of internal and external clients.
  • Independently Mine and acquire data from primary and secondary sources and reorganize the data in a format that can be easily read by either a machine or a person; generating insights and helping clients make better decisions.
  • Experience & Expertise in running Batch Jobs.
  • Expertise in Python & Pandas with good exposure in data analysis concepts which is mandatory.
  • Document new processes and best practices to drive commonality and reuse.
  • Ability to dive in data issues and trace root causes both collaboratively and independently.
  • Define and implement data acquisition and integration logic, selecting the appropriate combination of methods and tools within a defined technology stack to ensure optimal scalability and performance of the solution.
  • Good Exposure to Data warehousing and Data Modelling concepts. Experience in building end-to-end data pipelines.
  • You will deliver recurring reports and ad hoc requests, while meeting SLAs on timelines for deliverables.
  • You will perform coding, debugging, and testing to support improvements.

Technical expertise

  • You will be expected to be hands-on with Excel, google sheets, SQL and a programming language like Python so that you can process the data and build the analytical solution yourself.
  • Good to have Reporting Tool knowledge like Tableau and Google sheet.

Ownership

  • Major ownership lies within Data preparedness for reporting, querying data for analysis, triggering and debugging Batch Jobs.
  • You will need to showcase high ownership and leadership skills to independently work with people from different departments.

Skills, Experience & Qualifications Required

  • Advanced data manipulation skills using Excel and SQL, moderate experience with analytical tools Python.
  • 3-5 years prior experience building and maintaining automated reporting systems; and managing requirements from customers across various teams to efficiently deliver on large number of regular reporting requests, building end-to-end data pipelines and ETL workflows
  • Successful stint at a prior fast paced work environment (start-ups, consulting etc.)
  • Desire to get into the most granular details of technical/ implementation/ operational issues and being an individual contributor.
  • Bachelor s degree required.

Preferred Qualifications: (in addition to required)

  • Experience building ETL workflows connecting AWS S3 buckets and RESTful APIs with SQL databases
  • Experience with ecommerce analytics is a huge plus
  • Prior start up experience is highly preferred
  • High proficiency in building Tableau dashboards and executive friendly deliverables for business needs and to aid decision making

Apply Here

Submit CV To All Data Science Job Consultants Across India For Free

๐Ÿ” Explore All Related ITSM Jobs Below! ๐Ÿš€ โœ… Select your preferred “Job Category” in the Job Category Filter ๐ŸŽฏ ๐Ÿ”Ž Hit “Search” to find matching jobs ๐Ÿ”ฅ โž• Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link ๐Ÿ“๐Ÿ’ผ

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *