.. Company: PharMerica Overview: PharMerica is seeking a highly capable and motivated individual to join our team. PharMerica is a non-retail pharmacy that focuses on providing exceptional customer service and meeting the pharmacy needs for hospitals, rehabilitation facilities, long-term acute care centers .. read more
** Business Intelligence Data Warehouse Developer**
**Job Category****:** Information Technology **Requisition Number****:** BUSINShowing 1 location **Job Details**
**Description**
**Job Summary:**
We are looking for a skilled, passionate, and intellectually curious individual who wants to demonstrate and grow their BI data development skills in a highly collaborative, Scrum environment. Our BI team designs, implements, and maintains our data warehouse and front end reporting systems that allow users to access to pre-designed reports and self-serve analysis. This Data Warehouse Developer role will primarily support our growing brick and mortar gaming facilities and provides various opportunities for growth and advancement. We are big on collaboration, ethical work practices, diversity, and having fun.
You will be a great fit for this role if:
* You are passionate about working with data
* You enjoy helping others and get a thrill from others gaining insight based on your work
* You pay attention to details but also understand how your work fits into the larger picture
* You are willing to embrace Agile principles and practices
* You enjoy a fast-paced business atmosphere with co-workers that are committed, focused, open, and driven towards success
**Key Responsibilities:**
* Build and maintain ETL and Data Warehouse objects (including SSIS, Transactional Replication/CDC, SQL Procedures, MicroStrategy semantic model, SSAS, MDS/DQS, BIML, PowerShell scripts)
* Contribute to the design and optimization of our data layer as the companys single layer of the truth
* Translate business requirements into detailed, production-level technical specifications
* Contribute to our ETL framework by learning our current capabilities and leveraging your unique insights and experience
* Modify existing reports and/or to develop new reports by analyzing databases, data sources, and structures for the benefit of users
**Required Qualifications:**
* Bachelors degree or equivalent work experience in Computer Science or a related discipline
* Strong experience using SQL including complex stored procedures, common table expressions, analytic functions, query optimization, and indexing
* Five years of experience working with data warehouses; Microsoft SQL Server strongly preferred
* Three years of experience designing, implementing and maintaining normalized, operational data store, and dimensionally modeled database systems.
* Two years of experience designing and developing Extraction, Transform and Load (ETL) processes, Microsoft SQL Server Integration Services (SSIS) strongly preferred.
* Three years of experience with object oriented languages; preference with C#, PowerShell, or Python
**Desired Qualifications:**
* Experience using agile/scrum methodologies to iterate quickly on product changes, developing user stories and working through backlogs
* Experience with MicroStrategy or other Business Intelligence tools
* Experience working with multi-terabyte data sets
* Experience designing and building enterprise conceptual or logical data models
* Working knowledge of data management and data warehousing technologies related to data modeling, database administration and performance tuning, archiving and disaster recovery
* Ability to effectively communicate at different levels in and across the organization and to articulate to non-technical audiences the advantages and disadvantages of using various technologies and standards
**Qualifications**
**Skills**
**Behaviors**
**:**
**Motivations**
**:**
**Education**
**Experience**
**Licenses & Certifications**