Job Description
Role: Cognos ETL Developer
Location: Philadelphia, PA
Client: Randstad/Brown Brothers Harriman
Responsibilities:
>Maintain and enhance the Data Protection Business Intelligence tool
>Develop and maintain advanced reporting, analytics, dashboards, and other
BI solutions using Cognos Analytics
>Design, implement, and automate ETL processes with source data coming
from DBs (SQL and Oracle), CSV files, and Splunk
>Integrate new data feeds into the DPBI tool, ensuring seamless data flow
and enhanced reporting capabilities
>Utilize Python for data analysis, modeling, automation tasks, and
integration activities
>Write and maintain scripts in Python and PowerShell to automate data
processing, workflow tasks, and support data protection related control
enhancements
>Collaborate with cross-functional teams to understand data needs, gather
requirements, and deliver scalable data solutions
>Ensure data accuracy and integrity by implementing quality controls and
validation processes
>Stay up-to-date with the latest technologies and methodologies in data
science, machine learning, analytics, and data protection
>Contribute to the development of best practices for data management,
data governance, analytics, and data protection within the organization
Qualifications:
>Bachelor's degree
>Experience with Cognos Analytics
>Experience with platforms: Windows environment, Exchange, Office365
>Experience with data analytics technologies as well as analytical and
dimensional modeling
>Experience with Business Intelligence
>Experience with Power Automate
>Experience in coding/scripting with Python and Powershell
>Experience with Splunk
>Experience with SQL
>Adept networking and system administration abilities
>Experience in developing solutions in a Windows environment and for Microsoft products (Office365, Exchange etc.)
>Experience in developing, implementing, and managing Data Warehouse Solution