SQL/Business Intelligence Developer

Cai - Helena, MT

Full-time - Mid Level

Helena, MT

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 new complex Microsoft SQL database objects.
• Troubleshoot and resolve database performance issues.
• Design, document, create, unit and system test, deploy, and maintain databases including data warehouses.
• Work with business 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.
• Use KACE and Team Foundation Server (TFS) for organizational requests and version control.
• Provide technical support around systems capabilities to IT projects.
• Research and evaluate latest technology and tools for innovation.
• Contribute to the development and maintenance of Informatics functional architecture.

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 Azure Dev Ops and Agile techniques.
• Problem-solving skills and effective communication skills.
• Ability to facilitate problem solving among diverse groups and communicate effectively.

Nice-to-haves

• Knowledge of project management methodologies and practices.
• Ability to work unsupervised.
• Effective communication and documentation skills.