Data Analyst / Senior

SN

Opening Positions

Opening

A

Junior Data Analyst

( 2 )

 B

Senior Data Analyst

( 1 )

Key Responsibilities and Requirements:

Position:

Junior Data Analyst

Key Responsibilities:

• Deliver and communicate data-driven insights and reports to stakeholders by querying an Amazon Redshift data warehouse using SQL.

• Build and maintain SQL-based transformations in dbt (data build tool) for new and existing use cases.

• Develop and maintain Looker dashboards that are viewed by senior leadership and operation groups across the school network.

• Work closely with school operations and management teams across the network to help capture business requirements and translate those requirements into SQL code.

• Collaborate with data engineers to build transformed datasets for reporting needs. 

 Requirements:

• Bachelor’s Degree in a technical field like Math, Engineering, Computer Science, or Information Technology and/or experience in data analytics. Ability to easily code complex SQL queries from scratch, having done so for at least 4 years.

• Hands-on experience in reporting and data visualization tools such as Looker, Domo, PowerBI or other BI tools.

• Strong communication skills, capable of explaining complex data models and dashboards in a concise and digestible manner. 

• Ability to multitask in a fast-paced environment.

• SQL coding experience in dbt and/or LookML coding is a plus.

• Able to work well under pressure and achieve results within the scheduled time-frame

• Team-working skills

• Verbal and Written communication skills

• Problem-solving skills
• Accuracy and attention to detail

Position:

Senior Data Analyst

Key Responsibilities:

• Provide innovative analytical insights within the Data Products Program

• Conduct detailed data analysis on data used across business units to evaluate business processes and improve on/create new feature

• Respond to data and product-related inquiries in real-time to support business and technical teams

• Provide expertise and translate the business needs to design; and develop tools, techniques, metrics, and dashboards for insights and data visualization

• Responsible for developing and executing tools to monitor and report on data quality

• Responsible for establishing appreciation and adherence to the principles of data quality management

• Provide support to Tech teams in managing security mechanisms and data access governance.

• Deliver and communicate data-driven insights and reports to stakeholders by querying an Amazon Redshift data warehouse using SQL.

• Build and maintain SQL-based transformations in dbt (data build tool) for new and existing use cases.

• Develop and maintain Looker dashboards that are viewed by senior leadership and operation groups across the school network.

• Work closely with school operations and management teams across the network to help capture business requirements and translate those requirements into SQL code.

• Collaborate with data engineers to build transformed datasets for reporting needs.
• Supervise team and provide leadership; Serve as liaison for upper management

Requirements:

• Bachelor’s Degree in a technical field like Math, Engineering, Computer Science, or Information Technology and/or experience in data analytics; Master’s degree or related certification preferred

• Ability to easily code complex SQL queries from scratch, having done so for at least 5 years and above.

• Hands-on experience in reporting and data visualization tools such as Looker, Domo, PowerBI or other BI tools.

• Strong communication skills, capable of explaining complex data models and dashboards in a concise and digestible manner. 

• Ability to multitask in a fast-paced environment.

• SQL coding experience in dbt and/or LookML coding is a plus.

• Practical knowledge of data in various forms (data warehouses/SQL, unstructured data environments/PIG,HIVE, Impala)

• Understanding of Agile development methodologies, software design patterns, network design and architecture; Experience in quantitative analysis and statistical modelling

• Able to work well under pressure and achieve results within the scheduled time-frame
• Exceptional writing and verbal communication skills to perform their job duties and manage others