Senior Data Engineer (HCM/HR Analytics)

World Wide Technology is a technology solutions company whose internal IT team manages the organization’s technology infrastructure, data systems, and analytics capabilities. The Senior Data Engineer will architect and maintain data pipelines and ETL processes, build integrations and complex data models, and support data-driven decision-making across functional areas.

Responsibilities:

• Support our Analytics partners embedded in the business, providing data to analysts across the company
• Be an equal member of a cohesive and selfless team
• Take complete ownership of your work with the goal of exceeding customer expectations
• Work closely with analysts, developers, and data architects to ensure development meets requirements and delivers optimal performance
• Consult on the design, development, and implementation of innovative solutions to complicated data issues which enhance traditional star-schema data structures
• Expertise in Data Engineering and implement multiple end-to-end DW projects in Big Data environment
• Support and debug issues in production environment and be part of production support, across several reporting toolsets
• Work in an agile team – plan, prioritize design, test, and coordinate end-to-end delivery of solutions
• Embrace the opportunity to expand your skillset both functionally and technically
• Design, create, and implement complex data models (including canonical, conceptual, logical, and physical models)
• Implement new design methodologies
• Build, scale, and maintain our data infrastructure and data products
• Implement physical database models and tune SQL
• Use ANSI SQL and/or PL/SQL to perform data analysis
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and “big data” technologies
• Flexibility to work as a member of a matrix based diverse and geographically distributed project teams

Requirements:

• Experience with HCM/HR data
• Bachelor's degree – Computer Science or a minimum of 5 years' progressive experience in a related field
• 5+ years of experience in analytics, SQL, and/or ETL development
• Proficiency in data warehousing/business intelligence development/data modeling
• 5+ years' experience building large scale data sources in Oracle or equivalent relational database
• 3+ years' experience using API platforms such as MuleSoft / APIGee and ELT platform such as Matillion or Informatica
• Have excellent SQL skills with PL/SQL development experience
• Hands-on development experience using an ETL tool
• Strong analytical and problem-solving capabilities
• Experience with BI reporting tools like Tableau, Power BI
• Programming skills: Java, Scala, Python
• Expertise with CI/CD pipeline and integration tools e.g., Jenkins, GIT
• Understand an analytics platform, its use-cases, and best practices
• Experience working with different types of data stores (RDMS, Flat Files, Columnar DBs, etc.)
• Strong understanding of dimensional modeling, data lakes, and data vault
• Experience with Cloud-based environment, Saas
• Experience with any of the cloud warehousing products e.g. Databricks, Snowflake, Redshift, etc
• Experience with MS Power Platform
• Experience working with cloud environments Azure
• Experience in designing Data Architecture and pipelines
• Proficient in performance tuning and debugging
• Must be authorized to work within the US. We will not be able to sponsor employment for this position
• Oracle Data Integrator preferred
• Hands-on development experience with Oracle Cloud reporting and data replication; Business Intelligence Cloud Connector Console, BI Publisher, and OTBI preferred