Overview
On behalf of our client, Affinity is seeking a Data Engineer who will be responsible for designing, building, and maintaining secure, stable, and scalable data pipelines and infrastructure that support data driven products and analytics initiatives. In this role, you will collaborate closely with cross functional teams, including data analysts, data scientists, software engineers, and product managers, to ensure the seamless flow, quality, and accessibility of data across the organization.
The ideal candidate is passionate about working with large scale datasets and will play a critical role in transforming raw data into actionable insights that drive informed business decisions.
Responsibilities
- Design, build, and optimize scalable end-to-end data pipelines for processing large volumes of structured and unstructured data
- Develop robust ETL / ELT processes and API integrations to seamlessly integrate data from diverse sources
- Implement data validation, quality frameworks, and monitoring systems to ensure accuracy and reliability
- Define and maintain company data assets, data models, and associated Spark / SparkSQL jobs
- Design efficient data models, schemas, and database structures to support analytical and operational use cases
- Evaluate and implement data storage solutions including databases, data lakes, and cloud-based services
- Configure and manage data infrastructure components while optimizing for performance and scalability
- Develop long-term data platform architecture strategy and evaluate tools for data lineage and metadata management
- Build reliable integrations with internal / external data sources and develop RESTful APIs for data access
- Implement data security protocols, access controls, and governance policies
- Ensure system compatibility and interoperability across platforms
- Partner with cross-functional teams (data scientists, analysts, engineers, product managers) to deliver tailored solutions
- Improve data models that feed BI tools to increase data accessibility across the organization
- Create technical documentation and provide troubleshooting support for data-related issues and maintain robust ETL / ELT pipelines to ingest, transform, and load data from various sources (e.g., DMV records, insurance databases, auction feeds).
Qualifications
5+ years of experience in data engineering, software development, or related rolesProficiency in programming languages commonly used in data engineering (e.g., Python, Java, Scala)Strong knowledge of database systems, data modeling techniques, normalization, and performance optimization with advanced SQL proficiencyHands-on experience with ETL tools commonly used in data engineering (e.g., SSIS, Databricks, Azure Data Factory)Experience with big data technologies and frameworks (e.g., Hadoop, Spark, Kafka)Experience with cloud platforms and services (e.g., AWS, Azure, Google Cloud Platform)Experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery)Excellent problem-solving skills and attention to detailStrong communication and collaboration skills in a team-oriented environmentExperience with machine learning operations (MLOps) and supporting ML model deployment pipelines is considered an assetKnowledge of data governance frameworks and compliance requirements (GDPR, CCPA, etc.) is considered an assetExperience with containerization technologies (Docker, Kubernetes) is considered an assetExperience with real-time streaming data processing is considered an assetKnowledge of data visualization tools and analytics platforms is considered an assetBachelor's or master’s degree in computer science, Engineering, or related fieldAffinity Earn
Affinity Earn : Know someone who’s great for this, or any of our open roles? Earn up to $4,000 / year for each successful referral through Affinity Earn. You can also earn up to $50,000 for helping us find new clients. Learn about our referral program at https : / / affinity-group.ca / earn / or browse our jobs & follow us at https : / / www.linkedin.com / company / affinity-staffing / jobs /
About Affinity
Affinity Group is a technology and business consulting and services company. We believe in creating long term relationships between clients and consultants that foster a mutually beneficial partnership. Affinity is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. All employment is decided on the basis of qualifications, merit and business need.
For more information on Affinity, please visit www.affinity-group.ca
#J-18808-Ljbffr