Dot Net Architect

Primary Role

• Serve as a senior developer, contributing to the ongoing development efforts and new initiatives.
• Guide and Mentor, the development teams, including internal and external teams members.
• Design, develop, modify, implement, and support software components anywhere in the stack consisting of .Net, SQL server, SSIS, SSAS, and SSRS.
• Capable of providing overall leadership to others on larger change requests or projects impacting many disciplines that impact the Enterprise Warehouses.
• Be the technical expert to manage the production SQL Server environment for various business processes, reporting and the systems that feed data.
• Provide level 2 production support for systems and processes as necessary
• Determine root cause for complex software issues and develop efficient, and long-term technical solutions.
• Work in close partnership with cross-functional teams and management.

Key Accountability:

• Develop software solutions by identifying user requirements, conferring with users, and studying systems flow, data usage, and business processes.
• Documents and demonstrates solutions by producing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code.
• Ensure the code quality is being met with the appropriate test cases written to address the code correctness.
• Works closely with a team of frontend and backend engineers, product managers, and analysts.
• Comfortable working on projects where there is some element of unknown and ambiguity
• Ability to work independently and take initiative to develop solutions for business requirements.

Requirements

• Minimum of 10 years of designing and developing complex Full Stack custom applications using C#, .Net, ASP.Net, Reactjs,angular programming languages.
• Strong Microsoft SQL experience, script creation, database bug analysis & resolution
• Expert in business intelligence concepts including Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS) and overall SQL Server architecture.
• 5+ years of experience developing Business Intelligence Warehouse Applications
• Extensive experience with SQL Server Reporting Services, SQL Server Integration Services, Microsoft Power BI, and SQL Server Analysis Services
• Excellent SQL Server skills including experience with SQL Server 2012, 2016 and 2019
• Deep understanding of T-SQL, complex Joins, Stored Procedures, and Triggers
• Experience with an Enterprise Data Warehouse including data modeling and architecture
• Experience and understanding of the full SDLC including gathering business requirements, designing solutions, and working with stakeholders to test and implement the solutions you build.
• Experience working on large enterprise data warehouse applications.
• Designed high-availability applications in a multi-tier cloud architecture, including database, service/API, and UI components of the application.
• Experience with cloud-based technologies on AWS and/or Azure.
• Understand building solutions on Windows and Linux OS.
• Demonstrate familiarity with Continuous Integration and Continuous Deployment concepts.
• Working experience with both SQL and No SQL Databases.