Data Engineer - Dallas, United States - Ascendion

    Ascendion
    Ascendion Dallas, United States

    4 weeks ago

    Ascendion background
    Technology / Internet
    Description

    About Ascendion

    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. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.

    Ascendion | Engineering to elevate life

    We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:

    • Build the coolest tech for world's leading brands
    • Solve complex problems - and learn new skills
    • 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

    Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

    About the Role:

    Title: Data Engineer

    Responsibilities:

    • Analyze existing data sources and determine migration requirements, particularly from SQL to Snowflake.
    • Develop and maintain source to target (S2T) mapping documents.
    • Design and implement data integration solutions, leveraging ETL/ELT tools such as Apache Spark, Informatica PowerCenter/BDM, and SSIS.
    • Utilize programming/scripting languages such as Python to create custom ETL/ELT solutions.
    • Implement and optimize data models, particularly on star-schema model, for efficient data warehousing.
    • Collaborate with cross-functional teams in an Agile environment to deliver high-quality solutions.
    • Ensure data security measures are implemented in analytical systems.
    • Create and maintain documentation for data processes and procedures.
    • Stay updated with emerging technologies and best practices in data engineering.

    Requirements:

    • Bachelor's degree in Computer Science or equivalent field.
    • 8+ years of experience in data integration, data warehousing, and data modeling.
    • 7+ years of experience with relational database technologies such as SQL Server, Oracle, or Teradata.
    • 5+ years of experience with ETL/ELT tools like Apache Spark, Informatica PowerCenter/BDM, or SSIS.
    • Proficiency in SQL (T-SQL, MSSQL, TSQL, NoSQL) and programming/scripting languages, with Python being required.
    • Hands-on experience with Snowflake and developing on a Public Cloud Environment.
    • Familiarity with data visualization platforms like Tableau or Power BI.
    • Strong problem-solving skills and critical thinking ability.
    • Excellent communication skills with the ability to translate technical concepts to non-technical stakeholders.
    • Ability to work independently on multiple projects and prioritize workload effectively.
    • Experience with source control tools and Agile methodologies.

    Preferred Qualifications:

    • Management consulting experience is strongly preferred.
    • Experience working with large datasets and big data technologies, preferably cloud-based (e.g., Redshift, Databricks, Azure SQL Data Warehouse, MongoDB).

    Location: Hybrid in Dallas (2-3 days onsite)

    Salary Range: The salary for this position is between $130,000-140,000 annually. Factors that may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.

    Benefits: The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [long-term disability insurance] [short-term disability insurance] [5 personal day 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 day of paid vacation time] [6 paid holiday and 1 floating holiday per calendar year] [Ascendion Learning Management System]

    Want to change the world? Let us know.

    Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let's talk