Custom Software Engineer - ETL Developer with Azure and Snowflake Expertise

Custom Software Engineer

Project Role : Custom Software Engineer
Project Role Description : Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.
Must have skills : Microsoft Azure Data Services
Good to have skills : Snowflake Data Warehouse
Minimum 5 year(s) of experience is required
Educational Qualification : 15 years full time education

JOB SUMMARY:
Vertex is seeking an ETL Developer to design, build, and support scalable ETL/ELT data pipelines using Azure Data Factory and Snowflake with strong emphasis on Data Vault modeling.
The role supports the Customer 360 program by delivering trusted, auditable, and scalable data foundations. The developer partners with Data Architects, Analytics Engineers, and Platform Leads to ensure alignment and delivery excellence.


ESSENTIAL JOB FUNCTIONS AND RESPONSIBILITIES:
ETL / ELT Development
Design, build, and maintain ETL/ELT pipelines using Azure Data Factory.
Ingest data from APIs, files, and databases into Snowflake.
Implement ELT transformations using Snowflake SQL aligned to Data Vault standards.
Optimize pipelines for performance, scalability, and reliability.
Data Vault Modeling
Implement Data Vault 2.0 models including Hubs, Links, and Satellites.
Support historization, auditability, and schema evolution.
Collaborate with architects to map source systems to Data Vault.
Support downstream Business Vault and marts.
Snowflake Development
Develop and manage Snowflake tables, views, schemas, tasks, streams, and stored procedures.
Tune SQL transformations for performance.
Implement data access controls and security best practices.
Data Quality, Monitoring & Operations
Implement data quality checks, reconciliation, and exception handling.
Monitor ADF pipelines and troubleshoot issues.
Support incident resolution and root cause analysis.
Delivery & Collaboration
Own assigned ETL and Data Vault components end-to-end.
Participate in Agile ceremonies and technical reviews.
Collaborate with architects, analytics, AI, and C360 teams.
Maintain technical documentation and reusable assets.


SUPERVISORY RESPONSIBILITIES:
N/A



KNOWLEDGE, SKILLS, AND ABILITIES:
Technical Expertise
2–5 years ETL/data engineering experience.
Hands-on Azure Data Factory experience.
Strong Snowflake SQL, ELT patterns, and performance tuning.
Data Vault methodology including Hubs, Links, Satellites, Raw Vault, Business Vault.
Familiarity with Git and CI/CD.
Experience in Agile environments.
Preferred / Nice-to-Have Skills
Azure Blob Storage / Data Lake experience.
Experience with dbt or similar frameworks.
Exposure to Snowflake Streams & Tasks.
Experience with incremental ingestion patterns.
Support for Customer 360, analytics, or AI workloads.
Azure or Snowflake certifications.
Soft Skills
Strong analytical and problem-solving skills.
Ability to independently deliver assigned components.
Clear communication across distributed teams.
Attention to detail and focus on data lineage and auditability.


EDUCATION AND TRAINING:
Bachelor s degree in Computer Science, Engineering, Information Systems, or related field (required).


Other Qualifications
The Winning Way behaviors that all Vertex employees need in order to meet the expectations of each other, our customers, and our partners.
Communicate with Clarity - Be clear, concise and actionable. Be relentlessly constructive. Seek and provide meaningful feedback.
Act with Urgency - Adopt an agile mentality - frequent iterations, improved speed, resilience. 80/20 rule – better is the enemy of done. Don t spend hours when minutes are enough.
Work with Purpose - Exhibit a We Can mindset. Results outweigh effort. Everyone understands how their role contributes. Set aside personal objectives for team results.
Drive to Decision - Cut the swirl with defined deadlines and decision points. Be clear on individual accountability and decision authority. Guided by a commitment to and accountability for customer outcomes.
Own the Outcome - Defined milestones, commitments and intended results. Assess your work in context, if you re unsure, ask. Demonstrate unwavering support for decisions.


COMMENTS:
The above statements are intended to describe the general nature and level of work being performed by individuals in this position. Other functions may be assigned, and management retains the right to add or change the duties at any time.