Lead Data Engineer

For this opening we will consider candidates from the following locations:
Toronto,ON,Canada |

Notified is hiring a Lead Data Engineer in Toronto.
This position will offer a hybrid work schedule; Tuesday, Wednesday & Thursday in the office in Downtown located at 155 University Avenue with the option of working remotely on Monday & Friday.
Job Summary:
We are seeking a highly skilled and experienced Lead Data Engineer with 10+ years of expertise in Informatica application integration, data integration, ETL jobs, and SQL.
The ideal candidate will be an exceptional problem solver, possess outstanding leadership and communication skills, and have a solid understanding of batch & real-time data synchronization.
Experience with CRM, ITSM data, and knowledge of Tableau/PowerBI is a definite plus.
Essential Duties:

Lead, design, and implement complex ETL solutions using Informatica, Snowflake (or any other database), and SQL that meet business requirements and objectives.
Oversee the entire data integration process, ensuring the accurate and secure integration of data from various sources, such as CRM (Salesforce), ITSM (ConnectWise/ServiceNow), and other system applications.
Troubleshoot and resolve integration and performance issues within the Informatica and database (Snowflake) platform while maintaining the highest level of data quality and integrity.
Collaborate with cross-functional teams to gather requirements, develop data models, and design data infrastructure to support business intelligence and reporting needs.
Ensure real-time data synchronization to optimize system performance and enhance data-driven decision-making processes.
Ability to work with various data warehouses is key (Snowflake, MSSQL, MySQL, BigQuery)
Adopt a proactive approach in maintaining and optimizing existing ETL processes, identifying areas for improvement, and aligning them with the organization's strategic goals.
Mentor and guide junior engineers, fostering a culture of continuous learning and development.
Stay up to date with industry trends and best practices to ensure technical expertise and drive innovation within the team.
Act as a key point of contact for platform licensing models, ensuring proper usage, compliance, and optimization as well as liaising with stakeholders to provide technical guidance.
Write design and project requirements which may include both preliminary and firm estimates of system requirements, benefits, personnel, costs, timelines, etc., for review by management.
Design and participate in a comprehensive and logical test plan for systems using appropriate tools to ensure established standards are utilized.
Serve as a subject matter expert for program support after implementation, which may include additional training, upgrades, or program enhancements.
Minimum Qualifications:

10 years of experience in Informatica application integration (IICS), data integration, ETL jobs, Snowflake, and SQL, preferably in large and complex data environments.
Strong knowledge of Informatica PowerCenter, IDQ, and IICS.
5-7 years' experience in SQL query writing, building data warehousing models, data marts, stored procedures & views for front-end reporting.
Proven experience in resolving data integration issues, ETL performance tuning, troubleshooting, and optimization.
Extensive domain knowledge in CRM and Services area (Salesforce, ConnectWise or similar)
Experience with at one least BI/visualization tool (Tableau, PowerBI)
Strong leadership, communication, and problem-solving skills.
Ability to work independently and as part of a team, managing multiple projects simultaneously.
Understanding of Code Repository practices and CI/CD principles (Git, Jenkins)
Experience with Python
Knowledge on data quality and validation techniques
Understanding on Restful APIs, Webhook, and other near real-time integration patterns
Bachelor's degree in Computer Science, Engineering, or related field
Preferred Skills:

Knowledge of Big Data Technologies (Spark, Flink)
Knowledge of Orchestration Tools (Airflow or similar)
Knowledge of Distributed Event Platform (Kafka, Kinesis, equality)
Experience working within at least one public cloud (AWS, Azure, GCP)
Master's degrees or Data Engineering related certifications
ABOUT NOTIFIED
Notified is committed to creating a more connected world by providing you with the tools you need to amplify your story.
Together, our platform and our people elevate public relations, investor relations, and marketing for over 10,000 global customers.
We believe everyone has a story to tell and we're passionate about helping people and brands amplify their stories across the globe.
We are proud to be the number one provider of enterprise webcasting and investor relations content distribution, as well as a global leader in press release distribution.
Our clients have used Notified to monitor over 2 billion social media conversations and every year we run more than 100,000 events!
Our products are built so storytellers can do their best work.
But we're not just a platform-personalized, caring service is how we operate.
We add a personal touch to everything we do.
We strive to deliver wisdom and insight by helping our clients reach global and targeted audiences, measure outcomes, and fulfill their commitments.
CULTURE AND BENEFITS
At Notified, we aim to help our employees and their families maintain a healthy work/life balance and build a financially secure future.
Self-development and learning are key with all our global employees having access to our internal learning and development university DevelopU for career and skills enhancement.
EXAMPLE OFFERINGS:

International work environment - we have offices in 17 countries
Opportunities for innovation and creativity
Hybrid work schedule (office/home)
Comprehensive health insurance with localized options
Extensive learning opportunities via our in-house virtual university with >8,000 online courses, videos, business books and certification preps
Location-specific social outings and company events with amazing colleagues, such as laser tag, board game night, and company-wide trivia night
At Notified we don't just accept difference - we celebrate it, support it, and build success upon it.
We are proud to be an equal opportunities employer and no part of this advertisement is intended to discriminate on any grounds.
• LI-SB1
•