Data Architect(Snowflake)

The Staff Software Engineer is a key role within the organization, responsible for translating requirements and user stories into functional software that delivers value to the business. They help make the impossible become possible through the design, development, testing, and implementation of complex software for use across The Walt Disney Company. We're looking for a highly experienced Software Engineer, with a deep understanding and experience with large data ingestion, manipulation, and reporting which includes tools such as Snowflake, Snowpark, Snowpipe, and Python development technologies to ensure that that we are building the "best-in-class" products and continuously maintaining and enhancing existing products to improve our competitive advantage and technical excellence.

Responsibilities
- Responsible for the technical oversight of platform projects and related agile delivery teams, where a project comprises of multiple components
- Lead the development of (or develops, test and deploys) enterprise level, innovative software solutions that meet specifications and impact future development
- Develop or lead the development of specifications for software development projects
- Review or write code, leads programming and testing and debugging of major software development projects
- Design the component tasks of software development projects, developing specifications for each
- Manage the full lifecycle of projects
- Manage and oversight for architecting and building data engineering pipelines on Snowflake
- Manage and oversight with streaming ingestion and transformation utilizing Snowpipe and Dynamic Tables
- Manage resource plans and project budgets, providing monthly forecasts

Serve as an escalation point for difficult problems and complex inquiries
- Act as a peer group leader to and help train staff on Software Engineering standards and processes

Scope of project: The Ent Tech Solutions Engineering group is hiring for a data engineer to support their Corporate Real Estate portfolio, specifically they are focused on creating business intelligence/dashboards for Disney's space utilization efforts. Disney owns several properties nationwide, so the goal it to provide better data and analytics to make informed business decisions. There are 6 data integrations, looking for the engineer to build the API pipelines from scratch(various file types). The plan is to keep the data for one year. Tableau for reporting.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Required Skills & Experience
- At least 10 years of experience in a in a Software Engineering or software development role, managing complex products for large, multi-national corporation with multiple business units
- What is needed is someone with Architecture Design experience working with Corp Real Estate(will be working on data lakes, framework and will need to architect it)
- Must have that architect experience, design level experience where they can give requirements and design it
- 3 plus years experience with SQL and Python
- 2 plus years experience implementing data solutions on the Snowflake cloud data platform
- 1 plus years experience with Snowpark
- Experience with Python, Java , Spark and other Scripting languages

Experience in building real-time and batch data pipelines using Spark, Scala, or Snowpark
- Experience with Snowpark Container Services, Streamlit
- Extensive knowledge of and experience with large-scale database technology (e.g. Snowflake, Netezza, Exadata, Teradata, Greenplum, etc.)
- Experience working with multi-Terabyte data sets
- Experience building continuous pipelines using Snowflake dynamic tables and dbt
- Experience in Data Warehousing, Business Intelligence, AI/ML, application modernization, or Cloud projects
- Proficiency in implementing data security measures, access controls, and design within the Snowflake platform
- Experience with the integration to ServiceNow platform a plus
- Experience with data analytics platforms and visibility tools (Looker, Tableau, PowerBI) a plus
- Strong communication, writing, and executive presentation skills
- Able to translate complex ideas into understandable strategies, requirements, value statements, and business outcomes
- Demonstrated experience working within matrixed teams to deliver complex projects or technology transformation initiatives
- Experience implementing or managing using agile software development methodologies (PMI-ACP, SAFe Agilist, ICP-ACC, etc.) and managing the full SDLC
- Experience working in an outsourced IT environment and building strong collaborative vendor relationships
- BS in Computer Science or work exp
- Hybrid 3 to 4 days onsite: Burbank, CA or Orlando, FL

Nice to Have Skills & Experience
- Snowflake's SnowPro Certification(s) preferred

Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.