| ETL BI Developer || Data Engineer at Remote, Remote, USA |
| Email: [email protected] |
| From: Saurabh Rai, Cloud Think Tech Inc. [email protected] Reply to: [email protected] Title- ETL BI Developer (Developer/Data Engineer) -2 Direct Hire/Contract/Contract to hire: 6-Month Contract to Hire Location- Remote Duties: The ETL 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 Required Skills: Proven experience in designing, developing and implementing ETL processes (preferred tools: IBM's DataStage, SQL, SAS, Python) 3-5 plus years experience with SQL, Data Modeling and Dimensional Modeling 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 ETL BI Developer || Data Engineer [email protected] |
| [email protected] View all |
| Tue Oct 22 22:05:00 UTC 2024 |