Lead Oracle PL/SQL Developer--Hybrid--181 West Madison Street, Chicago, IL at Madison, Minnesota, USA |
Email: [email protected] |
Northern Trust - Lead Database Engineer Hybrid 12 month contract - 181 West Madison Street, Chicago Skills: Oracle - PL/SQL Development and performance tuning Team leading experience guiding/mentoring the team, getting work done on time / 50% OF THE ROLE Python Snowflake Azure cloud CI/CD DevOps for database Unix shell scripting Airflow Job Description As a Lead Senior Data Engineer you will play a crucial role in shaping our data infrastructure and strategy. You will be responsible for leading a team of data engineers, designing and implementing robust data solutions, and ensuring the scalability and reliability of our data system. This role is perfect for a dynamic leader passionate about leveraging data to make impactful decisions. You dedicate time to stay on top of the fast changing tech space and invest a lot of energy in learning new tricks. You are caught up on industry trends in data integration/transformation frameworks, DevSecOps, serverless computing/architecture and cloud technologies along with building skills to anticipate what the near future will bring. You love clean interfaces and have a real passion for extraordinary user experience. Our tech stack: Oracle Exadata / Snowflake / Azure / Airflow / Python / Kafka / Shell scripting / PowerBI Additional Information: There are (8) members of the team consisting of Data Engineers and Product Managers. You will be responsible for removing obstacles, blockers and ensuring team continuity Responsible for Reporting / currently using Cognos Tool Half of the time will be hands on Engineering activities and the other half will be lead responsibilities This is a net new add as they need someone on-site in Chicago to lead the team. Prior resource was off-shore and off-hours creating some complexities Will assist with code reviews, enhancements MUST BE willing to perform hands-on work Likely a Contract-to-Hire opportunity after 6 months to 1 year+ Role: Data Engineer Key Responsibilities: Data Integration: Implement and maintain data synchronization between on-premises Oracle databases and Snowflake using Kafka and CDC tools. Support Data Modeling: Assist in developing and optimizing the data model for Snowflake, ensuring it supports our analytics and reporting requirements. Data Pipeline Development: Design, build, and manage data pipelines for the ETL process, using Airflow for orchestration and Python for scripting, to transform raw data into a format suitable for our new Snowflake data model. Reporting Support: Collaborate with data architect to ensure the data within Snowflake is structured in a way that supports efficient and insightful reporting. Technical Documentation: Create and maintain comprehensive documentation of data pipelines, ETL processes, and data models to ensure best practices are followed and knowledge is shared within the team. Tools and Skillsets: Data engineering: proven track record of developing and maintaining data pipelines and data integration projects Databases: Strong experience with Oracle, Snowflake, and Databricks. Data Integration Tools: Proficiency in using Kafka and CDC tools for data ingestion and synchronization. Orchestration Tools: Expertise in Airflow for managing data pipeline workflows. Programming: Advanced proficiency in Python and SQL for data processing tasks. Data Modeling: Understanding of data modeling principles and experience with data warehousing solutions. Cloud Platforms: Knowledge of cloud infrastructure and services, preferably Azure, as it relates to Snowflake and Databricks integration. Collaboration Tools: Experience with version control systems (like Git) and collaboration platforms. CI/CD Implementation: Utilize CI/CD tools to automate the deployment of data pipelines and infrastructure changes, ensuring high-quality data processing with minimal manual intervention. Communication: Excellent communication and teamwork skills, with a detail-oriented mindset. Strong analytical skills, with the ability to work independently and solve complex problems. Warm Regards Raj | Lead US IT Recruiter Tech Rakers Inc | [email protected] Tel: +1(337) 999-0568 | Fax: 337.205.6136 1602 W Pin hook Rd, Suite 202-B, Lafayette, LA 70508 -- Keywords: continuous integration continuous deployment information technology procedural language Louisiana Lead Oracle PL/SQL Developer--Hybrid--181 West Madison Street, Chicago, IL [email protected] |
[email protected] View all |
Sat Jun 22 01:23:00 UTC 2024 |