Senior Database Developer

We have an opening for a

Senior Database Developer

with our direct client, the

Illinois State Board of Education -( State of Illinois).Job Title:

Senior Database DeveloperProject:

Early Childhood ProgramsJob Type:

Contract- W2Location:

100 N. 1st Street, Springfield, IL OnsiteDuration:

2 yearsJob Description:We are seeking Senior Database Developers for at least a two-year term. The developers will work primarily within the Azure DevOps environment, handling data from various systems, including the Student Information System (IBM database structure) and the SQL-based data warehouse. The role involves merging multiple data sets, creating data and technology tools, and presenting data in a user-friendly format. The EC Database Developer Senior will also develop databases, dashboards, and reports that provide essential insights about technical data and interpretation of state and federal business rules related to Early Childhood program areas, including developing reports and presentations.Responsibilities:Data Development and MaintenanceDesign, implement, and manage complex databases following the proven academic fundamental designs of Boyce-Codd/Inmon methodologies for Staging to Data warehouses and Kimball methodologies for Datamarts.Experience with Transparent Data Encryption (TDE), Data Encoding, Data Obfuscation, Cryptographic Functions, Encryption Algorithms, and Dynamic Data Masking.Knowledge of impact on SQL (Transaction-Level) Coding from Data Synchronization within Always Availability environments, Isolation Levels,Be able to tune and optimize sophisticated SQL Stored Procedures, including transactions, nested calls, and input/output parameters.Understand and be able to create Entity Relationship Data Models, Logical Data Models, and Physical Data Models.Understand and be able to implement normalization, denormalization, star and snowflake schemas, row-level-security, column-level-security, composite/business keys, surrogate keys, and attribute checksum/hash fundamentals.Develop and maintain outputs into dashboards, reports, cubes, and external roundtrip applications/application programming interfaces (APIs) for the Early Childhood Technical Data Program.Create and modify Crystal Reports to support existing collections and facilitate new data collection expansions.Utilize Power BI to transform tabular data into meaningful information and visualizations.Work with data marts, taking snapshots and maintaining a live operational data store (ODS).Assist in presenting data through ArcGIS for geo-related data visualization tasks.Data Integration and TransformationExperience with integration methods using BCP, BULK INSERT, OPENROWSET, ODBC, OLE DB, Linked Servers, SQL Server Integration Services, Azure Data Factory, Azure Synapse, and SQL REST API's.Be able to create an Operational Data Store (ODS) for data processing, to maintain state, statistics (i.e. runtime, file I/O, CPU usage, etc.), autonomous self-healing, and dynamic projections/forecasting of entire database management system environment from every stored procedure call.In-depth knowledge of how to create enterprise-level (TRY-CATCH Blocks, @@ERROR System Function, RAISERROR Function, THROW Statement, System Functions, etc.) SQL code for use in Stored Procedures.In-depth knowledge of how to tune and troubleshoot SQL code (i.e., Indexes and timing of indexes/statistics, blocking, locks, impacts on SQL engine, impacts on Operating System, etc.).Proven experience integrating SQL Server Databases with SQL Server Analysis Services (SSAS).Ability to build ETL (extract transform load) procedures that guarantee the absolute accuracy of data (i.e., down to the penny and the second), have built-in incremental (i.e., near real-time) data processing, and can scale through partitioning and sharding.Work across IBM (DB2) and SQL environments to merge multiple data sets in complex ways.Ensure data integration and ETL processes between systems, including nightly, weekly, and monthly updates automatically generated through Operational Data Store processing.Be able to quickly build proof-of-concept (POC) SQL statements for quick triage, which will ultimately be refined into enterprise solutions at the stored procedure levels, catering to the unique requirements of early childhood data.Analyze, interpret, and cleanse data using methods of Composite Keys, Surrogate Keys, Attribute Checksums/Hashing, and SQL Windows Functions at the point of entry into the Staging DMZ to ensure the validity of datasets and make data corrections before they enter the enterprise Datawarehouse system.Reporting and VisualizationExperience building Reporting and Business Intelligence Presentation Layers using SQL Business Intelligence Development Suite (BIDS), SQL Data Tools in Visual Studio, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Tabular Cubes, Multi-Dimensional Cubes, Azure Synapse, and Power BI.Know how to implement and validate security models within the Datamart before output into presentation layers using Active Directory, Row-Level-Security, and Column-Level-Security.Understand visuals available in Crystal Reports, SSRS Reports, and Power BI.Develop reports and presentations that provide insights into technical data and state and federal business rules interpretation.Produce insightful dashboards and reports to answer questions about program data that is immediately actionable.Help standardize data visualizations agency-wide to increase the functional use of dashboards and reports.Assist program areas in creating data stories using statistical techniques and data cataloging to clearly understand meta-data that can be presented in a self-service reporting output layer.Collaboration and SupportBe well versed in Rationale UML, Database Design Architecture Modeling, Use Case Diagramming, Data Flow Diagramming, and Database Cataloging to help with communication and translation between technical and business definitions.Collaborate closely with program specialists and other stakeholders to understand data requirements and ensure accurate data representation.Work with management to prioritize business and information needs.Assist program areas in the technical interpretation of business rules related to CTE program areas and developing presentations.Adhere to state-mandated training, audits, controls, and narratives on data security and compliance with all relevant regulations (i.e., GDPR, PII, HIPAA, SOX, etc.).Required Skills:At least eight (8) years of experience as a Senior Database DeveloperExtensive 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.).