BI DEVELOPER

POSITION SUMMARY:

The Business Intelligence Developer is responsible to research, design, support and provide expert consultation for development of and integration with databases and data warehouses. Works with current BI Developer to divide and conquer responsibilities to ensure availability, performance, security, consistency, and reliability of data/database across multiple systems. Recommends and implements new or modified data models, ETL methods or stored procedures to improve quality and completeness of information. Provides subject matter expertise on all data elements and integrations related to the data warehouse.

PRIMARY DUTIES AND RESPONSIBILITIES:

• Conduct data profiling according to pre-defined data quality rules, able to review and interpret results and engage appropriate team members for remediation, develop procedures to cleanse data and/or work with system owners to identify root cause for data quality issues


• Deliver and operate data and information systems including the data warehouse, analysis and reporting cubes, master data and related integrations


• Build and maintain ETL processes, stored procedures and data models for the Data Warehouse and/or Datamart


• Manage user permissions for Data Warehouse and/or Datamart


• Help write and optimize in-application SQL statements


• Ensure performance, security, and availability of databases


• Work with Business Analyst to prepare specification documents


• Handle common database procedures such as upgrade, backup, recovery, migration, etc.


• Profile server resource usage, and optimize and tweak as necessary

EXPERIENCE AND EDUCATIONAL REQUIREMENTS:

• Bachelor's degree in computer science or related field


• Minimum of 2 years of experience as a Business Intelligence Developer, ETL/DW Developer, or Data Engineer.

SKILLS, KNOWLEDGE, AND ABILITY REQUIREMENTS:

• Strong business acumen


• Advance SQL skills (complex querying capabilities)


• Experience performing ETL, Data Validation, Data Mapping, Data Migration, dimensional modeling


• SQL Server 2016, SSIS including SQL Job Management, and Stored Procedures


• Basic knowledge of Python


• Strong proficiency with SQL and its variation among popular databases


• Experience with modern relational databases


• Understanding of Data Warehousing design and modeling concepts


• Knowledge of best practices for managing relational databases


• Capable of troubleshooting common database issues


• Familiar with tools that can aid with profiling server resource usage and optimizing it


• Excellent analytical and problem-solving capabilities with special attention to accuracy and detail


• Self-starter with a proven ability to take ownership of job responsibilities and ensure successful completion of all projects and requests


• Strong verbal and written communication skills, with the ability to interface effectively with all levels of management, including executive and senior management teams


• Ability to effectively prioritize and multi-task in high volume workload situations

Preferred Skills:

• Experience developing and customizing requirements, process, and design documentation


• Experience performing requirements, design, and testing activities for SAP, CRM and ODS


• Experience in the Pharmaceutical, Medical Device or Healthcare industry


• Experience with SQL Server migration/upgrades