26 Sep
Cloud Data Engineer (Mid Level & Senior)
Illinois, Chicago , 60603 Chicago USA

Vacancy expired!

Job OverviewWe are on a journey to become a data-driven organization. The Data Office has identified the Data Engineer as a critical role in that evolution. Reporting to the Head of Data, the Data Engineer will play a key role in redefining and reengineering the way data is managed across the data enterprise. This role will support the defined strategic projects to deliver the Data Strategy as well as supporting and furthering the process reengineering and automation throughout our data supply chain. The Data Engineer will ensure the vision to improve the overall data quality across the enterprise and define solutions to realize the value of our data is reflective in execution of all deliverables. This role will work closely with the Data Architect role to align projects to the future state data architecture. As we continue to scale our data capabilities, we are looking for data evangelists who know how to make an impact and know how to create and deliver business value. We are searching for individuals who consider themselves self-starting professionals who thrive in an environment primed for innovation and change, who can lead us into the future. We seek specialists who are passionate about data who are ready to bring their experience to build a data-driven culture.

Responsibilities
  • Focused responsibility on translating business requirements into tangible data projects developing SQL queries, pipelines, stored procedures, data warehouse load process, etc. that support the business goals.
  • Manage data pipelines: assist in creation of end-to-end data pipelines from external and internal sources to the data warehouse; create new pipelines, recreate config files as needed.
  • Scale: Deliver performance at scale, and accurately anticipate system enhancement needs
  • Data integrity: Data manipulation, error identification and handling, and modeling
  • Tune and optimize current jobs for performance and throughput across Modern Data Estate.
  • Apply business and database analysis skill to gain deep understanding of user's needs and aid in the definition and creation of solutions that meet the needs of the business users.
  • Comprehensive documentation of all developed software & repositories and assist in documenting and maintaining requirement specification document.
  • Assist with troubleshooting efforts for pre-production and production related code.
  • Develop custom database objects, stored procedures, functions.
  • Communicate the status of project and planning activities with team leads lead business analyst and surface hurdles early on to find a resolution.
  • Analyze existing SQL queries for performance improvements.
  • Data mapping, transformation and performing ETL based on complex logic.
  • Enhance and support Modern Data Warehousing and data management projects along with ETL development.
  • Design system integrations as required for extracting data, enhancing data models and processes for reporting purposes.
  • Mapping of data sources, data movement and reconciliation with the goals of ensuring data quality & consistency and the ability to satisfy relevant business requirements by following best practices.
  • Collaboration with business analysts and business stakeholders to ensure a thorough understanding of strategic data requirements.
  • Data analysis / data profiling to understand gaps, inconsistencies and other quality issues in existing source system data, and develop data sourcing solutions, as well as collaborating with stakeholders to identify, document and implement corrections / business rules / workarounds.
  • Ability to manage priorities effectively in a dynamic and high performing team setting.

Qualifications

  • Bachelor's Degree or higher and an expert-level programming skills with 7+ years' work experience.
  • Experience in Tools used in the Modern Data Stack - Microsoft Azure, Azure Data Lake, Synapse, Databricks.
  • Mastery of SQL, Data warehouse design and implementation experience.
  • Advanced understanding of software and pipeline development aimed at data-driven business value generation.
  • Advanced experience in development, construction, testing, and maintenance of data architectures
  • A strong technical understanding of ETL processes, data analytics tools, and their associated technologies is required.
  • Sound understanding of software engineering best practices including version control and CI/CD; attention to detail and ready to work collaboratively
  • Strong project management skills in a deadline-oriented environment are required.
  • Self-starter with a can-do attitude to engage in hands-on fast prototyping and proven business acumen.
  • Excellent proven personal leadership, collaboration, communication, and analytical skills are required.
  • Excellent analytical, problem-solving and decision-making skills, interpreting and analyzing data.
  • Sound understanding of relational and non-relational databases.
  • Experience working in Azure cloud environment is a plus
  • Experience with Database Administrator roles (backup, restore, security) a plus
  • Analytical capability: strong ability to analyze and evaluate data, formulate accurate conclusions and clearly recommend creative solutions
  • Proven critical thinking and problem-solving skills

Requirements
  • You must have unrestricted authorization to work in the United States
  • Must comply with pre-employment screening, including background check

Vacancy expired!


Related jobs

Report job