The IT Data Engineer II advances by incorporating data architecture principles to design and propose data solutions that may require architecture reviews. They have a solid understanding of data pipeline orchestration, including developing solutions that manage data flow sequences with appropriate monitoring. Their skill set includes developing in big data technologies and enhancing their theoretical knowledge of data warehousing in an analytics environment.

• Design, implement, and optimize data pipelines with a strong focus on SQL and scripting.
• Develop and maintain ETL processes and contribute to data warehousing solutions, including understanding star schema and Kimball or Snowflake methodologies.
• Write and optimize SQL and calculations within data visualization tools to enhance data models and performance.
• Enforce data governance policies and ensure compliance with data s...