About this position

Join Our Mission to Elevate Ambulatory Health Care

At AAAHC, we are more than just a team; we are at the forefront of improving health care quality through accreditation. Our employees are the heartbeat of our mission-based culture, dedicated to applying their diverse skill sets—technical, research, clinical, analytical, and data-driven—to improve health care quality through accreditation. As we celebrate over four decades of excellence, we invite you to become part of our story. Here, your work is not just a job; it’s a journey filled with opportunities to learn, grow, and contribute to a higher purpose. Embrace the chance to be part of a community that values quality every day and strives for excellence in ambulatory health care.

What do we offer?

We prioritize our employees’ wellbeing by providing a comprehensive benefits package that includes:

Compensation: Receive annual merit increase consideration and an annual discretionary bonus

Work-Life Balance: Enjoy generous paid holidays, increasing paid time off with tenure, and potential hybrid schedule eligibility

Health & Wellness: Take advantage of our medical, dental, and vision plans including company contributions to HSA as well as our wellness reimbursement benefit

Retirement Plan: Invest in your future with our robust 401(k) plan that includes a company contribution and match

Professional Development: Advance your career with ongoing training and educational opportunities along with a tuition reimbursement program

Life & Disability Insurance: Experience peace of mind with company-paid short/long-term disability, life, & AD&D insurance

Employee Assistance Program: Access support services for personal needs

Position Description

Reporting directly to the Assistant Director, Business Intelligence, the Database Developer, Business Intelligence is an important member of the BI team central to its ability to extract, transform, and load data from AAAHC proprietary software applications generating useful data sets and designing dashboards, reports and data streams necessary to meet business requirements. This includes gathering and interpreting data requirements, research and analysis, business design, data mapping, partnering with technology to develop data flow, and performing business testing. This position will be exposed to multiple data sources to align information with the business of AAAHC.

Transform data into insight that can help to improve the value of the business—guide operations, inform and validate business decisions, and increase value for our clients and regulatory partners.

SQL Server Database Development. Design, develop, and maintain robust SQL Server databases to store and manage business-critical data, ensuring efficient query performance, data integrity, and security. Develop effective T-SQL- Queries, Stored Procedures, Views, Triggers.
ETL Development. Extract, transform, and load (ETL) data from various source systems into the data warehouse using SSIS. Develop SSIS Package and ETL pipelines to ensure accurate and timely data integration.
Data Mapping and Transformation. Collaborate with business and technical teams to design data mappings, transformations, and workflows that align with business requirements and reporting standards.
Data Analysis and Reporting. Develop and generate complex queries, reports, and extracts from SQL Server databases to support business analysis and decision-making. Design and implement dashboards using Power BI.
Collaboration with Cross-functional Teams. Work closely with business analysts, data engineers, and other stakeholders to gather data requirements, interpret business needs, and ensure data solutions align with organizational goals.
Database Performance Tuning and Optimization. Identify and resolve performance issues, optimize query performance, and ensure the efficient use of database resources.
Data Quality Assurance and Testing. Conduct business testing to ensure the integrity and accuracy of data, validating against business requirements and ensuring successful data flows.
Cloud and On-Premises data Integration. Develop solutions that integrate data from both on-premises and cloud-based systems, ensuring seamless data flows across diverse platforms.
Documentation and Best Practices. Document database designs, ETL processes, and data flow architectures. Promote best practices for database development, security, and data governance.

Minimum Qualifications and Job-specific Competencies Required

Bachelor’s degree in computer science OR equivalent 2+ years’ experience in roles that demonstrate business analytics, project management, and coding proficiency

Superior research, analytical, planning, organizational skills, and detail-orientation

Ability to coordinate several tasks at one time and perform well under pressure: excellent time and project management

Ability to work independently, exercise mature professional judgment and use discretion.

Proactive self-starter, ready to take tasks from other domains, anticipation, feedback seeking, feedback providing, solution-oriented

Possess a sense of urgency, end-to-end responsibility, accountability for mistakes, continuous improvement, resourcefulness

Ability to interpret data into insights; data storytelling, detail-oriented

Prior academic or professional experience writing and troubleshooting T-SQL statements, and creating stored procedures, views, and SQL functions

Strong knowledge of Data Warehouse design techniques and a good understanding of Kimball data warehouse development methodologies

Experience designing, implementing, and optimizing data lakes, data marts, and star schemas, and a good understanding of related components and dependencies

Experience in logical and physical database design using relational database platforms including SQL Server and Oracle; demonstrated understanding of SQL Server database

Customer service oriented

Advanced proficiency with Microsoft Office (i.e., Outlook, Word, Excel, PowerPoint)

Preferred Qualifications

Recent health care-focused experience

Knowledge of health care accreditation and the regulatory environment

Experience developing ETL/ELT packages using SQL Server Integration Services (SSIS) to bring large, complex data sets from various sources into a data warehouse

Demonstrated proficiency using data visualization tools (e.g., Microsoft Power BI, Tableau, Qlik, Cognos)

Working Conditions & Travel Expectations

Estimated travel: <10%

Ability to commute to work at least 3 days per week

Physical Requirements

Sedentary work: Exerting up to 10 lbs of force occasionally, and/or a negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met.

Salary varies based on experience, location, and qualifications

Salary Information

$77000.0 - $90000.0 Annual Salary