Job ID NumberR3905Employment TypeFull timeWorksite FlexibilityRemoteJob SummaryAs SQL/Business Intelligence Developer, you will be responsible for the development and maintenance of the information reporting systems for our client, including the design, configuration, implementation, and proactive management of the organization’s databases, warehouse solutions, backup, archiving, and monitoring resources.Job DescriptionWe are looking for a SQL/Business Intelligence Developer. This position will be a full-time and remote contract opportunity.What You’ll DoInnovate, articulate and provide well-thought out recommendations, solutions and ideas to existing problems as well as forward thinking opportunities for improvementAnalyzes the organization's database needs and develops a long-term strategy for data storageLeading activities relating to database systems development, documentation, and implementationMaintain, improve, and create new complex Microsoft SQL database objects including but not limited to stored procedures and functionsTroubleshoot/Resolve database performance issuesDesign, document, create, unit and system test, deploy, and maintain databases including data warehousesWork with the business and other teams to develop and implement business rules for the data warehouseSupport the development team with any database related issuesDevelop reference and workflow documents for documentation purposesIdentify and evaluate industry trends in database systems as a source of information and advice for the Informatics Manager of Data Management, Director of Informatics, and/or Chief Information OfficerReview project requests describing database user needs to estimate time and cost required to accomplish tasksIdentify and evaluate industry trends in database systems to serve as a source of information and advice for the Informatics Manager of Data Management, Director of Informatics, and/or Chief Information OfficerCoordinate with Informatics and Data Science staff, as neededUses KACE and Team Foundation Server (TFS) to respond to organizational requests, document and track progress, and maintain version control of code Provide technical support around systems capabilities to Information Technology projects Provides training for IT staff, as needed and directedResearch and evaluate latest technology and tools as opportunities for innovation and development excellenceDiscovers and contributes to the development, implementation, and maintenance of Informatics functional architecture, detail systems design, configuration, or program specifications to deliver IT system outcomes that meet user and organization needsOther duties as assignedWhat You'll NeedRequired:Minimum 6 years’ experience in one or more of the following areas: healthcare claims environment and reporting development, demonstrated experience in n-tier development and support including Microsoft SQL database development including relational and star schema data warehouses, ETL, data archiving, including the following software and tools; SQL Server 2008 R2 or above, Visual Studio Professional\Enterprise 2017 or above, Azure Dev Ops, SSMS, SSRS, SSIS, Advanced SQL, C#, .NET, PowerShell or equivalent of higher education or higher education/experience2 year degree required. One or more of Microsoft data systems certifications such as MTA, MCSA, MCSE, ITIL v3, or applicable certification(s) may be substituted to equivalent degree requirementsAdvanced SQL and MS SQL Server operating systems knowledgeUnderstand how to work with database projects in Visual Studio (currently on 2019 Pro or Enterprise)Experience in database development, maintenance, and execution of mission critical large scale system upgradesAdvanced knowledge in ETL and data warehousing. Knowledge of ALM and SDLC principles as well as well as an understanding of analysis of structured and unstructured data and of relational and star schema Microsoft SQL databasesKnowledge of Azure Dev Ops as a platform to serve as a master demand repository, workflow tool, source control/code promotion mechanics. Knowledge about Agile techniques like: Users Stories, Continuous Integration, Continuous Delivery, Continuous Deployment, Automated testing. Problem solving skills and effective communication skillsInnovative Troubleshooting and resolving database performance. Implementing operational automation through scriptingKnowledge of project management methodologies and practicesAbility to facilitate problem solving among administrative & technical groups with varying needs and priorities, and to communicate well with administrative users, technical staff, and senior managementAbility to work unsupervisedEffective communication and documentation skillsPhysical DemandsAbility to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standardsSedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitorReasonable Accommodation StatementIf you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to or (888) 824 – 8111.Equal Employment Opportunity Policy StatementIt is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.