Troy, Michigan
IT Data Warehousing Analyst #1010308Job Description:
Duties:
Job Summary:
- 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.
Skills: Required Skills & Experience:
- Five (5) years of applicable work experience required.
- Good understanding of HIPAA 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).
- Healthcare experience includes knowledge of EDI transactions; knowledge of Medicare, Medicaid, commercial products; understanding of ACA.
- 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
Preferred Skills & Experience:
- Experience with UNIX operating systems and Oracle database is 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.
- Experience with FACETS, IKA, PEGA and Windows and UNIX operating systems is preferred.
- 3 years applicable experience in a Healthcare setting preferred.
Keywords:
Education: Required Education:
- Bachelor’s degree.
Additional Info:
At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra. We act responsibly, give back to the communities we serve and have a little fun along the way.
We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years!
FastTek Global is financially strong, privately held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:
- Medical and Dental (FastTek pays majority of the medical program)
- Vision
- Personal Time Off (PTO) Program
- Long Term Disability (100% paid)
- Life Insurance (100% paid)
- 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
Plus, we have a lucrative employee referral program and an employee recognition culture.
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, 2022, and 2023!
To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/