Trabajos sql en Springfield, IllinoisCrear alertas

Senior Solution Architect Location: Hybrid – Chicagoland HQ or Springfield, IL Employment Type: Full-Time / Permanent Organization: Consulting Services / Service Delivery About the Role We are seeking a Senior Solution Architect who brings both strategic advisory capability and hands-on technical depth across modern enterprise platforms. This is a client-facing leadership role responsible for shaping solution strategy, influencing executive stakeholders, and guiding the delivery of scalable, future-ready architectures. This role plays a key part in business development, helping craft proposals, solution estimates, resource models, and architectural roadmaps for complex enterprise engagements. What You’ll Do • Lead solution architecture for large-scale initiatives ($3M–$30M), balancing quick wins with long-term sustainability., • Translate business needs into clear technical strategies and architecture roadmaps., • Drive end-to-end solution design across backend, frontend, DevOps, infrastructure, and cloud ecosystems., • Act as a trusted advisor to clients and executives—communicating decisions with clarity and confidence., • Architect solutions leveraging the Microsoft ecosystem (Azure, MS SQL, Dataverse, Dynamics, Power Platform, M365)., • Apply integration patterns, microservices, distributed systems, and resilience design principles., • Partner closely with Product, Delivery, and Client teams to ensure alignment and execution success., • Support proposal development, estimation, and technical pre-sales conversations., • Mentor architects and technical delivery teams; promote reusable frameworks and reference architectures., • Embed governance, compliance, and security standards into solution designs. What You Bring • 20+ years of enterprise technology experience., • 10+ years solutioning and estimating complex architectures, ideally in a consulting or professional services environment., • Proven leadership designing and guiding multi-disciplinary technical teams., • Deep technical expertise across:, • Cloud (Azure preferred), • Integration architecture & distributed systems, • Backend & frontend platforms, • DevOps, CI/CD, Infrastructure-as-Code, • Modern data and API design patterns, • Strong executive communication and stakeholder influence skills., • Ability to work in ambiguous, high-stakes environments with pace and confidence. Nice to Have • Advanced degree in CS, Engineering, or related field, • Microsoft / Azure / Dynamics / Architecture Certifications, • Experience delivering digital transformation initiatives across multiple industries, • Published thought leadership or conference speaking background Core Impact Areas • Strategic Solution Architecture, • Client Advisory, • Proposal & Estimation Leadership, • Enterprise Integration Strategy, • Governance & Architecture Standards, • Cross-Functional Collaboration, • Delivery Oversight, • Risk Analysis, • Roadmapping & Innovation Enablement INT

Job Title: Senior Business Analyst Work Location: Springfield,IL Position Overview A Senior Business Analyst leads the identification, analysis, and documentation of complex business requirements and processes across multiple projects and initiatives. This role partners closely with business stakeholders, technical teams, and leadership to translate business needs into clear, actionable requirements and solution designs. The Senior Business Analyst drives requirements discovery, process improvement, and business validation efforts, ensuring solutions align with organizational goals, technical standards, and operational realities. Senior Business Analysts are expected to proactively identify risks, resolve ambiguity, mentor junior team members, and support initiatives throughout the full development lifecycle. Key Responsibilities Requirements Discovery & Analysis • Lead end-to-end business and functional requirements analysis, including workflow and process analysis., • Elicit, analyze, and document complex business needs through stakeholder interviews, workshops, and document reviews., • Distinguish between user requests and true business needs through critical evaluation and structured analysis., • Identify gaps, inefficiencies, risks, and improvement opportunities in existing processes and systems., • Support business process re-engineering and transformation initiatives., • Act as a primary liaison between business stakeholders, technical teams, and leadership., • Plan, facilitate, and lead stakeholder workshops, working sessions, and requirement reviews., • Manage stakeholder expectations by clearly communicating scope, assumptions, risks, and dependencies., • Produce high-quality artifacts including business requirements, functional requirements, use cases, process flows, and workflow diagrams., • Ensure documentation is complete, accurate, traceable, and consumable by both business and technical audiences., • Work closely with development, testing, and implementation teams to support solution delivery., • Participate in Agile or hybrid delivery ceremonies and support backlog refinement, sprint planning, and validation activities., • Assist with test case definition, user acceptance criteria, and solution validation. Required Skills & Experience Core Competencies • Proven experience as a Senior Business Analyst or equivalent role supporting complex initiatives, • Advanced requirements elicitation, documentation, and facilitation skills, • Strong analytical, critical-thinking, and problem-solving abilities, • Excellent written, verbal, and interpersonal communication skills, • Proficiency with requirements management and documentation tools, • Business process modeling and workflow diagramming, • Strong Excel skills and experience working with data to support analysis, • Understanding of database concepts and working knowledge of SQL, • Familiarity with Agile and Waterfall delivery methodologies Preferred Qualifications • Experience with data analysis, reporting, or visualization tools, • Business intelligence or analytics platform exposure, • Experience supporting large-scale system implementations or modernization efforts, • Knowledge of change management principles, • Business Analysis certification (e.g., CBAP, PMI-PBA)

