Job Details

ID #21624978
State Ohio
City Columbus
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Pyramid Consulting, Inc.
Showed 2021-10-24
Date 2021-10-20
Deadline 2021-12-18
Category Et cetera
Create resume

Data Analyst with ETL and SQL

Ohio, Columbus, 43085 Columbus USA

Vacancy expired!

  • Candidate must have strong skills in data profiling, data analysis, and data mapping. Extensive hands-on experience interpreting, navigating, and extending data models (conceptual, logical, physical) is required.2. Strong SQL skills is a must. Experience using Informatica IDQ and IBM data architect is preferred.3. Should be able to understand and explain complex data integration and extraction/transformation/load processes (ETL).4. Should be able to work with the business to define scope of data-driven projects.5. Should be competent in reviewing Project Initiation Document, Reference/Domain value mapping.6. Should be able to work with Business and Architects to identify Pain points impacting data capabilities.7. Should be able to establish program/project specific Data Analysis approach.8. Should be competent at Source-Target Data mapping, S/T Record building/ Join conditions, writing transformations building data lineage.9. Should be able to conduct Peer Reviews.10. Should be able to support ETL/Test questions, output file validation, defect analysis.11. Should ensure data analysts (and other data leads, as necessary) are following standard work and best practices.12. Should ensure data work products being produced are at the level of expected quality.13. Should be able to perform skill uplift and coaching of teammates.14. Candidate having Insurance and Financial domain experience would be a plus.15. Candidate should be able to connect and communicate with people at all levels.16. Critical Thinking, excellent Communication, Detail Oriented, Team first attitude, Creative and Adaptive.17. Partners with Business/Requirement and Analyst Lead.18. Experience working in an Agile environment using Lean, Kanban and Scrum practices is a plus.19. Candidate should possess intermediary visualization techniques (Tableau, any BI tool etc.) skills and report generation necessary for the presentation of data to communicate to stakeholders, such as business partners and technical team, the conclusions and recommendations based on the state of the data being analyzed would be a plus.20. Measures and manages the quality of requirements and work products.21. Should be able to discern, understand and communicate changes affecting scope, time or budget.22. Maintains the knowledge base on existing application functionality and data structures and relationships.23. Balances business need for changes with current system constraints.24. Should be able to ensure staffing needs are forecasted as appropriate to ensure project success.25. Should be able to ensure that all data needs are being addressed within the program / project scope, all data risks and issues are captured / addressed, and to maintain the ongoing health and capability uplift for data for the enterprise.26. We value continuous improvement and capability uplift of data management for the enterprise, should have proven track record of doing this.27. Promotes an environment of sharing, exploration and collaboration.28. Promotes reusable processes and work products and builds common understanding.
  • Vacancy expired!

    Subscribe Report job