-
IT Data Warehousing Analyst
2 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
3 weeks ago
Strategic Staffing Solutions Troy, United StatesSTRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING · Title: IT Data Warehousing Analyst · Duration: 12+ Months · Location: Troy, MI (Remote in Michigan) · Job/Role Description This individual will serve as a critical resource in the day-to-day development and maintenance of the ...
-
IT Data Warehousing Analyst
2 weeks ago
A-Line Staffing Solutions Troy, United StatesJob 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 respon ...
-
IT Data Warehousing Analyst
3 weeks ago
Strategic Staffing Solutions Troy, United StatesSTRATEGIC STAFFING SOLUTIONS (S3) HAS AN OPENING · Title: IT Data Warehousing Analyst · Duration: 12+ Months · Location: Troy, MI (Remote in Michigan) · Job/Role Description · • This individual will serve as a critical resource in the day-to-day development and maintenance of the ...
-
IT Data Warehousing Analyst
3 weeks ago
InfiCare Technologies Troy, United StatesJob Description · Job DescriptionJob Title - IT Data Warehousing Analyst (Remote) · Location - Troy, MI 48083Hourly Pay Rate - $46/hr.Contract to hire position · Shift - Mon-Fri 8 hour/dayNOTE: Remote for now, will eventually work from the HAP office in Troy Will be using Datasta ...
-
IT Data Warehousing Analyst
1 week 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 ...
-
IT Data Warehousing Analyst
3 weeks ago
Select Source International Troy, United StatesJob Description · Job DescriptionTitle:- IT Data Warehousing Analyst · Duration:- 6+ Month · Location:- Remote Assignment · **REQUIRED: Bachelor's Degree, Minimum of 5 years applicable experience (3 years in healthcare setting preferred). · Proficient in usage of different ana ...
-
IT Data Warehousing Analyst
1 week 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
3 weeks ago
Techlink Systems Troy, United StatesJob Description · Job DescriptionJob Title: IT Data Warehousing Analyst · Location : Troy, MI (remote, local candidates preferred) · Contract Duration: Contract until 12/31/2024 with possible extension or conversion to Full-time · PRINCIPLE DUTIES AND RESPONSIBILITIES: · Collects ...
-
Sr. Datastage Developer
2 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
3 weeks 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 ...
-
Senior WMS Techno-Functional Business Analyst
4 weeks ago
Cummins Troy, United StatesSenior WMS Techno-Functional 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 ...
-
Senior WMS Techno-Functional Business Analyst
23 hours ago
Cummins Troy, United StatesSenior WMS Techno-Functional 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 todays most innovative thinkers to solve the worlds toughest ...
-
Senior Datastage Developer
1 week 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
4 weeks ago
Cummins 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 ...
-
Senior WMS Techno-Functional Business Analyst
3 weeks ago
Cummins Troy, United States**Senior WMS Techno-Functional 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 todays most innovative thinkers to solve the worlds ...
-
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 ...
-
Cummins Troy, United StatesSenior WMS Techno-Functional 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 ...
-
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 ...
-
Senior WMS Techno-Functional Business Analyst
3 weeks ago
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 ...
IT Data Warehousing Analyst - Troy, United States - Integrated Resources
Description
Duties:
PRINCIPLE DUTIES AND RESPONSIBILITIES:
Collects, analyzes and summarizes data to support business decisions.
Identifies opportunities for reuse of data across the enterprise. Validates data sources.
Keeps abreast of new Tools & Technology and functionalities across the application(s).
Works closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues.
Ensure data integrity and compliance by performing data profiling and data validations.Facilitates meetings with clients to gather and document requirements and explore potential solutions.
Gathers data and reporting requirements.
Detects and summarizes patterns in data and findings by producing simple reports and works with development teams for problem resolutions.
Analyzes and documents client's business requirements and processes and communicates these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization.
Collaborates with work teams, departments, system leadership, staff, other IT groups, and technology vendors to define needs and facilitate solutions.
Provides input into developing and modifying systems to meet client needs and develops business specifications to support these modifications.
Creates test scenarios and develops test plans to be used in testing the business applications in order to verify that client requirements are incorporated in to the system design.
Assists in analyzing testing results throughout the project.Assists in coordinating business analyst tasks on information technology projects, problem tickets and provide support to other team members.
Provides support, escalation response to production problem issues/errors. Performs root cause analysis and application resolution.Provides on call second-level escalation response for client issues and problem tickets
Assists in providing time estimates for project related tasks.
Ensure proper documentation and on-time delivery of all functional artifacts and deliverables.
Education:
EDUCATION/EXPERIENCE
REQUIRED:
Bachelor's degree required.
Five (5) years of applicable work experience required; 3 years applicable experience in a Healthcare setting preferred.
Preferred technical experience includes strong knowledge of state-of-the-art software engineering approaches in design, build, test, debugging problems, and ongoing technical support, and ability to articulate examples of workflows and processes associated with that experience.
Good understanding ofHIPAA data Privacy and Security requirements.
Ability to be flexible and work analytically in a problem-solving environment.
Good 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.
Experience with the System Development Life Cycle (SDLC).
Certifications & Licenses:
HIPAA
Skills
Must meet or exceed core customer service responsibilities, standards and behaviors as outlined in the Client' Customer Service Policy and summarized below:
Must meet or exceed core customer service responsibilities, standards and behaviors as outlined in the Client' Customer Service Policy and summarized below:
Communication Ownership
Understanding Motivation
Sensitivity Excellence
Teamwork Respect
Must practice the customer skills as provided through on-going training and in-services.
Must possess the following personal qualities:
Be self-directed
Be flexible and committed to the team concept
Demonstrate teamwork, initiative and willingness to learn
Be open to new learning experiences
Accepts and respects deversity without judgment
Demonstrates customer service values
PHYSICAL DEMANDS/WORKING CONDITIONS:
Normal office environment with minimal exposure to noise, dust, or extreme temperatures. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Healthcare experience includes knowledge of EDI transactions; knowledge of Medicare, Medicaid, commercial products; understanding of ACA.
Experience with FACETS, IKA, PEGA and Windows and UNIX operating systems is preferred.
Good understanding of
HIPAA data Privacy and Security requirements.
Experience in data warehousing, Data Mart environments.
Deep expertise with Oracle database including SQL/ PL SQL, indexing, partitioning, views, materialized views, performance tuning and optimization.
Understands Star Schema, Snow flake, Data Warehouse methodologies like Bill Inmon and Ralph Kimball
Experience with UNIX operating systems and Oracle database is preferred.
Must meet or exceed core customer service responsibilities, standards and behaviors as outlined in the Client' Customer Service Policy and summarized below:
Communication Ownership
Understanding Motivation
Sensitivity Excellence
Teamwork Respect
Must practice the customer skills as provided through on-going training and in-services.
Must possess the following personal qualities:
Be self-directed
Be flexible and committed to the team concept
Demonstrate teamwork, initiative and willingness to learn
Be open to new learning experiences
Accepts and respects diversity without judgment
Demonstrates customer service values
Education
City:
Troy
Schedule:
Start Date: 06/03/2024
End Date: 12/31/2024
Schedule Notes:
REQUIRED:
Bachelor's Degree, Minimum of 5 years applicable experience (3 years in healthcare setting preferred)
Remote Position:
Local candidates preferred For an ideal candidate in SQL, we do expect below things (rating: > 7 out of 10): Proficient in usage of different analytical functions (Partition By, Rank, Sum, Group By, Order By clauses, Lead, Lag, etc...) Optimize SQL queries/Performance Tunning Integration and working with multiple sources/ different datasets Expertise in using Nested, Sub and inner Queries and its appropriate usage.
Experience in handling errors and fixing the SQL issues For an ideal candidate in Healthcare Domain:(Average to above average). Healthcare domain is negotiable, someone might have other domain experience. Irrespective of the domain, candidate need to be proficient with their respective domain For an ideal candidate in Data-warehousing Skills: (Average to above average). Understands Star Schema, Snowflake, Data warehousing methodologies like Bill Inmon and Ralph Kimball. Good understanding on slowly changing dimensions (SCD's) and its types/usage. Responsible for designing, building, and supporting the components of data warehouse, such as ETL processes, databases, reports, and reporting environments Expertise in creation of BRD, STM and solution design documents. Contract to hire position Remote for now, will eventually work from the HAP office in Troy Will be using Datastage/Cognos/PowerBI Conversion Salary will be largely based on performance and number of years of relevant experience. The tentative range is 80k - 95k. 1. SQL skillset - This has to be good 2. Data Warehousing experience (can be relaxed if #1 & #3 are good) 3. Healthcare domain knowledge (can be relaxed if #1 & #2 are good) Candidate should be good in the following concepts of SQL and able to apply this knowledge. A good understanding of the first 5 is a must. 1. Joins 2. Group by 3. Having clause 4. Select - case when 5. Sub Query 6. Window functions 7. Set Operations 8. Cast & Date Functions Since this is an analyst position, along with technical skillsets, its important that the candidate is able to clearly explain the functional aspects of his work, this is applicable irrespective of whether the candidate has healthcare experience or not.
Hours Per Week: 40.00
Hours Per Day: 8.00
Days Per Week: 5.00
