Advanced Health Services

Compensation

Full Description

Advanced Health Services, LLC (AHS), a wholly-owned subsidiary of Delta Dental of Idaho, is an Idaho-based company providing information technology services and support for organizations in the healthcare industry. Here you'll use your technology skills to help improve the oral health of our community. AHS offers the following services: Custom web and application development and support Business intelligence and data analytics Cybersecurity program development and management IT network and help desk management We have a flexible, forward-thinking culture with trust at its heart. What does that mean? Our working model provides employees opportunities for brainstorming, team building, and co-creating balanced with options to work from home. We understand that personal preferences, work contexts, and key tasks all impact where team members feel most energized, whether at home or in the office. Join our team committed to making a difference in people's lives while working in an environment full of challenge, collaboration, flexibility, and industry-leading growth potential. The Database/BI Developer will design and build databases and data models to support efficient data storage, processing, and analysis. This position will create reports, dashboards, and visualizations to deliver actionable business insights and support data-driven decision-making. This role also involves collaborating with stakeholders to define KPIs and ensure reporting aligns with business objectives, while maintaining data quality and integrity across sources. ESSENTIAL FUNCTIONS Collaborate with Developers and other business stakeholders to design, develop, enhance and maintain reporting solutions. Develop and optimize SQL queries and stored procedures. Design, develop, and maintain business intelligence solutions, including reports, dashboards, and data visualizations (Power BI and Crystal Reports). Recommend application enhancements to automated repetitive tasks. Execute ad hoc database queries and conduct data analysis and updates. Monitor, support, and enhance our EDI, ETL and automated job processes to ensure accurate and timely execution. Enhance automated data movement reconciliations increasing data accuracy and integrity Perform database schema deployments to Testing, Stage and Production environments on a frequent basis. Assist with implementation, enhancement, maintenance, and integrity of data warehouse solutions. Develop and update technical documentation for data models, ETL processes, and BI solutions. Improve processes and standards in partnership with the team to ensure cohesion and high-quality results. Monitor and adapt to industry trends and best practices related to BI and ETL methodologies and technologies. Demonstrate a commitment to the organization’s core values, code of ethics, and compliance/security standards. Perform other duties, as assigned KNOWLEDGE, SKILLS, AND ABILITIES Bachelor’s degree in Computer Science, Information Systems, or related field; equivalent work experience may be considered. In-depth understanding of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS). In-depth understanding of database management systems and ETL (extract, transform, load) frameworks. Proven capability to interpret business requirements and develop technical .specifications and solutions aligned with the appropriate scope and complexity. Commitment to ongoing learning and incorporating AI to streamline and improve process flow. Proven capability to operate with autonomy while delivering leadership in business intelligence, data analytics, and ETL areas. Experience with online analytical processing (OLAP) preferred. Experience with cloud data platforms. Experience with a modern Reporting/BI platform (Power BI, Crystal Reports). Experience with the following technologies preferred: SQL Server 2019 or newer, Power BI, Source control (e.g. Github AI), Atlassian JIRA, Crystal Reports 10, Snowflake. PHYSICAL AND MENTAL REQUIREMENTS Sitting/Standing (alternatively) continuously Keyboard Use/Repetitive Hand motion continuously Skill/ability related to comprehension, organization, reasoning/decision-making and communication appropriate to position/level OUR CULTURE AHS seeks to provide a positive workplace where employees are treated with respect, and all are accountable for living our values and Code of Ethics while empowered to help the organization succeed in achieving its mission and vision. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status. Individuals that may need assistance with the applicant or interview process may contact human resources at amiles@deltadentalid.com or by phone: 208-488-7741. Advanced Health Services offers a competitive benefits plan including: Medical, dental, and vision 401K with up to 6% company contribution Generous PTO and up to 9 paid holidays Community Service Time Flexible schedule and 1/2 day Fridays Tuition and continuing education reimbursement Casual dress code ...and more!