Job Location : Urbandale,IA, USA
Job Title - Data Engineer Business Unit - Brokers International Location - Urbandale, IA About Brokers International As The Original Agency Builder since 1983, Brokers International is one of the largest and most experienced insurance marketing organizations in the country. We work effortlessly to help our agency partners, and their financial professionals build their businesses and serve their customers through innovative products, marketing, compliance, and operational support. In June of 2021, we partnered with Integrity Marketing Group, the nation's largest independent distributor of life and health insurance products, to help us expand our reach and provide a more holistic planning service to agents and agencies across the industry. BI and it's subsidiary organizations are making significant investments in talent, operations, sales and marketing capabilities, and digital platforms in order to step-change its ability to drive accelerated growth as a strategic partner. Our culture is one of inclusion, diversity of thought and passionate teamwork. You will be surrounded by individuals that are passionate about our company, our brand, the level of support we provide our partners, and working as one integrated team. Our core values are Teamwork, Work Ethic, Integrity, and Customer Service. If you are up for the challenge, come join us and be part of taking BI on a new journey of accelerated growth and success. Job Summary Excellent opportunity to join a successful well-established wholesale insurance company looking to grow to the next level. The Data Engineer has design, development and support responsibility for our business-critical data. In addition, this position is responsible for implementing the established data architecture, relying on experience and good judgement to design and develop solutions that expand our solid foundation. Utilizes existing or upcoming technology to set process automation and improvements where they are possible. Primary Responsibilities: Plan and design solutions, creating tables, views, triggers, partitions, procedures, functions, indexes and other database objects in line with our data architecture Analyze database and system response time and determine optimization and tuning recommendations Support the Data Warehouse by responding to process failures, data anomalies and performance events by taking appropriate measures to reduce system downtime and eliminate recurrence of problems. Perform and develop ETL (Extract, Transform, Load) processes to support reporting by integrating data from a variety of data sources into the Data Warehouse. Test ETL process, perform analysis, identify changes and share appropriately. Make data architecture and design recommendations based on database design concepts (3NF, Normalization/Denormalization, Dimensional Model) aiding in the decision-making process for their usage. Modify existing reports and/or develop new reports by analyzing databases, data sources and data structures, delivering critical reporting to customers both internally and externally. Adhere to and enforce data security requirements and solutions: help ensure that data (both on-premises and in the cloud) is treated as a protected asset. Primary Skills & Requirements: 8 years professional experience working with relational and/or dimensional database. Bachelor's degree in Computer Science, Computer Engineering, Information Systems or similar. Experience in an Agile Environment, preferred. Experience in Azure suite of tools including Azure SQL DW, Azure Synapse and/or Azure Data Factory preferred. Experience with one or more ETL Tools such as Informatica, SSIS, PowerCenter, Wherescape Red, etc, preferred. Experience with ACORD Standard, XML and/or DTCC, preferred. About Integrity Integrity is one of the nation's leading independent distributors of life, health, and wealth insurance products. With a strong Insurtech focus, we embrace a broad and innovative approach to serving agents and clients alike. Integrity is driven by a singular purpose: to help people protect their life, health and wealth so they can prepare for the good days ahead. Integrity offers you the opportunity to start a career in a family-like environment that is rewarding and cutting edge. Why? Because we put our people first At Integrity, you can start a new career path at company you'll love, and we'll love you back. We're proud of the work we do and the culture we've built, where we celebrate your hard work and support you daily. Joining us means being part of a hyper-growth company with tons of professional opportunities for you to accelerate your career. Integrity offers our people a competitive compensation package, including benefits that make work more fun and give you and your family peace of mind. Headquartered in Dallas, Texas, Integrity is committed to meeting Americans wherever they are - in person, over the phone or online. Integrity's employees support hundreds of thousands of independent agents who serve the needs of millions of clients nationwide. For more information, visit Integrity.com. Integrity, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability, veteran status, or any other characteristic protected by federal, state, or local law. In addition, Integrity, LLC will provide reasonable accommodations for qualified individuals with disabilities. About Integrity Integrity is one of the nation's leading independent distributors of life, health and wealth insurance products. With a strong insurtech focus, we embrace a broad and innovative approach to serving agents and clients alike. Integrity is driven by a singular purpose: to help people protect their life, health and wealth so they can prepare for the good days ahead. Integrity offers you the opportunity to start a career in a family-like environment that is rewarding and cutting edge. Why? Because we put our people first At Integrity, you can start a new career path at company you'll love, and we'll love you back. We're proud of the work we do and the culture we've built, where we celebrate your hard work and support you daily. Joining us means being part of a hyper-growth company with tons of professional opportunities for you to accelerate your career. Integrity offers our people a competitive compensation package, including benefits that make work more fun and give you and your family peace of mind. Headquartered in Dallas, Texas, Integrity is committed to meeting Americans wherever they are - in person, over the phone or online. Integrity's employees support hundreds of thousands of independent agents who serve the needs of millions of clients nationwide. For more information, visit Integrity.com. Integrity, LLC is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, national origin, disability, veteran status, or any other characteristic protected by federal, state, or local law. In addition, Integrity, LLC will provide reasonable accommodations for qualified individuals with disabilities.