Krasan Consulting Services is a Chicago boutique management consulting and technology solutions integrator. As a certified BEP WBE with the State of Illinois and a certified WBE, MBE, and DBE recognized by the City of Chicago, Krasan provides complex technology solutions and services for clients in the Public and Commercial sectors. With decades of experience, Krasan specializes in end-to-end technology solutions, integration, and implementation services and is proud to enable the success of our customers.
Role Title: Senior Database Developer
Location: Hybrid - Springfield, IL
Type of contract: W2
Required Skills:
At least eight (8) years of experience as a Senior Database Developer
Extensive experience with Azure DevOps and Team Foundation Server and their use-in/relation-to the Software Development Lifecycle (SDLC).
Proficiency in developing complex queries to complete data requests that are accurate, high performance, and scalable.
Strong communication skills.
Ability to perform analysis to assess the quality and meaning of data at both technical and business levels.
Experience using automated tools (i.e. SSMS, SSIS, ADF, Azure Synapse, Alteryx, Informatica, etc.) to extract data from any data source (i.e. API, JSON, XML, CSV, On Premise SQL, Cloud SQL, Oracle, DB2, SAP, NoSQL, etc.) that exists in the corporate world today.
Capability to quickly triage, identify, validate, and correct corrupted data and fix coding errors and related problems in a three phased approach (immediately fix P1 event to recover operations, mid-term fix to resolve automation ETL, and long-term fix to build in autonomous self-healing and elegant scalable design).
Experience with Microsoft Visual Studio 2015 (or greater), C#, ASP.NET, MVC, Microsoft SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Crystal Reports, Microsoft Power BI, Business Intelligence, ArcGIS, and Microsoft SharePoint.
Familiarity with additional software such as SAS, Stata, and R.
Additional Skills (Preferred):
Experience with early childhood education data or similar large-scale, complex data environments.
Familiarity with additional data visualization tools beyond Power BI.
Prior experience working in a governmental or educational setting.
Advanced data analytics skills and experience with data marts.
Knowledge of additional programming languages or data tools that could enhance data handling and presentation capabilities.
Knowledge of Machine Learning and Artificial Intelligence (i.e. SSAS Data Mining Algorithms, Azure OpenAI, Python/R/Matlab, etc.).