Data Warehouse BI Analyst

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

Job Description

Data Warehouse BI Analyst
Lansing MI
12 months

Phone and Skype 
MUST BE SENIOR LEVEL


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

Corp-to-Corp

Work Authorization

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

Direct Client Requirement

Yes

Working through a Preferred Vendor

Yes

Employer Details

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

Related Jobs

Jobs at Corpteq Solutions Inc

 Corpteq Solutions Inc
Key Skills
• Ruby on Rails • MySQL • Bootstrap, HTML/CSS • JavaScript/jQuery/MV* • Git and Gitflow workflows • AWS/Docker
7-10Yrs
Royal Oak Twp,MI
 Corpteq Solutions Inc
Key Skills
UNIX /Linux based environments or Windows environment, VMware
7-10Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
Local Area Networks (LAN), Wide Area Networks (WAN), firewalls, and other network infrastructure systems.
7-10Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
Need a Business Analysts - Contract to Hire (NO H1’s/OPT)
7-10Yrs
Livonia,MI
 Corpteq Solutions Inc
Key Skills
Need a Salesforce Developer in GA
7-10Yrs
Atlanta,GA
 Corpteq Solutions Inc
Key Skills
Enterprise Data Catalog (EDC), bigdata, data catalogs, the practice of data cataloging, meta data management, and data curation
7-10Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
IBM Security Identity Manager (formerly known as Tivoli Identity Manager / ITIM), IBM IGI product, Implementation experience of IBM ISIM product, Web development experience using Java and Javascript
7-10Yrs
Miami,FL
 Corpteq Solutions Inc
Key Skills
Java, Python, Ruby, Scala, Groovy, GO, BASH
10+Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
installing, configuring and troubleshooting UNIX /Linux based environments or Windows environment, shell scripts
7-10Yrs
Lansing,MI
Key Skills
Product Management, Product Owners,Agile and Scrum working with multiple Agile Teams, Continuous Integration/Continuous Delivery
10+Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
Active directory, AD health analysis, assess RAP report
7-10Yrs
Philadelphia,PA
 Corpteq Solutions Inc
Key Skills
Siteminder Identity management OR any IAM experience with strong JAVA
7-10Yrs
Indianapolis,IN
 Corpteq Solutions Inc
Key Skills
Cloud, AWS, IDS, IPS, SIEM, DevOps
7-10Yrs
Philadelphia,PA
 Corpteq Solutions Inc
Key Skills
Public Cloud including Azure and O365
10+Yrs
Philadelphia,PA
 Corpteq Solutions Inc
Key Skills
etl, sql, Business Analyst
7-10Yrs
Detroit,MI
 Corpteq Solutions Inc
Key Skills
IBM Mainframe, HP NonStop/Tandem, Java, .Net, Linux, Microsoft Windows, SQL Server, Mongo DB, Big Data Ecosystem (Hadoop)
10+Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
J2EE, Oracle, WebLogic, VMWare, message buses and Openstack
10+Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
Java, J2SE, REST JSON , HTML5, JQuery and MVC framework like Struts/Spring.
10+Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
Java, Microservices, springboot, Devops
10+Yrs
San Francisco,CA
 Corpteq Solutions Inc
Key Skills
JMeter, JavaScript, JSP, AJAX, CSS, XHTML, Flash
10+Yrs
Ann Arbor,MI
 Corpteq Solutions Inc
Key Skills
PEX APIs, APEX Triggers, and implementing new instances of Salesforce.com from scratch.
7-10Yrs
Atlanta,GA
 Corpteq Solutions Inc
Key Skills
to GitHub, Jenkins, Maven, Gradle.
3-7Yrs
Denver,CO
 Corpteq Solutions Inc
Key Skills
Functional Testing, System Testing, End-to-End Testing, Regression Testing and Ad Hoc Testing
3-7Yrs
Lansing,MI
 Corpteq Solutions Inc
Key Skills
Java/J2EE experience • Strong REST services • Strong DB (SQL skills) • Bonus: Any experience with BitBucket/Git/Maven • Bonus: Angular/Redux
7-10Yrs
Lansing,MI

Jobs by Company