Brokers International Data Engineer in Urbandale, Iowa
Employee-Centric Culture…Industry-Wide Impact
Now is an exciting time at Brokers International, we’re in a key position to chart the future of the insurance landscape, and we’re searching for creative thinkers, innovative problem solvers, and exceptional leaders to join our family.
Over nearly four decades, we’ve developed a rich, family-focused culture that values work-life balance and encourages all our team members to grow, collaborate, innovate, and have fun every day.
We want all our team members to enjoy where they work, what they do, and who they work with. Best of all we start our weekends early, closing the office every Friday at 3.
Our family is growing. We’re looking for a Data Engineer to develop, implement, and maintain our business-critical data management processes to create scalable efficiencies across our next-gen Data Warehouse. If you’re up to the challenge, we encourage you to apply and join the BI family.
What You’ll Be Responsible For:
Plans, designs, develops, and implements database tables and processes in line with our data architecture and develop solutions based on database designs.
Perform, develop, and test ETL (Extract, Transform, Load) processes to support reporting integrating data from various data sources into the Data Warehouse.
Identify, profile, and map relevant data sources.
Perform field analysis and mapping to ensure adherence to current standards while identifying and resolving discrepancies.
Adhere to and enforce data security requirements to ensure data is treated as a protected asset.
Knowledge, Skills, and Abilities:
Must demonstrate our Core Values—Teamwork, Work Ethic, Integrity, and Customer Service
Be willing to have fun, be challenged, and grow
Adapt to shifting priorities in an agile environment
Effectively collaborate with peers on technical topics and work towards optimal solutions
Strong SQL skills (T-SQL, PL/SQL, etc.) with experience writing queries, stored procedures, and query optimization.
Understands database design concepts and best practices (3NF, Normalization/Denormalization, Dimensional Model.)
Experience and/or Education:
Bachelor’s Degree in Computer Science, Computer Engineering, Information Systems, or similar.
5+ years of professional experience working with relational and/or dimensional databases.
Experience in an Agile Environment, preferred.
Experience with one or more ETL tools such as Informatica, SSIS, Wherescape Red, etc., preferred.
Experience with ACORD Standard and/or DTCC, preferred.
We’re one of the nation’s largest and longest-standing insurance marketing organizations. We were founded by Roger McCarty, with a focus on meeting the needs of agencies and financial professionals, and providing them with quality products, programs, and service.
As a member of our team, you’ll join a dedicated staff who work to make a real difference for independent agents and financial professionals around the nation.
Benefits and Perks
We want you to succeed here. Not only do we give competitive salaries, we also regularly recognize and reward outstanding performances through our incentive programs. Yes, that’s right. That means you get bonuses for doing great work. Plus, we have some pretty sweet benefits:
We wear jeans every day
Ability to telecommute
Flexible hours, plus we close at 3 p.m. every Friday
401(k) with company match
Comprehensive benefits package (Medical, dental, vision)
Career development opportunities
Free fresh fruit
Free coffee and tea
Monthly employee events
We do not sponsor employment visas.
Please apply at: https://www.biltd.com/careers/