ETL/SQL Backend Engineer-locals

Chicago 22 months ago Remote Full-time External
Negotiable
THIS IS RED HOT! Our Client Is Ready To Interview And Make An Offer. Please Focus On This And You Will Be Guaranteed An Interview • Local to Chicago or Beloit, WI (they will come into the officed 1-2 days per month • Experience with ETL/SQL backend engineering • DBT (Data Build tool) • DevOps • Azure Here Is The Full JD Position: SQL/ETL Backend Engineer Location: local candidates to Chicago or Beloit, will be mainly working remote however expected to go into the office 1-2 a month depending on meetings/projects Duration: 12+ months contract Start Date: ASAP Notes • This person is an ETL/SQL Backend Engineer, has good source control, production support with DevOps, data modeling exp is a must but this person will be a day-to-day coder living in SQL and understands ETL Job Description • Design, develop, implement, and maintain solutions in Azure using the following tech: Azure SQL, C#, Azure Functions, Azure Data Factory, and GraphQL. Expertise in Data Factory, Batch Services, Service Buses, Event Grid, Function Apps, APIM, GraphQL, App Insights, Key Vault, performance tuning/optimization. • Care about quality and clean code; deliver high quality code including logging, alerting, and monitoring – the DevOps mindset • Work in an agile fashion to develop, estimate, test, and maintain our backend systems, while collaborating with team members on product backlog grooming, sprint planning, execution, review, and retrospective • Be an active contributor to development best practices and code reviews to ensure coding standards are followed, implementation meets requirements, and proper tests are written • Communicate effectively with all associates and business contacts to promote a strong sense of teamwork • Foster an innovative culture with an eye towards a DevOps mindset, scalability, reliability & performance • Design high-performing queries and views; performance tuning of queries • Design efficient DB schemas • Data Driven Unit tests for Validating SQL Qualifications • Bachelor’s degree in Computer Science or comparable work experience • 5+ years of proven experience working as a hands-on Backend Software Engineer in an agile environment with multiple programming languages, frameworks, cloud architecture: • Languages: T-SQL (CRUD operations) • APIs: C# REST APIs (bonus: Azure Function Apps, GraphQL) • ETL: SSIS or Azure Data Factory • Architectural Patterns: Data Warehousing, Microservices Architecture, Event-based Architecture • Source control: Git code management • DBT Cloud • Deploying production services in a cloud environment; ideally Azure including: • Azure Functions, Azure Data Factory, Azure Batch Service, Azure API Management • App Insights (Logging / Alerts) • Demonstrated experience in identifying, debugging, and resolving complex production issues • Excellent written and verbal communication skills and strong cognitive ability especially with respect to understanding, documenting, and describing complex technical subjects • Strong interpersonal skills and broad business and technical knowledge Bonus Skills • NoSQL experience • Cloud experience with Azure (Web Apps, Terraform, Azure DevOps, DBT