This is a permanent, full-time position.
Jenzabar is seeking an ETL Developer to become part of an Agile/Lean product team who is designing, developing and deploying our next-generation enterprise data warehouse product. The ETL Developer, will be actively responsible for designing the data storage systems for the product and building the staging data. This role will also serve as a technical expert and resource collaborating with the Data Architect, Modelers, BI Developers, and Product Team to develop and deliver data storage and movement solutions and to organize and oversee the loading of data into the related systems.
Work closely with Senior ETL Developer and Product team to achieve company business objectives.
Architect, design, develop and deploy ETL infrastructures using data warehouse design best practices, with a focus on high availability, performance, scalability and maintainability.
Evaluate existing and emerging technologies and their potential to enhance the performance and robustness of a technical architecture. Research and experiment with emerging ETL technologies and tools related to Big Data.
Coding ELT/ETL, but also includes data structure analysis and data profiling of source data systems.
Traditional DBA skills, including understanding standard structures, such as Star Schema.
DevOps--Ability to understand and/or code cloud operations and infrastructure.
Ability to relate technical content to non-technical audience, including clients.
Proficiency using common source control systems and understand versioning concepts.
Ability to work in an Agile/Lean environment and team.
Ability to create useful documentation for code and processes, including basic graphical content.
PREFERRED SKILLS AND EXPERIENCE
Bachelors Degree in a technology area of study; preferably in Computer Science, MIS or Analytics.
3+ years ETL development experience using one or more of the following data toolsets: Python, R, or SSIS.
4+ years of experience in relational and data warehouse database design.
Familiarity with one or more of the following areas:
o* Developing web API--Microservices tools needed by the team or end users, including a web or mobile front end.
o* Creating reports, dashboards, charts using one or more of Power BI, Cognos or notebook (e.g., R markdown)
o* Using data scientist tools like R to build descriptive or predictive models for data analysis.
o* Designing and deploying multi-tenant Cloud solutions.
Medical Insurance, Life Insurance, Dental Insurance, Vision Insurance, Paid Vacation, Paid Sick Days, Paid Holidays, Short Term Disability, Long Term Disability, 401K/403b Plan, Educational Assistance