Lead - Data Engineering

Job Description:

Job Title LEAD DATA ENGINEERING

The Purpose of This Role

We are looking for an experienced Data Engineer with a passion for crafting and delivering Data solutions, collaborating in a team environment, with a deep interest in building products that make it easier for our customers to service their client!

How your Work Impacts the Organization

The Team

This is an exciting role within the Workplace Investing (WI) Solutions Office team. Our team delivers innovative digital solutions to engage and service our customers, while growing the business with reduced risk. Our dynamic and timely solutions provide full-scale experiences that simplify business for associates, clients, and advisors.

• Deliver high quality, innovative and maintainable software solutions in an agile environment.
• Participate in Architecture and Application design.
• Actively contribute to test automation and practices.
• Demonstrate strong leadership, communication, and presentation skills.
• Experience working with distributed teams.
• Understanding of fundamental data design principles.
• Ability to quickly learn, adapt and thrive to meet the needs of a fast paced, changing environment.
• Strong troubleshooting and problem-solving skills.

• Leveraging existing systems and architecture to drive scale and efficiency
• Building applications to control and mitigate business risk and exposure
• Performing application maintenance and ensure information security controls
• Provide timely status updates, issue resolutions, and step-by-step instructions on usability questions
• Collaborate with Product, Execution, and other support teams to resolve or escalate user inquiries
• Based on support queue trends, make recommendations for innovation and automation to reduce volume.

• Strong programming skills in SQL/PL-SQL
• Demonstrated expertise in Data Virtualization tools: Denodo (preferred) or Tibco Data Virtualization (TDV)
• Solid understanding of relational databases (PostgreSQL, MS SQL Server, Oracle)
• Experience in ETL/ELT tools: Informatica or SnapLogic or equivalent
• Experience with Enterprise Data Lake e.g. Snowflake
• Experience with GitHub
• Experience in ML and Python will be a nice addition
• Good experience in Agile/Scrum methodologies
• Experience of Cloud technologies and automated deployments
• Demonstrate strategic thinking and ability to analyze business direction and problems, understand long term vision and risk in developing strategic technical solutions.
• Demonstrate expertise in performance optimization techniques and tools, ensuring efficient and effective system operations
• Experience designing complex data solutions to solve key technical challenges.
• An innovative mindset committed to automating and streamlining manual processes.
• Ability to communicate software engineering and/or development concepts and principles.
• Ability to take up new challenges and explore new technology/tools
• Can collaborate well with the Business, your team members, work independently, and influence your technology peers.
• Proficient in ability to identify and pull data from various applications and systems (e.g., Salesforce, Oracle, SQL Server)
• Experience in performing complex data analysis and data aggregation
• Troubleshooting and Debugging skills
• Strong analytical and logical skills
• Ability to analyze trends and recommend improvements

• High level of commitment, initiative, vision and enthusiasm
• Creative, energetic, assertive hands-on professional who enjoys the challenge of change

• 8+ Years of IT experience
• Graduate
• Certifications if any