IT Data Warehousing Analyst - Troy, United States - A-Line Staffing Solutions

A-Line Staffing Solutions Troy, United States

1 month ago

Show more Collapse job

Description

Job Description

Title: 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:

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

Position Requirements:

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

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

We have other current jobs related to this field that you can find below

IT Data Warehousing Analyst

3 weeks ago

Global Technology Associates Troy, United States

Job 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

3 weeks ago

Global Technology Associates Troy, United States

IT 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 ...
AI Data Engineer

1 week ago

Hearst Troy, United States

Job 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 ...
Senior Datastage Developer

4 weeks ago

Info Services Troy, United States

Role: 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 Work

Senior 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 ...
Senior WMS Techno-Functional Business Analyst

3 weeks ago

Hispanic Technology Executive Council Troy, United States

Our 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 ...
Senior Data Analytics Engineer

2 days ago

UHY LLP Sterling Heights, United States

Position Summary: · Job Description · Summary/objective · As a Senior Data Analytics Engineer, you will design and build data solutions that span data engineering, data warehousing, data analytics, and data science in this multi-disciplinary role. You will lead engineering e ...
Logistics Director

1 day ago

Zippia Warren, United States

What is a logistics director and how to become one · Updated March 14, 2024 · 3 min read · A logistics director is an individual responsible for overseeing the movement of goods from production to the user while minimizing costs and maximizing efficiency. They work to develop a ...
Business Intelligence Analyst

1 week ago

RouteOne Farmington Hills, United States

The 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 ...
Business Analyst

1 week ago

Guardian Alarm Company of Michigan Southfield, United States

Summary & 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

1 week ago

Global Information Technology Southfield, United States

Business 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 ...
Business Analyst 5

2 days ago

Global Information Technology Southfield, United States

Job 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 ...
Senior Analytics Developer

2 weeks ago

Columbia University Detroit, United States Full time

Position 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

1 week ago

Global Information Technology Southfield, United States

Business 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. ...
PS-Technical Lead

1 week ago

Tekwissen Southfield, United States

Overview: · 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 ...
Data Quality Engineer, Data Warehousing

2 days ago

Heitmeyer Consulting Farmington Hills, United States Contract

Job 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 ...
Logistics Analyst

2 weeks ago

DCS Corp Novi, United States

DCS 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 Data Analyst

1 week ago

ICONMA Detroit, United States

Senior Data Analyst · Location: Detroit, MI/Hybrid · Duration: 12 months · Description: · Dept: Business Analytics & Cl · Engagement Description · Responsible for leading complex projects and independently executing analyses that support the healthcare value portfolio. · T ...
LA Galaxy, Sr Data Analyst- Marketing

1 week ago

AEG New Baltimore, United States

In order to be considered for this role, after clicking "Apply Now" above and being redirected, you must fully complete the application process on the follow-up screen. · For more than 20 years, AEG has played a pivotal role in transforming sports and live entertainment. Annuall ...
IT Architect

2 weeks ago

Tekwissen Detroit, United States

Overview: · 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 ...