Senior BI Data Warehouse Developer, Full Time, Miramar FL DIO Office: Information Technology Admin

Education – Bachelor’s degree Skills – SSRS – SSIS – T-SQL – Computer science – Tableau We look forward to having you on a team that will enhance your skills in SSIS, SSRS, and T-SQL development. You will be working on several projects in Data Warehousing and Tableau. Summary: This position is responsible for analyzing complex business intelligence data to inform business decisions and by evaluating datasets, and creating reports, dashboards and extracts for a variety of needs using established tools and data sources. This positions is responsible for all aspects of the Data Warehouse/ Business Intelligence (BI) development lifecycle, including the integration of new data sources, extraction/visualization of data, and quality assurance of data. Detailed responsibilities: – Responsible for creating and updating centralized data models using existing tools independently for complex data sets. – Conducts data discovery, data profiling and data modeling for complex data sets to gather insights and identify trends. – Builds Extract, Transform and Load (ETL) processes to normalize, apply business rules, and load data into tabular and multi-dimensional models within the business intelligence platform. – Works with assigned application teams to stay up-to-date with their data models, applications, tools, workflows and regulations. – Identifies upcoming workflow changes or software upgrades that may impact reports, dashboards or centralized data models. – Works closely with less experienced business intelligence team members to design specifications for new centralized data models or updates to existing models. – Leverages expertise to troubleshoot complex issues, perform root cause analysis, and take proactive corrective measures. – Coordinates a curriculum for coaching and training junior-level employees as well as customers in the use of business intelligence tools to enhance business decision-making capability. – Uses historical data from available industry reports, public information, field reports or purchased source to extract insight using data analysis and modeling to inform business decisions. – Leverages advanced analytical technologies within the business intelligence structure to assist with implementation, maintenance and support of data methodologies, outcomes, and insights. – Uses data from all sources to inform decisions, identify trends and drive insights. – Develop models and algorithms to support required reporting and innovation Competencies and skills:Essential: – STANDARDS OF BEHAVIOR: Acts in a manner that supports the standards of communication, respect, privacy, and teamwork by demonstrating a commitment to professional and ethical conduct. – CUSTOMER SERVICE: Demonstrates commitment to service excellence by promptly addressing internal/external customer issues/requests, resolving concerns while maintaining a professional image and behavior to build and enhance the patient/family/customer experience. – ACCOUNTABILITY: Accepts ownership of job roles and specific assignments/goals; works independently, takes responsibility for own actions; admits mistakes and judgment errors; and accepts constructive feedback. Connects personal work results to the accomplishment of team and organizational goals. – RESPONDING TO CHANGE: Accepts change and adapts in a positive and productive manner; handles unexpected situations and changes in direction calmly and with confidence. Views new assignments and job responsibilities as an opportunity for growth. – SYSTEMS ARCHITECTURE: Designs and adapts an information technology framework that accommodates multiple, co-existing operating systems. – IT CUSTOMER SUPPORT: Responds timely to end user requests for technical assistance. – EFFECTIVE COMMUNICATION: Communicates effectively with various audiences using the most appropriate method for the situation. – PROBLEM SOLVING: Ability to identify, analyze and effectively solve problems. – EFFECTIVE PRESENTATIONS: Develops and delivers presentations using effective facilitation techniques and audio visual materials. – DATA EXTRACTION AND TRANSFER: Creates scheduled processes to extract data from one application and transfer it to another application. – DATA MODELING AND AGGREGATION: Develops centralized data models specialized for the reporting and analysis needs of the health system. – DATA WAREHOUSING: Develops and supports centralized data models specialized for the reporting and analytics needs of the health system. Education:Essential: – Bachelors Education specialization:Essential: – Information Technology Credentials: Education equivalent experience:Essential: – Computer Science, or related field. Relevant work experience may substitute for education requirement. Other information: Complexity of Work: Requires critical thinking skills, decisive judgment and the ability to work with minimal supervision. Must be able to work in a stressful environment and take appropriate action. May require specialized knowledge in a business line. Required Work Experience: Minimum 4 years of relevant experience. Healthcare and Claims experience required if supporting Population Health Working conditions:Essential: – Bending and Stooping 60.00% – Climbing 60.00% – Keyboard Entry 60.00% – Kneeling 60.00% – Lifting/Carrying Patients 35 Pounds or Greater 20.00% – Lifting or Carrying 0 – 25 lbs Non-Patient 60.00% – Lifting or Carrying 25.01 lbs – 75 lbs Non-Patient 60.00% – Lifting or Carrying > 75 lbs Non-Patient 20.00% – Pushing or Pulling 0 – 25 lbs Non-Patient 60.00% – Pushing or Pulling 26 – 75 lbs Non-Patient 60.00% – Pushing or Pulling > 75 lbs Non-Patient 20.00% – Reaching 60.00% – Repetitive Movement Foot/Leg 20.00% – Repetitive Movement Hand/Arm 20.00% – Sitting 60.00% – Squatting 60.00% – Standing 60.00% – Walking 60.00% – Audible Speech 80.00% – Hearing Acuity 80.00% – Depth Perception 60.00% – Distinguish Color 60.00% – Seeing – Far 40.00% – Seeing – Near 60.00% – Bio hazardous Waste 20.00% – Biological Hazards – Respiratory 20.00% – Biological Hazards – Skin or Ingestion 20.00% – Blood and/or Bodily Fluids 20.00% – Communicable Diseases and/or Pathogens 20.00% – Dust 60.00% – Gas/Vapors/Fumes 20.00% – Hazardous Chemicals 20.00% – Computer Monitor 60.00% – Fire Risk 20.00% – Hazardous Noise 20.00% – Moving Mechanical Parts 40.00% – Needles/Sharp Objects 40.00% – Potential Electric Shock 40.00% – Potential for Physical Assault 20.00% – Radiation 20.00% – Wet or Slippery Surfaces 40.00% Disclaimer: This job description is not intended, nor should it be construed to be an exhaustive list of all responsibilities, skills, efforts or working conditions associated with the job. It is intended to indicate the general nature and level of work performed by employees within this classification.