| BI Developer (Developer|Data Engineer) || USC ONLY at Remote, Remote, USA |
| Email: [email protected] |
| From: Ishavdeep Singh, Cloud Think Technologies [email protected] Reply to: [email protected] Duties: The BI Developer will be responsible for building data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions with the IT Bus Intelligence & Data Mgt. Team at Cincinnati Insurance. Develop reliable, reusable, automated and streamlined ETL code Analyze and organize raw data from multiple sources to produce requested or required data elements Design table structures and ETL to build performant data solutions that are scalable in a fast growing data ecosystem Create reconciliation procedures and data checks to ensure data quality Build in automated audit, balancing and controls Lead user requirements gathering and documentation designs Proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries Lead application and technical architecture analysis, design and implementation, and ensure BI product fulfills requirements Lead efforts with data management and database specialists to troubleshoot and report issues Design new reporting applications to ensure reporting requests can be supported by the underlying data source Adhere to all metadata management and data quality standards by leading quality management reviews Understand configuration dependencies and interrelationships between data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge Proactively identify, build and maintain relationships with business process owners and colleagues Identify changes in scope or work effort that could result in budgetary overrun or missing of delivery date, design and implement contingency Provide production support, including on-call rotation and technical assistance to end-user and IT staff Required Skills: 3-5 plus years experience with SQL, Data Modeling and Dimensional Modeling Proven experience in designing and implementing ETL processes (preferred tools: IBM's DataStage, SQL, SAS, Python) Understanding of enterprise technical landscape (property and casualty insurance background a plus) Proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models Knowledge of developing BI dashboards (preferred tools: IBM's Cognos, Microsoft's Power BI); creating data quality scorecards and data lineage Strong ability to create effective visual models to enable collective understanding of processes, data flow, user interaction and others as needed Track record of successfully architecting small, medium and enterprise-scale solutions Prior experience or ability to mentor development team members in design and development of BI solutions Experience working with agile teams Provide production support, including on-call rotation and technical assistance to end-user and IT staff Preferred Skills/Characteristics: Experience implementing technical solutions for improving data integrity and reporting Strong quantitative, analytical, and problem-solving skills A detail oriented and self-motivated mindset Worked effectively with technical teams across functional departments Keywords: business intelligence active directory information technology BI Developer (Developer|Data Engineer) || USC ONLY [email protected] |
| [email protected] View all |
| Mon Sep 16 19:39:00 UTC 2024 |