Job description

Department: HSC Finance and Admin Location: Health Sciences Center Time Type: Full time Worker Type: Regular Job Req ID: R105748 Minimum Requirements: Bachelor's degree in a related field and eight (8) years of relevant experience or an equivalent combination of education and experience. Grade 11 (Salaried) Position Description: Health Science Center Finance and Administration is looking for a highly skilled Business Intelligence Engineer V (Data Engineer) with a passion for data architecture, data warehousing, and big data technologies to join our growing Business Intelligence and Analytics team. The ideal candidate will have a deep understanding of data engineering best practices and experience in designing and implementing scalable data pipelines. You will work closely with our Business Intelligence and Analytics team and non-technical users across the Health Science Center translating business opportunities into data products that enable the organization with actionable data driven insights. The ideal candidate will be self-directed and excited by the prospect of solving complex organizational processes and democratize data and analytics across the organization ensuring data integrity, optimizing data workflows, and support data-driven decision-making across the organization. Essential Duties and Responsibilities • Design, build, and maintain efficient, reliable, and scalable data pipelines and ETL processes. • Understand and manage the data needs of various stakeholders. • Develop and optimize data models, data warehouses, and data marts to support various business functions. • Collaborate with cross-functional teams to understand data requirements and translate them into technical solutions. • Implement and manage data integration solutions using various tools and frameworks such as: Apache Parquet, Apache Kafka, Apache Spark, AWS Glue, Delta Tables MongoDB, Node, Javascript, SQL, MS SQL Server Analysis Services, API’s, DAX, M, Fabric, Alteryx, etc. • Monitor and troubleshoot data pipelines and workflows to ensure high availability and performance. • Advocate for best practices in data engineering, including data quality, data governance, and data security. • Lead and mentor junior data engineers and other team members, providing guidance and support on technical and project-related issues. • Stay up-to-date with emerging technologies and industry trends, and recommend improvements to our data infrastructure. • Business Partnership: Partner with various non-technical business partners ranging from the C-Suite to the entry level analyst, data scientists and Senior Director of BI and Analytics on solution requirements to design solutions. Execute the Senior Director of Business Intelligence and Analytics vision translating data into actionable insights addressing business needs and objectives. Delves deeply into technology applications and a varying array of large data sources, determining the appropriate data for the analysis to be performed, discovering issues, identifying potential uses, and preparing for analysis. • Data Management: Works with the Senior Director of Business Intelligence and Analytics to streamline established data warehouses, initiates new development of databases, production data, and available tools to build strategic datasets in support of key initiatives. Establishes and systematically performs processes to assess and validate data accuracy. Successful candidate will implement automated ETL process ensuring data quality, accuracy is maintained and facilitates advanced analytical capabilities including diagnostic, descriptive, predictive, and prescriptive analytical capabilities. • Process Automation: Familiar with our current technology stack (PowerApps, Power Automate, Alteryx, RPA, etc.) to systematically perform automation of current manual processes to eliminate human error, further improving consistency, productivity and accuracy. Utilize technology to build automation services which includes data collection and analysis that will enable the team to drive innovation and automation of operation systems. • Configuration Management: Work directly with users to identify needs and resolve software configuration problems. Ability to modify software to meet user needs and monitor and troubleshoot common and daily tasks and events as well as changes. • Advanced Analytics: Works closely with the Senior Director of Business Intelligence to implement AI and Machine Learning capabilities across the Health Science Center as well advancing the use of predictive and prescriptive analytics. • Project Management: Independently gathers requirements from appropriate business partners for project, including necessary data for analysis to be performed. Develops project plans, executes on deliverables within agreed upon timeframes, manages deadlines, communicates progress and makes recommendations to address issues. • Implementing data security measures and access controls to protect sensitive information. • Liaise with data team for proper data sourcing and transformation for BI data model, with a solid understanding of data sources and their ultimate application and relation to the reports. • Responsible for the design and implementation of scalable & fault tolerant data applications (on-prem SQL & cloud based) to store and process large amounts of data from upstream sources with high availability. • Responsible for full life cycle methodology including change management processes and ensuring changes are properly tested and migrated to production. • Understand and maintain compliance with data management best practices and standards established by the Central IT office and the Senior Director of Business Intelligence and Analytics. Review and optimize current data management procedures ensuring they are aligned with the industry leading practices. Stay up to date on latest trends in data engineering, visualization and recommended best practices. • Ascertains and executes plans to build, implement and maintain operations reports using available tools and programming languages. Monitors and provides feedback on model performance and recalibrates model as necessary. • Perform other duties as assigned. Preferred Qualifications • Bachelor’s degree or equivalent work experience in Computer Science, Engineering, Mathematics, Accounting/Finance or a related field. • 2+ years of experience as a Data Engineer or similar role, with a proven track record of designing and implementing data solutions. • 1+ years in the higher education industry or in business analytics consulting, including experience in Business Intelligence Analytics as well as Healthcare, Accounting, Finance, and Operations analytics. • Strong proficiency in SQL and experience with database systems such as PostgreSQL, MySQL, MongoDB or Oracle. • Experienced with Python, R, and other data science and analysis programming languages. • Demonstrated general proficiency with MS Analysis Services and Tabular Models builds, leveraging DAX for calculated measures/columns, M experience. • Familiar with big data technologies and frameworks such as Hadoop, Spark, or Kafka. • Apache Parquet, Apache Kafka, Apache Spark, AWS Glue, Delta Tables MongoDB, Node, Javascript, SQL, MS SQL Server Analysis Services, API’s, DAX, M, Fabric, Alteryx, etc. • Familiarity with cloud platforms like AWS, Azure, or Google Cloud Platform and their data services (e.g., Redshift, BigQuery, Data Lake). • Proficiency in programming languages such as Python, R, SQL, Java, or Scala. • Experience with data modeling, data warehousing, and ETL/ELT processes. • Excellent problem-solving skills and the ability to work independently as well as part of a team. • Strong communication skills and the ability to convey complex technical concepts to non-technical stakeholders. • Demonstrated high proficiency with Business Intelligence tools (PowerBI, Tableau, etc.) • Demonstrated general proficiency in data management and enterprise data platforms (e.g., Microsoft SQL Server, MongoDB, etc.) and programing/statistical modeling software (e.g., Python, SAS, R, Alteryx) • Experience with rational database i.e. SAS, SQL, MS Windows based query software. • Familiar with Python, R, DAX, M with PowerBI experience. • Familiar with data integration Apache Kafka, Apache Spark, or AWS Glue, MongoDB, Node, Javascript, SQL, MS SQL Server Analysis Services, API’s, Alteryx, DAX, and M, etc • Experienced with obtaining user needs and translating into analytical solutions and managing the development process. • Experienced with communicating the results of technical analysis and recommendations to non-technical users across the organization including Senior Leadership. • Advanced Experience with data visualization technologies, Power BI. • Experience with containerization and orchestration tools such as Docker and Kubernetes. • Knowledge of data visualization tools like PowerBI, Tableau or Looker. • Familiarity with machine learning frameworks and data science tools. • Experienced with PowerApps and other similar software. • Demonstrated implementation of complex and innovative solutions. • Demonstrated experience with process documentation and re-engineering. • Demonstrated success developing and presenting solutions to complex business situations, supported by sound and thorough analytics solutions. • Strong quality control and testing techniques and attention to detail. • High degree of independence and exceptional work ethic. Competencies • Critical thinking: intellectually disciplined process of actively and skillfully conceptualizing, applying, analyzing, synthesizing, and/or evaluating information gathered from, or generated by, observation, experience, reflection, reasoning, or communication, as a guide to belief and action. • Decision Making: Ability to identify a decision by gathering information, and assessing alternative resolutions. • Program Management: Skill of managing programs mapped to business objectives that improve organizational performance. • Problem Solving: Ability to define a problem; determine the cause of the problem; identifying, prioritizing, and selecting alternatives for a solution. • Integrity: the practice of being honest and showing a consistent and uncompromising adherence to strong moral and ethical principles and values. • Communication: Balancing listening and talking, speaking and writing clearly and accurately, influencing others, keeping others informed. • Efficiency: Planning ahead, managing time well, being on time, being cost conscious, thinking of better ways to do things. • Excellent written and verbal communication skills. • Professional, proactive demeanor. • Strong interpersonal skills. • Ability to develop and maintain strong collaborative working relationships with Technology and Business Stakeholders. Compensation will be commensurate to candidate experience. Equal Employment Opportunity The University of Louisville is an equal opportunity, affirmative action employer, and is committed to providing employment opportunities to all qualified applicants without regard torace, sex, age, color, national origin, ethnicity, creed, religion, disability, genetic information, sexual orientation, gender, gender identity and expression, marital status, pregnancy, or veteran status. If you are unable to use our online application process due to an impairment or disability, please contact the Employment team atemployment@louisville.eduor 502.852.6258. Assistance and Accommodations Computers are available for application submission at the Human Resources Department located at 215 Central Avenue, Ste 205 - Louisville, Kentucky 40208. If you require assistance or accommodation with our online application process, please contact us by email atemployment@louisville.eduor by phone 502-852-6258.

Requirements