Snowflake Data Engineer

Develops applications by writing code based upon design specifications and business requirements under the direction of the Development Manager and Project Manager. Takes an active role in the development group by sharing knowledge and mentoring others. This candidate is a member of a team, must adhere to secure development process and configuration management process and must be able to work cooperatively and autonomously

Job Description: Engineer Software Development – Snowflake Data Mart

LPL’s Regulatory Data Team is working to build enhanced data and insights capabilities by transforming into Cloud applications. We are looking for a Software Development Engineer with exceptional communication, analytical, and organizational skills to drive application migration to Cloud warehouse. The candidate will be responsible for developing the solutions data warehouse, working closing with supporting teams and involve in release support.

Business/Division: Data Technology, Enterprise Data Products and Insights for Regulatory Data

Group Focus: Lead the efforts in the Regulatory Data Warehouse in design, development, enhancement, and application migration to Cloud to support our advisors as they manage their business. The ideal candidate will have four-plus years of experience in development utilizing Snowflake and AWS services and an understanding of working in financial services or other highly regulated environments.

Responsibilities
• Develop and support the Data Warehouse team members in application migration to the Cloud.
• Full life cycle involvement in all aspects of DW – Cloud Snowflake, AWS (ETL, Data modeling, Data cleansing)
• Perform development, enhancement, and document technical details to support the warehouse and provide data support for the downstream applications.
• Serve as hands on engineer in all database application deliveries with a focus on overall performance.
• Support release and post production support activities of the product.

What are we looking for?

We want strong collaborators who can deliver a world-class client experience. We are looking for people who thrive in a fast-paced environment, are client-focused, team oriented, and are able to execute in a way that encourages creativity and continuous improvement.

Requirements
• Bachelor’s Degree or a related study driven as a Data Engineer.
• 5+ years strong knowledge of Databases and MSSQL, PLSQL or other query languages.
• 3+ years of Snowflake experience in Cloud data warehouse technologies including Redshift, AWS S3/Lambda/Glue/Air Flow and other AWS native technologies.
• 3+ years of Python development and an in-depth understanding of Python programming/objects
• Experience with application migrations and development (conceptual, logical and physical model design, Operational Data Stores, Enterprise Data Warehouses and Data Marts).
• Familiar with data modeling practices and standards across conceptual, logical, and physical levels.

Core Competencies
• Strong verbal and written communication skills, with an ability to express complex technical concepts into comprehensible business terminology.
• Ability to work with cross-functional teams.
• Dynamism in understanding complex data environments.
• Commitment to excellence in service, performance, and execution

The Company

A prominent fortune 500 financial services firm with a nationwide network of independent financial advisors. This company offers an extensive selection of investment products and services to individuals, businesses, and institutions, with a strong emphasis on utilizing innovation and technology to cultivate client relationships.

Equal Opportunity Employer

Associate Staffing is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment based on race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other protected status under applicable law. We are committed to creating a diverse and inclusive work environment and welcome applicants from all backgrounds to apply for open positions with our company.