SQL/Business Intelligence Developer

Dew Softech - Atlanta, GA

Full-time - Mid Level

Remote - Atlanta, GA

Professional, Scientific, and Technical Services

About the position

The SQL/Business Intelligence Developer position is a fully remote contract role focused on database systems development and management within a healthcare claims environment. The developer will be responsible for analyzing database needs, creating and maintaining complex SQL database objects, troubleshooting performance issues, and collaborating with various teams to implement business rules for data warehousing. This role requires strong SQL skills and a proactive approach to problem-solving and innovation.

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 and advice 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.
• Provide technical support around systems capabilities to IT projects.
• Provide training for IT staff as needed and directed.
• Research and evaluate latest technology and tools for innovation and development excellence.
• Contribute to the development, implementation, 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.
• Ability to facilitate problem solving among administrative & technical groups.
• Effective communication and documentation skills.

Nice-to-haves

• Knowledge of project management methodologies and practices.
• Ability to work unsupervised.
• Innovative troubleshooting and resolving database performance issues.

Benefits

• Fully remote work opportunity.
• Flexible working hours within core EST hours.