- 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 SQL; Teradata SQL Assistant, MS SQL Server including:
- Experience in teams that support applications that have their source as a Data warehouse.
- Understanding of data visualization-reporting tools
- 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.
- Experience with leading project work, providing direction for team members
- Experience with Data Modeling/Database Design
- Experience with Court applications or relevant court experience
- 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 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
-
Data Warehouse Analyst
1 week ago
DATAMAXIS Lansing, United StatesRate: Depending on experience · Work location: Remote · 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 ...
-
Business Analyst
5 days ago
Professional Technology Integration Lansing, United StatesDescription: · ***Hybrid (2 days a week onsite) · ***Local Candidates · We are seeking a Business Analyst with a minimum of 12 years of general BA experience. · Roles and responsibilities: · •Facilitation of requirements elicitation meetings; experience with gap fit analysis an ...
-
Business Analyst
2 weeks ago
Rose International Lansing, United StatesDate Posted: 05/23/2024 · Hiring Organization: Rose International · Position Number: 464568 · Job Title: Business Analyst · Job Location: Lansing, MI, USA, 48933 · Work Model: Hybrid · Employment Type: Temporary · Estimated Duration (In months): 13 · Min Hourly Rate($): 57.00 · M ...
-
Business Analyst
3 weeks ago
Professional Technology Integration Lansing, United StatesDescription: · ***Hybrid - 2 days onsite a week · ** Local Candidates (Candidates MUST be local within a commutable distance.) · ** Non-local candidates may apply · We are seeking a Business Analyst to provide excellent customer service supporting both project and work request n ...
-
Supply Chain Analyst
3 weeks ago
InsideHigherEd East Lansing, United StatesJob no: 947103 · Work type: Support Staff · Pay Grade: 11 · Major Administrative Unit / College: University Procurement And Logistics · Department: Upl Administration · Sub Area: AP- Professionals · Salary: Salary Commensurate with Experience · Location: East Lansing, In State · ...
-
Senior Architect
2 days ago
Resource Informatics Group Lansing, United StatesJob Description · The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications. This position will also represent the team and coordinate team activities with other dat ...
-
Business Analyst
1 week ago
Rose International Lansing, United States PermanentDate Posted: 05/23/2024 · Hiring Organization: Rose International · Position Number: 464568 · Job Title: Business Analyst · Job Location: Lansing, MI, USA, 48933 · Work Model: Hybrid · Employment Type: Temporary · Estimated Duration (In months): 13 · Min Hourly Rate ($): ...
-
Business Analyst
2 weeks ago
Rose International Lansing, United States*Date Posted: * 05/23/2024 · *Hiring Organization: * Rose International · *Position Number: * 464568 · *Job Title: * Business Analyst · *Job Location: * Lansing, MI, USA, 48933 · *Work Model: * Hybrid · *Employment Type: * Temporary · *Estimated Duration (In months): * 13 · *Min ...
-
Business Analyst
1 day ago
Trillium Staffing Lansing, United StatesOur client is in need of a senior Business Analyst 5 to provide excellent customer service supporting both project and work request needs. · This person will have the opportunity to work on a new IT solution for issuing, analyzing, and monitoring energy rebates. These IT solutio ...
-
Business Analyst V
2 days ago
Ark Solutions Lansing, United StatesArk Solutions Inc is looking for Business Analyst V · Position: Business Analyst V · Location: Lansing, MI (Hybrid) · Duration: 12 Months and possibility of extension · Description: · Senior Business Analyst to provide excellent customer service supporting both project and wor ...
-
Business Analyst 5
2 days ago
Integrated Resources Lansing, United StatesJob Title: Business Analyst · Location: Lansing, MI(Hybrid) · Duration: 6+ Months (Possible Extension) · Client needs a senior Business Analyst 5 to provide excellent customer service supporting both project and work request needs for the Environment, Great Lakes . This person ...
-
Business Analyst 5
1 day ago
Tekfortune Inc Lansing, United StatesTekfortune is a fast-growing consulting firm specialized in permanent, contract & project-based staffing services for worlds leading organizations in a broad range of industries. In this quickly changing economic landscape, virtual recruiting and remote work are critical for the ...
-
Data Warehouse Developer
2 weeks ago
Optum Lansing, United StatesOptum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel ...
-
Manager - Data Management
1 week ago
Ally Lansing, United StatesGeneral information · Ref # 17436 · Remote? No · Ally and Your Career · * · Ally Financial only succeeds when its people do - and that's more than some cliché people put on job postings. We live this stuff We see our people as, well, people - with interests, families, friends, dr ...
-
Business Analyst
1 day ago
PSR Associates Lansing, United StatesPSR Associates is a consulting and talent solutions firm that connects qualified IT professionals with great opportunities. Whether you're looking for a contract or permanent position, we can help you find the right fit for your skills and experience. We have a team of experience ...
-
Senior Analyst
4 days ago
Ally Lansing, United StatesGeneral information · Ref # 17434 · Remote? No · Ally and Your Career · * · Ally Financial only succeeds when its people do - and that's more than some cliché people put on job postings. We live this stuff We see our people as, well, people - with interests, families, friends, dr ...
-
Business Analyst 5
3 weeks ago
Ideal Force Lansing, United StatesJob Description · Job DescriptionIDEALFORCE has a CONTRACT position available immediately for a Business Analyst 5 to join our customer in Lansing, MI. This is an Hybrid position. Please find below additional details about this job. Kindly respond with your most up to date resume ...
-
CRM Business Analyst 5
4 days ago
InterSources Lansing, United StatesTop Skills & Years of Experience Required: · Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. - 3 years of experience Familiar with industry standard (including Legacy, Core, and E ...
-
Business Analyst
14 hours ago
OpTech Lansing, United StatesWhy work at OpTech? · OpTech is a woman-owned company that values your ideas, encourages your growth, and always has your back. When you work at OpTech, not only do you get health and dental benefits on the first day of employment, but you also have training opportunities, grow ...
-
Business Analyst 5
3 days ago
Trilyon, Inc. Lansing, United StatesJob Description · Job DescriptionFor over 15 years, Trilyon has been at the forefront of providing comprehensive global workforce solutions and staffing services. Leveraging our extensive expertise across multiple domains such as Cloud technology, Salesforce, AI, Machine Learning ...
Data Warehouse Analyst - Lansing, United States - DATAMAXIS
![Default job background](https://contents.bebee.com/public/img/bg-user-ex-1.jpg)
Description
Rate: Depending on experience
Work location: Remote
Required Skills/Experience:
o Understanding of data warehousing definition concepts like
• Tables, Views
• Stored procedures and macros
o Experience using Teradata Utilities such as
• MLOAD
• BTQ
• SQLA
o Experience where there is involvement in working with any database related languages like SQL and their equivalent concepts like
• Indexing
• Joins
• Sub queries
• Volatile/temp tables
o Experience in maneuvering existing lines of complex SQL code in identifying an issue reported by non-technical/technical users
o Understanding of data in the terms of space and size and usage of the tables
o Understanding of Datatypes related to the tables like Char, timestamps, etc.
o Ability to understand and modify existing Views and their definitions to align and satisfy business requirements
o Involvement in processes that involve batch jobs
Preferred but not Required Skills/Experience: