> Markdown version of [/jobs/ext/1992660-reports-developer](https://www.wearedevelopers.com/jobs/ext/1992660-reports-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Reports Developer - **Company:** Atria Group LLC - **Location:** Vernon Hills, IL, United States - **Experience:** Expert - **Contract:** Temporary contract - **Skills:** Microsoft Access, Microsoft Word, Microsoft Excel, Microsoft Outlook, Unix, Software Documentation, Databases, Computer Literacy, Crystal Reports (Reporting Software), Data Cleansing, Data Conversion, Data Integration, Extract Transform Load (ETL), Data Warehousing, Revision Control Systems, IBM Cognos Business Intelligence, Microsoft Visio, Microsoft SQL Server, Oracle (Applications), Microsoft PowerPoint, Query Optimization, Standard Sql, Software Engineering, SQL Stored Procedures, PL-SQL, SQL*Plus, SQL Databases, Sap Business Objects, Er-Win, Toad (Software), Custom Reports - **Published:** August 8, 2026 - **Apply:** https://jobs.smartrecruiters.com/AtriaGroupLLC/87270484-reports-developer ## About the Role * Minimum of seven (7) years' Oracle, MS SQL, Data warehouse design and development experience required * Experience in designing and developing high volume transaction based systems required * Experience in SQL, SQL*Plus, SQL*Loader, Exp/Imp, Oracle scheduler, Advanced Queues, Object management, Informatica Power Center, PL/SQL development, stored procedures, and triggers required * Proficient in Toad, MS Access, Erwin, Visio, and Version Control tools required * Experience using bulk processing, DBMS packages required * Experience in analyzing query plans and query tuning, partitioning, and optimizer hints required * Experience in Data warehouse and Business Intelligence implementation required * Intermediate computer skills and proficiency in MS Word, Excel, PowerPoint and Outlook required ## Description * This position develops, tests, executes and documents database SQL programs for use in supporting disease management applications utilizing both Oracle and MS SQL technologies. * Development of custom reports and working with App Support team on a data cleanup project. * MS Access and Crystal Report experience is a must. * Delivery of documentation is required at end of the contract period., * Develop Packages, Stored Procedures, Triggers, and other PL/SQL and T-SQL programs. * Develop custom reports using Crystal Reports, Cognos, or Business Objects * Develop UNIX scripts to support batch processes or data conversion. * Optimize Queries, Stored Procedures, ETL process, and databases performance. * Gather and analyze business requirements for Data warehouse and Business Intelligence Projects. * Provide quality oversight for all activities related to data cleansing, data quality and data consolidation using standard data modeling methodologies and processes. * Write user documentation for database systems created and/or maintained by the department. ## Related Videos - [WeAreDevelopers LIVE - Node and Package Security](https://www.wearedevelopers.com/videos/2138-wearedevelopers-live-node-and-package-security) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [The Time Paradox: Building Timezone-Safe Python/Django Applications](https://www.wearedevelopers.com/videos/1915-the-time-paradox-building-timezone-safe-python-django-applications) - [Building with IBM Bob](https://www.wearedevelopers.com/videos/100275-building-with-ibm-bob) - [Valven Atlas: Engineering Intelligence That Delivers](https://www.wearedevelopers.com/videos/1660-valven-atlas-engineering-intelligence-that-delivers) - [Coffee with Developers - Robby Russell](https://www.wearedevelopers.com/videos/917-coffee-with-developers-robby-russell) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Quick guide: How to write a Software Developer CV](https://www.wearedevelopers.com/magazine/37-quick-guide-how-to-write-a-software-developer-cv) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers)