Data Engineer (T-SQL / Azure)

Requisition # : 19550

Functional Area : Software Development; Data Analytics; Engineering

Employment Type : Full-Time

Work Options : Remote / Work from Home in the US #LI-Remote

Work Hours : Standard Business Hours

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.

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.

This role can work 100% remote in the US, on-site at our Corporate Campus in Neenah, WI or hybrid.

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.

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 :

• Understanding of BI / DW methodology and techniques.
• Familiarity with ETL tools and ETL processes.
• Knowledge of data transformation.
• Proficient with Azure Synapse orchestration and transformation tools, Azure Data Factory, or Azure Databricks.
• 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.
• 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.

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

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 $98,000.00 to $115,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 Programand 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 : Milwaukee

Job Segment : Cloud, R&D Engineer, Testing, SQL, Database, Technology, Engineering