Job DescriptionAbout defi SOLUTIONS: It’s an exciting time to join defi! defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest-volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lenders reduce time-to-market, streamline operations, and customize lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn. About the Role: The Business Systems Analyst serves as a subject matter expert to define both business and software solutions to meet the needs of our Clients and Internal Product Managers. This role focuses on projects that pertain to the underwriting related functionality of the Loan Originations System product. The role includes many diverse responsibilities ranging from initial analysis of both External and Internal Client needs through the delivery of the software solution. The Business Analyst is responsible for capturing project requirements, designing comprehensive solutions and ensuring that the end deliverables satisfy the Client’s objectives and expectations. The Business Analyst works closely with other members of the project team to include supporting the Development and Quality Assurance Teams inclusive of supporting activities through the deployment of the project. The Business Analyst also works closely with the Client to provide education as it relates to the Lease and Loan underwriting transactions. The ideal candidate for this role is someone who can apply their direct and indirect lending skills as it relates to the Loan Origination System. The Business Analyst should have strong experience in direct lending, indirect auto finance, and auto leasing to support the evolution of our Loan Origination System (LOS). The platform currently supports indirect auto lending and leasing, and we are expanding its capabilities to include a full suite of direct lending and leasing products, such as: • Auto Loans, • Auto Leases, • Unsecured Loans, • Debt Consolidation, • Pledged Collateral, • Credit Cards Essential Job Responsibilities: Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions. • Lead business analysis for the expansion of our loan origination platform to support direct lending products., • Collaborate with internal teams and clients to define and document business requirements, workflows, and functional specifications., • Provide consulting on accounting-related functionality, including General Ledger Hierarchy and transactions from originations through recovery., • Apply knowledge of US GAAP, FASB, and Federal Reserve System standards related to consumer lending and leasing., • Analyze and document financial calculations including lease/loan payments, future/present value, and APR., • Conduct gap analysis between current indirect lending capabilities and required direct lending features., • Partner with software engineers, QA, and implementation teams to ensure accurate development and testing of new features., • Participate in test plan reviews and support validation of business requirements., • Provide demos and training to internal teams and clients on new functionality., • Recommend process improvements and assist in root cause analysis for product enhancements., • Utilize data and systems to support business goals through analysis and research. Required Qualifications: • 5+ years of experience in indirect/direct lending, underwriting, or financial services., • Strong understanding of consumer lending products and underwriting processes., • Excellent communication and client-facing skills. Preferred Qualifications • Bachelor’s degree in Accounting, Finance, Business, or related field., • Experience in auto finance and loan origination systems., • Experience writing business and functional requirements., • Background in underwriting or managing underwriting operations., • SQL knowledge., • Familiarity with Agile methodology., • Experience working with software development teams. Travel Required: • Less than 10% Affirmative Action/EEO statement: defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.

