SQL Developer

4 days ago

Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

LeverageTek is actively seeking a SQL Developer/Data Architect for a 6-month contract with its Ottawa-based customer.



Work Location

Remote position with 5-10% travel requirement to Montreal.



Key Tasks

  • Define and document data ETL procedures, standards, and metrics to support customer analytics business rules.
  • Establish data quality processes and compliance with data standards for data domains.
  • Troubleshoot issues with data quality as identified by stakeholders.
  • Perform activities to address data extraction, data validation, data cleansings, data harmonization, business logic, exception handling, and required data indication.
  • Design and build a data inventory including field definitions, ontologies, list of values (LOVs), and mappings as requested by the stakeholder and defined by requirements.
  • Understand critical data relationships and customer data domains.
  • Collaborate with business process owners, data producers, and data consumers to get an understanding of current processes and systems that has a direct impact on the quality of the enterprise data.
  • Work with business application engineers to define and maintain a customer data model and Analytics solutions.



Key Qualifications

  • Experience with defining and documenting data ETL procedures, standards, and metrics to support customer analytics business rules.
  • Experience establishing data quality processes and compliance with data standards for data domains.
  • Experience performing activities to address data extraction, data validation, data cleansings, data harmonization, business logic, exception handling, and required data indication.
  • Experience designing and building a data inventory including field definitions, ontologies, list of values (LOVs), and mappings as requested by the stakeholder and defined by requirements.



Qualifications

  • Strong experience working with retail Point-of-Sale (POS) Transaction Log (TLOG) files and mapping data to be used by other retail related business applications
  • Bachelor of Science degree and/or relevant work experience
  • 7+ years of prior experience as a data analyst or architect
  • Data Architect deep understanding of ETL Tools, Best Practice Processes (Enterprise ETL Tools, Self-Service, Data Preparation)- Data Movement Tools (SSIS, Informatica, Talend, etc.)
  • Proficient in SQL (SQL, Stored Procedures, Dynamic SQL, Joins, Aggregation, etc.)
  • Experience with Data Structure Solutions (Big Data, RDBMS, NoSQL)
  • Experience with a couple of Database Systems (Oracle, SQL Server, My SQL, Postgres, etc.)
  • Skilled in one scripting language, such as R, Python, VBScript, Shell Script
  • Understanding of Data Governance, Data Integrity, Master Data Management, Data Quality
  • Design, Develop, and Deployment Best Practices
  • Experience structuring and analyzing large quantities of data and information for statistical and analytical modeling
  • Understanding of Business Intelligence Best Practices, Architectures, Tools, Methodologies, and Software- Good Strong oral, written communication and leadership skills
  • Proven ability to partner with client stakeholders from various parts of an organization
  • Ability to handle multiple tasks and workstreams in a fast-paced environment
  • Experience with SDLC methodologies (Agile and Waterfall Development)
  • Experience with Data Modeling



About LeverageTek Staffing Solutions

Thank you for taking the time to apply Since our company’s inception in March 2003, LeverageTek Staffing Solutions has worked to become a trusted partner with our consultants and customers. LeverageTek provides end-to-end, cross-functional staffing solutions throughout North America. With thousands of successful engagements to our credit with leading public and private sector organizations, we are the experts in identifying, deploying, and supporting IT and business talent on a contract, contract-to-hire, and permanent basis.


Our responsive service and ability to deliver the right fit, on time and within budget, often leads to repeat engagements and a long-standing relationship.


