Data Engineer

World Wide Technology is hiring a Data Engineer for its Internal IT Services and Consulting Analytics team. The role architects, develops, and maintains data pipelines, ETL processes, integrations, and data models to support analytics reporting and AI tools across the company.

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
• 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
• Support and debug issues in production environment and be part of production support, across several reporting toolsets
• 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
• 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”
• Flexibility to work as a member of a matrix based diverse and geographically distributed project teams

Preferred

• Oracle Data Integrator preferred
• Oracle Data Integrator

Benefits

• For all full-time employees: Health (Medical & Prescription), Dental, and Vision Care
• For all full-time employees: Onsite Health Centers (MO & IL)
• For all full-time employees: Employee Assistance Program
• For all full-time employees: Wellness program
• For all full-time employees: Profit Sharing
• For all full-time employees: 401k Plan with Company Matching
• For all full-time employees: Life and Disability Insurance
• For all full-time employees: Flexible Spending Accounts
• For all full-time employees: Tuition Reimbursement
• For all full-time employees: PTO & Holidays
• For all full-time employees: Parental Leave
• For all full-time employees: Medical Leave
• For all full-time employees: Military Leave
• For all full-time employees: Bereavement
• For all full-time employees: Day of Caring
• For all full-time employees: Family Planning Benefits
• For all full-time employees: Nursing Mothers Benefits
• For all full-time employees: Voluntary Legal
• For all full-time employees: Voluntary Supplemental Accident/Illness/Hospital
• For all full-time employees: Voluntary ID Theft
• For all full-time employees: Pet Insurance
• For all full-time employees: Employee Discount Program
• Remote work (#LI-REMOTE)

Company

• Technology services for digital transformation and IT modernization
• Maryland Heights, Missouri, USA
• http://www.wwt.com/
• Founded in 1990
• 10001+ employees

Qualifications

• Bachelor's degree – Computer Science or a minimum of 5 years' progressive experience in a related field
• 3+ years of experience in analytics, SQL, and/or ETL development
• Proficiency in data warehousing/business intelligence development/data modeling
• 3+ years' experience building large scale data sources in Oracle or equivalent relational databases
• Have excellent SQL skills with PL/SQL development experience
• Hands-on development experience using an ETL tool
• Hands-on development experience with Snowflake/Snowpipe
• Strong analytical and problem-solving capabilities
• Experience with BI reporting tools like Tableau, Power BI
• Programming skills: Java, 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, including Data Lake, Data Warehouse and Data Lakehouse
• Experience with Cloud-based environment, Saas / Raas
• Experience with any of the cloud warehousing products g. Databricks, Snowflake, Redshift, etc
• Experience in designing Data Architecture and pipelines
• Proficient in performance tuning and debugging
• Experience required to work in a fast-paced environment with a focus on delivering customer satisfaction
• Must be authorized to work within the US
• We will not be able to sponsor employment for this position
• Oracle Data Integrator preferred
• Bachelor’s degree – Computer Science or a minimum of 5 years’ progressive experience in a related field.
• 3+ years of experience in analytics, SQL, and/or ETL development.
• 3+ years’ experience building large scale data sources in Oracle or equivalent relational databases

Required skills

• Data Modeling, Data Warehousing, ETL Development, Java, Jenkins, Oracle Data Integrator, PL/SQL, Power BI, Python, SQL, Snowflake/Snowpipe, Tableau

Preferred skills

• Oracle Data Integrator preferred

Experience

• 3+ years