Business Intelligence Developer at Delta Dental of Colorado (Greater Denver Area, CO)
The Business Intelligence (BI) Developer will develop, build, and maintain analytical solutions with the goal of turning data into knowledge. This team member will be responsible for writing advanced queries and developing reporting capabilities including dashboards, reports, or data extracts. In addition to report and dashboard creation, this person will be responsible for documenting solutions and contributing to the team’s document library The BI Developer role is multi-faceted with time spent understanding business processes and needs, developing optimized code for Power BI Dashboards and back-end SQL Server queries.
As part of a small team, the Developer is expected to work with minimal oversight to recommend ways to improve data reliability, efficiency, and quality. They will need to suggest and proactively implement new report development and enhancements.
o Design, build, and deploy business intelligence solutions using Power BI MS SQL server, and SSIS/SSRS.
o Work independently to develop accurate and timely solutions that align with stakeholder needs and objectives.
o Troubleshoot, resolve and document ETL processes.
o Write data extracts, queries, stored procedures, and functions to manipulate and prepare data for analysis and reporting.
o Understand business needs and create data solutions to meet those needs.
o Partners with stakeholders to build relationships and understand business objectives to deliver solutions aligned with organizational goals.
o Document solutions and maintain information libraries and data dictionaries.
o Other duties and projects as assigned.
Business Intelligence Developer Page 2 of 2
o Demonstrated ability to develop advanced SQL solutions to fully automate data-driven dashboards, reports, and workflows.
o Familiar with Qlik Sense / Tableau and can develop advanced solutions in either platform to drive data driven decisions.
o Understands the software development life cycle process and Agile methodologies.
o Strong written and verbal communication skills; can articulate complex concepts to non-technical audiences.
o Capable of independently troubleshooting reports, query and ETL issues.
o Someone who loves to learn and grow in data and analytics.
o 5+ years working with data and analytical solutions.
o 3+ years of hands-on experience working using MS SQL. Python experience is a plus.
o 3+ years of hands-on experience working in SSIS and SSRS.
o 3+ years of experience in Power BI building datasets and developing reports and dashboards.
o Able to comprehend data models and entity relationship diagrams.
o Experience with other data integration tools and platforms is a plus. Such as - snowflake, Salesforce BOOMI, Acumatica, REST API.
o Ability to work independently to research issues, gather information, troubleshoot, and prioritize tasks.
o College-level coursework, relevant certificates and/or commensurate experience required
o Domain knowledge of any dental/medical and insurance is a plus, but not required.
Scope of Authority:
o Works independently, proactively troubleshoots, plans work and executes with minimal oversight
o Prepares and/or develops plans for projects including leading meeting and working sessions including coordination with other departments
o Manages multiple projects at the same time with ability to execute effectively
o Must be willing to learn new technologies and grow in skill sets
o Primarily sitting or standing at a computer desk with regular exposure to computer monitors.
o Potential for tight deadlines or time periods of high workload might require additional hours.
o The noise level in the work environment is usually minimal.
o Light physical effort may be needed from time to time.