Alliant Credit Union

We set the standard for simple and rewarding digital banking.

Hybrid

View Profile

Jobs//Hybrid//Data + Analytics//

Sr. Business Intelligence Engineer

Sorry, this job was removed at 1:15 p.m. (CST) on Wednesday, December 23, 2020

View 470 Jobs

Find out who's hiring in Chicago.

See all Data + Analytics jobs in Chicago

View 470 Jobs

Apply

By clicking Apply Now you agree to share your profile information with the hiring company.

Save job

Start a Rewarding Career with Alliant

What will your day look like?

You will be responsible for collaborating with business teams and data owners to successfully implement and maintain enterprise level business analytics and data warehousing solutions. The ideal candidate must be able to support our business partners with their reporting needs, via dashboards, Business Object reports, mobile reporting, and self-service analytics requirements. Work involves moderate to complex difficulty in working on multiple high-level projects concurrently. Candidate must have a medium to expert level at designing, implementing, and operating our Business Intelligence toolkit. Additional requirements include experience in the financial industry and understanding requirements management process, and report testing and validation process.

Responsibilities

Do you see yourself doing this?

Participates in collaborating with end user to transform business requirements into BI and Reporting requirements
Strong working knowledge across the technology stack using SAP Business Intelligence tool (Version 4.1 and above) such as WebI, Designer, Data Explorer, Dashboards, Lumira and Crystal reports
Experience in data analysis and design using SAP tools such as Lumira, Data Explorer, Crystal Reports for Self-service reporting
Exposure to ETL tools such as Informatica and DB environment on MS SQL 2012/14 will be a great plus
At least 8-10 year of experience in design, develop and testing of BI Reports in Data warehouse environment is must
Experience in working with Global development teams in Agile development is required
Ability to communicate complex IT requirements with all levels of audiences (Marketing, Ops, Finance, Developers, QA and Senior Management)
Experience in SDLC process such as change management, Bug and issue Tracking, Report Test Management to resolve application issues or to implement development enhancements would be a plus
Prior experience in Estimating – Reporting requirements and Leading Data analysis efforts across reporting requirements would be a big plus
Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design
Technologies currently used and supported are: SQL Server Database, Business Objects, Crystal, Informatica PowerCenter, and Informatica Metadata Manager
Design and develop or modify ETL processes that load data for the data warehouse users or for web applications using ETL tools
Provide assistance with ETL design, development, and performance tuning
Design and architect ETL solutions as part of a cross-functional team
Will be responsible to Coordinate and lead onsite and offshore delivery/Support team of 3-5 FTE on report development and BI Support
Will be responsible to support Enterprise BI and Self-service initiatives
Responsible for identifying/enhancing/implementing industry best practices in BI and Analytics space
Responsible to ensure Application Service levels across all BI application

Qualifications

What makes you a great fit?

You’ll be a great fit if in addition to the Completion of a Bachelor’s degree in Computer Science or a related field, minimum of 5 years of BI analytics experience in a Data Warehouse environment, and you have:

Experience with administration and development in SAP Business Objects and Crystal Reports
Experience with administration and development in Tableau
Experience in working in Agile development teams (via Scrum methodology)
Experience in SDLC process such as change management, Bug and issue Tracking, Report Test Management to resolve data issues or to implement development enhancements
Project Management experience with Scheduling, Resource Loading, Planning and reporting on large project/program & Technical knowledge in software development methodologies, design and implementation required
Prior experience working in Financial Service industry a plus

Technical Skills:

Platforms: MS Windows
Database Management Systems: Microsoft SQL Server 2012/2014/2016
Data integration: Informatica PowerCenter ETL, Informatica Data Transformation Tool, and HortonWorks
BI Reporting: SAP Business Objects & Tableau
Job Scheduling: SMA Solutions OpCon
File Movement: GO Anywhere Managed File Transfer
Experience working with SharePoint
Azure/AWS Cloud experience a plus
Agile Development – Scrum Training
MS-Office/Visio
Experience working with SharePoint Data & OLAP environment
SQL, Strong SQL/T-SQL, MS PowerShell scripting

Preferred Technical Skills:

Languages: SQL, Strong SQL/T-SQL, MS shell scripting,
Good understanding of SharePoint 2012 environment
SAP BI 4.0 reporting tools, ER win R9.0

Additional Skills:

