At LPL Financial, the Technology organization is looking to hire a Data Engineer to support and build data models for Enterprise level integration projects.
Requirements
Experience in design and development of ETL using Snowflake Suite of Tools
Experience in developing scripts in a relational database i.e. SQL Server (TSQL and Stored Procedures) or Oracle using SQL/PLSQL
Experience in performance tuning (Snowflake DBT/Stored Procs)
Experience rolling out workflows through GitHub
Python
Snowflake Certification
AWS Glue, Airflow, Lambda
Responsibilities
Operate in Agile environment to build and deploy automated processes that populate a graph database used as part of the organizations metadata repo.
Work with analyst, end customers, and other technical resources to generate solutions from graph datasets
Design, develop, test and implement data pipelines based existing Informatica PowerCenter and SQL Server technologies.
Review existing pipelines for opportunities to tune, optimize and harden
Provide leadership to teammates through technical design, code reviews and implementation of best practices, adhering to LPL’s SDLC and RM processes.
Collaborate with other Development teams, Enterprise Architecture and Support teams to design, develop, test and maintain the various platforms and the integration with other systems.
Communicate with technical and non-technical groups on a regular basis as part of product/project support
Other
Strong collaborators who deliver exceptional client experiences and thrive in fast-paced, team-oriented environments.
Pursue greatness, act with integrity, and are driven to help our clients succeed.
Embrace creativity, continuous improvement, and contribute to a culture where we win together and create and share joy in our work.
Working knowledge of software development methodologies like Agile - Scrum experience
