JobRialto
SQL/Business Intelligence Developer
JobRialto, Greenville, North Carolina, United States, 27834
Job Overview:
We are seeking a skilled and innovative IT Security Administrator (ISA) to join our team. The ISA will be responsible for a wide range of security functions, including administering access controls, managing physical security, and implementing security policies and procedures. This role involves monitoring and analyzing security alerts, investigating suspicious activities, and supporting agency Information Security Officers. The ISA also conducts vulnerability assessments, assists with compliance audits, and provides physical security for DTI work locations. Continuous learning and collaboration with a larger security team are essential to maintain the organization's security posture and ensure business continuity.
Key Responsibilities:
•Innovate, articulate, and provide well-thought-out recommendations, solutions, and ideas to existing problems as well as forward-thinking opportunities for improvement.
•Analyze the organization's database needs and develop a long-term strategy for data storage.
•Lead 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 and 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.
•Coordinate with Informatics and Data Science staff, as needed.
•Use 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.
•Provide training for IT staff, as needed and directed.
•Research and evaluate the latest technology and tools as opportunities for innovation and development excellence.
•Discover and contribute to the development, implementation, and maintenance of Informatics functional architecture, detailed systems design, configuration, or program specifications to deliver IT system outcomes that meet user and organization needs.
•Perform other duties as assigned.
Required Qualifications:
•Minimum 6 years of 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 DevOps, 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 an understanding of analysis of structured and unstructured data and of relational and star schema Microsoft SQL databases.
•Knowledge of Azure DevOps as a platform to serve as a master demand repository, workflow tool, source control/code promotion mechanics. Knowledge about Agile techniques like: User 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 of project management methodologies and practices.
•Ability to facilitate problem-solving among administrative and 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.
Education:
Bachelors Degree
We are seeking a skilled and innovative IT Security Administrator (ISA) to join our team. The ISA will be responsible for a wide range of security functions, including administering access controls, managing physical security, and implementing security policies and procedures. This role involves monitoring and analyzing security alerts, investigating suspicious activities, and supporting agency Information Security Officers. The ISA also conducts vulnerability assessments, assists with compliance audits, and provides physical security for DTI work locations. Continuous learning and collaboration with a larger security team are essential to maintain the organization's security posture and ensure business continuity.
Key Responsibilities:
•Innovate, articulate, and provide well-thought-out recommendations, solutions, and ideas to existing problems as well as forward-thinking opportunities for improvement.
•Analyze the organization's database needs and develop a long-term strategy for data storage.
•Lead 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 and 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.
•Coordinate with Informatics and Data Science staff, as needed.
•Use 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.
•Provide training for IT staff, as needed and directed.
•Research and evaluate the latest technology and tools as opportunities for innovation and development excellence.
•Discover and contribute to the development, implementation, and maintenance of Informatics functional architecture, detailed systems design, configuration, or program specifications to deliver IT system outcomes that meet user and organization needs.
•Perform other duties as assigned.
Required Qualifications:
•Minimum 6 years of 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 DevOps, 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 an understanding of analysis of structured and unstructured data and of relational and star schema Microsoft SQL databases.
•Knowledge of Azure DevOps as a platform to serve as a master demand repository, workflow tool, source control/code promotion mechanics. Knowledge about Agile techniques like: User 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 of project management methodologies and practices.
•Ability to facilitate problem-solving among administrative and 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.
Education:
Bachelors Degree