Myticas’s direct client based out of Mettawa, IL is currently seeking a Data Warehouse (Snowflake) Lead for a 6+ months contract position – hybrid (3 days onsite/week).
TOP Skills:
- Building DW systems or solutions/analytics products/building data products
- Data pipelines-ETL
- Snowflake
- Python/PySpark
Job Description:
Seeking a Data Delivery Lead to orchestrate end-to-end Business Intelligence and Data Warehouse solutions. This role involves collaborating with cross-functional teams to architect, model and data solutions across perse business functions.
Requirements:
- Work with a cross-functional team of developers and business analysts to deliver on data and analytics initiatives.
- Define, develop and implement data engineering, data warehousing, and data analytics solutions.
- Create and review technical designs that align with our business segments.
- Possess advanced level knowledge of the tools and processes required, and function well in large-scale, highly complex, cross-functional data platform environment.
- Work on developing dashboards and reports on different data sources like Big Data, Snowflake, Oracle, and other technology stack, text files and excel documents.
- Advanced scripting and ETL, data modeling (star schema), and work with large data sets.
- Oversees feasibility studies, time and cost estimates, and the establishment and implementation of new or revised projects/ programs.
- Ability to plan, control and supervise multiple BI projects and activities simultaneously.
- Leading small group of offshore developers on multiple parallel projects.
- Assigns work assignments to team members and directs activities, providing technical guidance and completing inpidual tasks as needed.
- Working with IT management, product owners, business managers and business analysts, lead the effort to evaluate user requests and determine solutions to business problems.
- Expert knowledge of IT systems development, including process mapping, budgeting and timeline creation.
- Responsible for liaison between IT and Operations team to drive closure to any urgent on demand issues.
Qualifications:
- 10+ years of overall IT experience in DW/ Analytics space.
- 4 years bachelor’s degree in computer science or relevant field.
- Proven experience designing and implementing solutions in modern data warehouses (like Snowflake) including data modeling, schema design, and performance optimization.
- Proficiency in relevant languages and databases (SQL, Python, PySpark, SnowPark etc.) for data manipulation, data storage and automation tasks.
- Solid understanding of ETL/ Orchestration tools (Informatica ETL (IICS and PowerCenter), AWS Glue, etc.
- DW and Analytics experience will include one or more of the following roles: Data Delivery Lead, Data/ System Analyst, Data/ Reporting Developer.
- Proven track record in project delivery involving business, functional and technical teams.
- Proven experience identifying strategies for risk mitigation to reduce or eliminate issues.
- Experience with leading teams, demonstrated ability to coordinate cross-functional teams towards task completion.
- Experience with Service Operations in a multi-sourced and multi-project environment.
- Experience with Business Intelligence tools such as Power BI, QlikView, Qlik Sense, is preferable.
- Experience in Lifesciences commercial operations domain is preferred, but not required.
- An Agile mindset with experience working in Agile environment.
- A spirit of collaboration and transparent communication.
- Good communication and interpersonal skills, and ability to learn quickly.