- Facilitate meetings with clients to gather and document requirements and explore potential solutions
- Gather data and reporting requirements, detects and summarizes patterns in data and findings by producing simple reports and works with development teams for problem resolutions.
- Analyze and document client's business requirements and processes, and communicate these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization
- Collaborate with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions
- Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications
- Create test scenarios and develop test plans to be used in testing business applications in order to verify that client requirements are incorporated into the system design
- Assist in analyzing testing results throughout the project and assist in coordinating business analyst tasks on information technology projects, problem tickets, and in providing support to other team members
- Provide on call second-level escalation response for client issues and problem tickets, performing root cause analysis and application resolution
- A minimum of 5 years of applicable work experience, with at least 3 years of applicable experience in a Healthcare setting, including a minimum of a Bachelor's Degree in IT or a related field
- Experience in Data Warehousing or Data Mart environments, with strong knowledge of state-of-the-art software engineering approaches in design, build, test, debugging, and ongoing technical support, including the ability to articulate examples of workflows and processes associated with that experience
- Deep expertise with Oracle databases, including SQL and PL/SQL, indexing, partitioning, views, materialized views, performance tuning, and optimization; experience optimizing SQL queries/performance tuning
- An understanding of Star Schema, Snow Flake, and/or Data Warehouse methodologies like Bill Inmon or Ralph Kimball
- Proficiency in the usage of different analytical functions, including Partition By, Rank, Sum, Group By, Order By clauses, Lead, and/or Lag
- Experience in Datastage/Cognos/PowerBI Conversion
- Expertise using Nested, Sub, and Inner Queries
- Experience handling errors and fixing SQL issues
- Good understanding of Slowly Changing Dimensions (SCD's) and their types/usage
- Experience creating BRD, STM, and solution design documents
- Integration experience working with multiple sources/datasets
- Experience across the System Development Lifecycle (SDLC)
- Ability to be flexible and work analytically in a problem-solving environment
- Strong organizational, multi-tasking, and time-management skills
- Excellent communication (written and oral) and interpersonal skills
- Proven ability to work independently and as a team member
- Good understanding of HIPAA data privacy and security requirements
- Experience with UNIX operating systems and Oracle databases preferred
- Experience with FACETS, IKA, PEGA, and Windows and UNIX operating systems preferred
- Healthcare industry knowledge of EDI transactions, Medicare/Medicaid, commercial products, or ACA preferred
-
IT Data Warehousing Analyst
3 weeks ago
HCTec Troy, United StatesPosition: Data Warehousing Analyst · Length: 6 months with possible conversion at the end · Location: Troy, MI · Onsite/Remote: Remote, prefer local candidate but open to out of the area candidates · Covid Vaccination: Optional · Job Scope/Summary: · Bachelor's Degree, Minimum of ...
-
IT Data Warehousing Analyst
2 weeks ago
Global Technology Associates Troy, United StatesJob Description · Job DescriptionIT Data Warehousing Analyst · Job ID: · Location: Troy, MI REMOTE POSITION) · Pay Rate: $42-$45/hour · Additional Benefits: Health, Dental, Vision, 401(k), company-paid holidays and more · Type of hire: 6-month contract to hire position. · Posit ...
-
IT Data Warehousing Analyst
2 weeks ago
Global Technology Associates Troy, United StatesIT Data Warehousing Analyst · Job ID: · Location: Troy, MI REMOTE POSITION) · Pay Rate: $42-$45/hour · Additional Benefits: Health, Dental, Vision, 401(k), company-paid holidays and more · Type of hire: 6-month contract to hire position. · Position Responsibilities :Collec ...
-
Sr. Datastage Developer
3 weeks ago
Abidi Solutions Troy, United StatesJob Description · Job DescriptionJob Title: Sr. Datastage Developer · Work Environment: Hybrid in Troy, MI · Contract Length: 4 Month Contract to Hire · Interview: ASAP 1st round teams, second round on-site · Enterprise Req Skills · Pl/sql,datastage · Top Skills Details · 1. Dat ...
-
AI Data Engineer
19 hours ago
Hearst Troy, United StatesJob Description · MOTOR Information Systems, an operating group of Hearst, is actively seeking a team of enthusiastic, creative, and driven technologists. People with a proven track record, who are willing to experiment with new ideas, invest time in them, fail-fast, and move on ...
-
Logistics Analyst
4 weeks ago
DCS Corp Sterling Heights, United StatesDCS Corp is seeking a dynamic, pro-active, team oriented, energetic, customer focused Logistics Analyst to support our U.S. Army customer out of our Harrison Twp, MI location. You will be working with a group of Engineers and Technicians, supporting the execution of our customer' ...
-
Senior Datastage Developer
2 weeks ago
Info Services Troy, United StatesRole: Sr. Datastage Developer - · Location: Troy, MI Hybrid role - 2 days onsite in Michigan · Long term contract · Job Type: W2 Only. · Top Skills' Details · 1. Datastage Development · 2. PL/SQL Development · 3. Data Warehousing experience · Secondary Skills - Nice to Haves · ...
-
Senior IT Business Analyst
1 month ago
Cummins Inc. Troy, United States Paid WorkSenior IT Business Analyst · Description · Our culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest problems. · We beli ...
-
Hispanic Technology Executive Council Troy, United StatesOur culture believes in Powering Your Potential. We provide global opportunities to develop your career, make your community a better place and work with todays most innovative thinkers to solve the worlds toughest problems. · We believe in flexibility for you to explore your pa ...
-
Logistics Analyst
4 weeks ago
DCS Corp Sterling Heights, United StatesJob Description · Job DescriptionDCS Corp is seeking a dynamic, pro-active, team oriented, energetic, customer focused Logistics Analyst to support our U.S. Army customer out of our Harrison Twp, MI location. You will be working with a group of Engineers and Technicians, supporti ...
-
L2 Network Engineer
3 weeks ago
Kforce Warren, United States ContractDescription · Kforce has a client in East Chicago, IN that is seeking a Senior IT Applications Engineer.Responsibilities: · Design and develop end-to-end business intelligence solutions using Azure technologies, including but not limited to: Azure Data Factory, Azure Data Lake, A ...
-
Data Quality Engineer, Data Warehousing
3 weeks ago
Heitmeyer Consulting Farmington Hills, United States ContractJob Summary · : · Heitmeyer is seeking a Data Quality Engineer to support its global banking client on a long-term regulatory and cloud initiative. This role is required to be on-site 2 days a week in the following locations: Mount Laurel, NJ Greenville, SC, Falmouth, ME, Farmin ...
-
Business Intelligence Analyst
3 days ago
RouteOne Farmington Hills, United StatesThe Business Intelligence Analyst will be responsible for identifying trends, analyzing data, and preparing analytical and graphical reports for executive management. This person must have strong analytical skills, understand query logic, and be effective at organizing, interpret ...
-
Senior WMS Techno-Functional Business Analyst
4 weeks ago
Cummins Rochester, United StatesSenior WMS Techno-Functional Business AnalystDescriptionOur culture believes in POWERING YOUR POTENTIAL . We provide global opportunities to develop your career, make your community a better place and work with today's most innovative thinkers to solve the world's toughest proble ...
-
Business Analyst
3 days ago
Guardian Alarm Company of Michigan Southfield, United StatesSummary & Essential FunctionsThe Reporting Analyst is responsible for gathering, arranging, inspecting, analyzing, and interpreting data to provide insights that support business decisions. The Reporting Analyst works collaboratively with business leaders to create and maintain r ...
-
Business Analyst 5
22 hours ago
Global Information Technology Southfield, United StatesBusiness Analyst 5Job Location: Lansing, MI (Hybrid)Job Type: ContractJob Description:Reviews, analyzes, and evaluates business systems and user needs.Triage user requests and tickets, assign priority and severity, and communicate effectively to all stakeholders.Maintain and prio ...
-
Senior Analytics Developer
5 days ago
Columbia University Detroit, United States Full timePosition Summary · Under the direction of the Director of CUIMC Analytics Development Team, the Senior Analytics Developer develops and maintains the tools used for advancing the mission of Columbia University Irving Medical Center. · This position will design and create data str ...
-
Business Analyst 5
2 hours ago
Global Information Technology Southfield, United StatesBusiness Analyst 5 · Job Location: Lansing, MI (Hybrid) · Job Type: Contract · Job Description:Reviews, analyzes, and evaluates business systems and user needs. · Triage user requests and tickets, assign priority and severity, and communicate effectively to all stakeholders. ...
-
Business Analyst 5
3 weeks ago
Global Information Technology Southfield, United StatesJob Description · Job DescriptionBusiness Analyst 5 · Job Location: Lansing, MI (Hybrid) · Job Type: Contract · Job Description:Reviews, analyzes, and evaluates business systems and user needs. · Triage user requests and tickets, assign priority and severity, and communicate effe ...
-
PS-Technical Lead
1 day ago
Tekwissen Southfield, United StatesOverview: · TekWissen Group is a workforce management provider throughout the USA and many other countries in the world. Our client is a health insurance company. It offers different types of health care coverage plans that include individual and family, dental and vision, plan ...
IT Data Warehousing Analyst - Troy, United States - A-Line Staffing Solutions
Description
Job Description
Job DescriptionTitle: IT Data Warehousing Analyst
Location: Troy, MI (Role is currently Remote but may require Onsite availability in the future)
Note: This position is a contract on W2, and is NOT open to C2C
The IT Data Warehousing Analyst will be responsible for collecting, analyzing, and summarizing data to support business decision-making. They will identify opportunities for reuse of data across the enterprise, validating data sources and keeping abreast of new tools & technology and functionalities across application(s) Working closely with customers, vendors, business analysts, and application development project teams, the IT Data Warehousing Analyst will resolve information flow and content issues to ensure data integrity and compliance, performing data profiling and data validations. Additionally, the IT Data Warehousing Analyst will:
Position Requirements:
If you think this position is a good fit for you, please reach out to me - feel free e-mail me, or apply to this posting
Andrew Torchine
