Senior Data Engineer

Our not-so-secret sauce. Award-winning, inclusive, Top Workplace culture doesnt happen overnight. Its a result of hard work by extraordinary people. More than 10,000 of the industrys brightest talent drive our efforts to deliver purposeful work and meaningful impact every day. Learn more about what makes us different and how you can thrive as a Senior Data Engineer at MMA National. Marsh McLennan Agency (MMA) provides business insurance, employee health & benefits, retirement, and private client insurance solutions to organizations and individuals seeking limitless possibilities. With 180 offices across North America, we combine the personalized service model of a local consultant with the global resources of the worlds leading professional services firm, Marsh McLennan (NYSE: MMC). A day in the life. As a Senior Data Engineer on the MMA National IT Data and Analytics Team, we will count on you to develop and maintain scalable data pipelines, enhance data models, and provide subject matter expertise in data acquisition and consumption pipelines on Azure, Databricks and Confluent. It involves developing best practices, reusable code, libraries, and frameworks for cloud-based data warehousing and ETL, and uses multi-cloud, programming languages like Java, Scala, Python, RDBMS, NoSQL databases, and design enterprise data warehouse platforms. By fostering collaboration and aligning with business objectives, you will have the opportunity to elevate data models, drive data-driven decision-making, and enhance data accessibility throughout the organization. Join us in championing data-driven decision-making and becoming an essential contributor to our data-driven success. Our future colleague. Wed love to meet you if your professional track record includes these skills: 7 years of hands-on experience designing and implementing data engineering solutions using Azure cloud offerings including Data Factory, Azure Synapse, ADLS, and Azure Functions and Logic Apps. In-depth understanding and experience in data engineering and data warehousing best practices, data modelling, data security and governance principles throughout data lifecycle. Hands-on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle), as well as complex stored procedures and functions using SQL and optimization of SSIS packages and Redshift database queries. Experience designing and building data pipelines using APIs, BigQuery and Streaming ingestion methods. Proficiency in Spark, Python and ability work with telemetry using Azure monitor, App insights. Solid understanding of DevSecOps, Git integration, Code deployment using CI/CD pipelines, managing work in an agile environment using Azure Boards, Confluence. Ability to troubleshoot and deploy using Redgate tools and Visual Studio is a must. These additional qualifications are a plus, but not required to apply: Familiarity with Modern Data Platforms technologies like Snowflake, Matillion, Bryte Flow, and Tableau is a plus. Knowledge in Azure IoT, Azure HDInsight Spark, Kafka and Azure Stream Analytics is a bonus. Experience with Informatica - IICS task flows development and maintenance. Data bricks, Microsoft Azure Data Engineer, and/or other cloud certifications. We know there are excellent candidates who might not check all of these boxes. Dont be shy. If youre close, wed be very interested in meeting you. Valuable benefits. We value and respect the impact our colleagues make every day both inside and outside our organization. Weve built a culture that promotes colleague well-being through robust benefit programs and resources, encourages professional and personal development, and celebrates opportunities to pursue the projects and causes that give colleagues fulfilment outside of work. Some benefits included in this role are: Generous time off, including personal and volunteering Tuition reimbursement and professional development opportunities Remote work Charitable contribution match programs Stock purchase opportunities To learn more about a career at MMA National, check us out online: http://marshmma.com/careers or flip through our recruiting brochure: https://bit.ly/3Qpcjmw Follow us on social media to meet our colleagues and see what makes us tick: https://www.instagram.com/lifeatmma/ https://www.facebook.com/LifeatMMA https://twitter.com/marsh_mma https://www.linkedin.com/company/marsh-mclennan-agency/ The applicable base salary range for this role is $101,300-$151,900. The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives. We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, 401K savings and other wellbeing programs as well as employee assistance programs. Applications will be accepted until: September 24th, 2024 Who you are is who we are. We embrace a culture that celebrates and promotes the many backgrounds, heritages and perspectives of our colleagues and clients. We are always seeking those with ethics, talent, and ambition who are interested in joining our client-focused teams. Marsh McLennan and its affiliates are EOE Minority/Female/Disability/Vet/Sexual Orientation/Gender Identity employers. LI-Remote