A hands-on technical role that is responsible for data warehousing and business intelligence, with emphasis on reporting and data analytics through the entire project lifecycle. The Business Intelligence Developer will help lead the full Data Warehouse / Business Intelligence implementation across the MedExpress platform.
MedExpress Core Responsibilities:
Has a contagious and positive work ethic, inspires others, and models the behaviors of Genuine, Caring, Friendly.
Demonstrates effective verbal and written communication that is clear, well-organized, and demonstrates an understanding of audience needs.
Through genuine and positive communication, makes each customer feel informed, understood, and special.
An effective team player who contributes valuable ideas and feedback and can be counted on to meet commitments.
Is able to keep up in the MedExpress environment by facing tasks and challenges with energy and passion.
Pursues activities with focus and drive, defines work in terms of success, and can be counted on to complete goals.
Adherence to standards of business conduct and compliance.
Principal Duties and Responsibilities:
Lead overall BI User Experience, working closely with Executives and end users to define how they access, interact, and utilize business data
Proven experience with front-end reporting tools, preferably LogiAnalytics (formerly LogiXML) along with SQL Server Reporting Services (SSRS), web application development, design, and implementation.
Experience with BI Mobile application development and deployment, preferably with Roambi Enterprise
Meet with stakeholders to gather and document data warehouse and/or reporting requirements to ensure development work meets business objectives
Provide dashboard/reporting functionality and create key performance indicators, calculations, and metrics on web and mobile applications
Work in conjunction with offshore data architects/modelers on the backend data warehouse reporting solution running on SQL Server 2012
Experience in writing and tuning SQL queries, view, stored procedures, and functions
Create Microsoft SQL Server Integration Services packages (SSIS), scripts, and other elements to move data from the source databases into the data warehouse
Extract, transform, and load (ETL) data from various source systems to the data warehouse covering a variety of technical scenarios encountered in the construction of complex data warehousing solutions
SQL Server Analysis Services (SSAS) design and build experience including multi-tier infrastructures, partitioning, aggregations, proactive caching, actions, role and data-level security.
Proven experience sourcing data from a variety of applications, creating OLAP models, and generating multi-dimensional cubes using SSAS
Prepare deliverables such as source to target mappings and transformation rules documentation
Minimum 4 years of relevant work experience as a technical BI developer
Four-year college diploma or university degree in computer science or computer engineering
Technically fluent with relational databases - SQL Server 2008, SQL Server 2012
SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) required.
Experience with front end Business Intelligence tools required. LogiAnalytics (formerly LogiXML) preferred.
Experience implementing dashboards/reporting on Mobile devices. Roambi preferred.
Experience working with Security Assertion Markup Language (SAML), Active Directory Federation Services (ADFS) along with Kerberos (cube/dimension level security) preferred
Experience with SAS business analytics software preferred