Senior Business Intelligence Developer
GoHealth is a leading developer of Web-based sales and online insurance marketing tools for the health insurance industry, helping insurance brokers, agents and carriers connect with customers and transact business more efficiently. We are revolutionizing the health insurance industry through technology.
GoHealth made the Crain's Fast Fifty list in 2014, and we were named one of North America’s Fastest Growing Tech Companies on Deloitte’s 2014 Technology Fast 500.
This is your chance to be at the right place at the right time, and work on a product with real-life relevance for all Americans.
Job DescriptionAs a Senior Business Intelligence Developer, you will be responsible for helping to support our data analytics processes. This is achieved by focusing on ETL architecture, design, and development, and data quality and automation. This position provides additional opportunities to get involved on the business side, helping to design and automate reports using SSRS, SSAS, and Tableau.
Responsibilities
- Design and maintain ETL and supporting data object for our growing BI infrastructure
- Create new ETL solutions and maintain existing ones
- Schedule and monitor ETL processes and troubleshoot issues
- Assist in the design and maintenance of data schema projects
- Assist in teh development and documentation of technical design and standards
- Work with internal technical staff, as well as business users to quickly identify and resolve data integration issues
- Identify architectural improvements to enhance ETL performance and workflows
- Detailed knowledge of the Microsoft SQL Server BI stack
- Expert knowledge of SSIS and all Control and Workflow tasks available
- Firm grasp of T-SQL as well as all SQL Server programming objects
- 5+ years of experience designing and developing ETL solutions using SSIS in a Microsoft BI environment
- Experience extracting data from non-relational source systems such as REST APIs, NoSQL databases, Google Analytics, etc.
- Experience using C# or .Net to build advanced transformations or create custom data sources
- Use of Mercurial or similar source control tool
- Knowledge or experience working with Agile development practices
General Requirements
- A passion for working with data and coming up with creative ways to store it
- Detail oriented with strong verbal and written communication skills to collaborate and keep others informed
- Ability to take an abstract goal and break it down into actionable tasks that will deliver results quickly
- A hands on personality and demonstrated skills to own a complete solution from requirements gathering to implementation