Data Engineer

at  J J Keller Associates Inc

Requisition #: 18271
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 the components of a business intelligence (BI) data warehouse (DW), perform data analysis, create/assist in creating reporting solutions and to maintain software solutions in support of business objectives. This includes developing database interfaces to on premise and online multi-tier web and client-server applications, maintaining databases, understanding and evaluating business requirements and translating them into solutions. This role works primarily on small to medium sized projects and/or those of medium complexity.

QUALIFICATIONS

Experience:

• 3+ years in a development or systems analysis role.
• 2+ years designing and managing a business intelligence/data warehouse.

Education:

• Bachelor’s Degree in a technology-related field.
• In lieu of the Bachelor’s Degree, an Associate’s Degree in a Computer Science or technology-related field combined with two years of additional related experience may be considered.

Computer Skills:

• Must be proficient in the use of a PC and MS Office Suite.
• Understanding of BI/DW methodology and techniques.
• Knowledge of data transformation.
• Familiarity with ETL tools and ETL processes.
• Familiarity with SQL and data modeling, including SQL Server Analysis Services BI stack (SSIS, SSAS, SSRS).
• T-SQL development and/or past DBA experience preferred.
• Experience setting up databases and CI/CD infrastructure with Azure tools desired.
• Proficient with Azure Synapse orchestration and transformation tools, Azure Data Factory, or Azure Databricks.
• Experience with reporting tools such as Tableau or Power BI strongly preferred.

Other Requirements:

• Effective analytical, 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.

JOB RESPONSIBILITIES

• Designs and develops data warehouse, data analysis and reporting solutions. Works with data visualization developers to determine solutions that help drive business value.
• Develops databases, objects, functions and structures for data storage, retrieval, and reporting.
• Designs and develops Extract, Transform and Load (ETL) solutions to populate the data warehouse.
• Develops automated and reusable routines for extracting requested information from database systems and/or enterprise management system.
• Defines, develops, tests, analyzes, and maintains software applications and back-end interfaces (if applicable) 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 the purpose of correcting errors, isolating areas for improvement and general debugging. Writes programming scripts to enhance functionality and/or performance of company applications as necessary.
• 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.
• Conducts research on emerging software development solutions and standards in support of business needs.
• Collaborates with business leaders to design solutions.