Optum is a global organization that delivers care aided by technology to help millions of people live healthier lives. The Business Data Analyst role involves translating business needs into IT solutions, supporting data modernization efforts, and enhancing customer data integration. The ideal candidate will have strong analytical skills and be responsible for managing multiple data projects while ensuring data quality and alignment with business objectives.
Responsibilities:
- Understand and document the business requirements based on the customer's needs. This includes understanding and evaluating the enhancement request, the business process, and general system capabilities
- Support data modernization efforts and data migration to enterprise solutions
- Champion the thoughtful adoption of AI tools and techniques across initiatives to accelerate analysis, enhance quality, and scale impact, ensuring alignment with business objectives and enterprise standards
- Research and gain a high-level understanding of data elements and sources
- Data Profiling and Creation - in particular, experience working with streaming data sources and profiling data
- Define the source of data - type of ingestion, relationships, tables, variables, and transformations that may be needed
- Become a SME in how the data will be used and how it functions
- Create and ensure that artifacts are complete per the business and the artifact is ready for review with IT teams to begin the Solutioning phase of the Software Development Life Cycle (SDLC)
- Presenting ideas and findings in meetings
- Create process flows to simplify hand off from business to IT resources
- Excel at problem solving, identifying the root cause and approach a challenge in multiple ways
- Proactively troubleshoot data quality issues by identifying the root cause of data discrepancies and determining and implementing recommendations for resolution
- Work with business counterparts on operational readiness activities to ensure that necessary training and procedure updates have occurred
- Contribute to the execution of the Adobe Experience Platform data roadmap including initiatives related to data quality, data unification, data governance, data movement, and data access
- Provide leadership and project management in a cross-team environment
- Be comfortable juggling multiple projects and constantly shifting timelines in a fast-paced complex environment
- Understanding of data warehousing concepts
- Analyze large amounts of data and business processes to form ideas and solutions to support data enablement, standardization, cleansing of the data, and data readiness
- Data Gap Analysis
- Build Test Cases
- Conduct data Validation and Testing
- Ensure business rules are clearly defined
- Ensure metrics are clear and have supporting data
- Ensure metrics are measurable
- Ensure requirement collection is standardized - Data Selection or Transformations (including Table Joins)
- Ensure Data Governance standards are incorporated
Requirements:
- 4+ years of experience supporting data related initiatives (system integration, data warehouse build, data mart build or related) and a proven track record of exceeding expectations on these initiatives
- 4+ years of business analyst experience
- 1+ years of QA/UAT experience
- Proven solid documentation skills (business requirements documents, source to target mappings, transformation rules, etc.)
- Ability to write/understand complex SQL queries involving advanced unions, joins, aggregations, and groups
- Adobe Experience Platform experience
- JSON experience
- Azure experience
- Python experience
- R experience
- Workfront experience
- Rally experience
- MS Office Toolset experience
- Experience with Healthcare data
- Experience with marketing capabilities
- Proven solid communication skills
- Project management experience