SQL/Business Intelligence Developer
: Job Details :

Job ID Number

R3905

Employment Type

Full time

Worksite Flexibility

Remote

Job Summary

As 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 Description

We are looking for a SQL/Business Intelligence Developer​. This position will be a full-time and remote contract opportunity.

What You'll Do

• Innovate, articulate and provide well-thought out recommendations, solutions and ideas to existing problems as well as forward thinking opportunities for improvement

• Analyzes the organization's database needs and develops a long-term strategy for data storage

• Leading activities relating to database systems development, documentation, and implementation

• Maintain, improve, and create new complex Microsoft SQL database objects including but not limited to stored procedures and functions

• Troubleshoot/Resolve database performance issues

• Design, document, create, unit and system test, deploy, and maintain databases including data warehouses

• Work with the business and other teams to develop and implement business rules for the data warehouse

• Support the development team with any database related issues

• Develop reference and workflow documents for documentation purposes

• Identify 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 Officer

• Review project requests describing database user needs to estimate time and cost required to accomplish tasks

• Identify 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 Officer

• Coordinate with Informatics and Data Science staff, as needed

• Uses 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 directed

• Research and evaluate latest technology and tools as opportunities for innovation and development excellence

• Discovers 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 needs

• Other duties as assigned

What You'll Need

Required:

• 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/experience

• 2 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 requirements

• Advanced SQL and MS SQL Server operating systems knowledge

• Understand 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 upgrades

• Advanced 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 databases

• Knowledge 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 skills

• Innovative Troubleshooting and resolving database performance. Implementing operational automation through scripting

• Knowledge of project management methodologies and practices

• Ability to facilitate problem solving among administrative & technical groups with varying needs and priorities, and to communicate well with administrative users, technical staff, and senior management

• Ability to work unsupervised

• Effective communication and documentation skills

Physical Demands

• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state, and local standards

• Sedentary 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 monitor

Reasonable Accommodation Statement

If 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 ...@cai.io or (888) 824 – 8111.

Equal Employment Opportunity Policy Statement

It 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.