Job DescriptionDescription: At CSpring, we believe in the power of data to drive decisions and real-world impact. We’re a purpose-driven consulting firm specializing in data strategy, data engineering, and data analytics. Our clients span the public and private sectors, and our work helps them solve complex problems, gain insights, and achieve measurable results. We're seeking talented professionals who are collaborative, curious, and committed to making a difference that thrive at the intersection of data, technology, and business strategy. Whether you're passionate about transforming public programs, enabling executive decision-making, or modernizing legacy systems, you'll find meaningful work and purpose here. Why You’ll Love Working Here • Purposeful Projects – Improve systems that serve real people by delivering smarter data, streamlined processes, and strategic insight., • People-First Culture – We’re as committed to your growth as we are to delivering high-impact solutions. You’ll find support, autonomy, and community here., • Strategic, Hands-On Work – From data architecture and documentation to client workshops and solution delivery, you’ll influence every step of the process. CSpring is looking for a Quality Engineer who brings both technical depth and a quality-first mindset to modern data and application environments. In this role, you will help ensure the reliability, performance, and integrity of critical systems by designing thoughtful test strategies, executing manual and automated testing, and partnering closely with cross-functional teams throughout the development lifecycle. This is an ideal opportunity for someone who thrives in complex environments, enjoys solving technical problems, and wants to play a meaningful role in delivering high-quality solutions across data platforms, applications, and integrations. As a Quality Engineer, you will be a key contributor to product and platform quality from requirements through release. You will work across functional, integration, regression, and end-to-end testing efforts while helping teams strengthen quality engineering practices in Agile and CI/CD environments. • Participate in walkthroughs, inspections, reviews, and user group meetings to support quality assurance activities across the delivery lifecycle, • Develop, maintain, and prioritize comprehensive test cases and testing plans, • Execute test cases, identify and document defects, and clearly communicate severity and priority, • Perform regression testing after code changes to ensure fixes do not create downstream issues, • Build strong system and application knowledge to improve testing quality, accuracy, and coverage, • Design, develop, and implement automated tests using BDD/TestNG approaches, • Create and execute automated tests using Selenium, Cucumber, and Java in alignment with enterprise development and operational standards, • Embed quality engineering practices within CI/CD pipelines, including version control, test management, and automation framework integration, • Conduct functional, integration, regression, system, and end-to-end testing, • Partner with scrum teams during user story grooming to help define clear, testable acceptance criteria, • Take ownership of quality outcomes and communicate effectively with business sponsors, project leaders, and technical teams, • Document test results and validate that business and technical requirements are fully met, • Ensure compatibility with existing product functionality and integration points across product lines, • Apply knowledge of Bronze / Silver / Gold data architecture in modern data platforms such as Databricks, Snowflake, and Azure Synapse, • Leverage AI-enabled testing tools to generate test data, auto-generate test cases from requirements or user stories, and enhance API testing through intelligent validation and recommendations Requirements: What You Bring • 5+ years of experience in software testing and quality assurance, • 5+ years of experience testing backend, database, EDW, or ETL systems, • 4+ years of strong SQL experience and hands-on work with at least one relational database platform such as Teradata or SQL Server, • 4+ years of experience in UI, smoke, integration, and end-to-end testing, • 4+ years of strong troubleshooting and analytical experience, including debugging complex technical issues, • 4+ years of experience in test design and use of at least one test management tool, • Bachelor’s degree or higher in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business Technology, or a related field, • Familiarity with both Agile and Waterfall delivery methodologies, • Proven ability to collaborate effectively with customers, DBAs, ETL developers, business intelligence architects, and PMO teams, • Experience in the healthcare domain, including Commercial, Medicaid, or Medicare claims data, • Familiarity with EDI X12 transactions such as 999, 837, 834, and 277, or HL7, • Experience with DevOps tools and platforms, including Informatica, • Hands-on experience with testing and automation tools such as: Selenium (Java), Cucumber (BDD), SOAP UI, Postman, RestAssured, HP ALM, Jira, GitHub, • Experience working in CI/CD environments such as Jenkins for automated test execution and deployment, • Experience testing complex XML/JSON structures, EDI X12 transactions, and SQL-based data flows, • Strong understanding of automation framework design, development, and maintenance At CSpring, we unlock the potential of people and data. If you're ready to lead meaningful projects, collaborate with passionate teams, and grow your career in a people-first consulting environment—apply today!

