Expertise in SQL and data warehousing
Relevant working experience in ETL, preferably Microsoft SQL SSIS or AWS Glue
Experience in working with APIs for data ingestion
Working knowledge in data-oriented and statistical modeling programming languages such as Python, Spark, R, or Java.
Working knowledge of data visualization tools and how they function. Experience is a plus.
Preferred, but not required :
Experience in end-to-end dashboard creation using Tableau Desktop.
Experience in Tableau Server support
Able to easily understand the context of datasets and how to use them
Experience in supporting the data requirements of a sales or marketing organization
Job Description :
He / she will be assigned to work primarily on data engineering and data visualization development for ULSSI. Data engineering :
Use platforms such as Microsoft SQL and AWS platforms to fulfill data engineering requirements.
Perform ETL and create the necessary data pipelines using the aforementioned tools to satisfy the data requirements of ULSSI.
This involves a variety of tasks such as data ingestion, consolidation, transformation, cleansing, validation, automation, or other activities meant to prepare data to be suitable for ULSSI’s use cases.
Store prepared data into the data warehouse, following suitable standards and controls. Prepared data is expected to be used with Tableau, with dashboards as final outputs.
Work on data provided by different data ingestion tools or approaches such as APIs and ingest the required data into ETL pipelines.
For some deliverables, there will be a need to prepare data for statistical analysis, including predictive modeling.
Data visualization :
Connect and integrate a variety of data sources (text files, Excel files, Microsoft SQL sources, etc.) for use with dashboards
Design, develop and implement Tableau dashboards to support ULSSI’s requirements.
Review, design and implement modifications to existing Tableau dashboards in accordance with processes and controls.
Provide operational support as necessary for ULSSI dashboards that have been published to Tableau Server. This includes, but is not limited to, data updates and troubleshooting.