Data Warehouse BI Analyst

 Corpteq Solutions Inc
Lansing, MI, USA
  7-10 Years
Posted on 08 29, 2018
Key Skills: Data Modeling/Database Design, SQL; Teradata SQL Assistant, MS SQL Server

Job Description

Data Warehouse Business Intelligence Analyst
Lansing, MI
12 Months
Phone and Skype

We will have a position open at Treasury due to the upcoming retirement of one of our staff at the end of September.  This is a Data Warehouse BI Analyst position that crosses over into technical work.  The person in this role works with the Treasury clients to understand their needs related to the Treasury (tax) data on the Teradata DW, creates and runs SQL jobs on the DW, and also does some data modeling and database work.  Below are the required and desired skills for this position.

Required Skills/Experience:

•5 years’ experience working as a Data Analyst, Technical Business Analyst, Systems Analyst or Business Analyst experience in a Data Warehouse project environment
•5 years’ experience working with end users/customers to understand system and business issues and perform technical analysis to understand and develop requirements and solutions
•5 years’ experience with Data Modeling/Database Design
•5 years’ experience with SQL; Teradata SQL Assistant, MS SQL Server
•3 years’ experience developing test data and test scenarios
•Ability to facilitate customer requirements gathering meetings/sessions
•Must be able to work independently and not rely on State or other team members
•Must be able to communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector. 

Preferred but not Required Skills/Experience
•Experience with IRS or State Tax applications or experience as a tax accountant
•Experience with the State of Michigan PMM/SUITE or similar waterfall IT Development methodology
•Experience with JAD and Agile IT Development methodologies
•Ability to clearly communicate with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan. 
•Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, and devise solutions and alternatives and make appropriate recommendations.
•Working with the Data Modelers and developers, facilitate modification of the logical design to create a physical design most suited to the reporting needs of the customer. 
•Ability to design applications taking into consideration data reconciliation, (to the source system) query/reporting performance, and analytical business value. 
•Experience with BI Query
•Experience with Data Cleansing
•Experience with Data Governance
•Experience with SAP Tax module

Employment Type


Work Authorization

US Citizen Green Card EAD (OPT/CPT/GC/H4) H1B

Direct Client Requirement


Working through a Preferred Vendor


Employer Details

Name: Anil behara
Company: Corpteq Solutions Inc
Location: Cumming, GA, United States
Contact: (678) 679-3505

Related Jobs

Jobs by Company


Our Indian classifieds Job Portal is a platform that joins recruiters and the job seekers to complete their goals and requirements. Recruiters look for a right candidate who has the right qualifications to handle the responsibilities efficiently.
On the other way, job seekers want a job where they can apply their skills and knowledge to grow their professional career. Sending job applications through employment portals is a quicker way to get the right candidate.


  •   Your Jobs listed with PREMIUM Label
  •   PREMIUM JOB AD is Visible First – Free Next @ Concern Sub domain Home page and also List Page
  •   Your Job Ad will be shared via Newsletters
  •   Job Ad will be shared in Social Media
post jobs for Free
share jobs in Social Media
job Seeker Dashboard
Employer Dashboard
© 2018 Copyright | All Rights Reserved.