Database Developer (Data Warehouse)

$93,000 - $108,000/Yr

J. J. Keller & Associates - Austin, TX

Full-time - Mid Level

Remote - Austin, TX

501-1,000 employees

Professional, Scientific, and Technical Services

About the position

The Database Developer (Data Warehouse) role at J. J. Keller & Associates, Inc. is a new position within the Outsource Services area of Managed Services. This role focuses on designing and building components of a data warehouse to support business intelligence and data science initiatives. The position involves working on small to medium-sized projects and requires collaboration with various teams to enhance service delivery 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