Sign upLog in

BI Analyst/Report Developer

Expert In Recruitment Solutions

Malvern, PA

Apply
JOB DETAILS
SKILLS
Adobe Product Family, Amazon Web Services (AWS), Analysis Skills, Apiary/Beekeeping, Atlassian JIRA, Business Case, Business Intelligence, Channel Marketing, Cloud Computing, Communication Skills, Customer Relations, Customer/Client Research, Data Analysis, Data Cleaning, Data Collection, Data Migration, Data Quality, Decision Support, Desktop PC, Establish Priorities, Financial Planning, GitHub, IBM DB2, Mainframe Computer, Marketing, Metrics, Microsoft Access Database, Microsoft Excel, Microsoft Visual Studio, Oracle, Product Development, Product Documentation, Production Support, Project/Program Management, Python Programming/Scripting Language, Reporting Dashboards, SQL (Structured Query Language), Salesforce.com, Scripting (Scripting Languages), Strategic Planning, Tableau, Testing, Time Management, Use Cases
LOCATION
Malvern, PA
POSTED
30+ days ago
BI Analyst/Report Developer
assessment required
M alvern, PA - hybrid

Job description:
  • Must be robust in Python, SQL, AWS and Tableau. MUST have robust communication skills as the contract involves working with stakeholders and directors. Manager is looking for someone who loves data!
  • Developing, optimizing, testing, and troubleshooting SQL scripts (using Presto, Hive,
  • and PySpark query engines) to provide data as per clients' requirements and specifications on time
  • Catering to adhoc data pull requests, that involve structuring, segmenting, and deriving quick insights into company and client data, using platforms like AWS Athena, JupyterHub, and Visual Studio Code
  • Drafting Python scripts to be able to mine and merge together relevant data from various databases (like Mainframe/DB2, Oracle, Salesforce, and Adobe) and storing it in Excel/CSV format on shared drives for enterprise-wide access
  • Employing data handling techniques like data scrubbing, profiling, mapping, and quality testing before using the data for reporting, experimentation, and modeling
  • Assisting with data migration efforts to AWS Cloud, supporting the building of and validating new data products, and documenting any code/methodology used within GitHub; Bitbucket repositories
  • Remediating and automating business reporting to enable real-time/continuous data capture, minimizing manual intervention, ensuring ease of access, and introducing self-serve capabilities
  • Building executive-level and client-facing dashboards on Tableau Desktop/Cloud to capture and track business metrics on a weekly/monthly/quarterly basis, and providing production support in case of data/dashboard defects
  • Working with Adobe-tagged webpages and email links to track customers' engagement with the company's marketing channels and summarizing it in the form of open/click rates, impressions, and try-starts
  • Analyzing the adoption, retention, and unenrollment rates for various financial advice offers that the company offers at different tiers (advice channels, business lines, etc.)
  • Utilizing project management (PM) tools like JIRA and Confluence to plan, prioritize, and track the work in progress
  • Researching, planning, and scoping out business use cases as per the client's requirements and delivering them in the form of dashboards, analyses, recommendations, or other PMO templates
  • Setting up weekly touchpoints to discuss client requirements, business goals, technical specifications, and any other significant project milestones and deliverables
  • Summarizing and sharing data with the aligned business partners to support their decision-making, strategy planning, and client/marketing outreach efforts
  • Strategizing and partnering with various stakeholders involved end clients, product owners (POs), project managers (PMs), subject matter experts (SMEs), data analysts, and engineers to develop comprehensive products that suit business and reporting needs
Job Responsibilities
  • Analyzing the adoption, retention, and unenrollment rates for various financial advice offers that the company offers at different tiers (advice channels, business lines, etc.)
  • Utilizing project management (PM) tools like JIRA and Confluence to plan, prioritize, and track the work in progress
  • Researching, planning, and scoping out business use cases as per the client's requirements and delivering them in the form of dashboards, analyses, recommendations, or other PMO templates
  • Setting up weekly touchpoints to discuss client requirements, business goals, technical specifications, and any other significant project milestones and deliverables
  • Summarizing and sharing data with the aligned business partners to support their decision-making, strategy planning, and client/marketing outreach efforts
  • Strategizing and partnering with various stakeholders involved end clients, product owners (POs), project managers (PMs), subject matter experts (SMEs), data analysts, and engineers to develop comprehensive products that suit business and reporting needs

About the Company

E

Expert In Recruitment Solutions

Resume Resources

Free Resume TemplatesFree Resume Builder