RIT Solutions, Inc.
Location: Hyrbid Chicago but Fully onsite August 4th-September 26th
Interview Mode: Virtual 2 rounds
Type: Contract 6 months
Notes: Need to come up to speed with developing business critical reports. dozen tableau reports need to be built, each one has 8-10 sub reports (very complex). - reports are specific to OCCs business (margin calls) Not brand-new reports, but need to be migrated to a new environment (data sources need to be rebuilt, etc) Dashboards will stay consistent to the end user while they work under the hood Working in 2 week sprints
5 days a week onsite - 4th of august through 26th of September. 3 day a week onsite outside of this time Expert building dashboards Needs some Alteryx workflow experience Good understanding of role level security should have Need very strong comm skills- will be holding demos across exec stakeholders Must be very strong with SQL AWS cloud would be helpful Tableau public cloud link would be helpful or sample of work with submittal Experience in enterprise regulated environments
I. WORK TO BE PERFORMED:
Analyze and understand reporting requirements of various business streams Develop BI reports using best practices and adhere to best performance standards Setup report security and user access to relevant contents Develop BI data model for high performance and flexibility Develop Tableau data extracts and pass-thru queries for reporting needs Analyze the dimensional data model for reporting suitability and suggest changes if needed Collaborate with the BI Lead, DBA and ETL teams as required Provide support as required to ensure the availability and performance of developed reports and dashboards
II. SKILL AND EXPERIENCE REQUIRED:
5+ years of data-centric design and development experience with primary focus on BI, reporting, and analytics solution development 3+ years of experience architecting, designing, and developing enterprise-wide reporting solutions with Tableau business intelligence software suite Experience in performance optimization of complex workbooks, visualizations and dashboards using large datasets Experience with analyzing and developing Alteryx workflows Experience with Linux/ command line and git Understanding of relational and non-relational databases, data systems and data warehouses Strong knowledge of SQL, data warehousing concepts, various data management systems Scripting knowledge using Shell scripting, Python, or equivalent Experience working with Cloud ecosystems (AWS, Azure, GCP) Understand data models and their relationship to reporting Ability to interact with business users to identify reporting and data analysis needs Understanding of financial markets for derivatives and derivatives instruments Understanding of the software development life cycle (SDLC) in Waterfall, Lean, and Agile work environments Excellent communication and presentation skills
Notes: Need to come up to speed with developing business critical reports. dozen tableau reports need to be built, each one has 8-10 sub reports (very complex). - reports are specific to OCCs business (margin calls) Not brand-new reports, but need to be migrated to a new environment (data sources need to be rebuilt, etc) Dashboards will stay consistent to the end user while they work under the hood Working in 2 week sprints
5 days a week onsite - 4th of august through 26th of September. 3 day a week onsite outside of this time Expert building dashboards Needs some Alteryx workflow experience Good understanding of role level security should have Need very strong comm skills- will be holding demos across exec stakeholders Must be very strong with SQL AWS cloud would be helpful Tableau public cloud link would be helpful or sample of work with submittal Experience in enterprise regulated environments
I. WORK TO BE PERFORMED:
Analyze and understand reporting requirements of various business streams Develop BI reports using best practices and adhere to best performance standards Setup report security and user access to relevant contents Develop BI data model for high performance and flexibility Develop Tableau data extracts and pass-thru queries for reporting needs Analyze the dimensional data model for reporting suitability and suggest changes if needed Collaborate with the BI Lead, DBA and ETL teams as required Provide support as required to ensure the availability and performance of developed reports and dashboards
II. SKILL AND EXPERIENCE REQUIRED:
5+ years of data-centric design and development experience with primary focus on BI, reporting, and analytics solution development 3+ years of experience architecting, designing, and developing enterprise-wide reporting solutions with Tableau business intelligence software suite Experience in performance optimization of complex workbooks, visualizations and dashboards using large datasets Experience with analyzing and developing Alteryx workflows Experience with Linux/ command line and git Understanding of relational and non-relational databases, data systems and data warehouses Strong knowledge of SQL, data warehousing concepts, various data management systems Scripting knowledge using Shell scripting, Python, or equivalent Experience working with Cloud ecosystems (AWS, Azure, GCP) Understand data models and their relationship to reporting Ability to interact with business users to identify reporting and data analysis needs Understanding of financial markets for derivatives and derivatives instruments Understanding of the software development life cycle (SDLC) in Waterfall, Lean, and Agile work environments Excellent communication and presentation skills