Qualifications

Bachelor's degree in Computer Science, IT, or equivalent experience.
5+ years experience in System Analysis, system design, and advanced data profiling.
5+ years experience in data preparation, complex analysis, and ETL troubleshooting.
AdvancedT-SQL(complex queries, performance tuning, and stored procedures).
Strong hands-on experience withMS SQL, SSIS,and Visual Studio.
Proficiency in Python (Pandas), Excel (large datasets), and data profiling techniques.
Solid understanding of data modeling and warehousing principles.
Experience withPower BI, SSRS, Tableau, or advanced Excel reporting.
Familiarity with Azure Data Factory, AWS Glue, or Google Cloud Dataflow.
Exposure to data migration projects and strategies.
Knowledge inC#(for SSIS scripting) orPython.

Job Details

Responsibilities

Can perform detailed data analysis to validate ETL output, identify discrepancies, and ensure adherence to business rules and data quality standards.
Can collaborate with business stakeholders to elicit, analyze, and document complex data requirements, translating them into precise technical specifications and data mapping documents.
Develop, implement, and optimize robust ETL processes using SQL Server Integration Services (SSIS) or similar modern ETL tools, ensuring data integrity, performance, and reliability.
Proactively monitor, troubleshoot, and resolve issues related to ETL job failures, data discrepancies, and performance bottlenecks, performing root cause analysis and recommending sustainable solutions for Production Issues.
Design and develop effective data visualizations, reports, and dashboards using tools like Power BI, SSRS, or Excel to present actionable insights derived from analyzed data.
Shares knowledge as a subject matter expert for data integration and analysis, providing technical guidance and support to fellow development teams and business users(as needed).

Alteryx ETL Developer

Senior ETL Developer (project-based)