Full-time employee
Holland, OH or Toledo metropolitan area
Must be able to work on-site
For over 30 years, Midwest Tape has served libraries and their patrons with unparalleled access to the best content available in the media world. Our digital offering, hoopla Digital, combines the media and library expertise of Midwest Tape with the latest in web and mobile technology, delivering an all-in-one experience to the library world. As hoopla continues to grow on a global scale, we are expanding our team.
At Midwest Tape, we know our people are the reason for our success. We value our employees and believe in empowering them to help them thrive. We offer competitive pay and benefits, a healthy work/life balance, and appreciation for a job well done.
Position Summary:
Enhance and maintain data, data retrieval, and ETL data using .NET coding. Provide production support and react to potential issues through error reporting and exception notices. Analyze user requirements and resolve logical problems to design and develop robust and scalable information delivery solutions. Review current systems, present ideas for system improvements, and devise possible solutions to anticipated problems. Provide accurate estimates of the effort required to complete assignments while working closely with business teams. Provide support for deployment of reports and analytics in test and production environments. Integrate new data silos into the business delivery platforms. Work in IT to provide further capacity as a bridge between IT systems and the analytics department. Work with other data managers and DBAs to deliver information and reliability to the business.
Primary Duties and Responsibilities:
-
Interact and develop new ETL and logical services in .NET frameworks.
-
Create programs to integrate and pull data from third parties and decoupled data sources into organized local data stores.
-
Design and deliver enhancements to the business intelligence data and technologies.
-
Research and debug potential information ingestion and data transformation processes.
-
Collaborate with third-party experts to accelerate projects in order to deliver more accurate and robust information.
-
Follow all phases of the project life cycle including analysis, design, development, testing, deployment and post-production support/maintenance for assigned projects.
-
Review project tasks and provide accurate estimates for completion timelines.
-
Create technical specifications for assigned projects.
-
Communicate status of project tasks to senior team members and management as required.
-
Demonstrate effective and collaborative communication with internal team members and all business partners.
Skills:
-
Scripting and scheduling ETL jobs in information systems.
-
Knowledge of information delivery concepts such as summary, cube, dimension, and fact stores
-
Use Oracle PL/SQL or PL/PGSQL (procedural languages).
-
Some Oracle and PostgreSQL tuning experience.
-
Some experience coding HTML simple displays
-
Knowledge of AWS technologies.
Preferred Education Requirements:
-
Bachelor's degree in computer science, related area, or equivalent work experience.
-
Courses or certificates in modern development languages, information delivery, and enterprise data warehouse software.
Preferred Experience:
-
Minimum 5+ years’ experience in advanced information delivery and business intelligence.
-
Experience with data lake architecture and ideally AWS Redshift Ecosystems.
-
Previous experience as a software developer or similar role.
-
Experience with Oracle and PostgreSQL data stores.
-
Experience with NoSQL metric stores preferably AWS Redshift.
-
Experience presenting data findings and information insight drafts to business stakeholders.
-
Experience working with outside resources through conferencing and specifications.
Physical Requirements / Work Environment:
The work environment characteristics and physical demands described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
-
Ability to regularly sit for extended periods of time.
-
Perform repetitive motion type tasks.
-
Able to be present for meetings, trainings, and presentations that take place onsite or virtually.
Benefits:
-
Medical, dental, & vision insurance
-
401k + match
-
Profit sharing
-
Paid vacation and personal time
-
Flex time
-
10 paid holidays
-
Company performance bonus
-
Holiday bonus
-
Paid time to volunteer
-
Training & career development opportunities
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
