Steneral Consulting Looking for Backend Engineer-locals at Chicago, IL Full Time

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: perm or c2h (they will do whatever the candidate prefers

Start Date: early/mid-January

Interview Process/Times: first round is a virtual hour interview with hiring manager (he will go over the role, org, team, SQL questions, will include skills challenge with screen share), second interview with be a virtual 3-hour interview with break in between (meeting with devs on the team, Agility delivery lead and digital manager, and Director)

Salary: base 115-130k salary for mid-level and 140-160k for senior/lead level

Pre-Screening Questions

These must be asked while on the call with a candidate and included in the submittal

• Please describe a feature that you were the go-to person for.
• How have you been responsible for design/application architecture?
• Describe your experience for production support and your responsibilities.
• What is your experience doing pull request reviews?
• Please describe your experience working with Azure.
• What is your experience working in a DevOps environment?

Manager Notes

• This person is an ETL/SQL Backend Engineer, someone who takes more of a software dev approach, has good source control, production support with DevOps, less hacky more software dev type, data modeling exp is a must but this person will be a day to day coder living in SQL and understands ETL
• DBT experience would be ideal but not a must if the person is strong in everything else; DBT is a framework where you can develop in SQL and has integrations with Github, will also have a unit test suite
• Team make up: 10 devs, QA scales up and down based on the business needs, dedicated architect and product owner, someone helping to lead us in agile practices

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)