SW Developer Sr.

Company: Mercury Insurance
Location: Brea
Posted on: August 6, 2022

Job Description:

Position Summary:Minimum 10 years' experience in Business Intelligence, Data AnalyticsMinimum if 6 year experience in Informatica, Java/Python.Excellent data analysis and data profiling skillsProficient in building Conceptual, Logical and Physical data modeling for Data Lake, ODS, EDW, and Semantic LayersProficient in cloud-based data warehouse using Redshift, Snowflake, etcExperience working with AWS cloud data services such as Athena, S3, Glue, Spectrum, Kinesis, etcProficient in writing complex SQL queriesApply Dev/Ops mindset, take ownership of production success, optimize, automate and lead the resolution of production issues to ensure high-availability and performanceExperience on Agile software development methods - knowledge in JIRA, Confluence, etcKnowledge in analytical tools like Power BI, Tableau, MicroStrategy, etcAbility to troubleshoot and identify performance bottlenecks for Redshift and other cloud DatabasesProvide 24/7 production support.Self-motivated, responsible, conscientious, and detail orientedAbility to work independently and in conjunction with a team. Takes ownership of work assignments and manages them to completionStrong interpersonal and communication skills (both verbal and written) and ability to interact with and effectively address concernsEssential Job Functions:Collaborate with Architects, Product owners, development and business teams to understand and collect data requirementsPartner with source system SMEs to analyze the data and design dimensional models to integrate with enterprise data warehousesEnsure data integrity, consolidation, consistency and metadata development in conjunction with data governance and data product ownersPartner with Data Engineers to implement and improve current and new data martsImplement best practices for ETL and data modelingWork on deployment and production support activitiesResearch and contribute to system architecture and designPrepare detailed functional specificationsResearch new technologies, define best practices, define standards, develop code libraries and frameworks, develop Proof of ConceptsEducation:---Bachelor's Degree required in information technologies with specific emphasis on process design and software development

Keywords: Mercury Insurance, Fullerton , SW Developer Sr., IT / Software / Systems , Brea, California