Senior Data Analyst
UST
- Aliso Viejo, CA
- $73,000-109,000 per year
- Permanent
- Full-time
- BRD assessment / evaluation / feedback (if applicable)
- High level solution / design (big picture, design for future)
- Performing Analysis
- Completing all required SA deliverables for the project
- Follow SA process and checklists
- Support throughout the entire SDLC process (DEV, PV, UAT) until validation completed in production
- Review all project deliverables from other areas (DEV, PV, UAT) and provide feedback
- Planning and estimating for future releases while supporting past releases and delivering on work for current release
- Roadmap involvement
- Assessments of project scope and timelines
- Involved in the intake of the requirements to ensure that the requirements are feasible given the company’s technology stack
- Gaps are highlighted and filled if possible
- Translate requirements into technical documents which describe what the development team is expected to build
- Troubleshoot issues when they arise. In situations where old tickets are being analyzed the SA is expected to be capable of presenting a clear and concise analysis of the issue with examples that support the analysis. Expected to propose solutions to the issues
- Generally the SA is involved in building applications on top of a given technology stack. However, there are projects which involve upgrading or changing the technology stack which have a heavy involvement of the SA group.
- Modeling Dimensional Databases and Data Marts (includes physical and logical models)
- Writing complex SQL and stored procedures (DB2 preferred); translating specifications and rules into SQL
- Working with data modeling tools (Erwin preferred)
- Interpreting and writing source to target mappings (ETL transformation rules)
- Working with string and data manipulation functions and macros with Microsoft Excel
- Metadata management and data governance
- Creating and maintaining data dictionaries
- Maintaining and interpreting data lineages
- Minimum of 8-10 years of hands-on experience with the following:
- Working in the following areas:
- Data Warehousing and ETL
- Data Marts
- Data Profiling
- Data Modeling
- Data Quality Analysis
- Ability to draw out high-level and detailed designs and represent them as flow diagrams (preferably using Visio)
- Ability to translate business requirements into functional and technical specifications.
- Ability to look at the given system/solution from a tool/technology-agnostic perspective and document deterministic rules / behavior in pseudo-code.
- Ability to design end-to-end data warehousing / reporting solutions using components like databases, ETL tools and reporting frameworks.
- Ability to provide time estimations for SA activities for a project based on the design.
- Ability to work closely with Development, PV and UAT teams to provide them the required support.
- Ability to perform and provide a detailed system impact analysis for a given change request and provide estimates.
- Able to lead junior SA persons and possibly provide feedback on multiple projects.
- Required Soft Skills:
- Good analytical and problem-solving skills
- Exceptional communication skills (written and verbal)
- Good documentation skills
- Proficiency in English language (as a medium of communication)
- Frank and open communication with peers and higher-ups about realistic estimations and meeting timelines/expectations and proactive communication of issues and concerns thereof.
- Assertiveness in communicating ideas, estimates, scope and timelines.
- Nice to have:
- Experience with working on DB2 and Postgres Databases
- Experience working with PHI & PII and sensitive data
- Knowledge about ETL tools (preferably Ab Initio)
- Knowledge about other Ab Initio tools like Query>IT, MDH, BRE etc.
- Knowledge about business intelligence / analytics / tool experience – Cognos/Tableau
- Knowledge about medical and Rx claims processing, healthcare enrollments and providers
- Knowledge and understanding of security standards
- Preferred: Master’s Degree in Computer Science or similar technologies
- Must: Bachelor’s Degree
- Ability to speak to the various aspect of the SDLC