Business Intelligence Developer
The BI developer participates in data acquisition and transformation delivery while providing oversight and technical checkpoints in order to enforce standards and quality solutions. This individual researches new technologies, tools and methodologies as they emerge that may be applicable to improving the overall service offering. Additionally, they are responsible for collaborating with the various IT support and customer teams to ensure that technical architecture complies with the proper guidelines. In this role, the qualified resource will be responsible for the design, development and maintenance of ETL’s and various data marts as well as developing and maintaining existing reports to both internal and external clients. This position may not conduct any activities that require evaluation or interpretation of clinical information.
Typical Experience Required:
- 7+ years of experience working as a Business Intelligence developer with focus in ETL design, development and architecture.
- 4 + years end-to-end SSIS design and development, including scheduling & maintaining SSIS jobs
- 3+ years of Data Warehouse experience including strong Dimensional Data Modeling skills
- Healthcare industry experience is a plus
- Microsoft SharePoint 2007/2010 experience a plus
Typical Required Skills:
- Demonstrated understanding of SDLC’s and use of revision control systems such as TFS or SVN.
- Ability to express business and technical concepts concisely both verbally and in writing.
- Design, develop and support ETL processes for data staging, extraction, transformation, and loading of fact and dimension tables, data cleansing, automating ETL processes using SQL Agent.
- Expert ability to Collect, organize and generate new documentation for ETL projects including technical specifications, ETL test scripts, change control, implementation checklists, data flow diagrams.
- Strong T-SQL query programming and performance tuning skills, expert knowledge of relational and dimensional databases design and development
- Help out in the report development process using SSRS as needed basis.
Job Responsibilities:
- Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.
- Provide technical knowledge of Extract/Transform/Load (ETL) solutions for Business Intelligence projects
- Work with DBA, team members and data analysts to identify, design and implement solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis and performance tuning initiative.
- Design, develop and troubleshoot complex SSIS packages
- Follow and improve ETL strategy, “best practices” and standards as they relate to ETL in the environment
- Production Support for ETL processes and Data Warehouse
