THIS ROLE REQUIRES ONSITE WORK IN LOS ANGELES NEAR THE FINANCIAL DISTRICT ON TUESDAYS, WEDNESDAYS, & THURSDAYS. 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. This role will require collaboration across multiple teams and troubleshooting complex systems to ensure smooth operation.
Key Responsibilities: - Enhance ETL Pipelines: Develop and optimize existing ETL pipelines using SQL, C , and Python. Focus on debugging multi-threaded, concurrent load processes, ensuring data integrity, and resolving complex issues.
- Collaboration with Business and Infrastructure Teams: Partner with business teams to enhance, update, and expand available datasets to meet evolving needs. You will work closely with teams such as Accounting System, System Applications, Infrastructure, and DBAs when issues arise, particularly for source system or infrastructure-related challenges.
- Data Quality and Security: Maintain high standards of data quality, consistency, and security in all aspects of the data pipeline, addressing and resolving data quality issues as they arise.
- System Collaboration: Work with source system and downstream system teams to ensure seamless integration and alignment. This includes debugging multi-layered stored procedures and collaborating with multiple teams when something goes wrong.
- Improve Architecture Scalability: Evolve the current architecture to scale effectively, accommodating ever-increasing volumes of data, with a focus on improving system reliability and debugging in a multi-layered environment.
- Develop .NET Applications: Build and maintain .NET applications using C and WPF for monitoring tools, data exploration tools, backend job processors, and Windows services. You will be working in a complex WPF-based UI, integral to the Data Warehouse management, written using the MVVM design pattern. The UI controls key functions such as monitoring data loads, kicking off jobs, updating data, and managing configurations.
- Support for Concurrent Loads & Multi-threaded Architecture: Address challenges that come with debugging .NET code in a multi-threaded architecture, ensuring that processes run smoothly and effectively.
- Technical Documentation: 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, balancing production support, BAU work, and large multi-sprint projects.
Day in the Life:
- Attend Scrum Ceremonies and Meetings (10%): Participate in daily stand-ups and sprint meetings with the development team, ensuring alignment on progress, blockers, and priorities.
- Production Support (15%): Address and resolve issues related to data quality, application bugs, or data load failures, often in collaboration with other teams such as the DBA or Infrastructure team.
- BAU Work and Requests (15%): Handle daily operations, including adding new tables, reloading data, and assisting users with accessing data or applications.
- Long-Term Projects (40%): Focus on infrastructure changes, data enhancements, framework enhancements, and process improvements. These initiatives span multiple sprints and will require collaboration with various teams to ensure successful implementation.
Requirements Experience Required: - Bachelor's degree in engineering, information technology, or a related field required.
- MBA/CFA and/or finance-related education (Investment Management or Financial Engineering) preferred.
- Programming Proficiency: Skilled in C and Python for ETL, backend development, and automation. Experience with multi-threaded code and debugging concurrent load processes is critical.
- Experience with WPF and MVVM Models for Frontend and UI Development, specifically for building tools and systems that manage data loads and backend processing. The WPF-based application is integral to Data Warehouse operations and is written using the MVVM design pattern.
- SQL & T-SQL Expertise: Strong proficiency in SQL for data querying, transformation, and performance optimization, particularly within Microsoft SQL Server. Experience with complex, multi-layered stored procedures and debugging T-SQL code.
- System Troubleshooting and Collaboration: Experience working with multiple teams (e.g., Accounting System, Infrastructure, DBAs) to resolve issues in multi-layered environments.
- Bonus Skills:
- .NET Maui (Multi-platform App UI).
- Cloud Technologies: Familiarity with Azure, particularly for data warehouse migration and development.
- Data Visualization Tools: Proficiency in Power BI for creating insightful dashboards and reports.
- Microservices: Experience with Azure Service Bus and in-house built microservices using C running on a VM server.