Business Intelligence Data Analyst (6375)

"Our basic strength lies in the people who work here." - Samuel C. Johnson.

The words of our founder are indicative of how we have valued our people for more than 35 years. We believe that our associates are our greatest asset and strive to make sure they know it. Along the way, we've earned a reputation for developing and rewarding successful people. Johnson Bank is the proud recipient of numerous workplace of choice awards including FORTUNE magazine's "100 Best Companies to Work For" in 2008, Number 1 Best Place to Work in Southeastern Wisconsin (MRA/Milwaukee Magazine) and Best Places to Work in The Valley (Phoenix Business Journal/BestCompaniesAZ).Description



Analyze logical / physical database designs, data models, and definitions for data warehouses. Assist with design of data models. Work directly with clients, ETL analysts, and database engineering team to design and develop high performance database solutions for analytical analysis and reporting. Monitors data load processes, validates results, and determines related data patterns. Work closely with business units to define data requirements. Support medium to large scope projects which are technically complex and cross business functions. Required Skills



Analyzes logical and physical data models and database definitions.

Provides data element naming consistent with standards and conventions and ensures that data dictionaries are maintained across multiple database environments.

Consults with database administration and client areas in resolving questions regarding translation of data requirements to database design.

Provides in-depth consulting to clients, IT management, and IT staff in the identification and resolution of information flow and data quality issues.

Performs data modeling studies and develops detailed data models.

Works with clients, IT management, and IT staff to establish and maintain consistent data element definitions.

Participates in the design, development, and maintenance of corporate data architecture, data management standards and conventions, data dictionaries and data element naming standards, and conventions for multiple computing environments to support data warehousing and efficient data mining.

Evolves models to meet new and changing business requirements.

Identifies and investigates data patterns for issue resolution.

Effectively writes detailed functional specifications and data environment documentation.Required Experience



B.S. or B.A. degree and 3-5 years work experience in data modeling, data warehousing, data mining, data entity analysis, logical and relational database design or an equivalent combination of education and work experience.

Demonstrated expertise in data analysis, data warehouse technologies and data tools.

Excellent analytical ability, judgment, and problem analysis techniques.

Knowledge of the business unit's functions and applications, excellent consultative skills and the ability to work effectively with clients, IT management, and IT staff.

Ability to independently create and query multi-dimensional and relational databases.

Demonstrated problem solving skills and analytical skills.

Excellent verbal, written, technical, and interpersonal communication skills.

Ability to work independently with minimal direction.

Leader as well as a team player with ability to foster good working relationships with both and client teams.

Strong attention to detail and excellent sleuthing capabilities

Willingness to promote, embrace, and reflect the JFG vision and mission.Johnson Bank and Johnson Insurance are part of Johnson Financial Group, a premier financial services company offering comprehensive financial solutions in the areas of banking, trust, insurance, investment management and leasing. As a privately-owned company, we pride ourselveson the enduring values and principles of our founder Sam Johnson and the Johnson Family. In the midst of five generations of change andevolution, those values and principles have not changed and serve to guide us in all we do.JFG wants to be your place for opportunity through a competitive compensation and excellent benefit package which includes medical, dental, life, vacation, holidays as well as educational reimbursement for our associates. To learn more about our organization and our career opportunities please visit johnsonbank.com.Please apply for this position directly at: http://hostedjobs.openhire.com/epostings/jobs/submit.cfm?fuseaction=dspjob&jobid=281330&company_id=15760&jobboardid=24Johnson Financial Group is an equal opportunity employer. We embrace differences, welcome diversity, and value a culture of respect.