Job DescriptionOffice of the Illinois Secretary of State Alexi Giannoulias Job Title: Data Architect – Information Systems Division: Architecture Union: N/A Location: 501 S Second St, Springfield, IL – Sangamon County Salary: Salary commensurate with experience Benefits: Attention: Applicants must be authorized to work in the United States; the Office of the Secretary of State will not complete certification and/or sponsorship requests. Overview: Under the general direction, the Data Architect is responsible for designing, creating, deploying, and managing the organization's data architecture. This role includes defining how the data will be stored, consumed, integrated, and managed by different data entities and IT systems. Duties and Responsibilities: • Develop robust database (or other data storage) designs that support efficient data storage, retrieval, and manipulation. This involves selecting appropriate database models, defining data relationships, and implementing indexing strategies to optimize performance., • Analyze business processes, applications, and user needs to determine the structure of databases. This includes evaluating data volume, usage patterns, and future scalability requirements., • Assess database implementation procedures to ensure they comply with internal and external regulations., • Lead the setup and configuration of database management systems, ensuring optimal performance and integration with other enterprise information systems., • Generate detailed reports and documentation on database architectures, models, and guidelines for management review. This includes presenting findings and recommendations to executive teams for strategic decision-making., • Manage the process of migrating data from legacy systems to modern database solutions, ensuring data integrity, minimal downtime, and a smooth transition for users., • Conduct regular performance evaluations of database systems, identify bottlenecks or inefficiencies, and apply optimizations. Troubleshoot and resolve issues as they arise., • Proactively suggest enhancements to existing database systems and evaluate new technologies or features that could benefit the organization. This involves staying current with industry trends and best practices., • Educate staff members through training and individual support., • Offer support by responding to system problems in a timely manner., • Performs other duties as required or assigned.Specific Skills:, • Extensive experience in data modeling, data warehousing, and database design (both SQL and NoSQL technologies)., • Proficiency in big data technologies (Hadoop, Spark) and data processing frameworks., • Knowledge of data governance, quality, and compliance standards (e.g., GDPR)., • Experience with ETL processes, tools, and data integration techniques., • Skills in data visualization and reporting tools (PowerBI, Tableau)., • Familiarity with cloud data services and architectures., • Strong analytical and problem-solving abilities to address data challenges., • Communication skills to liaise with IT teams and business stakeholders., • Certification in data architecture or related technologies (e.g., Microsoft Certified: Data Analyst Associate)., • Understanding of machine learning and data science principles to support advanced analytics initiatives., • Requires a valid Illinois driver’s license and the ability to perform physical activities such as lifting, carrying, and pushing/pulling items weighing up to 50lbs.Education and Work Experience: Requires knowledge, skill and mental development equivalent to the completion of four years college, preferably with courses in computer science, management information systems, mathematics or statistics AND minimum of three years' experience as a Data Architect. Application Process: • Preference will be given to Illinois residents in the hiring and selection process, in accordance with the Illinois Secretary of State Merit Employment Code. tteOUWGPnB

