SQL/BUSINESS INTELLIGENCE DEVELOPER
Company: CAI
Location: Salt Lake City
Posted on: October 11, 2024
Job Description:
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 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 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/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 skillsPhysical
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 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 application.accommodations@cai.io
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.
Keywords: CAI, Logan , SQL/BUSINESS INTELLIGENCE DEVELOPER, IT / Software / Systems , Salt Lake City, Utah
Didn't find what you're looking for? Search again!
Loading more jobs...