Vacancy expired!
- Analyze data-related business and technical needs, elicit and document requirements related to data integration from source systems to target data warehouse, data marts, data analytic tools, and information delivery solutions.
- Develop SQL to report out information from data warehouse and other data repositories as required by business operations and analytics team.
- Develop hands-on experience with our systems to understand policy, claims and billing life cycles and information collected to operate our business.
- Develop a thorough understanding of our insurance business and business processes and how these are represented in our data within the systems and the data warehouse.
- Support release planning (blueprinting) efforts by identifying data pertinent scope and requirements driven by Policy, Claims, Billing workstreams on major and monthly releases.
- Gather data needs from business consumers: BI/Analytics, Finance, Operations, etc.; and assesses the business "reasonableness” of the requests, as well as getting to the best requirement for the business.
- Perform other duties as assigned.
- Bachelors' degree and at least two years of relevant experience.
- Equivalent is defined as six years of relevant experience.
- Relevant experience as a business analyst for technical projects
- Experience and proficiency in creating SQL queries out of complex data models.
- Understanding of business intelligence/data warehousing technologies
- Preferably strong knowledge of insurance industry data models/modeling relevant to the property & casualty industry and ability to apply models to a newly developed data warehouse and related tools and processes
- Excellent oral and written communication and presentation skills, capable of presenting complex issues in a clear, concise and persuasive manner to the business and technical professionals, including C-level executives
- Strategic mindset with an ability to plan and execute strategies
- Demonstrated initiative, self-starter, with strong analytical and problem-solving skills
- Strong work ethic and commitment to meeting deadlines
- Advanced knowledge of TSQL, database schema design, reports, SQL performance tuning.
- Strong knowledge of related technologies (Data Analytics, Business Intelligence, Warehousing, Information Governance, etc.).
- Ability to troubleshoot difficult and undocumented issues with creative and well-thought-out solutions, after gaining manager's approval
Vacancy expired!