Ability and willingness to develop creative solutions to business problems and work well within a team environment
Must be able to multi-task and balance multiple projects in a fast-paced environment
Must have good communication and collaboration skills
Solid diagnostic, testing, and problem-solving skills. Good organizational and time management skills
Ability to adapt to a fast-paced and changing environment
Must be enthusiastic, team-oriented and positive attitude

When you’re happy, we’re happy!

As a thank you for joining our team, you’ll benefit from:

Competitive medical, dental, and free vision benefits
Competitive compensation plan
Contributions towards gym memberships
Generous PTO and banking holidays off

Apply Now

By clicking Apply Now you agree to share your profile information with the hiring company.

Save job

Email For Later

loading ...

Emailed

By clicking Apply Now you agree to share your profile information with the hiring company.

Calli Cardillo

Director, Technical Strategy & Portfolio Management

PUTTING PEOPLE FIRST

Propelling product forward through teamwork

Cardillo oversees enterprise execution for digital products at Alliant. To this end, her team has been rapidly growing and building out new processes and changes to products designed to enhance customer experience. She credits her team with being her number one asset in approaching these goals. “Happiness in teams leads to top output,” Cardillo said. To encourage a happy and healthy team environment, they align on individual development plans. Employees are encouraged to join ERGs, explore their strengths and pursue training and certification programs.

I feel genuinely supported by the team I work with. It is so rewarding to celebrate successes as a team when you can directly see and feel the impact from how hard everyone is working.

Crystal Luna

Director, Banking Operations

EMPOWERING EMPLOYEES

Inviting contributors to take the lead

Since joining Alliant in 2006, Luna has experienced the company’s focus on professional development first hand, advancing through several roles into a senior leadership position. “My approach to leadership has always been to take my team along for the ride,” Luna said, noting that she celebrates the successes of direct reports that move into managerial positions. As the founder of EMPOWER, Alliant’s Black professionals ERG, Luna is committed to creating leadership opportunities for a diverse workforce and ensuring the company is an equitable and inclusive place that elevates its employees.

I take a supportive role and allow my team members to take the lead. This showcases their talents to others in the organization and gives them the confidence to take on bigger roles and responsibilities.

Sean Briscoe

Director, Credit Product Strategy & Analytics

PRODUCING FINANCIAL WELLBEING

Developing tech in service of people

Briscoe was initially excited to join Alliant for two reasons: its forward-thinking digital-first approach to lending and its commitment to serving members as a nonprofit organization. His team recently set its sights on improving Alliant’s flagship Visa Cashback Signature Card, working with product, marketing, compliance and technology teams to enhance member experience. “We continue to find new opportunities for growth and new ways to serve our members,” Briscoe said. “The team at Alliant is engaged, energized, self-motivated and always member-focused.”

Everything I do helps improve the financial lives of our members, and each one of my ideas is heard and taken seriously.

What are Alliant Credit Union Perks + Benefits

Alliant Credit Union Benefits Overview

Alliant constantly works on improving its Employee Value Proposition. Our Human Capital Group team seeks ongoing employee feedback to continue to raise the bar on employee-focused benefits, making updates to the existing and adding new benefits every year.

Culture

Volunteer in local community

Alliant offers 8 hours of paid volunteer time benefit for all employees.

Partners with nonprofits

To execute on our mission of Bridging the Digital Divide, Alliant has partnered with PCs for People, Connected Nation, DiGiTunity and the National Digital Inclusion Alliance.

Open door policy

OKR operational model

Team based strategic planning

Flexible work schedule

Alliant provides employees with a flexible work schedule that includes Flexible start and end times.

Remote work program

Since the pandemic began, all non-essential job functions have been remote 100%.

Diversity

Documented equal pay policy

Dedicated diversity and inclusion staff

Highly diverse management team

Mandated unconscious bias training

Alliant provides our leaders and employees with unconscious bias, psychological safety and inclusive mindset training.

Diversity manifesto

Diversity employee resource groups

Alliant supports employee resource groups. At this time, employees created INCLUDE, a women's resource group and ALL, an LGBTQ+ employee resource group, and EMPOWER black employees' resource group.

Hiring practices that promote diversity

At Alliant, we ensure that we have a diverse candidate slate for every role for which we hire and that our interview panels are also diverse.

Health Insurance & Wellness Benefits

Flexible Spending Account (FSA)

Alliant employees can contribute up to $2,750 annually to their Health Care FSA and $5,000 to their dependent care FSA.

Disability insurance

