Job Duties:
- Understand business requirements and translate them to technical specifications.
- 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.
- Create and maintain optimal data architectural design.
- Gather large complex data sets that meet functional / non-functional business requirements.
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- 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.
- Conduct periodic meetings with business teams to validate results and projects’ deliverables
- Monitor performance and quality control plans to identify improvements.
- Troubleshoot, debug and upgrade existing ETL solutions.
- Gather and evaluate users’ feedback.
- Saving technical documentation for reference and reporting.
- Identify data discrepancies and develop data metrics.
Knowledge and Functional Skills:
- Strong knowledge of relational databases, SQL server.
- Strong knowledge in developing complex SQL Queries, Stored procedures, functions, and triggers.
- Minimum of 2-4 years of Experience
- Strong analytical skills related to structured or unstructured data sets.
- Ability to collect, organize, analyze, and disseminate significant amounts of information with attention to details.
- Experience in building operational ETL data pipelines from several disparate sources.
- Strong working experience with SSIS / ADF
- Strong working experience with SSAS / AAS.
- Experienced in designing reports in SSRS.
- Experience with Tableau is a plus.
- Experience with Data Mining is a plus.