ETL/BI Developer (Chapel Hill)

We’re a smart, collaborative team that’s willing to go the extra mile. We’re not messing around – we have fun, but we get it done. You’ll fit in if you’re tenacious and focused when it counts, and have the sense of humor to roll with the unique challenges that come with working in a dynamic, growing business.

BENEFITS:

• Competitive salary based upon experience
• Paid personal days and company holidays
• 401k Retirement Savings Plan and medical, dental and vision benefits
• Our casual, team-oriented work environment

RESPONSIBILITIES:

• Design and implement ETL architecture using Microsoft SSIS and other SQL Server tools.
• Work with business stakeholders to develop requirements, specifications, and business rules for new diagnostic products and projects.
• Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement.
• Maintain data architecture and environment documentation
• Understand the source data components and how they integrate with each other (which might be both relational and dimensional)
• Design and build ETL packages to load data from disparate source systems
• Automate solutions (SQL Server jobs), server administration, query and database optimization using BI best practices
• Facilitate development, QA, and deployment in testing and production environments

REQUIREMENTS:

• Minimum 3 years of database architecture and data integration experience in a data warehousing environment.
• Designed and implemented ETL architecture using SSIS and other SQL Server tools (Server 2008+)
• Strong skills developing queries, scripts, and stored procedures (T-SQL preferred; PL/SQL or equivalent acceptable)
• Experience with database performance optimization techniques
• Understanding of data modeling and data transformation
• Knowledge with reporting software (SSRS, Tableau, others)
• Strong organizational and time management skills; detail oriented