Review and understand code and architecture of the existing code, and make updates as required to ensure the code is modular and can support scalability requirements
Code enhancements to existing features and new features as per approved requirements and design direction
Provide realistic work estimates to support project planning; capture business requirements and update business rules based on the requirements
Use structured methodologies, design best practices, implement code that is of quality, and clearly documented. The application should function as required, without any defects. The application must operate with the Operating System (OS) and other peripherals as identified
Create custom reports as required, applying Microsoft Technologies
Conduct testing, integration and deployment of the developed changes across the environment
Review, analyze and recommend solutions to any defects discovered in production
Fully document all developed code, and transition in a steady-state to a full-time resource.
10+ years of experience with developing code in SQL and Azure SQL. Experience in SQL performance and optimization
Demonstrated experience with power query/power pivot, and being able to combine datasets from different sources
Demonstrated experience with Data factory, On-Premise data gateway
Familiar with ADFS (Active Directory Federation Services).
Familiar with Power BI best practices
Experience with and knowledge of UI Design Principles
Experience in SOAP and REST web services for processing real-time data streams
Experience in conducting unit testing and troubleshooting
Demonstrated experience in enabling role-based security in the reports by restricting access to information (record-based access) and reports
Demonstrated experience with deployment of Report into Azure infrastructure.
Analytical mind with a problem-solving aptitude
10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence
Experience with Azure Analysis Services / SSAS (tabular/multidimensional), SQL Server Reporting Services (SSRS) and Power BI
Building complex data analytics and reporting for the improvement of dispatch operations, patient transports and cost savings,
Demonstrated experience in design and development of visualizations for various reports/dashboards including near real-time to be shared with both B2B and B2C
Demonstrated the ability to create interactive near real-time dashboards (with drill-downs)
Demonstrated experience in building and deploying Mobile dashboards
Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.
Strong consulting skills to engage with all stakeholders, lead meetings with internal and external clients to gather and document business requirements.
A demonstrated team player with a proven track record for meeting deadlines
Demonstrated experience in creating of conceptual, logical, and physical data documentation for knowledge retention and transfer.
Demonstrated experience in architecting, design, and building of dynamic, real-time analytics pipelines and dashboards using visualization tools such as PowerBI