Database Developer (Data Warehouse)
Apply now »Date: Oct 3, 2024
Location: Chicago, IL, US, 60601
Company: J. J. Keller & Associates, Inc.
Functional Area: Software Development; Data Analytics
Employment Type: Full-Time
Work Options: Remote / Work from Home in the US #LI-Remote
Work Hours: Standard Business Hours
Position Summary
Join one of J. J. Keller's fastest growing business units as we protect people and the businesses they run! This NEW role is part of our Outsource Services area in Managed Services, where we provide services to help customers manage their safety and regulatory compliance programs. These services are heavily technology-enabled with this development team building internal-facing and external- facing applications to support service delivery.
The purpose of this EXCITING NEW position is to design and build components of a data warehouse (DW) to support business intelligence and data science initiatives. This positions work primarily involves small - medium sized projects and/or those of medium complexity.
This role can work 100% remote in the US, on-site at our Corporate Campus in Neenah, WI or hybrid.
Why work at J. J. Keller?
- Latest MS tech stack: Our projects use the latest MS tech stack, Microservices, CI/CD, Automated Testing, Cloud Architecture and Predictive Analytics / AI / ML.
- Emerging technologies: We strive to keep current with emerging technologies to prevent platforms from slipping into the dreaded “legacy applications” category.
- Native solutions: Our 200+ Developers are building J. J. Keller’s line of native cloud robust solutions (web/mobile/IoT) from the ground up. They are passionate about technology, growing their skills and doing meaningful work.
- User-centered focus: Although we still have some proprietary applications, we’re continually evolving our technology footprint to provide a better, more intuitive user experience for our customers.
- Collaborative environment: The average software development team has 7-10 Developers who work closely with our QA’s and a dedicated Product Management team (Product Owner, Business Analyst & UI/UX resource).
- 80% Remote: We’ve embraced remote work for many years – long before the pandemic – so you can work remotely and feel confident in joining our remote culture.
Job 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.
Qualifications
Experience:
- 3+ years designing and managing a data warehouse in a development role.
Education:
- Bachelor's Degree in a technology-related field.
- In lieu of Degree, may consider an equivalent combination of education and related work experience.
Computer Skills:
- Understanding of data warehouse methodology and techniques.
- Experience with data modeling.
- Familiarity with Data Warehouse and ETL processes.
- Familiarity with Azure is desirable.
Other Requirements:
- Aalytical, troubleshooting, and problem-solving skills – 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
J. J. Keller is #66 / 600 on Fobes list of America's Best Employers for Women in 2024!
We Protect People & The Businesses They Run™
Every associate at J. J. Keller makes a difference by creating safer, more respectful workplaces. Whether serving our customers directly with expertise in safety and regulatory compliance or supporting the business with specialized skills, together we contribute to better workplaces for people across North America.
J. J. Keller History: November 1, 2023, marked 70 years of business for J. J. Keller & Associates, Inc. Click HERE to take a tour through three generations of this family-owned business – from our founding as a one-man consulting firm through decades of delivering on our purpose of protecting people and the businesses they run.
J. J. Keller Career Stories: Click HERE to hear from our associates about what they have to say about life as an associate at J. J. Keller.
J. J. Keller Earns 7th Great Place to Work Certification™: Click HERE to find out what makes J. J. Keller great.
J. J. Keller Certified as a Top 100 Most Loved Workplace® in America: Click HERE to find out why our associates LOVE working at J. J. Keller.
2023 Top Company for Women to Work for in Transportation: Click HERE to learn more about this prestigious recognition.
J. J. Keller provides a competitive benefit package which includes the following (eligibility requirements apply): Medical, Dental, and Vision Insurance, 401(k) and Profit Sharing Plan, etc. The compensation range for this role is $89,000.00 to $104,000.00 which varies depending on factors including, but not limited to, a candidate’s overall experience and geographic location. Note that J. J. Keller is not currently recruiting employees to work in California.
If you experience system-related issues or need assistance with the online application, please call (920) 720-7700.
Professional Referral Program: Not the right role for you, but know someone who could be a great fit? Click HERE to refer them to us through our Professional Referral Program and you will earn a cash payment if your referral is hired.
J. J. Keller & Associates, Inc. is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class.
Nearest Major Market: Chicago
Job Segment:
Data Warehouse, Database, Cloud, Compliance, Testing, Technology, Legal