Associate Manager – Data Engineer

Tredence Inc. is a data and analytics consulting firm, and they are seeking an Associate Manager – Data Engineer. The role involves designing and implementing ETL data pipelines, ensuring data quality, and collaborating with stakeholders to meet their data needs.

Responsibilities:

• Comprehensively understand the business objectives and technical requirements of data engineering project
• This requires collaborating closely with stakeholders to grasp their data needs and desired outcomes
• Design and implement ETL data pipelines which involve the planning and execution of processes aimed at efficiently transferring data from source(cloud/on-prem) to the data warehouse
• Utilize dimensional modeling principles to organize data into fact and dimension tables to support diverse analytical queries and reporting requirements
• Analyze the data quality, align the technical design to data governance, and address all the required non-business but operational requirements during the design and build of data pipelines
• Advanced SQL knowledge and hands-on experience in complex query writing using Analytical functions
• Provide advice, guidance, and best practices around Snowflake
• Implement robust security and access control policies within the Snowflake environment
• Ensure the delivery and quality assurance of data pipelines, dashboards and conduct thorough troubleshooting before promoting changes to production
• Leverage Snowpark for advanced transformation and data science workloads
• Collaborate with business users and stakeholders to gather feedback and ensure alignment with business objectives
• Engage proactively with stakeholders and collaborate on managing Jira sprints, including task allocation, sprint planning, backlog refinement, and retrospective meetings

Requirements:

• Bachelor's degree (or foreign equivalent) in Data Science, Engineering (any), or related field
• Five (5) years of experience in the job offered or a related position
• Demonstrable knowledge of: Snowflake
• Demonstrable knowledge of: SQL
• Demonstrable knowledge of: Python
• Demonstrable knowledge of: Apache Spark
• Demonstrable knowledge of: Airflow
• Demonstrable knowledge of: Talend
• Demonstrable knowledge of: Data Modelling
• Demonstrable knowledge of: Data Warehousing
• Demonstrable knowledge of: Tableau
• Demonstrable knowledge of: PowerBI
• Demonstrable knowledge of: Data Governance & Security
• Travel to unanticipated client locations throughout the U.S. approximately 30%, as required
• May telecommute from any location within the U.S