Accessibility accommodations are available upon request

  • SQL Developer

    3 days ago

    Greater Ottawa Metropolitan Area, Canada LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking a SQL Developer/Data Architect for a 6-month contract with its Ottawa-based customer. Work Location Remote position with 5-10% travel requirement to Montreal. Key Tasks Define and document data ETL procedures, standards, and metrics to support customer analytics business rules. Establish data quality processes and compliance...

  • SQL Developer

    4 weeks ago

    Greater Ottawa Metropolitan Area, CA LeverageTek Staffing Solutions Full time

    LeverageTek is actively seeking a SQL Developer/Data Architect for a 6-month contract with its Ottawa-based customer.Work LocationRemote position with 5-10% travel requirement to Montreal.Key TasksDefine and document data ETL procedures, standards, and metrics to support customer analytics business rules.Establish data quality processes and compliance with...

  • Senior Intellimatch Development Manager

    2 weeks ago

    Greater Montreal Metropolitan Area, Canada Dacaro Services Full time

    About Dacaro ServicesDacaro Services is a leading provider of innovative solutions in data reconciliation and analysis. Our team of experts is dedicated to delivering cutting-edge technology that meets the evolving needs of our clients.Job SummaryWe are seeking a highly experienced Senior Intellimatch Development Manager to join our team. The successful...

  • Developer - Java/Python & SQL

    2 months ago

    Ottawa, Canada SHOEBOX Ltd. Full time

    p>We're looking for a Java Cloud Developer who has good DevOps experience and is excited to make a real impact on the world by developing the cloud component for innovative mobile and web based medical solutions with an amazing group of brilliant and passionate people. p>You'll have the opportunity to do all kinds of cool things like:Develop complex...

  • S4 Hana SQL

    7 months ago

    Ottawa, Canada Sophus Info Full time

    Client : Adobe. - Type of hire : Contract - Location : Montreal, Ottawa. - Hybrid : 3 days onsite - Mandatory - not negotiable. * - Level of Hire : Sr. Consultant or Sr Developer or Lead Level - Please do not Architect level. **Job Description**: Base location for this position will be in Montreal Ottawa, Canada **Responsibilities**: - Design and build...

  • SQL Database Tester Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Employment and Social Development Canada Full time

    About the JobWe are seeking an experienced SQL Database Tester Analyst to join our team. As a key member of our IT service delivery group, you will play a crucial role in ensuring the quality and security of our information systems.ResponsibilitiesCollaborate with clients to identify requirements for database testing and development.Design, develop, and...

  • Senior Business Intelligence Developer

    3 weeks ago

    Greater Montreal Metropolitan Area, Canada PrecisionERP Incorporated Full time

    PrecisionERP Incorporated is seeking a highly skilled Data Architect for a 4-5 month contract in our Montreal office. The ideal candidate will work a hybrid schedule with two days onsite per week.We require an individual with at least five years of experience in delivering data engineering projects, preferably using agile methodologies and rapid...

  • Lead Java Developer for Investment Banking Solutions

    4 weeks ago

    Greater Montreal Metropolitan Area, Canada QUANTEAM - North America Full time

    Job DescriptionWe are seeking a highly skilled Lead Java Developer to join our team at Quanteam - North America. As a Senior Full-Stack Developer, you will be responsible for designing and developing robust, scalable, and high-performance applications for one of our clients, an Investment Bank based in Montreal.The ideal candidate will have at least 10 years...

  • Lead Software Developer for High-Performance Applications

    4 weeks ago

    Greater Montreal Metropolitan Area, Canada QUANTEAM - North America Full time

    About Quanteam - North AmericaWe are a consulting firm specializing in Banking, Finance, and Financial Services with a team of 1,000 expert consultants representing 35 different nationalities. Our offices span across 10 international locations.Job Description:We are seeking an experienced Lead Software Developer to join our client, an Investment Bank based...

  • Senior Software Development Manager

    4 weeks ago

    Greater Toronto Area, Canada Sage Recruiting Full time

    Sage Recruiting seeks a highly skilled Technical Lead to join our team.The role involves leading the design and development of enterprise-wide technology solutions for a prominent client in the private sector. You will work closely with end-users to understand their needs and challenges, delivering elegant, scalable solutions that meet both technical and...

  • ServiceNow Developer

    3 days ago

    Greater Montreal Metropolitan Area, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • ServiceNow Developer

    3 days ago

    Greater Montreal Metropolitan Area, Canada Synechron Full time

    We are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud &...

  • ServiceNow Developer

    3 days ago

    Greater Montreal Metropolitan Area, Canada Synechron Full time

    We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps,...

  • .NET Developer

    1 day ago

    Greater Kitchener-Cambridge-Waterloo Metropolitan Area, Canada company Full time

    Looking for experienced .NET Developers (senior and Intermediate level) committed to a hybrid-model work in London, Ontario.Location: London, ONHybrid: 2 days a week in officeInterview: 2-3 rounds (including in-person meeting)Domain: Software development / marketplace e-commerce platform/ payments, billing, ordering, rebate managementKey Tech Requirements:...

  • .NET Developer

    1 day ago

    Greater Kitchener-Cambridge-Waterloo Metropolitan Area, Canada company Full time

    Looking for experienced .NET Developers (senior and Intermediate level) committed to a hybrid-model work in London, Ontario.Location: London, ONHybrid: 2 days a week in officeInterview: 2-3 rounds (including in-person meeting)Domain: Software development / marketplace e-commerce platform/ payments, billing, ordering, rebate managementKey Tech Requirements:...

  • [MONTREAL] - Senior JAVA / Angular Full-Stack Developer

    1 month ago

    Greater Montreal Metropolitan Area, CA QUANTEAM - North America Full time

    About the Company:As the founding entity of RAINBOW PARTNERS, Quanteam is a consulting firm specializing in Banking, Finance, and Financial Services. Guided by our core values of closeness, teamwork, diversity, and excellence, our team of 1,000 expert consultants, representing 35 different nationalities, collaborates across 10 international offices: Paris,...

  • Delphi Developer

    3 days ago

    Greater Toronto Area, Canada Connexall Full time

    GlobeStar Systems is a leader in integrated clinical communication. Our cornerstone product, Connexall®, is an award-winning Enterprise grade IoT platform, purpose built for the healthcare industry. Connexall® is a sophisticated and customizable end-to-end integration and communication platform that helps its customers improve clinical workflow, reduce...

  • Delphi Developer

    3 days ago

    Greater Toronto Area, Canada Connexall Full time

    GlobeStar Systems is a leader in integrated clinical communication. Our cornerstone product, Connexall®, is an award-winning Enterprise grade IoT platform, purpose built for the healthcare industry. Connexall® is a sophisticated and customizable end-to-end integration and communication platform that helps its customers improve clinical workflow, reduce...

  • Delphi Developer

    4 days ago

    Greater Toronto Area, Canada Connexall Full time

    GlobeStar Systems is a leader in integrated clinical communication. Our cornerstone product, Connexall®, is an award-winning Enterprise grade IoT platform, purpose built for the healthcare industry. Connexall® is a sophisticated and customizable end-to-end integration and communication platform that helps its customers improve clinical workflow, reduce...

  • .NET Developer

    2 days ago

    Greater Kitchener-Cambridge-Waterloo Metropolitan Area, CA company Full time

    Looking for experienced .NET Developers (senior and Intermediate level) committed to a hybrid-model work in London, Ontario.Location: London, ONHybrid: 2 days a week in officeInterview: 2-3 rounds (including in-person meeting)Domain: Software development / marketplace e-commerce platform/ payments, billing, ordering, rebate managementKey Tech Requirements:...