ETL BI Developer

3 weeks ago


East York, Canada Maarut Inc Full time

Resource Profile

  • This requirement is for a ETL and BI Developer to work with technology and business teams to provide technical leadership in planning, analysis, building, configure, testing, and post implementation support data solutions with experience with enterprise ETL and data integration and reporting tooling such as IBM Infosphere Information Server DataStage and/or Cognos. Experience with the Guidewire suite or the insurance industry general would be an asset.

Resource Responsibilities

  • Analyze and assess legacy data landscape and reporting solutions and ascertain and identify the impacts to the legacy reporting based on the Dynamic Intake modernization initiative.
  • Design, develop, implement, and support through the full development lifecycle the creation/modification/enhancement of the data pipelines and reporting product as per requirements to support the modernized solution working with the broader Dynamic Intake project team
  • Monitor and administer automated and manual data integration and ETL and reporting jobs to verify execution and measure performance.
  • Work with management to provide technical assistance, advice and guidance to client IT staff and business clients in response to enquiries on the functionality of BI/ETL tools, and data in warehouse and related data marts to ensure efficient and uninterrupted IM services to the business users.




Requirements

Knowledge & Skills

MUST HAVE:

  • 5+ Years of experience in designing, developing, testing and implementing Extract/Transform/load (ETL) data pipelines and reporting with InfoSphere DataStage and/or Cognos
  • 4+ years' experience in data modelling and working with common data warehouse models
  • 4+ years' experience doing analysis and developing with SQL (e.g. Oracle, MS SQL, DB2)
  • Strong understanding of Data Engineering best practices for moving large volumes of data
  • Experience writing well documented unit tests and executing them.
  • Experience of reverse-engineering data mappings based on application-layer code highly desirable.
  • Ability to express complex technical concepts effectively, both verbally and in writing


NICE TO HAVE:
  • Good knowledge of popular data standards and formats (e.g, JSON, XML, Proto, Parquet, Avro, ORC)
  • Experience working with high volume data exchange and transaction processing systems Experience writing well documented unit tests and executing them
  • Strong understanding of SDLC and Agile Methodologies
  • Degree in computer science, math, engineering or equivalent work experience Excellent Communication Skills
  • Experience working with the Guidewire Suite or in the insurance industry would be an asset.




  • York, ON, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. Builds complex SQL queries, reports(SSRS/Power BI), and dashboards (Power BI) to meet business needs. Design, develops and implements BI solutions using technology best...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Software Developer - ETL for our public sector client.Work location: North YorkDuration: Twelve Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)AdvantagesGood...


  • York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...


  • York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly. Key...


  • York, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...


  • York, ON, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...


  • York, ON, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly.Key...


  • York, ON, Canada Robert Half Full time

    Our client is looking for a Business Intelligence Report Developer for a long term contract position. The ideal candidate will have strong experience in SQL, Power BI, Tableau and Azure. This is a hybrid position in Thornhill, Ontario. If you meet the requirements and are interested in this opportunity please apply to the position directly. Key...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    Our client, a leader in the Healthcare industry, is looking for a Senior ETL developer for doing product updates, operations and maintenance on a series of ETL products. This Senior Developer must be knowledgeable and experienced in the following technologies to be able to support the related portfolio of products: Informatica DEI and shell scripting,...

  • RQ07285 CDT

    2 weeks ago


    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Senior ETL Developer for our public sector client.Work location: 21 College Street, TorontoDuration: 11 months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)AdvantagesGood...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    Our client, a leader in the Healthcare industry, is looking for a Senior BI Developer who has a strong background with Microstrategy, to assist them with a migration from Qlik to MicrostrategyThis Senior BI Developer will design, develop, test and deploy the code and implementation of MicroStrategy based visualizations, documents, dossiers and...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    Is our Government client is looking for candidates. Experience and Skill Set RequirementsDeliverables:• Create Power BI report(s), data models• Undertake special assignments/sub-projects as assigned• Conduct, assess, evaluate and document stakeholder interests and business needs• Ensure alignment and adherence to IT processes and...

  • Business Analyst

    1 month ago


    East York, Canada Kastech Canada Full time

    Job Summary: - Incorporation/INC canddiates only. This is a contract job - Pay range $30-38 per hour. - Hybrid - 3 times in Office. **Duties**: - Understand the end-to-end merchant onboarding process, implementing processes that remove points of friction and streamline/speed the onboarding workflow - Conduct thorough checks on merchant catalogs ahead of...


  • North York, Canada Mevotech Full time

    **Take your Career to the next Level with MEVOTECH.** **JOB PURPOSE** Reporting directly to the Director Enterprise Architecture, the Manager, Data Governance will be responsible for managing and optimizing our data warehouse infrastructure, ensuring its reliability, scalability, and efficiency. This individual will be working closely with our finance and...


  • East York, Canada Yoush Consulting] Full time

    Job Description:Job Description Welcome to Yoush Consulting. Are you an independent IT Consultant, or do you wish to become one? Must have 5+ years experience as a D365 System Administrator with knowledge of the Dynamics Finance and Operations (F&O) module. The D365 Administrator will be responsible for analyzing, configuring, and maintaining the...

  • RQ07280 CDT

    2 weeks ago


    North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a CDT - One (1) Report Developer - Senior for our public sector client.Work location: Downtown TorontoDuration: Eight Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Database Administrator - Intermediate for our public sector client.Work location: 777 Bay Street, TorontoDuration: Nine Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...


  • North York, Canada Stalco Full time

    **Company**:Stalco Inc. **Reports to**:Director of Sales **Schedule**:Monday to Friday **About Us**: Stalco is a Toronto-based full-service fulfillment and logistics company, shipping millions of consumer packages each year. Our entrepreneurial spirit and nimble mindset differentiates us from the competition. We place a high value on collaboration,...


  • North York, Canada Randstad Canada Remote Work Freelance Full time

    This is a contract position for a Data Analytical Specialist/Scientist - Junior for our public sector client.Work location: 315 Front St., TorontoDuration: Nine Months7.25 hours/dayThis is a Hybrid role that requires the candidate to be onsite 3 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional...

  • Data Analyst

    4 weeks ago


    York, Canada Silk & Snow Full time

    **Job Overview**: **Key Responsibilities**: **Forecasting & Inventory Management**: - Develop and maintain accurate demand forecasts using statistical models and historical sales data. - Collaborate with sales and marketing teams to understand promotional activities and new product launches that could impact demand. - Monitor inventory levels of our 3PL’s...