This position will work tightly with the functional leads and analysts on the Global Operations Data Analytics team to create the data infrastructure and pipelines to drive our financial and operational analytics platform, from initial experimentation to production level deployment. The analytics engineer will work across diverse functional, business, and finance teams. This position will work on critical data engineering problems, prototyping, and building unique high quality reliable, accurate, consistent and architecturally sound data sets that are aligned with our business needs.
This position is also responsible for functioning as the Subject Matter Expert (SME) for Snowflake cloud database development although will also need to operate across other source systems/technologies (e.g., Salesforce, SAP, AS400, Oracle, MySQL, etc.). This individual will work very closely with the other members of the team to build and maintain different zones of the Snowflake data lake environment. Partnering with the existing Data Analytics and Insights team, they will determine the optimal approach for extracting, transforming and loading data into different zones of Snowflake data lake (Raw/Native, Processed/Transformed, Enriched, Archive). This includes design and development to prepare data for movement storage & consumption, views, ETL processes, extracts and other processes that manipulate, error trap, aggregate, clean, or enrich the data.
This data lake will evolve with regular planned addition of datasets from internal and external sources deemed important for Wiley’s data analytics and insights requirements. In some cases, this role may involve building repeatable data feeds to and from platforms such as, Salesforce, SAP, ecommerce websites, etc. The position requires development skills to enable matching and linking of internal and external data sources using analytical techniques/tools. It also involves researching against other source data sets, profiling and mapping to those targets.
This role will require an individual who can work with minimal supervision on a wide range of projects interfacing with functional leads, financial analysts, management, and business units while constantly ensuring that their work is aligned with the Data Analytics & Insights team’s strategic direction. He/she will be expected to stay current on technology and technique developments in cloud computing space while also continuing to grow their knowledge of the Wiley’s business.
Design, develop, test, implement, and support an analytical data infrastructure
Interface with other teams to extract, transform, and load data from a wide variety of data sources
Collaborate with functional leads to recognize and help adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
Help continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers
Explore and learn the latest data engineering technologies to provide new capabilities and increase efficiency
Perform source data analysis and qualification for inclusion into the Operations Data Lake
Create meta data dictionaries, data flows and other critical documentation
Bachelor’s degree in Computer Science or related field
Hands-on experience with Snowflake development/implementation
5 + years’ experience developing ETL, ELT and Data Warehousing solutions
5 + years’ experience developing SQL scripts and stored procedures that processes data from databases
5 + years’ experience with batch job scheduling and identifying data/job dependencies
Strong understanding of various data formats such as CSV, XML, JSON, etc.
1+ years’ experience with Snowflake cloud-based database.
1+ years’ experience with Snowflake SnowSQL and writing user defined functions
Highly proficient in database technologies including RDBMS, DW/DL, Cloud, NoSQL
Knowledge of ETL development & advanced SQL querying.
Experience with Data profiling tools and data cleansing tools
Proficiency in SQL
Experience with at least one statistical or scripting language/tool such as Python/R/SAS/SPSS
Ability to work independently
Ability to maintain technical proficiency
Strong analytical problem-solving skills
Strong verbal and written communication skills
Ability to multi-task
Wiley is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics.
To apply for this job please visit www.linkedin.com.