BI Developer

The Hartford • Wayne, PA

1d

About The Position

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future. The BI Developer is responsible for designing, developing, and maintaining advanced business intelligence solutions that transform raw data into actionable insights. This role requires expertise in Tableau for data visualization, strong SQL skills for data modeling and optimization, and experience with ETL/ELT tools to ensure efficient data integration. The ideal candidate is a self-starter, problem solver, and critical thinker who can collaborate across teams and communicate insights effectively.

Requirements

• Required Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field.
• 7+ years in BI development, data analytics, or related roles.
• Technical Skills: Advanced proficiency in Tableau (Desktop and Server).
• Strong SQL skills, including stored procedures, views, and functions.
• Experience with ETL/ELT tools (dbt, Talend, Matillion, or similar).
• Familiarity with data warehousing concepts and cloud platforms (Snowflake, AWS, Azure).
• Knowledge of CI/CD practices and version control (e.g., Git).
• Strong understanding of ETL/ELT processes, data warehousing, and data modeling.
• Soft Skills: Strong analytical and problem-solving abilities.
• Excellent communication and storytelling skills.
• Self-starter with curiosity and critical thinking mindset.

Nice To Haves

• Knowledge of Python or other scripting languages for automation.
• Knowledge of data governance and security best practices.

Responsibilities

• Report & Dashboard Development Design, develop and maintain advanced Tableau dashboards and SSRS reports. Ensure visualizations are intuitive, performant, and aligned with business goals. Apply business practices in data visualization to communicate complex data effectively.
• Data Modeling & SQL Development Develop and optimize complex SQL queries, stored procedures, views, and functions. Ensure data accuracy, consistency, and performance across reporting solutions. Work with ETL/ELT tools to prepare and transform data for reporting. Collaborate with data engineering teams to maintain scalable and efficient data pipelines.
• Performance Optimization Monitor and improve dashboard performance. Tune SQL queries and Tableau extracts for scalability.
• Monitor Collaboration & Advisory Partner with data operation engineer, analysts, and architects to design scalable data solutions. Provide guidance on BI best practices and data-driven decision-making. Contribute to documentation, standards, and knowledge sharing across the team. Partner with business stakeholders and technical teams to gather requirements and deliver solutions aligned with business objectives.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees