Data Warehouse Engineer / ETL Consultant



Job Description:Job Title: SQL Server Data Warehouse/ETL Consultant Type: Contract Location: Burnaby, BC V5C 4E2 Duration: 3 Months (possibility of a further 3-month extension) Start Date: August 30th, 2021 End Date: December 3rd, 2021 Days/Hours: Monday to Wednesday Office Thursday to Friday Remote/ 9:00 AM to 6:00 PM Hours/Week: 40 Pay Rate: $85.00.00/hour TO $105.00.00/hour Responsibilities:Create Data warehouse, migrate or Transform data using mapping data flows, Working with SQL, and Progress DB.Design, develop, test, optimize, and deploy SQL Server Integration Services (SSIS) packages to perform all data integration requirements including automated and reusable routines for extracting requested information from database systems Extract, Transform and Load (ETL) solutions to populate the data warehouse.Actively participate in requirements gathering meetings and team meetings to convert business requirements into technical specifications.Design tables/views and load data. Write logic to extract data i.e., using stored procedures ensuring design and development tasks conform to all data consolidation, data integration, data transformation, and data quality best practices.Write and create data processing/control scripts and stored procedures, use ETL (SSIS) methods- loading a data warehouse from an existing Transactional model. Create package for Loading multiple files into a system for daily jobs and monthly jobs ensuring the quality of the dataWorking with the team on database design, query tuning, index assignment, and trigger and procedure creationCreate relationships between data and develop tabular data models.Chart creation and data documentation explaining algorithms, parameters, models, and relations.Develop new SQL reports using SSRS and SSISAnalyze and troubleshoot technical issues related to existing reporting Skills Required:Must have extensive experience working with the entire Microsoft BI Stack (SQL Server, SSIS, SSAS, Azure Data Factory), along with excellent communication skills.Extensive experience as a data analyst in writing Transact SQL, SQL Stored Procedures, and automation scripts to automate the data extraction and optimize reporting processes.Prior work experience architecting ETL tools for multi-database organizations with Microsoft SSIS ETL Development.Must have experience using ETL on MS SQL/Progress database.Ability to write complex SQL Queries and Stored Procedures is needed3+ years SQL experience in a BI capacity REQUIRED (data warehouse experience)Recent experience performing complex data analysis and ETL.Proven experience writing data loads using stored procedures and SSIS packages. Company Description:The PeopleToGo ApproachLooking for a job or ways to use spare time to increase your income? You need a staffing agency that appreciates the full value of your talents and skills, and knows how to put them to work to your best advantage.You Need PeopleToGoWith almost 20 years experience in finding the right opportunities for workplace professionals, PeopleToGo understands the business and knows how to help you reach your full potential.Whether you are looking for contract or full-time positions, the PeopleToGo Approach will find the right job for your skills, experience and goals.* Responsive – When you choose PeopleToGo, we will respond to you quickly, accurately and with your best interests in mind.* Connected – Depending on your wishes, you will get exposure to top IT companies in North America.* Committed – As part of the PeopleToGo team of professionals, you get the help you need with resumé writing and interview optimization. You can also take advantage of ongoing training, education and certification programs designed to expand your skills and keep them up-to-date.The Result of The PeopleToGo Approach?When you take advantage of everything PeopleToGo offers job seekers, you maximize your work potential and you quickly add to your experience, skills and connections. It all leads to the best result possible: increased market value for your talents.L’approche PeopleToGoVous recherchez un emploi ou des moyens d’utiliser votre temps libre pour augmenter vos revenus? Vous avez besoin d’une agence de recrutement qui apprécie toute la valeur de vos talents et de vos compétences et sache les utiliser au mieux.Vous avez besoin de PeopleToGoAvec près de 20 ans d’expérience dans la recherche d’opportunités pour les professionnels du lieu de travail, PeopleToGo comprend l’entreprise et sait vous aider à atteindre votre plein potentiel.Que vous recherchiez un poste contractuel ou à temps plein, l’approche PeopleToGo trouvera le poste qui convient à vos compétences, à votre expérience et à vos objectifs.* Responsive – Lorsque vous choisissez PeopleToGo, nous vous répondrons rapidement, avec précision et en tenant compte de vos intérêts.* Connecté – En fonction de vos souhaits, vous obtiendrez une exposition aux meilleures entreprises informatiques en Amérique du Nord.* Engagement – En tant que membre de l’équipe de professionnels de PeopleToGo, vous obtenez l’aide dont vous avez besoin pour la rédaction de CV et l’optimisation des entretiens. Vous pouvez également profiter de programmes de formation continue, d’éducation et de certification conçus pour développer vos compétences et les maintenir à jour.Le résultat de l’approche PeopleToGo?Lorsque vous profitez de tout ce que PeopleToGo offre aux demandeurs d’emploi, vous maximisez votre potentiel de travail et vous ajoutez rapidement à votre expérience, à vos compétences et à vos relations. Tout cela conduit au meilleur résultat possible: une valeur de marché accrue pour vos tal. Job ID: 42315030
PeopleToGo Inc

View original article here Source