Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+

Business Intelligence Developer


Job Id : 14659

Jobtitle : Business Intelligence Developer

Location : Milwaukee, WI

Company Name : DentaQuest

Industry : Information Technology

Salary : $55,000 - $145,000  PER YEAR

Job type : Fulltime

Posted on: 2020-06-29


Required Skills : Must Have A High Level Of Initiative And Sound Independent Judgment,Must Be Able To Collaborate And Take A Team-based Approach

Benefits : No benefits are available


Job Description :

 

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.

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.

 

Preferred:

 

  • 1 years exp. with of report development (using reporting solutions like SSRS, Tableau, Cognos) preferred.
  • Experience with Healthcare data domain is strongly preferred.

Latest jobs for you

  • Java (Microservices) Developer

    VIVA USA Inc. Pittsburgh, PA

    Required Skillset Knowledge: Knowledge and practical experience of Java Springboot,. Ability...

    View Job
  • Senior Salesforce Developer (Vlocity)

    Youngsoft Ferndale, MI

    Job Description: Seeking a Salesforce Application Developer Advance for our Salesforce Platform ...

    View Job
  • Sr Engineer, Software - Salesforce/Heroku

    T-Mobile USA, Inc. Bellevue, WA

    Job Description: An experienced Heroku Developer to build and customize solutions and manage ...

    View Job
  • Salesforce Developer (Greater Kansas City or Remote, USA)

    Optiv Security Overland Park, KS

    Job Description: The Salesforce Developer will be responsible for all types of standard ...

    View Job
  • Senior Salesforce developer with apex exp

    ICONMA San Francisco, CA

    Job Description Architect, design, implement, test, and deliver highly scalable products. ...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First