at AAAHC, Inc. in Deerfield, Illinois, United States
Job Description
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.
