Job Title: ETL Lead Architect
Location: Seattle, WA
Job Description:
Primary Skill : Sql,
Secondary Skill: Snowflake, Qlik Sense, Tableau, Data Modelling
Location: Seattle, WA
Job Description:
Primary Skill : Sql,
Secondary Skill: Snowflake, Qlik Sense, Tableau, Data Modelling
- 12+ years of overall experience in IT Industry on Data Architecture, Data Analytics, Data Modeling and Designing BI Solutions
- Develop complex SQL queries, scripts, user defined functions, views, and triggers for business logic implementation
- Develop and own ETL Data Pipeline and Data Model solutions for integrating new data sets
- Strong experience in Sql, SSIS, Python, Spark, Scala, Azure Databricks , DevOps build & release automations
- Good experience on design and build Data Lakes and Data Pipelines, metadata driven Acquisition & Transformation
- Good experience in Sql Azure & Snowflake cloud warehouse to design, build & deploy different reporting solutions
- Analyze the impact of changes on existing metadata, dashboards and reports and ensure the compatibility with goals in all areas
- Participate in design reviews and ensure that all solutions are aligned to predefined project goals and requirements
- Experience in modeling and business system designs.
- Formal experience with any cloud-based warehouse or AWS/GCP environments is a plus
- Participate in data strategy and roadmap exercises, business intelligence/data warehouse product selection, design, and implementation
- Proven experience with STAR and SNOWFLAKE schema techniques.
- Proven track record as an ETL Architect, leading development teams to deliver successful business intelligence solutions with complex data sources.
- Own, monitor, and improve automated solutions to ensure quality and performance SLAs are met
- Demonstrated knowledge of best practices when scoping new data sets (Data Mapping, expected follow-up questions w/ business consumers)
- Perform hands-on design, development, configuration and testing of reporting solutions in Snowflake for new and existing business metrics
- Simplify complex business problems and extract insights from large data sets
- Interfaces with analytics development teams to validate test results for new applications verifying that they meet the requirements of the business group.
- Develop and update a project plan/task list and keep all parties updated on progress
- Analyze source system APIs, data schema, and data profiles to define what is possible
- Define and document solution designs, with feedback from team members and other technical architects
- Work in projects based on Agile Scrum methodologies and will be part of one or more project[1]based Scrum Teams using tools like Jira, Confluence
- Proactively identifies recurring issues or "value-add" areas and proposes process, data, and/or systematic solutions.
- Develop strong collaborative relationships with key partners in Sales, Sales Operations, Finance and Marketing teams
- Excellent Communication, Documentation, and Presentation skills.