Business Intelligence / Python Visualization Developer (Hybrid 3/2 Work Schedule)

Castleton Commodities International; Houston (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Developer to join their dynamic Data Science and Technology team. This hands-on role is perfect for candidates passionate about solving complex business problems through innovative visualizations using Microsoft Power BI and SQL. You'll collaborate directly with commercial trading teams to create impactful analytics solutions for Natural Gas, Power, and Oil sectors. The position offers the opportunity to work with cutting-edge technologies like Streamlit and cloud-based data warehouses, making it an exciting chance to enhance your technical skills in a fast-paced environment. If you thrive in a collaborative setting and are eager to make a difference, this role is for you.

Benefits

Comprehensive medical benefits

Dental insurance

Retirement benefits

Employee assistance programs

Tuition assistance

Paid time off

Wellness programs

Charitable contribution match

Quarterly Innovation Awards

Employee discount program

Qualifications

• 3+ years of experience in Power BI and SQL development.
• Strong analytical skills with attention to detail.

Responsibilities

• Create and optimize visualization solutions for analytics projects.
• Develop scalable Power BI dashboards for informed decision-making.

Skills

Power BI

SQL

Data Visualization

Analytical Skills

Communication Skills

Python

Adaptability

Education

Bachelor's Degree in a relevant field

Tools

Microsoft Power BI

Streamlit

Snowflake

Power Automate

Job description

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.

Qualifications:

• 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.

Employee Programs & Benefits:

CCI offers competitive benefits and programs to support our employees, their families and local communities. These include:

• 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

Visit https://www.cci.com/careers/life-at-cci/# to learn more!