Data Engineer Data Analytics - Dallas, TX, United States - Ascendion Inc.

Description

Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. We have a culture built on opportunity, inclusion, and a spirit of partnership. Build the coolest tech for world's leading brands
Experience the power of transforming digital engineering for Fortune 500 clients
Master your craft with leading training programs and hands-on experience

Experience a community of change makers


Title:
Data Engineer

8+ years' experience in data integration, data warehousing, and data modeling, preferably recent,
7+ years' experience with relational database technologies (SQL Server, Oracle, Teradata, or similar)
5+ years' experience with ETL/ELT tools such as Apache Spark, Informatica PowerCenter/BDM, SSIS, AWS Glue, DataStage, or similar
Experience with custom ETL/ELT and programming/scripting language experience: Python, PHP, Perl, or Scala (Python required)
Experience with data migration from SQL to snowflake preferred
Analyze existing data sources and determine migration requirements.
Ability to document source to target (S2T) mapping documents
Expert knowledge of SQL (T-SQL, MSSQL, TSQL and NoSQL) including programmability features and techniques, as well as best practices for performance and readability
Current experience with developing on a Public Cloud Environment (Snowflake preferred)
Experience in development, design, and application of data modeling (on star-schema model), data mining and data architecture concepts and techniques
Experience working in an Agile team and delivery capability.
Ability to work independently on multiple projects and prioritize workload.
Familiarity with Data Visualization platforms (e.g. Tableau, Power BI)
BS Degree or equivalent required in Computer Science or similar area of study. > Experience working with large datasets and big data technologies, preferably cloud-based, such as Redshift, Snowflake, Databricks, Azure SQL Data Warehouse, MongoDB, Cosmos, or similar

medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [long-term disability insurance] [short-term disability insurance] [5 personal days accrued each calendar year.

The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State] [10-15 days of paid vacation time] [6 paid holidays and 1 floating holiday per calendar year] [Ascendion Learning Management System]