CRG Solutions

Sign Up/Sign In
Flag job

Report

Interesting Job Opportunity: Alteryx Developer - ETL

Location

Greater Kolkata Area

JobType

full-time

About the job

Info This job is sourced from a job board

About the role

Job Description

Role & Responsibilities :

  • Design and develop ETL workflows and Datasets/Datamarts in Alteryx to be used for visualization.
  • Solid, deep experience with data extract, transform and load (ETL) tools as Alteryx and high-level knowledge on data visualization tools (Pref Tableau/Power BI).
  • Prepare technical specifications and documentation for Alteryx workflows.
  • ETL specific for creating datasets (to be used by Tableau Data Extract for BI)
  • Write Complex SQL queries on multiple tables using complex joins.
  • Perform end to end Data validation.
  • Ability to interact with business users and understand their requirements.
  • Develop impactful presentations and documents.
  • Communicate complex topics to team through both written and oral communications.
  • Ensure data is stored effectively and provide the ability to maintain the data analytics platform, so that data can effectively be mined for information later.
  • Conduct unit tests and develop database queries to analyse the effects and troubleshoot any issues that arise.
  • Evaluate and improve existing systems that are in place as well as collaborating with teams within the business to integrate these new systems to streamline workflows.
  • Develop and update technical documentation for senior leaders and colleagues to serve as a reference guide.
  • Understand if there is technical or business limitation to implement technology control/configuration.
  • Understand and document the compensating control for managing or mitigating security risk that might exist due to the technical or business limitation.
  • Provide recommendations to strengthen current processes, controls pertaining to technology platforms.
  • Provide regular updates on assign tasks to team members.

Technical Mind Set

  • Alteryx (Mandatory)
  • 2+ years of related experience with Alteryx
  • Hands-on skills and experience in Alteryx Designer, Alteryx Scheduler, Alteryx Server (good to have), and the tools with Alteryx such as Predictive, Parsing, Transforms, Interface (good to have)
  • Experience with data ETL (SQL, Alteryx) and ability to manipulate data and draw insights from large data sets.
  • 2+ years writing SQL queries against any RDBMS with query optimization.
  • Strong analytical, problem solving, and troubleshooting abilities.
  • Good understanding of unit testing, software change management, and software release management
  • Good understanding the star schema and data models in the existing data warehouse.

(Desirable) Tool Knowledge

  • Python Experience will a definite plus
  • Any other ETL experience will be definite plus.

Essential

  • Strong communication skills and analytics
  • Self-Starter and able to self-manage.
  • Ability to prepare accurate reports for all levels of staff in a language and tone appropriate to the audience.
  • Good team player, ability to work on a local, regional, and global basis.
  • Able to perform under pressure.
  • Ability to drive to succeed and go beyond the extra mil

(ref:hirist.tech)

Skills

Tableau
Python
Power BI
change management
communication skills
data analytics
data models
data visualization
data warehouse
database
ETL
SQL