Senior Manager, Advanced Data Analytics and Insights

Fidelity Investments•Durham, NC

About The Position

Develops, debugs and supports Python, complex SQL on Snowflake (AWS) and Oracle. Optimizes performance for large data sets. Manages ELT/ETL pipelines. Creates Data models in Atscale, Power BI and Tableau for reporting and analytics. Builds, updates and maintains technical documentation for software-based projects and products. Interacts effectively with business partners to understand requirements and assist in creation of technical requirements. Translates the vision for divisional initiatives into business solutions by developing complex or multiple software applications and conducting studies of alternatives. Works closely with architects to design most viable products for future solutions and benefits.

Requirements

Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and five (5) years of experience as a Senior Manager, Advanced Data Analytics and Insights (or closely related occupation) designing and developing applications for a finance environment -- Assets & flows, Profitability, Expenses, Revenue, Tax and Treasury, and Technology Business Management.
Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Senior Manager, Advanced Data Analytics and Insights (or closely related occupation) designing and developing applications for a finance environment -- Assets & flows, Profitability, Expenses, Revenue, Tax and Treasury, and Technology Business Management.
Demonstrated Expertise (“DE”) building universal semantic layers and complex data models in Atscale and Power BI desktop using multiple data sources -- Snowflake, Oracle, and SQL Server; building composite models using Assets and Flows, profitability, revenue, expense and UID critical data; and scaling data models by bridging data and decision-making functions using Python scripts.
DE designing and building Enterprise standard security process for universal semantic layer (Atscale) common to Power BI, Tableau, and Portal; designing large data sets and implementing pre-aggregations, using Snowflake's data modeling patterns to avoid data wrangling and inaccuracies; and processing data into analytics and reports for real-time insights using Azure analytics, Power BI, and Tableau.
DE implementing ETL/ELT using python snowsql on Snowflake (AWS), and adhering the enterprise standards and solutions; designing and implementing solution architecture for the business functions using Devops tools -- Git, Jenkins, Udeploy and CNTLM; completing data analysis for the end-to-end data life cycle -- using advanced SQL, modeling (multi-dimensional cubes), mapping, transformation, and distribution using Snowflake, AWS, Azure and Python; and performing impact analyses, reporting, visualization, and dashboard creation using Power BI and Tableau.
DE adhering to Agile methodologies to review and plan the deliverables within prescribed time frames for current and future sprints; utilizing API calls to analyze technology solutions for supporting model deployment and integration in Cloud and on-premises environments, and building model deployment and integration workflows.

Responsibilities

Participates in architecture design teams.
Defines and implements application-level architecture.
Develops applications on complex projects, components, and subsystems for the division.
Recommends development testing tools and methodologies and reviews and validates test plans.
Responsible for QA readiness of software deliverables.
Develops comprehensive documentation for multiple applications or subsystems.
Establishes full project life cycle plans for complex projects across multiple platforms.
Responsible for meeting project goals on-time and on-budget.
Advises on risk assessment and risk management strategies for projects.
Plans and coordinates project schedules and assignments for multiple projects.
Acts as a primary liaison for business units to resolve various project/technology issues.
Provides technology solutions to daily issues and technical evaluation estimates on technology.
Advises senior management on technical strategy.
Performs independent and complex technical and functional analysis for multiple projects supporting several divisional initiatives.
Develops original and creative technical solutions to on-going development efforts.