The Developer II will work with various business unit and IT resources to develop solutions for operational and ad-hoc reporting, ETL, data driven business decisions, and systems integration from technical specifications based on customer and business needs, industry best practices and available technology.
Requirements
- 3 plus years of experience in hands-on with SSIS, SSRS, SSAS design. Azure Data Factory.
- 3 plus years of experience in SQL development-developing and designing applications and/or reports on SQL server 2014+ and/or SQL DW aka dedicated SQL Pools in Azure Synapse.
- Experience designing and developing applications on SQL Server 2014+ and/or SQL DW aka dedicated SQL Pools in Azure Synapse.
- Hands-on experience in writing T-SQL queries, Stored Procedures, User Defined Functions, Jobs, Cursors, Views and Triggers, optimized for database efficiency.
- Hands-on experience with SSIS, SSRS, SSAS design and development including Azure Data Factory
- Hands on experience with DAX and M Query
- Experience with various programming and scripting languages (JAVA, RPG, C, XSLT, various. NET languages, python, javascript, shell script...)
Responsibilities
- Uses analytical, data and SQL development skills to produce reports to support the Business in making data driven business decisions. Includes producing both ad-hoc and regularly scheduled reports.
- Works with Business Systems Analysts, Business Stakeholders, vendors, and solutions partners to develop solutions for operational and ad-hoc reporting, ETL, data driven business decisions support, and systems integration.
- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the development lifecycle and ETL process.
- Implement processes and logic to extract, transform, and distribute data across one or more data stores from a wide variety of sources.
- Provides analysis and development support for initiatives, including business function support for system migrations and consolidations, business area process improvement projects, and product installations.
- Develops and/or reviews departmental business system requirements and business systems design documents, customer acceptance test plans, and post-implementation plans.
- Works directly with external customers or in collaboration with the Senior Developers in implementing new reporting capabilities, systems enhancements and technology.
Other
- Gold Coast Health Plan will not sponsor applicants for work visas.
- Ability to comprehend complex technical topics and specialized information.
- Ability to determine how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
- Ability to grasp and understand business concepts and issues.
- Strong written and verbal communication skills, especially the ability to explain system and technical topics to non-technical resources.
