Analytics Engineer - Financial Services
New
L
Lightspeed CommerceFinancial Services
Located in Canada, EST/EDT hoursFull-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Languages
- English
- Required Skills
- PythonSQLGCPBigQuerydbtLooker
Requirements
- Experience with SQL
- Experience with Python coding (or equivalent language)
- Experience with MPP data warehouse (BigQuery)
- Experience with dbt or dataform
- Experience in performing data profiling, data mapping and data quality validation
- Experience with data orchestrator
- Understanding of industry standards for data warehousing and data modelling
- Knowledge of data environments (GCP)
- Knowledge of containerization solutions
- Experience in source control, CI/CD and automated testing
- A security mindset with the ability to work with compliance protocols (SOX, GDPR)
- Excellent communication skills and ability to communicate with technical and non-technical stakeholders
- Excellent problem-solving skills
- Ability to work independently and in teams
- Self-motivated and great at taking initiative
Responsibilities
- Cleanse and transform raw data into business logic to help stakeholders build reports and data models
- Analyze raw data and suggest data sources that best meet expressed business needs
- Ensure the right data gets to the right people at the right time
- Collaborate with the Central Data Team to build data pipelines in accordance with shared best practices and design, and feed data models for usage
- Act as a champion for data quality and usability across the Financial Services organization
- Ensure availability, quality and searchability of data and documentation
- Write, clean and maintainable queries and scripts that are highly performing, well-structured and easy to understand and extend using version control and CI/CD
- Automate testing of data models and add appropriate validations to ensure quality
- Help define and improve our internal standards for data models and infrastructure
- Ability to explain intermediate to complex information to other team members
- Ability to maintain or develop simple report or dashboard in Looker
View Full Description & ApplyYou'll be redirected to the employer's site
