Business intelligence manager [h1.location_city]

POSITION TITLE : Business Intelligence Developer II

COMPENSATION : Pursuant to Colorado regulations, if this job is performed in Colorado, the salary range is $95,000 - $105,000 plus bonus potential. ​Eligible to participate in the . We offer health, vision, dental, and pet insurance. We offer a 401(k) retirement plan, student loan assistance, licensing and continuing education reimbursement, parental leave, and housing allowances or gifts.

DIRECT REPORT : Business Intelligence Cloud Architect

SUMMARY : The Business Intelligence Developer II is responsible for designing, developing, and implementing BI solutions that support Cardinal’s end-to-end BI and Analytics ecosystem. The BI Developer II will partner with the BI Architect and key business stakeholders to design, implement, and optimize data models and reporting structures within Cardinal’s EDW, gather and translate business and technical requirements, and help govern Cardinal’s back-end data platform.

RESPONSIBILITIES (Included but not limited to)

• Design, build, and optimize technical solutions that meet business needs by delivering data in an efficient, scalable, and durable manner within Cardinal’s EDW.
• Lead data modeling efforts through requirements gathering, process documentation, and data discovery efforts.
• Design and implement advanced data models in SQL, including :
• Table definitions
• Complex procedure builds
• Advanced function development
• Optimized view definitions
• Perform and present complex ad-hoc analyses of relevant business processes.
• Provide front-end support in our Business Intelligence tool, including dashboard maintenance, managing ETL data flows, and occasionally designing and building new reports.
• Proactively diagnose, debug, and resolve inaccuracies and inconsistencies within deployed database objects.
• Establish, document, and champion standard operating procedures and warehousing standards.
• Own and maintain data dictionaries and metadata repositories.
• Optimize and monitor daily database operations, including diagnosing and resolving inefficiencies and instabilities.
• Enforce and improve a governed data environment through the application of warehousing standards, best practices, and established conventions as defined with the BI Architect.
• Serve as a key technical liaison to business stakeholders, managing support needs and translating feature requests into technical solutions.
• Mentor Junior Developers through code reviews, technical guidance, and best-practice enforcement.

QUALIFICATIONS

TECHNICAL EXPERIENCE

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Incumbents primarily work in an office environment but may also have frequent exposure to outside of apartment buildings and in all areas of the property including amenities and have frequent exposure to outside elements where temperature, weather, odors, and / or landscape may be unpleasant and / or hazardous.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is regularly required to use hands to finger, type, handle, or feel and talk or hear. The employee regularly required to stand; walk; reach with hands and arms, and climb, stoop, or squat. The employee is often required to sit. Incumbents must be able to physically access all exterior and interior parts of the property and amenities and must be able to work inside and outside in all weather conditions including, but not limited to rain, snow, heat, hail, wind and sleet. The employee must be able to push, pull, lift, carry, or maneuver office products and supplies of up to twenty (20) pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus. Routine local travel is required to attend training classes, client visits, or other situations necessary for the accomplishment of some or all of the daily responsibilities of this position. Overnight travel required to attend company functions, training, property visits, and other situations necessary for the accomplishment of special projects that may be assigned from time to time.

The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as assigned by their supervisor.