Business Intelligence / Python Visualization Developer

About the position

Castleton Commodities International is hiring a Business Intelligence Developer to join our Data Science and Technology team. The ideal candidate will have demonstrated a passion for solving business problems by creating visualizations in Microsoft Power BI. In addition, the candidate will have experience working directly with databases, including writing SQL and data modeling. This position is a hands-on role responsible for developing, supporting, and maintaining visualizations. This is an excellent opportunity for candidates with a strong technical background to interface directly with technical colleagues and CCI's commercial trading teams.

Responsibilities

• Work directly with commercial trading teams to create and optimize visualization solutions for Natural Gas, Power, and Oil analytics projects.
• Develop scalable and maintainable PowerBI dashboards and reports, which will be adopted throughout the organization, enabling users to make informed decisions.
• Utilize Streamlit to create custom, interactive web applications for data visualization and exploration.

Requirements

• 3+ years of hands-on development in Power BI (excellent knowledge of DAX and Power Query).
• Strong database/SQL skills - Writing complex SQL queries for data analysis.
• Experience working with cloud-based data warehouses such as Snowflake.
• Experience with Python based visualization technology such as Streamlit, Dash, Plotly.
• Strong analytical skills are required, including a thorough understanding of interpreting customer business needs and translating them into report/dashboard visualization requirements.
• Ability to communicate and interact with a wide range of users, from very technical to non-technical.
• Results-oriented team player who can handle rapidly changing projects and priorities while maintaining a strong professional presence.
• Strong analytical skillset with demonstrated attention to detail.
• The candidate should be passionate about technology and stay current with trends.
• Fast learner with the ability to adapt quickly and work in a dynamic environment.
• Excellent time management skills.
• Data warehousing concepts (e.g., Facts, Dimensions, Star and Snowflake design, etc.) and SQL query performance tuning.
• Experience working with Power Automate.

Benefits

• Competitive comprehensive medical, dental, retirement and life insurance benefits
• Employee assistance & wellness programs
• Parental and family leave policies
• CCI in the Community: Each office has a Charity Committee and as a part of this program employees are allocated 2 days annually to volunteer at the selected charities.
• Charitable contribution match program
• Tuition assistance & reimbursement
• Quarterly Innovation & Collaboration Awards
• Employee discount program, including access to fitness facilities
• Competitive paid time off
• Continued learning opportunities