Data Engineer at Sidley Austin LLP

SummaryThe Data Engineer will help build and maintain the data pipelines models and infrastructure that power analytics business-intelligence and machine-learning initiatives across the company. Youll work alongside senior engineers and cross-functional partners to turn raw data into reliable well-documented datasets that drive informed decisions and innovative products. This role reports to the Senior Manager Data Engineering.Duties and ResponsibilitiesDesign develop and maintain robust scalable data pipelines and ETL/ELT processes ensuring efficient ingestion transformation and storage of data.Build and optimize data models and schemas for analytics reporting and operational data storesImplement and maintain data quality frameworks including data validation monitoring and alerting mechanisms.Collaborate closely with data architects data analysts BI engineers and product teams to align data engineering activities with business goals.Contribute to CI/CD pipelines supported by version control linting automated testing security scanning and monitoring Troubleshoot and resolve complex data infrastructure and pipeline issues ensuring minimal downtime and optimal performance.Follow coding standards participate in code reviews and document your work to foster knowledge sharing.Salaries vary by location and are based on numerous factors including but not limited to the relevant market skills experience and education of the selected candidate. If an estimated salary range for this role is available it will be provided in our Target Salary Range section. Our compensation package also includes bonus eligibility and a comprehensive benefits program. Benefits information can be found at Salary Range$129000 - $144000 if located in IllinoisQualificationsTo perform this job successfully an individual must be able to perform the Duties and Responsibilities (Duties) above satisfactorily and meet the requirements below. The requirements listed below are representative of the minimum knowledge skill and/or ability required. Reasonable accommodations will be made to enable individuals with disabilities to perform the essential functions of the job. If you need such an accommodation please email (current employees should contact Human Resources).Education and/or Experience: Required:Bachelors degree in Computer Science Engineering Data Science or a related fieldA minimum of 3 years of hands-on experience in data engineering building scalable data pipelines ETL/ELT processesProficiency with Python SQL and Apache Spark for data processingFamiliarity with cloud data-platform components such as object storage metadata / data catalog services batch/streaming/CDC ingestion & processing Proven experience with data modeling schema design and performance tuning of large-scale data systemsExperience working with AI & BI engineers to deliver high-quality data products to stakeholdersSkilled at crafting compelling data narratives through tables reports dashboards and other visualization toolsUnderstanding of data engineering best practices: code repositories CI/CD pipelines test automation monitoring and alerting systemsStrong problem-solving and analytical skills with excellent attention to detailExcellent communication skills and experience collaborating with technical and business stakeholdersPreferred:Experience building data pipelines in an Azure Databricks environment Familiarity with Infrastructure as Code (IAC) Experience working with regulated/sensitive data and controls Experience working in an Agile delivery modelOther Skills and Abilities:The following will also be required of the successful candidate:Strong organizational skillsStrong attention to detailGood judgmentStrong interpersonal communication skillsStrong analytical and problem-solving skillsAble to work harmoniously and effectively with othersAble to preserve confidentiality and exercise discretionAble to work under pressureAble to manage multiple projects with competing deadlines and prioritiesSidley Austin LLP is an Equal Opportunity Employer#LI-Hybrid#LI-OE1 Key Skills Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala Employment Type : Unclear Experience: years Vacancy: 1 Monthly Salary Salary: 129000 - 144000