Principal Data Engineer - 2076123
Company: Fidelity Investments
Location: Westlake, TX
Posted on: May 10, 2023
Job Description:
***Multiple Positions Available*** Crafts secure, scalable, resilient Cloud-based services using
data warehousing, visualization, and integration methodologies.
Reviews the implementation of relational database technologies --
Oracle SQL and PL/SQL -- within Snowflake, Amazon Web Services
(AWS), or MS Azure. Manages data movement technologies Extract,
Transform, and Load and Extract, Load, and Transform (ETL/ELT)
processes and schedulers. Delivers and supports Cloud strategies --
migrating legacy products and implementing Software as a Service
(SaaS) integrations. Manages multi-functional enterprise data,
navigating between business analytic needs and data. Executes on
product roadmaps to enable new insights with data. Crafts and
implements operational data stores and data lakes in production
environments. Primary Responsibilities: Manages project functionality, using DevOps, Continuous
Integration and Continuous Delivery methodologies and tools. Develops and deploys pipelines within a Cloud native
infrastructure. Performs data analysis on database platforms using SQL. Develops ELT/ETL pipelines to move data to and from Snowflake
data store, using Python and Snowflake SnowSQL. Implements data modelling techniques and standard
methodologies. Designs and develops data services. Sets the technical direction for the team. Develops and improves data architecture, database design, and
performance optimization. Sets up reliable infrastructure -- hardware, scalable data
management systems, and frameworks to perform data-related
tasks. Simplifies and communicates technical challenges, solutions
options, and recommendations to business partners and technology
leadership. Provides technical leadership and support in data and
solutioning to team members. Produces scalable, resilient, Cloud-based systems design. Analyzes information to determine, recommend, and plan
installation of a new system or modification of an existing
system. Confers with systems analysts, engineers, programmers, and
others to design systems and to obtain information on project
limitations and capabilities, coordinating installation of software
system. Determines system performance standards. Education and Experience: Bachelors degree (or foreign education equivalent) in Applied
Computer Science, Computer Science, Engineering, Information
Technology, Information Systems, Mathematics, Physics, or a closely
related field and five (5) years of experience in the job offered
or five (5) years of experience developing applications that
support legal, compliance, risk, security, and audit functions
within a financial services environment. Or, alternatively, Masters degree (or foreign education
equivalent) in Applied Computer Science, Computer Science,
Engineering, Information Technology, Information Systems,
Mathematics, Physics, or a closely related field and three (3)
years of experience in the job offered or three (3) years of
experience developing applications that support legal, compliance,
risk, security, and audit functions within a financial services
environment. Skills and Knowledge: Candidate must also possess: Demonstrated Expertise (DE) performing data analysis and
implementing databases, schemas, roles, tables, and queries to
enable detection, prevention, and surveillance of financial crimes,
using AWS Cloud Platform, S3, Snowflake, SnowSQL, and Snowpipe. DE implementing Dataverse tables, forms, business rules,
relationships, and flows for legal, compliance, risk, and security
applications on the Microsoft Power Platform, using Dataverse,
Power automate flows, custom connectors, and Power BI reports. DE implementing data components (databases, tables, views,
types, stored procedures, functions, roles, and queries) for legal,
compliance, risk, and security applications on relational databases
(DB2, Oracle, and Sybase), using SQL and PL/SQL queries. DE implementing ControlM jobs and Compliance aggregate reports
for legal, compliance, risk, and security applications on customer
identification program. For full job details and to apply, please visit
https://jobs.fidelity.com/ and search for job number: 2076123.
Keywords: Fidelity Investments, Dallas , Principal Data Engineer - 2076123, Finance , Westlake, TX, Texas