Job Description
TELUS Agriculture & Consumer Goods is a great place to work. You can see it in our team members. The diversity of the team and their unique contributions set us apart from the competition. Our success is based as much on our future friendly team as the innovative technology solutions we offer.
Our team members include people like you enthusiastic, innovative, passionate and energetic. We believe that you'll find our high-performance culture personally fulfilling, professionally challenging and financially rewarding.
Here's the impact you will make and what we will accomplish together
TELUS Agriculture & Consumer Goods is leveraging our world-leading technology and innovation to create better producer-to-consumer outcomes. To do this, we are creating a unified, trusted and sustainable value chain that enables the most efficient production and logistics outcomes, while lowering the impact on the environment. We deliver actionable digital solutions and data insights that connect global supply chains, improving the safety, quality and sustainability of food and consumer goods, all in a way that's traceable and clear to the end consumer.
We offer an unmatched suite of innovative solutions and purpose-built applications for every participant in the supply chain, from seed manufacturers and farmers through to grocery stores and consumer goods companies. Our solutions are comprised of the latest technologies that enable our customers to optimize their businesses and move goods through supply chains with more accuracy, efficiency and profit to get the right products to shelf, at the right time and at the right price, creating more sustainable production and consumption outcomes.
The Sr Tech Lead Consultant will work on day-to-day resolution efforts for Enterprise NA E3, E4 Support issues and work in collaboration with other Support technicians and developers.
This position requires interfacing with customers, project leaders and product developers on support-type technical issues and in the research of problems. This position is required to ensure that assigned tasks are performed efficiently and on time according to the respective SLAs.
As Sr Tech Consultant, you will have 5-7 years' experience in SQL Server TSQL development and are considered skilled in this area. You have a proven track record in being a natural, methodical problem solver of complex issues, considering all aspects and implications of the problem and possible solutions.
Here's how
- Taking full ownership of assigned support tasks, including detailed technical planning, code review and unit testing.
- Connecting with management where necessary, for example to raise flags, discuss potential issues or brining new ideas and improvements to the table.
- Working with support techs and the Customer Success team to triage and deliver reported defects, ultimately driving customer satisfaction.
- Contributing to estimation processes and communicating effectively to the Support Manager and Customer Success leaders.
- Providing progress updates on all tasks related to Support issues owned.
- Join weekly meetings conducted by the Enterprise Manager and work collaboratively with all Support Techs.
- Join client meetings when required.
What you bring to this role
Qualifications/Knowledge / Skills
- Bachelors or higher degree in Computer Science or a related discipline.
- Minimum of 10 years of SQL Server Suite developer experience, version 2012+
- Creation of complex stored procedures involving CTEs, explicit transactions, shredding and creation of XML and exception handling
- Database backed N-tier applications.
- Kimball methodologies for Data Warehousing
- Working the data sets on the order of millions of rows
- Query performance tuning for large datasets
- Experience working with Developer tools such as Azure DevOps, Visual Studio Team Server
- Strong experience in developing data ingestion, data processing and analytical pipelines for big data, relational databases, NoSQL and data warehouse solutions.
- Experience with SSRS/SSAS/SSIS
Desirable experience
- Experience developing and deploying ETL solutions on Azure - Desirable
- Hands-on experience in Azure and Big Data technologies such as PowerShell, C#, Java, Node.js, Python, SQL, ADLS/Blob, Databricks - Desirable
- DBA experience
- Familiarity with the Technology stack available in the industry for data management, data ingestion, capture, processing, and curation
- Well versed in DevOps and CI/CD deployments
- Experience with private and public cloud architectures.
- Proven ability to work creatively and analytically in a problem-solving environment
- Desire to work in an information systems environment
- Excellent communication (written and oral) and interpersonal skills
- Excellent leadership skills
- Excellent organizational, multi-tasking, and time-management skills
Job Information
Location - Remote
Employment Type - Full Time
Career Stream Level - P3
The US base salary range for this position is: $78.5k - $98.0k. This position may be eligible for a 10% performance- based bonus. Our salary ranges are determined by role, level and location. Within that range, individual pay is determined by work location and a variety of factors, which may include but not limited, as applicable, the qualifications of the individual applicant for the position, years of relevant experience, specific and unique skills, level of education attained, certifications or other professional licenses held. All candidates are encouraged to apply.
Your recruiter can share more information about the specific salary range for your preferred working location during the hiring process.
In addition to your salary, TELUS Agriculture & Consumer Goods offers benefits such as, a comprehensive benefits package, incentive and recognition programs, and 401k contribution (all benefits are subject to eligibility requirements and may be dependent on country of residence).
Join us
Collectively, our talented team and integrated solutions uniquely position us to transform collaboration within the industry at a global level, empowering and connecting producers to consumers for a more efficient, sustainable future.
Everyone belongs at TELUS Agriculture & Consumer Goods. It doesn't matter who you are, what you do or how you do it, at TELUS Agriculture & Consumer Goods, your unique contribution and talents will be valued and respected. Because the more diverse perspectives we have the more likely we are to crack the code on what our customers want and our communities need.
Do you share our passion for enabling remarkable human outcomes?
Together, let's make the future friendly.
Accessibility
TELUS Agriculture & Consumer Goods is proud to foster an inclusive culture that embraces diversity. We are committed to fair employment practices and all qualified applicants will receive consideration for employment.
We offer accommodation for applicants with disabilities, as required, during the recruitment process.
#LI-remote