LP
Datastage ETL
LinkedIn Recruiter Post
Aarorn Technologies seeks a Datastage ETL contractor with 5+ years of experience for a hybrid role in Toronto. Must have IBM InfoSphere DataStage, SQL, Unix scripting, and scheduling skills.
About the role
- Data Engineer designing and implementing cloud-native data ecosystem for sports analytics. Building scalable infrastructure to transform raw data into valuable consent assets.
Responsibilities
- Design and build robust, scalable data transformation pipelines using SQL, DBT, and Jinja templating
- Develop and maintain data architecture and standards for Data Integration and Data Warehousing projects using DBT and Amazon Redshift
- Monitor and ensure the smooth operation of data pipelines between OneTrust (OT) application and external data platforms (ESPs, CRMs, etc.).
- Collaborate with cross-functional teams to gather requirements and deliver dimensional data models that serve as a single source of truth
- Assist in the ongoing data integration tasks (e.g., connectors, APIs) between OT and various business systems.
- Own the full stack of data modeling in DBT to empower analysts, data scientists, and BI engineers
- Enhance and maintain the analytics codebase, including DBT models, SQL scripts, and ERD documentation.
- Familiarize regulatory compliance guidelines across different geographical areas (CCPA, GDPR) and integrate them into current and new pipelines for consent collection.
- Ensure data quality, governance alignment, and operational readiness of data pipelines
- Apply software engineering best practices such as version control, CI/CD, and code reviews
- Optimize SQL queries for performance, scalability, and maintainability across large datasets
- Implement best practices for SQL performance tuning, including partitioning, clustering, and materialized views
- Build and manage infrastructure as code using AWS CDK for scalable and repeatable deployments. Integrate and automate deployment workflows using AWS CodeCommit, CodePipeline, and related DevOps tools
- Support Agile development processes and collaborate with offshore teams
Requirements
- Bachelor’s or Master’s (preferred) degree in a quantitative or technical field such as Statistics, Mathematics, Computer Science, Information Technology, Computer Engineering or equivalent
- 5+ years of experience in data engineering and analytics on modern data platforms
- 3+ years’ extensive experience with DBT or similar data transformation tools, including building complex & maintainable DBT models and developing DBT packages/macros
- Deep familiarity with dimensional modeling/data warehousing concepts and expertise in designing, implementing, operating, and extending enterprise dimensional models
- Understand change data capture concepts
- Experience working with AWS Services (Lambda, Step Functions, MWAA, Glue, Redshift)
- Hands-on experience with AWS CDK, CodeCommit, and CodePipeline for infrastructure automation and CI/CD
- Python proficiency or general knowledge of Jinja templating in Python and/or PySpark
- Agile experience and willingness to work with extended offshore teams and assist with design and code reviews with customer
- Familiarity with OneTrust or similar consent management platforms is a plus.
- A great teammate and self-starter, strong detail orientation is critical in this role.
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
LP
Azure Databricks Developer-HR Platforms
LinkedIn Recruiter Post
Azure Databricks Developer needed for HR tech projects at a top financial client. Design ETL solutions, support data integrations, and modernize HR data platforms.
Senior Software Engineer, Data responsible for building data pipelines and maintaining infrastructure for analytics and ML. Collaborate with teams to optimize data systems at Narvar.
Data Architect leading conversations and decisions on data modeling at a global consulting firm specializing in Data & Analytics. Transforming complex processes into clear, reusable information models.
Senior Data Engineer at Supabase managing data pipelines from source to analysis. Collaborating with growth, finance, and product teams to drive business insights.
LP
Data Architect – Snowflake
LinkedIn Recruiter Post
Data Architect - Snowflake needed for full - time hybrid role in Markham, ON. Expertise in Snowflake on AWS, data migration, and ETL required.
LP
Datastage ETL
LinkedIn Recruiter Post
Hiring Datastage ETL contractor for hybrid role in Toronto. Requires 5+ years experience with IBM DataStage, SQL, Unix scripting.
LP
Data Architect (Snowflake & DBT)
LinkedIn Recruiter Post
Data Architect needed to architect and implement Snowflake on AWS solutions, with 8+ years experience in data architecture and engineering.
Associate Data Architect collaborating with stakeholders to design scalable data architecture for AXIS Capital. Maximizing profit through data - driven decision making and implementing effective data governance strategies.
Data Engineer II at Finning supporting production data platforms and integrations using Snowflake, Databricks, Azure services. Collaborating with teams to ensure operational stability and reliability.