Data Engineer

The Role

This position is responsible for the analysis, design, execution, assessment, security, and troubleshooting of data, data pipelines, and reporting. This role is responsible for understanding the business unit functions and contributing to the evolutionary plans for the reporting environment. This includes defining, configuring, coding, developing, and documenting reporting, data, and data pipeline specifications throughout the project life cycle. In addition, the Data Engineer will provide day-to-day operations and production support, including off-hours problem resolution of supported applications.

Strategy and Planning

• Contributes to evaluation of design options and approach.
• Familiar with architectural patterns that contribute to the production of secure, reliable, manageable, and high-performance solutions.
• Contribute to architectural modelling to assist in determining solution efficacy.
• Performs estimating, prioritizing, planning of tasks to reliably and consistently deliver according to plan.
• Estimates feasibility of requests and negotiates on deliverables

Acquisition and Deployment

• Conduct research as directed on emerging application development software products, languages, automation tools, and standards in support of procurement and development efforts.
• Performs detailed technical design of proposed solutions for individual software components.
• Contributes to the determination of relevant risks and determines mitigation strategies.

Operational Management

• Develop and review software programs, code, and unit tests for new and existing applications and systems, ensuring functional and non-functional requirements are met.
• Develop, and maintain supporting documentation as required.
• Gather statistics and prepare and write reports on the status of the programming process for discussion with management and/or team members.
• Recommend, schedule, and perform software improvements and upgrades for optimal performance of software applications.
• Perform troubleshooting and root cause analysis in support of incident and problem management and recommend options to address identified issues.
• Participates in development, implementation, and maintenance of plans to ensure continuation of critical operations in the event of a disaster or interruption.
• Provides ongoing system maintenance and monitoring to ensure adherence to SLAs.

What You Bring To The Team

• 1-6 years relevant experience
• Experience with application analysis, design and development using a broad range of tools and techniques
• Experience with Business Intelligence and Data Warehousing environments
• Experience with data modeling and database schema design
• Strong analytical and troubleshooting skills
• Understanding of structured programming and object-oriented design and service-oriented architecture
• Experience in the mortgage or financial industry is preferred
• Minimum knowledge of cloud native development practices and design patterns using private or public cloud providers required
• Basic understanding of cloud patterns and infrastructure management using private or public cloud providers required
• Understands software development lifecycle and the practices and procedures of software development including Agile Development Methodology
• Ability to design, develop and maintain data pipelines for a variety of data sources
• Create and optimize complex SQL queries for data analysis and reporting.
• Participate in related technology installations, upgrades, migrations, and configuration.
• Ability to make recommendations to IT and business processes
• Knowledge of business procedures and applicable systems
• Excellent communication skills – both verbal and written
• Strong attention to detail and excellent organizational skills
• Strong analytical, designing, problem-solving, and decision-making skills with the ability to interpret client needs
• Demonstrated ability to work cooperatively in a team environment and ability to maintain a professional attitude
• Ability to develop strong working relationships with internal and external business partners and clients.
• Experience writing high-quality documentation, reports, and proposals, as well as documentation of system deliverables documentation
• Knowledge of business procedures and applicable systems
• Ability to mentor and coach others
• Self-starter, results-oriented with proven success in prioritizing and managing multiple tasks projects of varying complexity in the context of business operations
• Computer Science degree or related field, or equivalent experience
• Database technologies: Microsoft SQL Server, NoSQL (MongoDB), DB2
• Data ETL/ELT Tools: Microsoft SSIS, SSRS
• Reporting/Visualization tools: Crystal Reports, Power BI
• Azure Devops (automated CI/CD), build and release pipelines
• Languages: T-SQL, C#, Python, (COBOL is an asset)
• Experience with Data Catalog and Data Fabric technologies is an asset