Jobs via Dice · 13 hours ago
Data Analyst Lead
Jobs via Dice is seeking a Data Analyst Lead who will develop SSIS ETL processes and optimize SQL queries for reporting and BI dashboards. This role involves leading data initiatives, mentoring junior analysts, and supporting full project lifecycles using agile methodology.
Computer Software
Responsibilities
Develop SSIS ETL processes
Optimize SQL queries for reporting and BI dashboards
Lead critical data initiatives including mapping, migration, and database design
Support full project lifecycles using agile methodology and Azure DevOps
Contribute to data governance through building and maintaining a data catalog to ensure data quality
Mentor 2-3 junior data analysts and guide their technical development
Qualification
Required
Develop SSIS ETL processes
Optimize SQL queries for reporting and BI dashboards
Lead critical data initiatives including mapping, migration, and database design
Support full project lifecycles using agile methodology and Azure DevOps
Contribute to data governance through building and maintaining a data catalog to ensure data quality
Mentor 2-3 junior data analysts and guide their technical development
Complete a comprehensive technical assessment evaluating proficiency across data science, data management, data warehousing, Microsoft SQL Server 2019 Business Intelligence, Tableau, and database concepts
Work with relational databases
Manage structured and unstructured data
Develop SSIS packages and SSRS reports
Create Tableau dashboards
Write clean, performant SQL
Experience with ETL processes such as building pipelines and analyzing data
Reporting Experience with SSRS
Tableau Visualization
Experience leading data migration projects and handling large scale data transfers
Support the full lifecycle of a project and can lead projects
Prior Leadership Experience: Managing teams of at least 2-5 people
Ability to take a project from requirements gathering through completion
Experience with Azure DevOps for Scrum/Agile management and implementing Agile methodology
Preferred
Power Designer
Conceptual understanding of Database Design
Benefits
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Company
Jobs via Dice
Welcome to Jobs via Dice, the go-to destination for discovering the tech jobs you want.
Funding
Current Stage
Early StageCompany data provided by crunchbase