LPL Financial is looking to transform and enhance its data and insights capabilities by building Cloud applications and migrating its data warehouse to the Cloud, and is seeking a technical leader to drive this effort.
Requirements
- 3+ years of experience and resident expert of Cloud data warehouse technologies like Snowflake, Redshift, AWS S3/Lambda/Glue/Air Flow and other AWS native technologies.
- Understanding of Data Vault, Warehouse, Lake and Hub architecture.
- Significant experience with application migrations and development (conceptual, logical and physical model design, Operational Data Stores, Enterprise Data Warehouses and Data Marts).
- Cloud ETL or ELT experience in one of the tools like Fivetran, DBT, stitch or Matillion.
- Expertise with SQL databases like Oracle and Microsoft SQL server.
- Experience in coding technologies like Python, Scala, and SQL.
- Experience with Informatica, Data Lake, Hadoop, MapR is a big plus.
Responsibilities
- Lead the Data Warehouse Product in design, development, enhancement and application migration to the Cloud.
- Full life cycle experience (requirements gathering through production deployment) in all aspects of DW (ETL, Data modeling, Data cleansing, Support on premise Database and Cloud Snowflake, AWS)
- Lead, coach, mentor and inspire a dedicated team of onshore and offshore developers to architect, build, deploy and support best-in-class software solutions for the customers.
- Drive resolution for technical issues and provide alternate solutions.
- Serve as resident expert in all database application deliveries with a focus on overall performance.
- Support release and post production support activities of the product.
- Support and remediation of existing application implementations and oversee all new implementations accessing databases.
Other
- Bachelor's Degree in Computer Science or a related study accompanied by 15+ years of experience in Information Technology with at least 8+ years in Data Warehouse development and support.
- 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.
- Strong organizational and planning skills and process orientation.
- Commitment to excellence in service, performance, and execution
