SQL/Business Intelligence Developer

Cai - Concord, NH

Full-time

Concord, NH

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 improve database performance.

Responsibilities

• Innovate and provide recommendations for existing problems and opportunities for improvement.
• Analyze 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 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 database-related issues.
• Develop reference and workflow documents for documentation purposes.
• Identify and evaluate industry trends in database systems for management.
• Review project requests to estimate time and cost for tasks.
• Coordinate with Informatics and Data Science staff as needed.
• 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 and maintenance of Informatics functional architecture and system design.

Requirements

• Minimum 6 years' experience in healthcare claims environment and reporting development.
• Demonstrated experience in n-tier development and support including Microsoft SQL database development.
• Experience with SQL Server 2008 R2 or above, Visual Studio Professional/Enterprise 2017 or above, Azure Dev Ops, SSMS, SSRS, SSIS, Advanced SQL, C#, .NET, PowerShell.
• 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.
• Knowledge of ALM and SDLC principles, structured and unstructured data analysis, and relational and star schema databases.
• Knowledge of Azure Dev Ops as a master demand repository and Agile techniques.
• Problem-solving skills and effective communication skills.
• Ability to facilitate problem solving among administrative and technical groups.
• Ability to work unsupervised and communicate effectively.