Alliant Credit Union
We set the standard for simple and rewarding digital banking.
Hybrid

Data Modeler

Sorry, this job was removed at 3:33 p.m. (CST) on Monday, April 20, 2020
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply
By clicking Apply Now you agree to share your profile information with the hiring company.

Start a Rewarding Career with Alliant

 

What will your day look like?

You will be responsible for setting the strategy for the translating business requirements into the Data Warehouse data model for use in the Business Intelligence platform, to oversee the development of data extraction and integration routines and to incorporate data quality and validation routines. This position will also create/maintain the logical and physical data models, lead the effort for a Business Glossary to empower Self-Service Analytics, and for conversion of business requirements into detailed technical designs. You must understand the dimensional/relational modeling techniques and bridge the gap between the OLTP developers, data warehouse developers, and DBA teams.

 

A key responsibility is to work with business stakeholders and peers (such as Business Analysts, Data Integration and Business Intelligence Engineers, DBAs, and business owners) to enhance the organization’s enterprise data warehouse.

 

The Data Modeler will be expected to leverage their deep technical knowledge of data modeling and data integration best practices along with cross industry data expertise to empower the business to make data-driven decisions.
 

 

Responsibilities

Do you see yourself doing this?

  • Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
  • Expert knowledge in dimensional data modeling, ETL processes, data integration applications and business intelligence tools. SAP Business Objects and Tableau a plus.
  • Interacts with OLTP systems and translated relational models into dimensional models.
  • Drives conversations with development teams and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance
  • Participates in collaborations to transform business requirements into ETL and data validation designs. This includes knowledge sharing and mentoring fellow team members.
  • Evaluates source system data and data models
  • Assists with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
  • Address data related problems in regards to systems architecture, integration, compatibility, and multiple-platform integration

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, 3+ years of experience writing and tuning complex SQL (T-SQL in SQL Server), and you have:

  • Experience with software quality assurance testing, release procedures, coding design and documentation protocol.
  • Solid experience using Informatica PowerCenter in a Data Warehouse environment. Experience in Informatica Data Transformation and Metadata Manager a plus.
  • Proven success working in a collaborative and Agile environment (Scrum methodology a plus).
  • Demonstrates analytical thinking and strong problem solving skills
  • Strong working knowledge across the technology stack including ETL, data analysis, metadata, data quality, audit and design
  • Experience or exposure to SAP Business Objects & Crystal, Tableau, Hadoop, and CA ErWin
  • Proven background designing and architecting ETL solutions as part of a cross-functional team
  • Experience in making hardware recommendations, sizing, and configuration for development systems
  • Experience in Hybrid Cloud based implementations and architecture preferred. Azure experience a plus.

 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
See More
Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.

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.

More Jobs at Alliant Credit Union

Apply Now
By clicking Apply Now you agree to share your profile information with the hiring company.
Learn more about Alliant Credit UnionFind similar jobs like this