Lead Technical Analyst

Job Title: Lead Technical Analyst
Location: 100% Remote Position
Duration: 6+ Months

Job Description
Top 3 things looking when reviewing resumes:

1. End-to-End BI Development Experience

• Design and Architecture: Look for evidence that they can translate business needs into a scalable BI solution (e.g., data models, ETL pipelines, dashboards).
• Data Engineering: Experience with data extraction, transformation, and loading (ETL/ELT) processes, working with tools like SQL, Python, or ETL platforms (e.g., Informatica, Talend).
• Data Warehousing: Proficiency in building and optimizing data warehouses or data lakes (e.g., Snowflake, Redshift, BigQuery).
• Visualization and Reporting: Expertise in BI tools like Power BI, Tableau, Qlik, or Looker, with a focus on user-centric dashboard design.
• Analytics: Ability to create advanced analytics solutions (e.g., predictive modeling, KPI reporting, or business forecasting).

2. Technical Proficiency Across the BI Chain

• Database and Querying Skills: Advanced SQL knowledge and experience with relational and NoSQL databases.
• Cloud Platforms: Experience working with cloud BI ecosystems (e.g., Azure, AWS, or Google Cloud).
• APIs and Automation: Ability to integrate external systems via APIs and automate workflows.
• Programming Skills: Familiarity with Python, R, or similar for advanced analytics or data integration.
• Version Control: Experience with Git for managing BI codebases and collaborating with teams.

3. Strong Interpersonal and Business Skills

• Stakeholder Engagement: Evidence of collaborating with business teams to gather requirements, present insights, and iterate on solutions.
• Cross-Functional Collaboration: History of working closely with data engineers, analysts, and business teams to deliver seamless BI solutions.
• Communication: Ability to translate technical insights into actionable business strategies and present findings to non-technical stakeholders.
• Problem-Solving: Examples of addressing complex data challenges and delivering innovative BI solutions that drive value.

JOB DESCRIPTION: The Lead Technical Analyst is primarily responsible for the design and configuration of the Alation Data Catalog to meet the needs of KeyBank's associates - with a keen focus on improving the efficiency of analysts in their quest to find, understand and use data. The Lead Technical Analyst will be part of on an agile squad, working closely with business stakeholders, data consumers, data producers, and data engineering to improve the usability of data through coordinated efforts in data lineage, business definitions of data and data quality, to create a best-in-class catalog experience.

ESSENTIAL JOB FUNCTIONS:

• Define, develop & implement Alation data catalog functionality to satisfy the needs of broader data mgmt. programs and initiatives in flight
• Lead the technical solution design and build for a comprehensive suite of Business Intelligence (BI) reporting objects, including data models, python scripts / data pipelines, stored procedures and Tableau dashboards, that satisfy the catalog platform and cross-program requirements
• Support the technical integration efforts of Alation to other enterprise systems which could contain critical data lineage or data quality information
• Leveraging program languages e.g. Python and platform APIs, design & develop custom workflows and integrations with other systems to automate data mgmt. processes
• Troubleshoot and resolve Alation issues as they occur

REQUIRED EXPERIENCE:

• 5+ years' in end-to-end BI development experience, across design / architecture, data engineering, data warehousing and viz / reporting layers
• Strong understanding of how to design and develop relational data models, PL/SQL stored procedures and SQL querying
• Intermediate Python skills automating system integrations with APIs and workflows
• Intermediate understanding of data catalogs and their respective capabilities including data dictionaries, business glossaries, business lineage, technical lineage, and data mgmt. workflows
• Hands-on experience with on-boarding technical and functional metadata from various sources including cloud data platforms, traditional RDBMS systems e.g., SQL Server, Oracle, etc. or Business Intelligence (BI) platforms e.g. Tableau
• Understanding of cloud technologies such as Google Cloud Platform (Google Cloud Platform) (preferable), Azure, or AWS
• Comfortable working independently and with other teams/vendors to resolve issues
• Strong presentation skills and being able to effectively communicate across all levels of the enterprise

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Job Title: Lead Technical Analyst
Location: 100% Remote Position
Duration: 6+ Months

