Scope and Responsibilities
- We are seeking a Full-Stack Developer to manage the day-to-day operations of our Microsoft SQL Server Data Warehouse while driving long-term enhancements in architecture, ETL pipelines, data quality, and user interfaces.
Key Responsibilities:
- Enhance ETL Pipelines:
- Develop and optimize existing ETL pipelines using SQL, C#, and Python.
- Collaborate with Business Teams:
- Partner with business teams to enhance, update, and expand available datasets to meet evolving needs.
System Collaboration:
- Work closely with source system and downstream system teams to ensure seamless integration and alignment.
- Ensure Data Quality and Security:
- Maintain high standards of data quality, consistency, and security in all aspects of the data pipeline.
Improve Architecture Scalability:
- Evolve the current architecture to scale effectively, accommodating ever-increasing volumes of data.
Develop .NET Applications:
- Build and maintain .NET applications using C# and WPF for monitoring tools, data exploration tools, backend job processors, and Windows services.
Document Technical Processes:.
- Create and maintain technical documentation for processes, designs, run books, and best practices for internal reference and training.
- Provide Technical Support and Guidance:
- Offer assistance to IT team members and business power users to troubleshoot and resolve data-related issues.
Experience required
- Programming Proficiency:
- Skilled in C# and Python for ETL, backend development, and automation.
- Experience with WPF and MVVM Models for Frontend and UI Development
- SQL & T-SQL Expertise:
- Strong proficiency in SQL for data querying, transformation, and performance optimization.
- Experience working with T-SQL in a Microsoft SQL Server Environment