Job DescriptionQuality Assurance AnalystContract Duration: 7+ months Location: Remote (U.S. only; excluding Hawaii and Alaska) Travel: Up to 3 times per year to Springfield, IL Job Summary:We are seeking a skilled and experienced Quality Analyst (QA) to support a large-scale data warehouse project. This role ensures software quality and reliability through active participation in QA activities, including inspections, reviews, and automated testing. The ideal candidate will have strong experience in backend/database/ETL testing, automation frameworks, and healthcare data systems. Key Responsibilities: • Participate in QA activities such as walk-throughs, inspections, reviews, and user group meetings., • Develop, prioritize, and execute test cases; report defects with defined severity and priority., • Perform regression testing following code changes., • Acquire deep system and application knowledge to enhance test quality and coverage., • Develop and implement automated tests using BDD and TestNG; execute tests using Selenium, Cucumber, and Java., • Implement quality engineering practices within a CI/CD pipeline, including version control and test management., • Conduct end-to-end testing including functional, integration, and regression testing., • Collaborate with scrum teams to groom user stories and develop acceptance criteria., • Document and review test results to ensure business and technical requirements are met., • Ensure compatibility with existing product features and interfaces., • Understand Bronze/Silver/Gold data architecture in platforms like Databricks, Snowflake, and Azure Synapse., • Use AI-based tools to create test data, auto-generate test cases, and conduct API testing with tools like Postman., • Employ generative AI for efficient testing, including generating test case requirements and user stories.Required Qualifications:, • 5+ years of experience in software testing., • 5+ years of experience as a backend/database/EDW/ETL tester., • 4+ years of strong SQL skills and experience with RDBMS (e.g., Teradata, SQL)., • 4+ years of experience in UI, smoke, end-to-end, and integration testing., • 4+ years of troubleshooting and debugging experience., • 4+ years of test design experience and use of test management tools., • Ability to travel to Springfield, IL up to three times per year.Preferred Qualifications:, • Experience with healthcare data (Medicaid, Medicare, commercial claims, EDI X12 transactions, HL7)., • Experience with DevOps and Informatica PowerCenter., • Familiarity with tools: Selenium with Java, Cucumber (BDD), SOAP UI, Postman, RestAssured, HP ALM, Jira, GitHub., • Experience in CI/CD environments (e.g., Jenkins)., • Experience with complex XML/JSON, EDI X12, and SQL transactions., • Knowledge of automation framework development and usage., • Strong communication, collaboration, and influencing skills., • Located within driving distance to Springfield, IL (preferred).

Job DescriptionMedicaid Business / QA Analyst • 7–12+ Month Contract | Remote | No ThirdParty Firms | Medicaid SME Required, • Candidates with previous State Medicaid program experience will be given strong consideration., • Drug screen and background check required as part of onboardingPosition SummaryThe Medicaid Business/QA Analyst serves as a subject matter expert (SME) for Medicaid data and processes while performing quality assurance testing within a large-scale Enterprise Data Warehouse (EDW) environment. This position combines program knowledge—eligibility, claims, encounters, provider enrollment, managed care, and reporting—with QA discipline to ensure accuracy, completeness, and usability of EDW deliverables such as data marts, inbound source data loads, outbound extracts, reporting outputs, and operational dashboards.Key Responsibilities1. Business SME – Medicaid Data & Processes, • Interpret Medicaid data elements, business rules, and program logic for EDW initiatives., • Review inbound data from core systems (eligibility, provider, claims, managed care) for accuracy and mapping alignment., • Validate outbound extracts and reporting outputs for accuracy, timeliness, and format requirements., • Support development of data marts across eligibility, claims/utilization, provider, managed care, LTSS, and behavioral health.2. QA Planning & Execution, • Develop QA plans, scenarios, and test cases aligned to business rules., • Perform data reconciliation between source files and EDW target tables., • Validate transformations, aggregations, and derived fields., • Participate in User Acceptance Testing (UAT) with business stakeholders.3. Data Quality & Issue Resolution, • Identify data anomalies, mapping issues, and business rule gaps; work with data engineering and ETL teams to resolve., • Ensure referential integrity across eligibility, claims, provider, and plan datasets., • Define business data quality rules for ongoing monitoring., • Track and document issues in defect management tools.4. Collaboration & Documentation, • Work with business stakeholders, vendors, and technical teams to validate requirements and deliverables., • Review BRDs, mapping documentation, and data models for accuracy., • Maintain QA evidence, testing documentation, and business rule records., • Support knowledge transfer related to Medicaid data usage within the EDW.Required Skills & Qualifications, • Strong Medicaid business knowledge (eligibility, claims, encounters, provider, managed care)., • Experience working with EDW environments, including inbound feeds, staging layers, integration layers, data marts, and outbound extracts., • Proficiency with SQL for validation and reconciliation., • Experience in data warehouse QA/testing, including validating data transformations and dimensional models., • Ability to translate Medicaid program rules into testable acceptance criteria., • Familiarity with HIPAA compliance and PHI guidelines., • Excellent analytical, documentation, and communication skills.Preferred Qualifications, • Experience with Medicaid EDW or MMIS modernization projects., • Familiarity with provider handbooks, policy documentation, or administrative rules., • Experience with managed care data (capitation, encounters, member assignments)., • Experience validating dashboards or reports in tools such as Tableau, Power BI, or Cognos., • Background in data governance or metadata management.

