Description Our team is looking for a data driven person who has engineered and supported critical applications in an insurance / financial environment and is experienced in analytics, business intelligence, data warehousing and setting up data pipe
Our team is looking for a data driven person who has engineered and supported critical applications in an insurance / financial environment and is experienced in analytics, business intelligence, data warehousing and setting up data pipelines across the enterprise. This seasoned professional will need to interface with multiple client groups and IT management, providing them with data solutions, timely and accurate status updates, short-term / long-term plans, release plans, etc. in a clear consistent manner that emphas performance metrics, strategic planning, continuous improvement and adherence to industry best practices.
Data engineering abilities and expertise in using SQL, DDL/DML, performance tuning, data modelling and data warehousing techniques. Knowledge of Python/Java with an ability to code in other web languages.
Experience working with relational/non-relational databases and understanding of storage technologies like MySQL, Aurora PostgreSQL, SQL Server, Oracle, DB2. Work with DBA and other staff as necessary, to instantiate physical databases based on the models.
Cloud Data Technologies: Experience working with cloud services and cloud data warehouses.
Experience with big data tools Athena, Redshift, HIVE, Presto, Spark, Kafka, etc. Experience with AWS Glue, Redshift, Athena, Parquet file formats, Snowflake, or data lake architecture is a plus.
Data Analysis & Design: Review data sources and assess data quality; determine the appropriate data inputs, outputs and integration rules and strategy. Create functional design specifications to be used by the developers. Advanced problem solving, data ...