Database Developer

Accreditation Associati • Deerfield, IL

4h • Hybrid

About The Position

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.

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. 

Requirements

• 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)

Nice To Haves

• 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)

Responsibilities

• 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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level