Job DescriptionSQL Data Analyst - Healthcare ClaimsRemote | Contract (Multi-Year or Permanent Option) | Competitive Pay + Benefits Why This Role Is DifferentThis opportunity gives you real impact on Medicaid data solutions that improve healthcare delivery for millions. You’ll work with cutting-edge tools, collaborate with smart teams, and enjoy flexibility without sacrificing stability. What You’ll Do • Develop complex SQL for data warehouse reporting and analytics., • Analyze business processes and document requirements for new systems., • Partner with internal teams and clients to deliver clear documentation and updates., • Support user acceptance testing, defect tracking, and scenario development., • Dive into Medicaid enrollment, provider, and claims data to uncover insights., • Identify and resolve data anomalies across cross-functional teams., • Create professional presentations and contribute to operational guides.What We’re Looking For, • Must-Have Skills:, • Advanced ANSI SQL coding experience., • Healthcare business analysis and claims/encounter experience., • 2+ years of Unix/Linux Shell scripting (Bash/Korn)., • Strong communication and organizational skills., • Ability to thrive with minimal guidance and tight deadlines., • Education: Bachelor’s degree in a related field.Preferred Extras, • Experience with CMS Federal Reporting (CMS-416, CMS-64), PERM, T-MSIS., • Familiarity with HEDIS, CMS Core Set, and Symmetry EBM Connect., • Teradata DBMS experience., • Knowledge of data integration, agile methodologies, and tools like Azure DevOps, SharePoint, MS Project, Visio.Why You’ll Love It, • Flexibility: Remote work with occasional travel., • Stability: Multi-year contract or potential permanent hire., • Benefits: Competitive pay plus comprehensive benefits., • Impact: Your work will directly improve Medicaid program performance.

