Database Developer (Data Warehouse)

$89,000 - $104,000/Yr

J. J. Keller & Associates - Chicago, IL

Full-time - Mid Level

Remote - Chicago, IL

501-1,000 employees

Professional, Scientific, and Technical Services

About the position

This position is part of J. J. Keller's Outsource Services area in Managed Services, focusing on designing and building components of a data warehouse to support business intelligence and data science initiatives. The role involves working on small to medium-sized projects, primarily in a remote capacity, and aims to enhance safety and regulatory compliance programs through technology-enabled solutions.

Responsibilities

• Designs and builds data warehouses and reporting solutions.
• Works with data visualization tools to develop solutions that help drive business value.
• Designs and develops Extract, Transform and Load (ETL) solutions to populate the data warehouse.
• Develops automated and reusable routines for extracting requested information from source systems.
• Defines, develops, tests, analyzes and maintains front-end and back-end interfaces in support of business objectives.
• Builds report and analytic prototypes based on initial business requirements.
• Designs, runs and monitors performance tests on new and existing systems for correcting errors, isolating areas for improvement and general debugging.
• Promotes strong quality practices by performing unit testing and providing appropriate level of support for user acceptance testing, as needed.
• Acts as a support resource for the technical support staff to ensure that customer-reported issues are being addressed in an efficient and accurate manner.
• Serves as a liaison with database administrators, developers and vendors (if needed) to assist in resolving problems with systems.
• Maintains and tests the data warehouse in compliance with the company's disaster recovery plan.
• Trains end users on new or modified applications and reports.
• Conducts research on emerging software development solutions, tools and standards in support of business needs.

Requirements

• 3+ years designing and managing a data warehouse in a development role.
• Bachelor's Degree in a technology-related field, or equivalent combination of education and related work experience.
• Understanding of data warehouse methodology and techniques.
• Experience with data modeling.
• Familiarity with Data Warehouse and ETL processes.
• Familiarity with Azure is desirable.
• Analytical, troubleshooting, and problem-solving skills.

Nice-to-haves

• Experience in analyzing and understanding business/technology system architectures, databases, and client applications.
• Ability to work with business and technology users to define and gather reporting and analytics requirements.

Benefits

• Medical / Dental / Vision Insurance
• Annual Reviews, Merit Increases + Quarterly Bonus Program
• 401(k) with Employer Match + Annual Profit Sharing
• 17 PTO Days + 8 Paid Company Holidays + 1 Paid Floating Holiday
• Work/Life Balance & Flex Time
• Annual Learning & Development Subscriptions
• Free Onsite Wellness Clinic for those associates near our corporate office + free telehealth coverage for all associates regardless of where you live
• Free access to FLEX by Fitness on Demand providing 24/7 access to online workout videos
• Strong company culture that fosters internal growth and development
• Computer Equipment Provided for Home Office