https:/www.cdwjobs.com/jobs/11855463-sr-software-engineer-ii-cloud-azure-data

CDW; Chicago (IL); On-site; USD 120,000 - 160,000; Full time

Job summary

CDW is seeking a Senior Software Engineer II - Data to build and operationalize enterprise data pipelines and data assets for analytics across the organization.

You will work with data scientists, analysts, and business stakeholders to deliver curated data, improve data models, and enable data-driven decision making using SQL, Python, and cloud-based tools.

Qualifications

• 7+ years data application development experience.
• BS or MS in Computer Science or related field.
• Strong experience with data management architectures (Data Warehouse, Data Lake, Data Hub).
• Extensive experience with SQL, PL/SQL, Python and NoSQL databases.

Responsibilities

• Develop scalable data pipelines to handle increasing data volume and complexity.
• Interface with teams to extract, transform, load data from diverse sources using big data technologies and SQL.
• Collaborate with business teams to improve data models for BI tools and data-driven decisions.
• Work with data science teams to prepare datasets for analytics, ML, and statistical analysis.
• Automate common data preparation and integration tasks to improve productivity and reduce errors.
• Educate data scientists and analysts on pipelines and data preparation techniques.

Skills

Cross-functional collaboration

Mentoring

Communication skills

Problem solving

Attention to detail

Facilitation

Prioritization

Education

BS or MS degree in Computer Science or related field

Tools

SQL

PL/SQL

Python

MongoDB

Cassandra

NoSQL/Hadoop

Azure Data Factory

ETL Tools (SSIS, Informatica, Ab Initio, Talend)

Databricks

MS SQL Server

Job description

Overview

The Senior Software Engineer II - Data will play a pivotal role in building and operationalizing the minimally inclusive data necessary for the enterprise data and analytics initiatives following best practices. The bulk of the data engineer's work would be in building, managing and optimizing data pipelines and then moving these data pipelines effectively into production for key data and analytics consumers like business/data analysts, data scientists or any persona that needs curated data for data and analytics use cases across the enterprise.

Key Areas of Responsibility

• Develops and maintains scalable data pipelines to support continuing increases in data volume and complexity.
• Interface with other technology teams to extract, transform, and load data from a wide variety of data sources using big data technologies and SQL.
• Collaborates with business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
• Collaborate with other technology teams to help engineer data sets that data science teams uses to implement advanced analytics algorithms that exploit our rich datasets for statistical analysis, prediction, clustering and machine learning.
• Responsible for using innovative and modern tools, techniques and architectures to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity.
• Train counterparts such as data scientists, data analysts, data consumers in data pipelines and preparation techniques, which make it easier for them to integrate and consume the data they need for their own use cases.
• Helps ensure compliance and governance during use of data.
• Be curious and knowledgeable about new data management techniques and how to apply them to solve business problems.

Education and/or Experience Qualifications

• BS or MS degree in Computer Science or a related technical field.
• 7+ years data application development experience

Required Qualifications

• Strong experience with various Data Management architectures like Data Warehouse, Data Lake, Data Hub and the supporting processes like Data Integration, Governance, Metadata Management.
• Extensive experience with popular data processing languages including SQL, PL/SQL, Python, others for relational databases and on NoSQL/Hadoop oriented databases like MongoDB, Cassandra, others for nonrelational databases.
• Demonstrated ability to build rapport and maintain productive working relationships cross-departmentally and cross-functionally.
• Demonstrated ability to coach and mentor others.
• Excellent written and verbal communication skills with the ability to effectively interact with and present to all stakeholders including senior leadership.
• Strong organizational, planning and creative problem solving-skills with critical attention to detail.
• Demonstrated success of facilitation and solutions implementation.
• History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines.

Preferred Qualifications

• Extensive experience with Azure Data Factory
• Extensive experience working with cloud platform (at least one of Azure, AWS, GCP)
• Experience with ETL Tools (SSIS, Informatica, Ab Initio, Talend), Python, Databricks, Microsoft SQL Server Platform (version 2012 or later), and/or working in an Agile environment