Senior Consultant, Supplemental Health
Sun Life
Consultant, Data Management
Beghou Consulting
full-time
Posted on:
Location Type: Hybrid
Location: Rockville • Maryland • 🇺🇸 United States
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
AzureETLInformaticaMySQLOraclePostgresPythonTableauVBA
About the role
- Work with cross-functional project teams in the design and development of high-quality deliverables for clients
- Collaborate with leadership to define project scope, approach, and development strategies
- Contribute to Beghou’s internal data warehouse build (ARMADA)
- Demonstrate knowledge of data platform components (warehouse, monitoring) and data engineering (ETL design, schema design) and CI/CD best practices
- Analyze data, synthesize findings, and develop actionable insights, communicating results to both internal and external teams
- Handle client communications, meeting facilitation, and timelines, serving as a primary point of contact with minimal oversight
- Develop and optimize data processes, utilizing coding where necessary to facilitate efficient data handling and reporting
- Coordinate with global and diverse teams to ensure seamless project execution
- Contribute to internal firm initiatives to drive organizational growth
- Lead project teams and provide thought leadership to guide internal stakeholders toward project success
Requirements
- Bachelor’s or advanced degree with at least 2+ years of relevant professional experience, preferably in the pharmaceutical or life sciences industry
- Experience with one or more additional UI-based ETL tools (e.g., Azure Data Factory, Alteryx, Informatica, SnapLogic, Boomi, Prophecy), preferred
- Experience with relational database technologies (PostgreSQL, Oracle, MySQL, Databricks, Snowflake)
- Knowledge of data platform components (warehouse, monitoring) and data engineering (ETL design, schema design) and CI/CD best practices
- Strong proficiency in Microsoft Office tools (Word, PowerPoint), with advanced expertise in Excel
- Knowledge of coding languages (SAS, Python, R, VBA) and experience with data visualization software (Tableau, Power BI) is highly preferred
- Excellent analytical and quantitative skills
- Exceptional communication skills, both written and verbal
- Demonstrated organizational, time management, and project management skills, with the ability to lead teams and manage multiple projects simultaneously
- Strong ability to collaborate, adapt quickly, and work effectively in a fast-paced environment
- Familiarity with industry best practices in data analytics within the pharmaceutical sector
- Must be legally authorized to work in the United States; candidates requiring sponsorship cannot be considered
Benefits
- Comprehensive medical, dental, and vision insurance
- Life & AD&D coverage
- Disability insurance
- Lifestyle Wellness Account
- Generous PTO
- Company holidays
- Paid parental & bonding leave
- Flexible hybrid work policy
- 401(k) and employer match
- Tax-free commuter, health, and childcare accounts
- Performance bonuses
- Monthly phone stipend
- Employee discount program
- Mentorship, training, and tuition reimbursement
- Charitable donation match
- Competitive compensation package
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
ETL designschema designdata engineeringdata analysisdata visualizationSASPythonRVBAMicrosoft Excel
Soft skills
analytical skillsquantitative skillscommunication skillsorganizational skillstime managementproject managementcollaborationadaptabilityleadershipmeeting facilitation
