SQL/Business Intelligence Developer

Cai - Columbia, SC

Full-time

Columbia, SC

Chemical Manufacturing

About the position

The SQL/Business Intelligence Developer will be responsible for the development and maintenance of information reporting systems, focusing on the design, configuration, implementation, and management of databases and data warehouse solutions. This role requires innovative problem-solving and collaboration with various teams to enhance data storage strategies and ensure optimal database performance.

Responsibilities

• Innovate and provide recommendations for existing problems and opportunities for improvement.
• Analyze the organization's database needs and develop a long-term strategy for data storage.
• Lead activities related to database systems development, documentation, and implementation.
• Maintain, improve, and create new complex Microsoft SQL database objects, including 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 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 for management.
• 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 and maintain version control of code.
• Provide technical support around systems capabilities to IT projects and training for IT staff as needed.
• Research and evaluate latest technology and tools for innovation and development excellence.
• Contribute to the development, implementation, and maintenance of Informatics functional architecture.

Requirements

• Minimum 6 years' experience in healthcare claims environment and reporting development, including Microsoft SQL database development and ETL.
• 2 year degree required; Microsoft data systems certifications may substitute for degree requirements.
• Advanced SQL and MS SQL Server operating systems knowledge.
• Experience in database development, maintenance, and execution of large scale system upgrades.
• Advanced knowledge in ETL and data warehousing, and understanding of structured and unstructured data analysis.
• Knowledge of Azure Dev Ops and Agile techniques.
• Problem-solving skills and effective communication skills.
• Ability to work unsupervised and facilitate problem-solving among diverse groups.