Accreditation Association for Ambulatory Health Care (AAAHC) · 7 hours ago
Database Developer
Deerfield, IL
Full-time
Hybrid
Entry, Mid Level
2+ years expThe Accreditation Association for Ambulatory Health Care (AAAHC) is dedicated to improving health care quality through accreditation. The Database Developer will be responsible for SQL Server database development, ETL processes, data analysis, and ensuring data quality to support the organization's business intelligence needs.
Non ProfitHealthcareHealth CareMedical
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
Qualification
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
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)
Benefits
Receive annual merit increase consideration and an annual discretionary bonus
Enjoy generous paid holidays, increasing paid time off with tenure, and potential hybrid schedule eligibility
Take advantage of our medical, dental, and vision plans including company contributions to HSA as well as our wellness reimbursement benefit
Invest in your future with our robust 401(k) plan that includes a company contribution and match
Advance your career with ongoing training and educational opportunities along with a tuition reimbursement program
Experience peace of mind with company-paid short/long-term disability, life, & AD&D insurance
Access support services for personal needs
Company
Accreditation Association for Ambulatory Health Care (AAAHC)
Founded in 1979, AAAHC is the leader in ambulatory health care accreditation, with more than 6,800 organizations accredited.
51-200 employees
H1B Sponsorship
Accreditation Association for Ambulatory Health Care (AAAHC) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
Funding
Current Stage
Growth StageLeadership Team
Noel Adachi
President & Chief Executive Officer
Kathy Fagan Dale
Senior Vice President-CFO, IT & Administration
Recent News
2024-03-13
2023-10-30
2022-12-10
Company data provided by crunchbase