Senior Data Engineer responsible for designing and validating data solutions, consolidating disparate data sources, documenting functional specifications, reviewing data models, supporting production deployments, investigating data quality issues, and collaborating with stakeholders and technology leads to ensure data completeness and lineage.
Responsibilities
- Big Data - Spark, Hive, Java, CDP, 6 Years + with 3 Years of Dev experience on Big Data
- Analyze data requirements and identify disparate data sources required for consolidation and distribution.
- Document functional specifications and coordinate delivery of the same with technology team.
- Review logical and conceptual data models in alignment with business requirements.
- Work with the stakeholders to understand and gather requirements and produce business specifications
- Validate solution implementations and ensure they meet business and functional requirements.
- Provide production deployment support and investigate data quality issues.
- Work with various technology leads to ensure the gaps in the data completeness or accuracy are bridged.
Qualifications
- Subject matter expertise in financial industry - wholesale loans /lending business OR Capital Markets or Finance or Risk Reporting
- Strong hands on experience with database and SQL is required.
- Excellent documentation, analytical skills to produce process flow diagrams, business modelling, and functional design.
- Proficiency in MS Office (Word, Excel, Visio, PowerPoint) with extensive experience using Excel for data analysis.
- Experience with Data tracing/ Lineage efforts
- Knowledge of logical and physical data model
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
