Data Engineer

• Role: Data Engineer
• Location: Remote US
• Full time role

Strict instruction don’t submit consultants more than 8 to 12 years

Job description:

Overview /Objective:

Our Sports Analytics & Engineering Practice is seeking a seasoned Senior Data Engineer, whose primary focus would be defining and bringing our client’s vision for their ultra-modern data environment to life. These data assets will be used across business & data analytics teams and will become the core repository for their data needs. This involves discovering needs for data stakeholders, architecting solutions, and building infrastructure to transform raw data into high-value data assets that support those needs. Building these cloud-centric assets will be key in driving the mission to build word class customer data platform. We are looking for an individual who cares about organizing data into reusable and maintainable components and can bring their energy to helping us grow this function.

Responsibilities:

• You will leverage your experience and skills with Data Modeling, SQL, Jinja templating and DBT to build robust, performant, and reliable data transformation and feature extraction pipelines
• Collaborate with business and technical team members to collect business requirements to deliver best-in-class dimensional data models to serve as single-source-of-truth for product, customer, and marketing analytics
• Design, develop and maintain the data architecture, data models and standards for various Data Integration & Data Warehouse projects in DBT & Redshift
• Full stack ownership of data models in DBT to supercharge analysts, data scientists, and BI engineers
• Define, develop, and enhance the dbt/SQL codebase and companion ERD documents used to bring the Analytics Warehouse to life
• Analyze the data quality, align technical design to data governance, address all the required non-business but operational requirements during the design and build of data pipelines
• Apply software engineering best practices like version control and continuous integration to the analytics code base

Required Qualifications:

• Bachelor’s or Master’s (preferred) degree in in a quantitative or technical field such as Statistics, Mathematics, Computer Science, Information Technology, Computer Engineering or equivalent
• 5+ years of experience and progressive responsibility in data and analytics and modern data platforms
• 5+ years writing SQL with advanced level knowledge, including various join types, CTEs, partitioning, pivoting, and aggregates
• 4+ years’ extensive experience with DBT or similar data transformation tools, including building complex & maintainable DBT models and developing DBT packages/macros
• Deep familiarity with dimensional modeling/data warehousing concepts and expertise in designing, implementing, operating, and extending enterprise dimensional models
• Understand change data capture concepts
• Experience working with Cloud data platforms, preferably AWS (Lambda, Step Functions, S3, Glue, Athena, Redshift)
• Python proficiency or general knowledge of Jinja templating in Python and/or PySpark is a plus
• Understanding of the full software lifecycle and how development teams should work with DevOps to create more software, faster
• Agile experience and willingness to work with extended offshore teams and assist with design and code reviews with customer
• A great teammate and self-starter, strong detail orientation is critical in this role.

Email: [email protected]