Intermediate Database Developer

2 weeks ago

Richmond Hill, Ontario, Canada Sym-Tech Dealer Services Full time $80,000 - $120,000 per year

Position Summary:

The Intermediate Database Developer is responsible for designing, developing, and maintaining data solutions to support BI and analytics. Expertise in SQL, ETL, SSIS, SSRS, SSDT, Power BI, DAX, and related tools is required. Key duties include analyzing data needs, building data models, optimizing queries, and delivering insights through reports and visualizations. The role emphasizes data accuracy, integrity, and performance, working closely with stakeholders to meet business requirements.

Position Functions:

  • Design and implement complex SQL queries to support data retrieval, analysis, and reporting needs.
  • Optimize database queries, workflows, and reports by analyzing execution plans, tuning queries, and improving overall system performance.
  • Develop, enhance, and maintain data solutions, including ETL workflows, data models, reports, and dashboards using tools such as SQL, SSIS, SSRS, Power BI, and DAX.
  • Support data warehousing initiatives by designing and implementing data integration processes that ensure data consistency, accuracy, and integrity across multiple sources.
  • Collaborate with business units to gather requirements and translate them into efficient data models, queries, and visualizations.
  • Continuously monitor and improve data development processes, including documentation, version control, and system enhancements.
  • Work closely with IT teams to support application delivery, troubleshoot issues, and optimize data-related performance.
  • Assist with the development and maintenance of data marts and data governance standards.
  • Stay informed on emerging data technologies and trends, recommending innovative solutions to improve data systems.
  • Contribute to project planning, effort estimation, and resource management for data development initiatives.
  • Ensure data security, compliance, and governance standards are integrated into all data solutions.
  • Respond promptly to data support requests, collaborating with Help Desk and IT teams to troubleshoot and resolve issues.
  • Promote best practices in data development, including reducing technical debt and ensuring scalable, maintainable solutions.

Qualifications and Competencies:

  • Bachelor's degree in Computer Science, Data Science, Information Technology, or related field.
  • 5+ years of experience in Microsoft SQL data development, BI and analytics with a strong focus on optimization, standardization, and rewriting existing processes to improve performance.
  • 5+ Proven expertise in SQL, ETL processes, SSIS, SSRS, Power BI, and DAX.
  • Strong understanding of data modeling, data warehousing, and data integration best practices.
  • Experience with cloud data platforms (e.g., Azure) is an asset.
  • Strong problem-solving, troubleshooting, and analytical skills.
  • Excellent communication skills, with the ability to work effectively with technical and non-technical stakeholders.
  • Ability to manage multiple priorities and deliver high-quality results on time.

  • Senior Data Developer

    18 hours ago

    Richmond Hill, Ontario, Canada OpenText Full time US$100,000 - US$180,000 per year

    Opentext - The Information CompanyOpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that...

  • Sr. Software Developer

    1 week ago

    Richmond Hill, Ontario, Canada Staples Full time $80,000 - $120,000 per year

    DescriptionSome of what you will do:Provide AS400 based applications development and support services, including requirements and development specifications, delivery schedules, programming, testing and implementation to deliver high quality business information processing systems.Specifically, You Will:Design/Development/Maintenance: 80% Responsible for...

  • Software Development Team Lead

    1 day ago

    Richmond Hill, Ontario, Canada Staples Canada Full time

    Some of what you will do:The Staples technology team is seeking a talented and energetic Team Lead to join our team. We want an individual who will challenge the norm, strive to create the best experience's and someone who always puts the customer first. You will have a passion for writing clean, simple code and a willingness to share learnings within your...

  • Principal Software Developer 1

    2 weeks ago

    Richmond Hill, Ontario, Canada OpenText Full time $120,000 - $180,000 per year

    Opentext - The Information CompanyOpenText is a global leader in information management, where innovation, creativity, and collaboration are the key components of our corporate culture. As a member of our team, you will have the opportunity to partner with the most highly regarded companies in the world, tackle complex issues, and contribute to projects that...

  • Millwork Project Coordinator

    7 days ago

    Richmond Hill, Ontario, Canada The Pod Group Full time $60,000 - $90,000 per year

    Retail EnvironmentsDevelop engineering plans and solutions for brands that embrace artistic freedom across the retail world.Recognized globally, our client is one of the largest retail environment manufacturers in the industry. They take pride in developing innovative spaces with the ability to blend multi-materials in a creative fashion that produces unique...

  • Administrative Project Coordinator

    7 days ago

    Richmond Hill, Ontario, Canada The Pod Group Full time $40,000 - $60,000 per year

    Retail EnvironmentsDevelop engineering plans and solutions for brands that embrace artistic freedom across the retail world.Recognized globally, our client is one of the largest retail environment manufacturers in the industry. They take pride in developing innovative spaces with the ability to blend multi-materials in a creative fashion that produces unique...

  • Graphic Designer

    1 week ago

    Richmond Hill, Ontario, Canada RENO Lighting Full time $60,000 - $90,000 per year

    Reno Lighting is looking for a Junior–Intermediate Graphic Designer to join our marketing team and help elevate our brand through impactful visuals, product storytelling, and cohesive design. You'll collaborate closely with the Marketing Manager and cross-functional teams to create engaging content that communicates the quality and innovation behind Reno...

  • Senior Project Manager

    1 week ago

    Richmond Hill, Ontario, Canada Amico Full time $80,000 - $140,000 per year

    Senior Project Manager – Amico Clinical SolutionsRichmond Hill, ONWe offer many opportunities for advancement within the Amico Group of Companies, along with a comprehensive benefit package, employer paid vacation, management approved tuition reimbursement and an employee referral program.The successful candidate will be energetic, eager, driven, and able...

  • Technical Implementation Engineer/Manager

    22 hours ago

    Richmond Hill, Ontario, Canada Paymentus Full time

    Paymentus leads the North American marketplace in electronic bill payment solutions and is looking for high performers to join our development team building SaaS Fintech solutions across a range of industries. You will contribute to a massively scalable data platform that is built on top of a world-class enterprise platform supporting thousands of clients...

  • Senior Electrical Estimator

    23 hours ago

    Richmond Hill, Ontario, Canada Symtech Innovations Ltd. Full time $80,000 - $120,000 per year

    The Senior Electrical Estimator is responsible for preparing cost estimates and bid documents for a variety of electrical construction projects. Working closely with suppliers, clients, and the Chief Estimator, they ensure accurate estimates across all design stages—conceptual, schematic, design development, tender, and construction. The role includes...