Project Manager

Robotic Process Automation LLC; Illinois; On-site; USD 120,000 - 180,000; Full time

Job summary

Robotic Technologies Automation in Illinois is seeking a Senior data platform engineer to lead Snowflake-based data warehousing initiatives and oversee Power BI, Cognos, and Talend environments. You will design DB objects and schemas, write SQL/Python scripts for loading and transforming data, and monitor platform utilization across Snowflake and Azure.

This role requires strong communication with client stakeholders, collaboration with onsite and offshore teams, and ensuring security and

Qualifications

• Extensive knowledge on data warehousing technologies.
• Extensive Snowflake platform experience for large projects.
• Scripting with Unix and Python for loading, extracting, and transforming data.
• Develop DB objects (tables, views, stored procedures) on Snowflake with knowledge of Snow pipes.
• Knowledge of cloud technologies Azure.
• Good knowledge on Power BI Reporting Platform.
• Good knowledge on Cognos reporting Platform.
• Strong knowledge and hands-on experience with SF queries, DB Model, and Python.
• Excellent communication and interpersonal skills and stakeholder management.
• Proficiency in SQL, Python, or scripting languages for data operations and warehousing concepts.
• Familiarity with data security, governance, and compliance standards.

Responsibilities

• Interacting with customer and discovering needs for each tool set.
• SF Platform operations knowledge and maintaining various SF environments.
• Monitor the Snowflake system utilization.
• Power BI Platform operations knowledge and maintaining various environments of Power BI.
• Talend Platform operations knowledge and maintaining various environments of Talend.
• Work with large data volumes including structured and unstructured data.
• Prioritize tasks and follow customer processes for timely completion.
• Coordinate with onsite and offshore teams on work plans.
• Provide timely status reporting to the customer.

Skills

SQL

Python

Unix scripting

Data warehousing

Cloud platforms

Stakeholder management

Communication

Tools

Snowflake

Power BI

Cognos

Talend

Azure

Job description

• 1 Program Management Skills + Platform Operation Knowledge on BI tools like Snowflake, Talent, Azure, Power BI , Cognos on Admin functions
• 2 Required Technical Skill Set Good Knowledge on Snowflake eco system, Snowflake Architecture, Power Bi, Cognos, Talend and Azure Platform, Snow SQL, Python

Desired Competencies (Technical/Behavioral Competency)

Must-Have

• Extensive knowledge on data warehousing technologies
• Extensive experience in designing and developing on Snowflake Platform using snowflake ecosystems for the large projects.
• Development of scripts using Unix, Python, etc. for loading, extracting, and transforming data into the DB.
• Develop DB objects Table, views, stored procedure on SF and knowledge of snow pipes
• Knowledge of cloud technologies Azure
• Good knowledge on Power Bi Reporting Platform
• Good knowledge on Cognos reporting Platform
• Strong knowledge and hands-on experience with SF queries, DB Model, and high-level languages like Python etc.
• Excellent Communication and Interpersonal Skills, builds solid internal and external relationships and managing client stakeholders.
• Proficiency in SQL, Python, or scripting languages for data operations, warehousing concepts
• Familiarity with data security, governance, and compliance standards

Good-to-Have

1. 1. Netezza, Oracle, MS SQL Server (One of the RDBMS – Knowledge)
2. 2. ETL experience on technology like Talend
3. 3. Unix
4. 4. Python, Power BI

Responsibility of / Expectations from the Role

• Interacting with customer and focusing on discovering customer needs and finding out how to best meet them for each of their tool set.
• SF Platform operations knowledge and maintaining various environment of SF
• Monitor the Snowflake system utilization
• Power BI Platform operations knowledge and maintaining various environment of Power BI
• Talend Platform operations knowledge and maintaining various environments of Talend
• Work with large data volumes including structured and unstructured data
• Ability to prioritize tasks, execute them by complying to processes and towards timely completion. Follow all the customer processes.
• Interact with the other Onsite team and offshore team do work plan to them.
• Provide timely status reporting to the customer.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.