The Business Intelligence Developer participates as a member of the SMPO team focused on Senior Products data integration. This role will work to ensure that business technology solutions align with the long-term vision and goals of Point32Health, and with the existing enterprise architecture. This role leverages appropriate influence on collaborative efforts to ensure that the best knowledge is sought, critical thinking and planning skills are leveraged, and the best possible decisions are reached for the application, support, and change in business technology solutions and processes.
Key Responsibilities/Duties - What You Will Be Doing
- Drive data quality across the business with advanced/expert experience in data engineering and data warehousing. Has a track record of success solving various business problems and handling scalability issues for ELT/ETL platforms.
- Leverage Data Integration tools to synthesize data for use with internal dashboards, reports, case studies, pipeline forecasts, as well as for adhoc analyses.
- Ensure that technical design processes and products adhere to industry standard best practices and that they integrate efficiently and effectively.
- Consult in the identification and refinement of business needs, requirements, and functional specifications for assigned project and change activities.
- Consult in the identification, research, and presentation of alternative solution models as a means to ensure the best possible business outcome.
- Consult in the creation of useful model(s) to communicate current state, future state, and gap definitions in support of decision-making processes.
- Consult in the refinement of existing models, adding new ideas to make the result more flexible and tightly linked to current and expected requirements.
- Provide an expert-level view on the assigned technical discipline, serving the consultative needs of all areas of the Medicare team.
- Participate in project requirements reviews, conceptual modeling, discovery processes, technical design reviews, and project meetings to provide appropriate guidance that influences good business outcomes.
- Maintain knowledge and familiarity with current and emerging technologies, best practices, business processes, industry trends, and information security considerations.
- Perform data analysis, including data profiling into data warehouses, to obtain a good understanding of data availability, relationships, and nuances for consideration of ETL solution design.
- Work with end users, technical staff, and project team members to plan, design, develop, implement, and enhance business analytics capabilities through data integration of various external data sources.
- Develop and enforce change management and versioning processes surrounding new releases of ETL jobs and evaluate and recommend new tools and methodologies to assist with change and version management.
- Assist with performing change impact analysis on code changes to estimate the level of effort required for code changes and testing.
- Review current operational data structures and data flows and recommend optimizations and opportunities for automation.
Education Qualifications - What You Need to Perform the Job
- Bachelor's degree in Mathematics, Statistics, Business, or related fields.
Experience
- 3-5+ years of experience in ETL and data wrangling.
- Effective ETL (Extract/Transform/Load), data shaping, and data wrangling skills are critical to success in this role. Knowledge of tools such as Alteryx/Microstrategy is preferred but not required, while exceptional knowledge of Microsoft Excel and experience with SQL/Access will be necessary.
- Effective BI and analytic skills are critical to company growth as we move forward with our next-gen performance optimization deployment.
- Excellent verbal and written communication skills to attend stakeholder meetings, gather complex requirements from business partners, present findings back out, and document work procedures.
- Ability to work well within a team environment and be highly motivated and self-directed.
- Mathematical problem-solving, statistical, and analytical skills are required.
- Strong relationship-building skills to channel issues effectively toward resolution.
- Knowledge and experience with different types of database structures, joins, and data blending techniques.
- Developing presentation skills, primarily presenting within the department and to project teams.
- Experience writing and modifying Python and/or VBA code is a plus.
- Increasingly applies own judgment to analytical/technical issues.
Commitment to Diversity, Equity & Inclusion
Point32Health is committed to making diversity, equity, and inclusion part of everything we do—from product design to the workforce driving that innovation. Our DEI strategy is deeply connected to our core values and will evolve as the changing nature of work shifts.
Who We Are
Point32Health is a leading health and wellbeing organization, delivering an ever-better personalized health care experience to everyone in our communities. At Point32Health, we are building on the quality, nonprofit heritage of our founding organizations, Tufts Health Plan and Harvard Pilgrim Health Care, where we leverage our experience and expertise to help people find their version of healthier living through a broad range of health plans and tools that make navigating health and wellbeing easier.
This job has been posted by Ignyte AI on behalf of Point32Health. Ignyte AI is committed to the fundamental principle of equal opportunity and equal treatment for every prospective and current employee. It is the policy of Ignyte AI not to discriminate based on race, color, national or ethnic origin, ancestry, age, religion, creed, disability, sex and gender, sexual orientation, gender identity and/or expression, military or veteran status, or any other characteristic protected under applicable federal, state, or local law.
Req ID: R6798
#J-18808-Ljbffr
