Developer – ETL Data Engineer x 2

Developer – ETL Data Engineer x 2

Typical Day in Role:
Reporting to the Senior Manager, the incumbent will be responsible for the following:
• Implementing data ingestion pipelines / DevOps (on prem and Azure cloud) to move data from source systems to our central data warehouse
• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
• Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
• Develop custom reports, analytics and KPI’s for the Business and Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients
• Developing SQL views to enable data consumers to read data from data warehouse
• Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
• Responsible for documenting databases, data process flows and maintain data dictionaries
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
• Coordinating code deployments / production implementations.
• Train and assist users at all levels

Candidate Requirements/Must-Have skills:
1. 5+ years of experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager etc.
2. 5+ years of experience with data warehouse, ETL, SSIS to move data / integrate systems
3. Experience in documentation, developing BI reports, completing ad hoc queries and data analysis
4. Expertise with data visualization / BI tools eg. Power BI, SSRS
5. Experience with automated test cases

Nice-To-Have Skills:
• Knowledge on Banking / Risk related systems
• Experience developing code to consuming REST API services
• Experience integrating systems with COTS Commercial Off The Shelf software packages
• Experience with implementing DevOps / MS Azure Cloud services, Google Cloud Platform
• Experience with web development (in ASP.NET / SharePoint / Power Apps / Power Platform)
• Experience with Azure Data / Synapse / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau

Soft Skills:
• Excellent written, presentation, and verbal communication skills to be able to work well with technical peers and business stakeholders at different levels within the organization.
• Strong decision making, forward thinking and creative problem-solving skills to anticipate and respond quickly to technological/market influences.
• Ability to work as part of a team, as well as work independently or with minimal direction.

Education/Experience:
• Post-secondary degree in a technical field such as computer science, computer engineering or related IT field required