Job Duties:

1. Understand business requirements and translate them to technical specifications.
2. Work with stakeholders including executives and line managers to gather the analytical requirements and assist with data-related technical issues and support data infrastructure needs.
3. Create and maintain optimal data architectural design.
4. Gather large complex data sets that meet functional / non-functional business requirements.
5. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
6. Build the infrastructure required for optimal extraction, transformation, and loading of data (ETL) from a wide variety of data sources using SQL and big data technologies.
7. Conduct periodic meetings with business teams to validate results and projects’ deliverables
8. Monitor performance and quality control plans to identify improvements.
9. Troubleshoot, debug and upgrade existing ETL solutions.
10. Gather and evaluate users’ feedback.
11. Saving technical documentation for reference and reporting.
12. Identify data discrepancies and develop data metrics.

Knowledge and Functional Skills:

1. Strong knowledge of relational databases, SQL server.
2. Strong knowledge in developing complex SQL Queries, Stored procedures, functions, and triggers.
3. Minimum of 2-4 years of Experience
4. Strong analytical skills related to structured or unstructured data sets.
5. Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to details.
6. Experience in building operational ETL data pipelines from several disparate sources.
7. Strong working experience with SSIS / ADF
8. Strong working experience with SSAS / AAS.
9. Experienced in designing reports in SSRS.
10. Experience with Tableau is a plus.
11. Experience with Data Mining is a plus.