Senior .NET and SQL Consultant

Consultant KDNI-Tax Tech-Canada-IGN

Net and SQL 

 

• Strong Object-Oriented Programming skills 
• Deep knowledge of SOLID principles including Dependency Injection (DI) 
• Proficient in C# and .NET ecosystem 
• Hands on knowledge of Windows Forms based application development 
• Familiar with ORMs (Entity Framework, Dapper) 
• Skilled in LINQ 
• Intermediate SQL and ETL knowledge 
• High code quality with unit testing (xUnit/nUnit) 
• Git fundamentals 
• Knowledge of basic cloud services (Azure or AWS) 

Excel 

• Proficiency in Excel Language 
• Developing robust, modular code utilizing procedures and functions. 
• Advanced application of Excel formulas, including dynamic arrays and LAMBDA functions. 
• Integration with external data sources such as SharePoint lists and SQL databases. 
• Experience working with Power Query 
• Expertise in the Excel Object Model 
• Comprehensive knowledge of key objects: Application, Workbooks, Worksheets, Range, and others. 
• Skilled use of ActiveX and Form controls. 
• Event handling at both workbook and worksheet levels. 
• Practical experience designing and developing VBA solutions interacting with COM objects. 
• Error Handling and Debugging 
• Mastery of various error handling methodologies. 
• Performance and Memory Optimization 
• In-depth understanding of effective memory management. 
• Strong ability to evaluate and optimize existing VBA logic for performance improvements. 
• Security 
• Knowledgeable about macro security and Trust Center configurations. 

General 

• End-to-end Software development leveraging Azure Dev Ops 
• Sound understanding of Agile principles and development life cycle activities. 

 

• Ability to understand complex business logic and building data models that reflect business rules. 

Bonus 

• Experience with using APIs and JSON. 
• Experience with scripting programming languages such as Python or PowerShell, etc. 

 

Net and SQL 

 

• Strong Object-Oriented Programming skills 
• Deep knowledge of SOLID principles including Dependency Injection (DI) 
• Proficient in C# and .NET ecosystem 
• Hands on knowledge of Windows Forms based application development 
• Familiar with ORMs (Entity Framework, Dapper) 
• Skilled in LINQ 
• Intermediate SQL and ETL knowledge 
• High code quality with unit testing (xUnit/nUnit) 
• Git fundamentals 
• Knowledge of basic cloud services (Azure or AWS) 

Excel 

• Proficiency in Excel Language 
• Developing robust, modular code utilizing procedures and functions. 
• Advanced application of Excel formulas, including dynamic arrays and LAMBDA functions. 
• Integration with external data sources such as SharePoint lists and SQL databases. 
• Experience working with Power Query 
• Expertise in the Excel Object Model 
• Comprehensive knowledge of key objects: Application, Workbooks, Worksheets, Range, and others. 
• Skilled use of ActiveX and Form controls. 
• Event handling at both workbook and worksheet levels. 
• Practical experience designing and developing VBA solutions interacting with COM objects. 
• Error Handling and Debugging 
• Mastery of various error handling methodologies. 
• Performance and Memory Optimization 
• In-depth understanding of effective memory management. 
• Strong ability to evaluate and optimize existing VBA logic for performance improvements. 
• Security 
• Knowledgeable about macro security and Trust Center configurations. 

General 

• End-to-end Software development leveraging Azure Dev Ops 
• Sound understanding of Agile principles and development life cycle activities. 

 

• Ability to understand complex business logic and building data models that reflect business rules. 

Bonus 

• Experience with using APIs and JSON. 
• Experience with scripting programming languages such as Python or PowerShell, etc. 

 

Preferred Qualifications

• Experience with .NET or Python.
• Familiarity with Agile methodologies.
• Bachelor’s degree in:
  • Computer Science
  • Information Technology
  • Or a related field

Experience Level

Senior Level