RQ10377 - Software Developer - Senior

Requirements <\/h3>

Experience and Skill Set Requirements: <\/span><\/u><\/b>
<\/p>

Must Haves: <\/span><\/u><\/b>
<\/p>

• 10+ years of experience with developing code in SQL and Azure SQL, T\-SQL, Azure Streaming Analytics SQL <\/b>
  <\/span><\/li>
  
  
• In\-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data Factory <\/b>
  <\/span><\/li>
  
  
• Demonstrated experience in design and development of ETL (Extract, transform, load) processes, and validating data sources <\/b>
  <\/span><\/li>
  
  
• Demonstrated experience in architecting, design, and building of dynamic, real\-time analytics pipelines and dashboards using visualization tools such as PowerBI <\/b>
  <\/span><\/li>
  
  
• Ability to work with minimal supervision in an agile environment, be an effective communicator with other team members and the business owners. <\/b>
  <\/span><\/li>
  
  
• Demonstrated knowledge and experience with OPS governance methodologies (e.g. UPM, architecture gating)<\/b>
  <\/span><\/li>
  
  <\/ul>

  <\/span>
  <\/p>

  Skill Set Requirements: <\/span><\/u><\/b>
  <\/p>

  Design and Development Experience: <\/span><\/b>
  <\/p>
  
  

  
  
  • 10+ years of experience with developing code in SQL and Azure SQL, T\-SQL, Azure Streaming Analytics SQL <\/span><\/b>
    <\/span><\/li>
    
    
  • In\-depth knowledge of Azure PaaS data services such as Azure SQL Database, Data Lake Store (Gen 2), Data Factory <\/span><\/b>
    <\/span><\/li>
    
    
  • In\-depth knowledge of on premise SQL Server <\/span>
    <\/span><\/li>
    
    
  • In\-depth knowledge of Azure PaaS data streaming services such as Azure Event Hub, Streaming Analytics <\/span>
    <\/span><\/li>
    
    
  • Familiar with SSAS Partitioning <\/span>
    <\/span><\/li>
    
    
  • Demonstrated experience with power query\/power pivot, and being able to combine datasets from different sources <\/span>
    <\/span><\/li>
    
    
  • Writing Python and SQL script for custom Computer Aided Dispatch (CAD) installations <\/span>
    <\/span><\/li>
    
    
  • Demonstrated experience with Datafactory, On\-Premise data gateway <\/span>
    <\/span><\/li>
    
    
  • Familiar with PowerBI best practices <\/span>
    <\/span><\/li>
    
    
  • Experience with and knowledge of UI Design Principles <\/span>
    <\/span><\/li>
    
    
  • Experience in SOAP and REST web services for processing real\-time data streams <\/span>
    <\/span><\/li>
    
    
  • Demonstrated experience in enabling role\-based security in the reports by restricting access to information (record\-based access) and reports <\/span>
    <\/span><\/li>
    
    
  • Demonstrated experience with deployment of Report into Azure infrastructure. <\/span>
    <\/span><\/li>
    
    
  • Demonstrated ability to translate complex business requirements into technical solutions <\/span>
    <\/span><\/li>
    
    
  • Analytical mind with a problem\-solving aptitude <\/span>
    <\/span><\/li>
    
    <\/ul>

    <\/span>
    <\/p>

    Technical Skills: <\/span><\/b>
    <\/p>
    
    

    
    
    • 10+ years of technical data warehousing experience with a focus in the design and development of Business Intelligence
      <\/span><\/li>
      
      
    • Experience with Azure Analysis Services \/ SSAS (tabular\/multidimensional), SQL Server Reporting Services (SSRS) and Power BI
      <\/span><\/li>
      
      
    • End to end management of the Software Development Life Cycle (SDLC) for Computer Aided Dispatch (CAD)
      <\/span><\/li>
      
      
    • Developing process models and ongoing analysis of program effectiveness for Computer Aided Dispatch (CAD),
      <\/span><\/li>
      
      
    • Demonstrated experience in design and data modeling of data warehouse (e.g. dimensional modeling), data cubes, tabular models to support reporting, both ad\-hoc and “canned” reports.
      <\/span><\/li>
      
      
    • Demonstrated experience in design and development of data models for OLTP (On\-line Transaction Processing) and OLAP (On\-line Analytical Processing) environments based on industry best practices.
      <\/span><\/li>
      
      
    • Demonstrated experience in design and development of ETL (Extract, transform, load) processes, and validating data sources <\/b>
      <\/span><\/li>
      
      
    • Demonstrated experience in design and development of visualizations for various reports\/dashboards including near real\-time to be shared with both B2B and B2C
      <\/span><\/li>
      
      
    • Demonstrated experience in architecting, design, and building of dynamic, real\-time analytics pipelines and dashboards using visualization tools such as PowerBI <\/b>
      <\/span><\/li>
      
      
    • Demonstrated experience in building and deploying Mobile dashboards
      <\/span><\/li>
      
      <\/ul>

      <\/span>
      <\/p>

      Communication Skills: <\/span><\/b>
      <\/p>
      
      

      
      
      • Strong verbal and written communication skills that enable to effectively communicate ideas and concepts. Strong Interpersonal and negotiation skills.
        <\/span><\/li>
        
        
      • Writing Business Requirements Document, Data Sharing Agreements,
        <\/span><\/li>
        
        
      • Strong consulting skills to engage with all stakeholders, lead meetings with internal and external clients to gather and document business requirements.
        <\/span><\/li>
        
        
      • Ability to work with minimal supervision in an agile environment, be an effective communicator with other team members and the business owners. <\/b>
        <\/span><\/li>
        
        
      • A demonstrated team player with a proven track record for meeting deadlines
        <\/span><\/li>
        
        
      • Demonstrated experience in creating of conceptual, logical, and physical data documentation for knowledge retention and transfer.
        <\/span><\/li>
        
        <\/ul>

        <\/span>
        <\/p>

        Industry Experience: <\/span><\/b>
        <\/p>
        
        

        
        
        • Experience in working on multi\-year projects
          <\/span><\/li>
          
          
        • Experience with building enterprise level reporting solutions that protect high\-sensitive information
          <\/span><\/li>
          
          
        • Demonstrated knowledge and experience with OPS governance methodologies (e.g. UPM, architecture gating)<\/b>
          <\/span><\/li>
          
          <\/ul>

          <\/span>
          <\/p>
          
          

          
          <\/div><\/span>
          
          <\/body>
          <\/html>"}}],"isMobile":false,"iframe":"true","jobType":"Contract","applyName":"Apply Now","zsoid":"653862245","FontFamily":"PuviRegular","jobOtherDetails":[{"fieldLabel":"Term","uitype":1,"value":"250 days"},{"fieldLabel":"Assigned Recruiter(s)","uitype":80,"value":"Margret Tinitha"},{"fieldLabel":"Job Opening ID","uitype":111,"value":"10287"},{"fieldLabel":"Industry","uitype":2,"value":"Technology"},{"fieldLabel":"Number of Positions","uitype":32,"value":"1"},{"fieldLabel":"Work Experience","uitype":2,"value":"10+ Years"},{"fieldLabel":"City","uitype":1,"value":"Toronto"},{"fieldLabel":"State\/Province","uitype":1,"value":"Ontario"},{"fieldLabel":"Zip\/Postal Code","uitype":1,"value":"M4C"}],"headerName":"RQ10377 \- Software Developer \- Senior","widgetId":"383123000000072311","isJobBoard":"false","userId":"383123000000184003","attachArr":[{"fileName":"RQ10377 \- Software Developer \- Senior.docx","linkDocs":0,"isView":"false","fileDigest":"View email address on jobs.jobcopilot.com\-\-","fileType":"docx"}],"customTemplate":"4","isCandidateLoginEnabled":true,"jobId":"383123000204220131","FontSize":"15","googleIndexUrl":"","location":"Toronto","embedsource":"CareerSite","indeedCallBackUrl":""}