Job DescriptionThe Software Development Engineer role is a 100% Fully Remote Position About defi SOLUTIONS: It’s an exciting time to join defi! defi SOLUTIONS is a pioneer in end-to-end, SaaS loan originations, servicing, and managed servicing solutions. Our customers include the highest volume captive auto lenders, banks, credit unions, and finance companies in North America. We have more than three decades of experience helping lending reduce time-to-market, streamline operations and customer lending processes with proven, scalable performance. Learn more at defisolutions.com and follow us on LinkedIn. Position Purpose: The Software Development Engineer is responsible for creating complex, critical and rewarding financial business applications used by high profile financial institutions. As a software application provider, the timeliness and success of your application development is paramount to the companies reputation and success. Software development is not a support function in our company --- it is our Business! Essential Functions: Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions. • Designs, codes, installs, runs, and maintains application software programs., • Assists in design, coding, and installation of application enhancement projects., • Analyzes specifications for application enhancements for compatibility with other systems and within operating guidelines., • Analyzes dumps, debugs problems and applies fix procedures., • Prepares documentation for use by computer operations, applications programming, and user personnel., • Provides technical assistance and information., • Assists with the training of application programming and user personnel in the use of the software and systems., • Reviews new designs, enhancements and programs with supervisor and application programmers for operating efficiencies. Required Education and Experience: • Bachelor’s degree in Computer Science or equivalent in work experience., • Requires 3 -5 years experience with web application development., • Agile development methodology Preferred Education and Experience: • Experience with Auto finance, • Knowledge of and coding on financial systems software, especially lease and loan financial calculations., • Experience with Lease or Loan data conversion., • Experience with the ASP.NET MVC stack, ASP.NET core., • Experience with JavaScript, jQuery and AJAX, promises., • Experience with HTML5, CSS3 and responsive UI design, • Extensive experience with full-lifecycle development (i.e. design, coding, testing, debugging, etc.)., • Experience with distributed systems, C#, ASP.NET, REST and SQL programming & Linq, • Experience developing or working with web services (REST and Web API preferred), • Experience with test driven development (TDD), dependency injection (DI) and mocking frameworks Additional Eligibility Requirements: • A superior knowledge of programming (i.e. program design, flowcharting, coding, testing, debugging, etc)., • Ability to solve problems that require extensive data gathering, investigation, review, and analysis to define the problem and then develop/implement solutions, which requires the use of complex analytical techniques and innovative thinking., • Ability to read, understand, and interpret complex business or technical subjects; must be able to discuss or explain this data with others, either internal or external to defi Solutions., • A superior knowledge of how to document program design, coding, and maintenance., • A superior understanding of how critical project completion is to client satisfaction., • The ability to interact and communicate with external, as well as, internal clients for the purpose of data gathering and design initiation., • Ability to resolve and follow up on software support issues., • Experience with client-side controls like jQuery UI, Kendo UI, VUE.js, • Experience with modern programming techniques (i.e. fluent, async), • Experience with Git & TFS, • Experience with Webpack, ES6, TypeScript, • Experience with Azure (focused on Virtual Machines, API Management and app monitoring using Application Insights)., • Experience with Azure DevOps in the ALM (Application Lifecycle Management) is a plus., • Troubleshooting skills (with tools like Fiddler, SQL profiler, browser’s Developer Tools and logging). Travel Required: • Travel is less than 5% of time Affirmative Action/EEO statement: defi SOLUTIONS is an Equal Opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status.

Job DescriptionOffice of the Illinois Secretary of State Alexi Giannoulias Job Title: Information Systems Technician I Division: Information Technology - Systems and Programming Union: IFT Location: 501 S Second St, Springfield, IL – Sangamon County Salary: $4,865.00 monthly, commensurate with experience Attention: Applicants must be authorized to work in the United States; the Office of the Secretary of State will not complete certification and/or sponsorship requests. Overview: Responsibilities include, but are not limited to, the development of new Drivers programs, as well as enhancements and maintenance of existing Drivers programs and related sub-systems. Duties and Responsibilities: • Assists in the planning, analysis, design, development, and support of Drivers programs of varying size and complexity; maintains sub-systems of a large Drivers Services processing system and understands integration points to make relevant modifications when necessary; hands-on technical experience using technologies including COBOL, CICS, and JCL is required; a strong working knowledge of DB2, SQL, and stored procedure experiences is also required. HTML, CSS, and XML interface development experience is preferred., • Based on project specifications, utilizes applicable tools to design flowcharts, process models, and use cases in preparation for program development and testing., • Assists in analyzing test results for the detection of technical programming errors., • Assists in assessing and formulating strategies to improve efficiency of existing applications, maintenance, and enhancement processes., • Prepares and modifies detailed programming documentation in accordance with established documentation standards., • Responsible for test plan development, execution, and unit testing verification., • Performs other duties as required or assigned.Minimum Requirements:, • Requires knowledge skill and mental development equivalent to the completion of one year of college, with Computer Science coursework or one and one-half (1.5) years of technical systems and/or programming experience., • Hands-on technical experience using technologies including COBOL, CICS, and JCL is required., • A strong knowledge of DB2, SQL, and stored procedure experiences is also required., • HTML, CSS, and XML interface development experience is preferred., • Requires the ability to lift and carry up to 50 lbs., • Requires a valid Illinois Driver's License.Application Process:, • Preference will be given to Illinois residents in the hiring and selection process, in accordance with the Illinois Secretary of State Merit Employment Code. vzt9XGDmJW