RIT Solutions, Inc.
BI Analyst / Report Developer
RIT Solutions, Inc., Charlotte, North Carolina, United States, 28245
BI Analyst / Report Developer
Charlotte, NC - Hybrid
Job Description Responsibilities
As an Operational Risk team member, you will be dedicated to help design, implement, and maintain a modern, robust, and scalable platform which will minimize operational risk exposures within the investment process while enabling efficient business growth and innovation. Primary goal will be to make data available and build or update Tableau dashboards. Qualifications
Proficiency in Python programming Strong expertise in SQL, Presto, HIVE, and Spark Experience in big data technologies such as Spark and developing distributed computing applications using PySpark Experience with libraries for data manipulation and analysis, such as Pandas, Polars and NumPy Understanding of data pipelines, ETL processes, and data warehousing concepts Strong experience in building and orchestrating data pipelines Strong experience in data visualization tools and ability to create visual representations of data, particularly using Tableau Extensive experience with key AWS services/components including EMR, Lambda, Glue ETL, Step Functions, S3, ECS, IAM, RDS PostgreSQL, Timeseries DB, Dynamodb, CloudWatch Events/Event Bridge, Athena, SNS, SQS, and VPC Skills in designing and implementing data models, including normalization, denormalization, and schema design Knowledge of data warehousing solutions like Amazon Redshift Strong analytical skills with the ability to troubleshoot data issues Good understanding of source control, unit testing, test-driven development, and CI/CD Ability to write clean, maintainable code and comprehend code written by others Strong communication skills. Knowledge of trading and investment data - Nice to have
Charlotte, NC - Hybrid
Job Description Responsibilities
As an Operational Risk team member, you will be dedicated to help design, implement, and maintain a modern, robust, and scalable platform which will minimize operational risk exposures within the investment process while enabling efficient business growth and innovation. Primary goal will be to make data available and build or update Tableau dashboards. Qualifications
Proficiency in Python programming Strong expertise in SQL, Presto, HIVE, and Spark Experience in big data technologies such as Spark and developing distributed computing applications using PySpark Experience with libraries for data manipulation and analysis, such as Pandas, Polars and NumPy Understanding of data pipelines, ETL processes, and data warehousing concepts Strong experience in building and orchestrating data pipelines Strong experience in data visualization tools and ability to create visual representations of data, particularly using Tableau Extensive experience with key AWS services/components including EMR, Lambda, Glue ETL, Step Functions, S3, ECS, IAM, RDS PostgreSQL, Timeseries DB, Dynamodb, CloudWatch Events/Event Bridge, Athena, SNS, SQS, and VPC Skills in designing and implementing data models, including normalization, denormalization, and schema design Knowledge of data warehousing solutions like Amazon Redshift Strong analytical skills with the ability to troubleshoot data issues Good understanding of source control, unit testing, test-driven development, and CI/CD Ability to write clean, maintainable code and comprehend code written by others Strong communication skills. Knowledge of trading and investment data - Nice to have