ETL Developer On-Site Contract

Company Overview:

Arctiq is a global intelligence-driven technology services company delivering professional and managed services across Hybrid Cloud Infrastructure Networking & Connected Experiences Cybersecurity Data & AI Autonomous Operations & Intelligence and Enterprise Service Management. We help organizations operate secure and modernize complex environments by unifying infrastructure networking data security automation and observability under a single integrated operating model. Our work focuses on helping customers reduce operational friction improve resilience and make better faster decisions as their environments evolve. Arctiq builds on decades of industry expertise and a customer-centric ethos to deliver exceptional value to clients across diverse industries.

This is an on-site contract opportunity for one of Arctiqs clients.

Position Overview:

The ETL Developer will support the organizations transition from SQL Serverbased data infrastructure to Snowflake. While the role is formally housed within the Data Governance team to ensure adherence to enterprise data standards security and quality practices the position will be 100% dedicated to supporting the Research Evaluation and Analytics (REA) department. This role will design build and optimize ELT pipelines and enable high-quality well-governed analytic datasets to support research evaluation reporting and decision-making across the organization.

This position plays a critical role in modernizing the organizations data infrastructure while ensuring data quality trust and usability for research and analytics. The work directly supports evidence-based decision-making by enabling timely access to reliable well-structured data.

Responsibilities

Data Migration & ELT Development

• Design develop and maintain ELT pipelines to migrate data from SQL Server to Snowflake
• Refactor and modernize existing SQL Serverbased processes for Snowflake architecture and performance
• Implement efficient data loading transformation and validation processes using Snowflake-native capabilities
• Optimize queries storage and compute usage for cost and performance

Data Governance & Quality

• Partner with the Data Governance team to ensure ELT processes align with data standards definitions and quality rules
• Implement data validation auditing and reconciliation checks during migration
• Support metadata documentation data lineage and transparency for analytical datasets
• Ensure compliance with privacy security and regulatory requirements

Research Evaluation and Analytics Support

• Work closely with REA analysts researchers and evaluators to understand data needs and analytic workflows
• Translate research and reporting requirements into scalable ELT solutions
• Support development of clean analysis-ready datasets optimized for statistical analysis and reporting tools
• Troubleshoot data issues impacting analytics dashboards and research outputs

Collaboration & Knowledge Transfer

• Collaborate with data engineers analysts and governance partners across teams
• Document ELT processes migration decisions and best practices
• Support knowledge transfer to internal staff to ensure sustainability beyond the contract period

Qualifications

• Proven experience building ELT/ETL pipelines in a production environment
• Strong SQL expertise including advanced querying and performance optimization
• Hands-on experience with Snowflake (data modeling loading transformations and performance tuning)
• Experience migrating data from SQL Server or similar relational databases to cloud data platforms
• Familiarity with data quality governance and documentation practices
• Ability to translate business or research requirements into technical data solutions
• Strong collaboration and communication skills especially with non-technical stakeholders
• Experience supporting research evaluation or analytics teams
• Familiarity with data modeling approaches for analytics (e.g. dimensional models flat analytic tables)
• Experience with ELT orchestration and transformation tools (e.g. dbt Azure Data Factory Airflow or similar)
• Experience working in regulated or privacy-sensitive data environments
• Prior work in matrixed roles supporting both governance and analytics functions

Arctiq is an equal opportunity employer. If you need any accommodations or adjustments throughout the interview process and beyond please let us know. We celebrate our inclusive work environment and welcome members of all backgrounds and perspectives to apply.

We thank you foryour interest in joining the Arctiq team! While we welcome all applicants only those who are selected for an interview will be contacted.

Required Experience:

Senior IC