Delivers a state-of-the-art analytics platform using SQL, Python, Java, and Extract, Load, Transform (ELT) development. Implements relational and dimension data models to improve platforms. Maintains data using database technologies (Snowflake). Provides long-term solutions for foundational data and analytics platforms.
Requirements
- using SQL, Python, Java, and Extract, Load, Transform (ELT) development
- database technologies (Snowflake)
- Continuous Integration and Continuous Delivery (CI/CD) methodologies and software version control
- building data warehouses and developing Big Data Hadoop solutions using Snowflake, Informatica, Airflow, Control-M, UNIX, Spark SQL, and Python.
- analyzing, profiling, mining, extracting, and cleansing data and large-scale data warehouses using Snowflake, Postgres, Netezza, AWS, SQL Server, and Oracle.
- creating data models and data structures using Oracle Business Intelligence Enterprise Edition (OBIEE), BI Publisher, and Tableau.
- performing data analysis -- data cleaning, preparation, transformation, and modeling data from various data sources onto a data warehouse platform -- to support business needs and decision making, using Snowflake, Oracle, SQL Server, and IBM DB2.
Responsibilities
- Delivers a state-of-the-art analytics platform using SQL, Python, Java, and Extract, Load, Transform (ELT) development.
- Implements relational and dimension data models to improve platforms.
- Maintains data using database technologies (Snowflake).
- Provides long-term solutions for foundational data and analytics platforms.
- Coordinates workflows using Continuous Integration and Continuous Delivery (CI/CD) methodologies and software version control.
- Provides business solutions by developing complex software applications.
- Develops original and creative technical solutions to on-going development efforts.
Other
- Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office.
- Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others.
- Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.
