| Hiring! Snowflake SQL Developer (Remote) at Snowflake, Arizona, USA |
| Email: [email protected] |
| From: Vijayakumar R, TechStar Group [email protected] Reply to: [email protected] Job Title: Snowflake SQL Developer Location: Remote Duration: 12 months contract Skills: SQL expert, SSIS, Snowflake, Python We are seeking a highly skilled and experienced Senior Back-End Software Engineer with a strong background in developing and maintaining large-scale batch processing data pipelines. The ideal candidate will have extensive expertise in working with MSSQL databases, SSIS (SQL Server Integration Services), and SQL Agents. This role requires a self-motivated and independent individual capable of managing complex projects and collaborating effectively with cross-functional teams. Key Responsibilities: 1. Batch Processing Data Pipelines: Design, develop, and maintain robust batch processing data pipelines for handling large volumes of data efficiently. 2. MSSQL Database Management: Manage and optimize MSSQL databases for performance, scalability, and reliability. 3. SSIS Integration: Develop, deploy, and maintain ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS) for data integration and transformation. 4. Python Expertise: 3+ years of hands-on experience with Python, with proficiency in writing efficient and maintainable code. Bonus points for experience using Python packages such as pandas, numpy, and requests for data manipulation, analysis, and API interactions. 5. Data Quality Assurance: Proficiency in implementing data quality checks, data validation processes, and data cleansing techniques to maintain high data integrity and accuracy throughout the data pipelines and databases. 6. Performance Tuning: Identify and resolve performance bottlenecks in data pipelines and databases to ensure optimal system performance. 7. Documentation: Create and maintain comprehensive documentation for data pipelines, database schemas, and integration processes. 8. Monitoring and Troubleshooting: Set up monitoring tools and processes to proactively identify and address issues in data pipelines and databases. Additional Skills and Qualifications: Strong SQL Proficiency: Expertise in writing complex SQL queries, stored procedures, and optimization techniques. Data Modeling: Proficiency in data modeling and database design principles. ETL Design: Experience in designing and implementing efficient ETL processes for data integration and transformation. Version Control: Familiarity with version control systems (e.g., Git) for code management and collaboration. Self-Management: Ability to work independently and manage projects with minimal supervision. Communication: Excellent written and verbal communication skills for documenting processes and collaborating with team members. Education and Experience: Bachelor's or higher degree in Computer Science, Software Engineering, or a related field. 5+ years of relevant experience in back-end software development and data engineering. Previous experience in designing and maintaining large-scale batch processing data pipelines, MSSQL databases, SSIS, and SQL Agent jobs. Keywords: rlang |
| [email protected] View all |
| Fri Oct 13 20:32:00 UTC 2023 |