As a BI Developer Senior to BI Developer Lead in the Commercial Lines group you'll assist our business partners with their data analysis and reporting. This will include your coding of complex, cost-effective solutions for business related problems. You'll interact daily with our business customers, serving as a knowledge expert to prepare business specific data analysis, build new and maintain existing ETL structures, multidimensional cubes, and reporting to aid in their decision making.
This is a Cleveland based role. Open to work-from-home several days a week
Must-have qualifications
- Bachelor's degree or higher in an Information Technology or Business discipline or related field of study (e.g., Computer Science, MIS, Business Management) and a minimum of 2 years designing/developing, programming and supporting software programs/applications.
- In lieu of a degree, a minimum of 4 years related work experience with working knowledge of designing/developing, programming and supporting software programs/applications.
Preferred skills
- Proficient with the Microsoft BI stack (SSIS,SSAS), including recent versions of SQL Server. Also proficient with Tableau or similar.
- Strong experience in design and implementation of ETL framework for complex data mart projects. Plus experience in multiple database platforms, including SQL Server and DB2/Oracle.
- Strong knowledge of data modeling, data warehousing, and data quality with proven ability to architect and build solution-oriented data models (i.e. architecture, business process, design, and the implementation of automation).
- Experience working with data analysts, IT, and/or project teams to define data requirements and execution to streamline the data ingestion.
- Scripting language skills – C#, Python to aid with complex ETL structures & along with some application development knowledge. Knowledge of Big Data technologies and Cloud (i.e. Azure, AWS, Snowflake) is a plus.
Compensation
- $72,800 - $117,500/year depending on position level and experience
- Gainshare bonus up to 30% of your eligible earnings based on company performance
Benefits
- 401(k) with dollar-for-dollar company match up to 6%
- Medical, dental & vision, including free preventative care
- Wellness & mental health programs
- Health care flexible spending accounts, health savings accounts, & life insurance
- Paid time off
- Paid & unpaid sick leave where applicable, as well as short & long-term disability
- Parental & family leave; military leave & pay
- Diverse, inclusive & welcoming culture with Employee Resource Groups
- Career development & tuition assistance
- Onsite gym & healthcare at large locations
Sponsorship for work authorization for this position is available for candidates who already possess a H-1B visa
Equal Opportunity Employer