Full-Time Business Intelligence Analyst SR
DentaQuest Business Intelligence Services team effectively and sustainably provides data solutions and tools across the organization. We integrate, transform, and improve volumes of data for the enterprise level reporting and analytic processes.
PRIMARY JOB RESPONSIBILITIES:
The BI Developer plays a critical role in the partnering with clients across the enterprise in analyzing, creating complex ETL solutions and analytic process for supporting internal and external reporting.
Develops databases SQL queries for data analysis and data extracts/loads.
Utilizes experience with Informatica and/or SSIS and/or equivalent ETL (Extract, Transform, Load) to load and optimize solutions from multiple data sources.
Analyze, debug and tune SQL databases queries for performance improvements.
Analyze data warehouse architecture, maintain normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, troubleshoot and recommend improvements and alternate methodologies.
Monitors nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use.
Analyze and resolve problems and provides technical assistance as is necessary.
Implements corrective actions to legacy issues.
Conduct code reviews and participate in technical design.
Conduct performance analysis and optimize ETL jobs, custom SQL and T-SQL jobs.
Working closely with multiple teams to design, develop and maintain SQL Stored procedures and Informatica and/or SSIS ETL scripts to implement Business Intelligence Solutions.
Other duties as needed or required.
B.S. or MS degree in Computer Science, business or related discipline, or equivalent experience.
4 year experience T-SQL Stored Procedures, Views and T-SQL design and development using Visual Studio and SQL Management Studio (or equivalent tools).
4 Years’ experience using SQL Server 2008, 2012 or equivalent tools.
4 Years’ exp. with ETL tools like Informatica and/or SSIS or equivalent tools.
2 years exp. in design of appropriate data structures for the development of a database system.
2 year Business Intelligence Architecture and Design experience.
1 year leading and managing technical projects experience.
Experience with data access performance tuning and performance optimization.
Must have a high level of initiative and sound independent judgment.
Must be able to collaborate and take a team-based approach.
Required to attend additional training as requested/deemed necessary.
1 year’s exp. with of report development (using reporting solutions like SSRS, Tableau, Cognos) preferred.
Experience with Healthcare data domain is strongly preferred.
Incumbent must be able to communicate effectively.
Requires overall light physical effort (up to 25lbs.)
Manual dexterity and sitting is required in carrying out position own position responsibilities (i.e. use of personal computer).
Ability to travel or move about within and outside serviced facilities required.
How to Applyhttp://gr.8job.co/kVjnLH8Q
29 total views, 2 today