Database Developer at Accreditation Association for Ambulatory Health Care (AAAHC) in Deerfield, Illinois

Job Description:

Position Title: Database Developer

Worker Category: FT Benefits Eligible Full-Time

Job class: Professional

Location: Deerfield, IL, US

Requisition ID: 1216

Salary Range: $77,000.00 To $90,000.00 Annually

Description:

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:

• Health & Wellness: Take advantage of our medical, dental, and vision plans 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
• Life & Disability Insurance: Experience peace of mind with company-paid short/long-term disability, life, & AD&D insurance
• Professional Development: Advance your career with ongoing training and educational opportunities
• Employee Assistance Program: Access support services for personal needs
• Work-Life Balance: Enjoy generous paid company holidays and paid time off that increase with tenure

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 4+ 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
• Minimum 2 years of demonstrated 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 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 Microsoft Power BI data visualization tools
• 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

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.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

PI256439298

Salary:

$77,000.00

Apply Now