Company provides Short Term Disability benefit payable for up to 13 weeks as well as Long Term Disability insurance that covers 66.67% of your monthly earnings up to $10,000 monthly maximum payout.

Dental insurance

Preventive services covered at 100%, Basic services covered at 80%; Major restorative services covered at 50%; Orthodontics covered at 50%

Vision insurance

Alliant offers free vision benefits to its employees and their dependents. The vision benefits plan covers 100% for annual eye exams after a $10 copay and $150 for glasses and contacts.

Health insurance

Alliant provides a choice of two medical plans. If you elect a medical plan, you are automatically enrolled in an HSA where Alliant contributes funds to help you pay for your out-of-pocket expenses.

Life insurance

Basic Life insurance and Accidental Death & Dismemberment is equal to 1 times an employee's annual salary. Employees can also purchase Voluntary Life insurance for themselves and their dependents.

Pet insurance

Our pet insurance policy covers up to %90 of out of pocket expenses.

Wellness programs

With Alliant's wellness reimbursement program, each employee receives up to $35 per month (non-cumulative) to spend on wellness activities and discounted wellness services through ThrivePass.

Mental health benefits

Alliant employees get free access to ComPsych, Calm and myStrength apps and services.

Financial & Retirement

401(K)

Alliant offers a 401(k) plan administered through Fidelity where employees can contribute up to 60% of eligible compensation to the annual IRS limit.

401(K) matching

We match 100% of contributions up to the first 5% of an employee's annual gross pay. eligible salary. You will be 100% vested in these contributions right away.

Performance bonus

In the last years, Alliant’s bonus payouts were above 100%.

Charitable contribution matching

The Alliant Credit Union Foundation also matches employee donations made to non-religious, non-political 501(c)(3) organizations up to a total of $1,000 per person per calendar year.

Child Care & Parental Leave Benefits

Generous parental leave

We provide up to 6 weeks of parental leave for the primary and secondary caretakers.

Family medical leave

Employees who have been with the company for 12 months are eligible for up to 26 weeks of family medical leave.

Vacation & Time Off Benefits

Unlimited vacation policy

Generous PTO

Our employees receive between 21 and 31 days per year of paid time off based on years of service. Alliant also offers a Flexible Time Off (unlimited time off) policy for Sr. Managers and above.

Paid volunteer time

Our employees receive 8 hours per year of paid volunteer time.

Paid holidays

Office Perks

Commuter benefits

Employees can withhold up to $280 per month pre-tax for transit expenses and up to $280 per month pre-tax for parking expenses.

Company-sponsored outings

Alliant hosts between 4 and 6 major employee events in a year, including the Annual Volleyball Tournament, annual summer party and employee appreciation day celebration.

Free snacks and drinks

Currently, Alliant offers free snacks, free hot beverages and bottled water during the day, free lunch/food events on occasion and bi-weekly free fruit.

Some meals provided

Fitness stipend

Alliant reimburses its employees up to $35 per month for gym, health and fitness services and activities.

Professional Development Benefits

Job training & conferences

Alliant offers employees professional development opportunities like Annual individual budget for training, onsite training courses and the ability to attend job-related conferences and seminars.

Tuition reimbursement

We offer up to $5,250 annually for continuing education through our tuition reimbursement benefit.

Lunch and learns

Alliant hosts lunch and learn and hour with the leader meetings once per quarter, giving our employees to hear from our executive and senior leadership teams.

Promote from within

Continuing education stipend

We offer up to $5,250 annually for continuing education through our tuition reimbursement benefit.

Online course subscriptions available

Customized development tracks

Paid industry certifications

Additional Perks + Benefits

Alliant constantly works on improving its Employee Value Proposition. Currently, Alliant offers free snacks, free hot beverages and bottled water, free lunch/food events on occasion, personal concierge service, on-site package/mailing service, massage therapy, discounted ticket sales, car wash, dry cleaning, convenience store, vehicle maintenance, banking and a gym at our headquarters location.

Our company works hard to create a work environment that allows our employees to maintain a healthy work/life balance. We encourage our employees to take advantage of flexible hours and offer an option to work remotely. Alliant also offers a very generous PTO package, which starts new employees with 21 PTO days annualized in their first year of employment.

The well-being of our employees and their families translates to productivity and commitment to their jobs. That is why we constantly work on launching new benefits that will help them find the best medical care at the lowest cost and get the help they need with convenience and without unnecessary stress.

View full list of perks + benefits

Photo Gallery