Work in Iowa STEM Jobs

Job Information

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.

About Us

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

  • PTO

  • Paid holidays

  • 401(k) with company match

  • Comprehensive benefits package (Medical, dental, vision)

  • Career development opportunities

  • Free fresh fruit

  • Free coffee and tea

  • Monthly employee events

  • And more!

We do not sponsor employment visas.

Please apply at: https://www.biltd.com/careers/

DirectEmployers