Data Analyst joining Oscar's Clinical Data Analytics team in Tempe, Arizona. Analyzing performance metrics and insights to support business goals with a hybrid work model.
EX
Hybrid Associate Business Analyst, Data Management and Analytics – Data Ops/Data Analyst
Posted 4 months ago
About the role
- Data analyst role focusing on interactive reports and dashboards in an analytics team. Requires extensive experience in PowerBI, SQL, and reporting tools in insurance and reserving.
Responsibilities
- Designing interactive reports and dashboards using PowerBI/SSRS or excel integrating MS Access Database
- Writing complex DAX expressions for custom measures and calculations, use MS Access forms, macros, modules (including VBA automations) for further custom report generation
- Configuring scheduled data refresh and Power BI Gateways, Implementing Row Level Security
- Connecting to various data sources (SQL Server, ODBC, Excel, APIs, etc.) for data extraction from relational databases and external sources
- Create, modify and test various SQL queries, Access/VBA Macros, Stored procedures and views for obtaining data from diverse source systems and platforms
- Leverage SQL/SSIS code as part of an ETL process to support report development on PowerBI or help support with necessary enhancement
- Develop stored procedures functions using T-SQL/SQL to automate report refresh or data views
- Excellent verbal and written communication skills including demonstrated ability to effectively and professionally communicate with others, including situations where you may disagree with people
Requirements
- Bachelor’s/Master's degree in economics, mathematics, computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
- 5+ years in analytics (Preferably with Insurance and Reserving)
- Must have experience in reporting tools like MS Access, VBA, PBI and good advance SQL skills
- Must have experience in using ETL tools like SSIS or Azure etc.
- Good to have experience in SSRS, Excel , SSAS
- Good critical thinking and problem solving skills
- Strong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to work
- Outstanding written and verbal communication skills, and presentation skills
- Able to work in fast pace continuously evolving environment and ready to take up uphill challenges
- Is able to understand cross cultural differences and can work with clients across the globe
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Data Analyst supporting business units with data - driven insights and performance metrics at Oscar Health. Collaborating across departments and delivering analysis to improve healthcare efficiencies.
Data Analyst intern at Ledger, supporting AI initiatives and analytics engineering. Collaborating with teams to transform data into actionable insights for business growth.
Data Analyst supporting supply chain risk management for federal agencies. Focusing on data analysis and mitigation strategies in a collaborative team environment.
Data Analyst supporting threat analysis operations within supply chain risk management program. Focus on identifying vulnerabilities and assessing geopolitical exposure.
Senior Quantitative Analyst validating the Standard Initial Margin Model in investment banking. Involves quantitative validation and risk analysis in a regulated environment.
HR Coordinator & People Analytics Specialist supporting HR operations and managing people analytics reporting. Ensuring data accuracy and handling sensitive employee information with confidentiality.
Data Analyst developing dashboards and reports using Power BI and SQL for strategic insights. Collaborating with business areas to map analytical needs and ensure data quality.
Business Data Analyst II supporting SAS/SQL - based CCAR Y14 reporting solutions at Truist. Ensuring accuracy and regulatory alignment of CCAR Y14 data through reporting enhancements and analysis.
ERP Data Analytics Governance Manager leading data governance and compliance initiatives within SAP S/4HANA transformation project. Collaborating across teams to ensure data integrity and regulatory adherence.