Job Description
Top 3 things looking when reviewing resumes:

1. End-to-End BI Development Experience

• Design and Architecture: Look for evidence that they can translate business needs into a scalable BI solution (e.g., data models, ETL pipelines, dashboards).
• Data Engineering: Experience with data extraction, transformation, and loading (ETL/ELT) processes, working with tools like SQL, Python, or ETL platforms (e.g., Informatica, Talend).
• Data Warehousing: Proficiency in building and optimizing data warehouses or data lakes (e.g., Snowflake, Redshift, BigQuery).
• Visualization and Reporting: Expertise in BI tools like Power BI, Tableau, Qlik, or Looker, with a focus on user-centric dashboard design.
• Analytics: Ability to create advanced analytics solutions (e.g., predictive modeling, KPI reporting, or business forecasting).

2. Technical Proficiency Across the BI Chain

• Database and Querying Skills: Advanced SQL knowledge and experience with relational and NoSQL databases.
• Cloud Platforms: Experience working with cloud BI ecosystems (e.g., Azure, AWS, or Google Cloud).
• APIs and Automation: Ability to integrate external systems via APIs and automate workflows.
• Programming Skills: Familiarity with Python, R, or similar for advanced analytics or data integration.
• Version Control: Experience with Git for managing BI codebases and collaborating with teams.

3. Strong Interpersonal and Business Skills

• Stakeholder Engagement: Evidence of collaborating with business teams to gather requirements, present insights, and iterate on solutions.
• Cross-Functional Collaboration: History of working closely with data engineers, analysts, and business teams to deliver seamless BI solutions.
• Communication: Ability to translate technical insights into actionable business strategies and present findings to non-technical stakeholders.
• Problem-Solving: Examples of addressing complex data challenges and delivering innovative BI solutions that drive value.

JOB DESCRIPTION: The Lead Technical Analyst is primarily responsible for the design and configuration of the Alation Data Catalog to meet the needs of KeyBank's associates - with a keen focus on improving the efficiency of analysts in their quest to find, understand and use data. The Lead Technical Analyst will be part of on an agile squad, working closely with business stakeholders, data consumers, data producers, and data engineering to improve the usability of data through coordinated efforts in data lineage, business definitions of data and data quality, to create a best-in-class catalog experience.

ESSENTIAL JOB FUNCTIONS:

• Define, develop & implement Alation data catalog functionality to satisfy the needs of broader data mgmt. programs and initiatives in flight
• Lead the technical solution design and build for a comprehensive suite of Business Intelligence (BI) reporting objects, including data models, python scripts / data pipelines, stored procedures and Tableau dashboards, that satisfy the catalog platform and cross-program requirements
• Support the technical integration efforts of Alation to other enterprise systems which could contain critical data lineage or data quality information
• Leveraging program languages e.g. Python and platform APIs, design & develop custom workflows and integrations with other systems to automate data mgmt. processes
• Troubleshoot and resolve Alation issues as they occur

REQUIRED EXPERIENCE:

• 5+ years' in end-to-end BI development experience, across design / architecture, data engineering, data warehousing and viz / reporting layers
• Strong understanding of how to design and develop relational data models, PL/SQL stored procedures and SQL querying
• Intermediate Python skills automating system integrations with APIs and workflows
• Intermediate understanding of data catalogs and their respective capabilities including data dictionaries, business glossaries, business lineage, technical lineage, and data mgmt. workflows
• Hands-on experience with on-boarding technical and functional metadata from various sources including cloud data platforms, traditional RDBMS systems e.g., SQL Server, Oracle, etc. or Business Intelligence (BI) platforms e.g. Tableau
• Understanding of cloud technologies such as Google Cloud Platform (Google Cloud Platform) (preferable), Azure, or AWS
• Comfortable working independently and with other teams/vendors to resolve issues
• Strong presentation skills and being able to effectively communicate across all levels of the enterprise

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.