SQL/BUSINESS INTELLIGENCE DEVELOPER
Company: CAI
Location: Salt Lake City
Posted on: October 12, 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 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
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
Click
here to apply!
|