logo inner

Sr. Data Warehouse Developer - Hybrid

Federal Home Loan Bank of IndianapolisIndianapolis, Indiana, United StatesRemote, Hybrid, Onsite

Is it a Bank? A cooperative? A leader in affordable housing? We are all those things and more!


Our core mission at FHLBank Indianapolis is to provide reliable and readily available liquidity to our member institutions to support housing finance and community development. Simply put, we’re a bank for banks, credit unions, community development financial institutions and insurers across Indiana and Michigan. We also assist in meeting the economic and housing needs of communities and families through grants and subsidized advances that support affordable housing and economic development.

But enough about us, let’s talk about you.


Are you looking for a company that views their employees as their greatest asset?A company that’s dedicated to making a difference in the community? So much so they pay their employees to volunteer?Do you want to join a talented workforce that prioritizes diversity, equity and inclusion, and promotes learning and development, unique skills/ideas, and employee engagement?

If you’ve said yes to these questions, then we might be a match!


Here is what we offer:



  • Flexible hybrid workforce model: Onsite three days a week and two days remote. We also offer five fully remote weeks per year!

  • Fantastic, competitive pay and total rewards

  • Industry-high 401(k) match: up to 6% PLUS…an additional 4% contribution!

  • Tuition reimbursement assistance: To help you continue to develop personally and professionally.

  • Student loan repayment assistance: That’s right, we will help you repay outstanding student loans!

  • Awesome Benefits Package: Medical, dental, vision benefits and even pet (you read that right) insurance!

  • Generous time off: Vacation, paid federal holidays, birthday month floating holiday, volunteer day and summer hours program

  • “Dress for your day” dress code: You choose the appropriate work attire based on what your day looks like.

Statistics show that it is less likely for some candidates to submit their application if they don't meet all the criteria within the job description. If this is you, we encourage you to give yourself a chance and submit your application anyway, as you may be the perfect match for this role!  ​


Purpose


:


The Senior Data Warehouse Developer will lead the delivery of BI/DW initiatives and advocate for the use of best practices in all development and data migration solutions. The following statements are intended to describe the general nature and level of work being performed by persons assigned to the job. They are not intended to be an exhaustive list of all responsibilities or abilities required of persons so classified. The Bank reserves the right to alter or amend this description at any time.

Specific Responsibilities


:



  • Provide technical leadership, direction, and mentoring for team members.

  • Analyze project requirements, establishes project milestones, and leads peers towards completion of milestones.

  • Design and develop Business Objects Universes and Business Objects WEBI reports.

  • Design and develop ETL jobs, including writing scripts and complex SQL statements.

  • Create and execute ETL job schedules.

  • Optimize ETL jobs.

  • Create and maintain technical design documentation.

  • Assist in data modeling and design for data marts and data warehouses.

  • Identify data quality issues. Be responsible for understanding source system database structures and underlying data by performing source system data profiling, including structure, data, and relationship discovery.

  • Collaborate with team members throughout the SDLC to perform model reviews, data reviews, issues resolution, and assure the successful delivery of applications.

  • Consolidate, integrate, and deliver data for warehouse solutions.

Competencies:


Business



  • Job Knowledge

General



  • Decision Making/Judgment

  • Dependability

  • Productivity

People



  • Communication

Position Requirements


:



  • BS in Computer Science or related technical field.

  • Minimum 5 years’ experience implementing BI solutions with Business Objects suite.

  • Minimum 5 years’ experience implementing ETL processes in Business Objects Data integrator/Data Services.

  • Minimum 7 years’ experience with data migration/integration projects and/or data warehouse projects.

  • Proven experience on ETL design & architecture.

  • Strong SQL or T-SQL background.

  • Experience with SQL Server (experience with Oracle 11G a plus).

  • Experience in performance tuning of ETL jobs and data models.

  • Experience migrating ETL code from development to production environments.

  • Strong conceptual, communications, and technical skills.

  • Exceptional data analysis skills.

  • Must be able to work independently.

  • Must not have been convicted on any civil or criminal charge that would suggest a risk to Bank security.

  • Ability to work full time.

  • Ability to uphold and model the Bank’s Guiding Principles.

FHLBank Indianapolis is an Equal Opportunity Employer.


Life at Federal Home Loan Bank of Indianapolis

The Federal Home Loan Bank of Indianapolis is a wholesale bank that provides loans, grants, and business services to member financial institutions in Indiana and Michigan. We are one of twelve such banks in the Federal Home Loan Bank System established in 1932. FHLBanks are privately capitalized and funded, and receive no Congressional appropriations
Thrive Here & What We Value1. Dedicated to strengthening communities throughout our region2. Views employees as their greatest asset3. Promotes learning, development, diversity, equity, inclusion, unique skills/ideas, employee engagement4. Offers flexible hybrid workforce model (three onsite days and two remote)5. Provides competitive pay with industry-high 401(k) match up to 6% PLUS an additional 4% contribution6. Offers tuition reimbursement assistance, student loan repayment assistance7. Provides comprehensive benefits package including medical, dental, vision insurance, and pet insurance8. Generous time off (vacation, paid federal holidays, birthday month floating holiday, volunteer day, summer hours program)9. “Dress for your day” dress code policy10. Offers five fully remote weeks per year
Your tracker settings

We use cookies and similar methods to recognize visitors and remember their preferences. We also use them to measure ad campaign effectiveness, target ads and analyze site traffic. To learn more about these methods, including how to disable them, view our Cookie Policy or Privacy Policy.

By tapping `Accept`, you consent to the use of these methods by us and third parties. You can always change your tracker preferences by visiting our Cookie Policy.

logo innerThatStartupJob
Discover the best startup and their job positions, all in one place.
Copyright © 2024