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.

TheDatabase/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!

Advanced Health Services remote jobs

Database/BI Developer