Federal Home Loan Bank of Indianapolis
Sr. Data Warehouse Developer - Hybrid
Federal Home Loan Bank of Indianapolis, Indianapolis, Indiana, us, 46262
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 rewardsIndustry-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 KnowledgeGeneral
Decision Making/JudgmentDependabilityProductivityPeople
CommunicationPosition 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.
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 rewardsIndustry-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 KnowledgeGeneral
Decision Making/JudgmentDependabilityProductivityPeople
CommunicationPosition 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.