Job description
- In this role you will work with the Lead Data Engineer to serve as the technical experts within the Business Intelligence & Analytics group to support firmwide reporting needs .
- A s trong background in DOMO combined with experience in writing complex R scripts is highly valued .
- An ideal candidate is adept at integrating transforming and wrangling large datasets in preparation for reporting and modeling . Significant experience in interpreting business needs into technical requirements that will translate into robust and scalable data designs will serve as a foundation to create intuitive and userfriendly dashboards and analysis.
- Experience in data science such as training statistical model using machine learning algorithms is a plus.
Primary Responsibilities
- Design and maintain Magic ETL and MySQL dataflows for sustainability viability and efficiency to support firmwide reporting needs from various departments and stakeholders
- Develop and maintain R/Python scripts to support PDP management group management user account management and task automation
- Build and maintain intuitive DOMO cards/dashboards based on BI best practices
- Identify analy ze and interpret trends in complex data sets
- Receive and respond to requests for data / ad hoc reports
- Convert adhoc reporting to normalized/automated reports when the need arises
- Validation of new reports and quality control of existing reports to ensure accuracy
- Retrofit outdated/cumbersome existing reports
- Update distribution lists and permissions for automated report recipients in DOMO
Required Q ualifications
- Bachelor s degree in Business Analytics Computer Science or related field
- 01 years professions ex perience working in an analytically focused role
- Capable in scripting with R Python and Java programming languages
- E xperience working with mainstream BI tools such as DOMO Tableau or PowerBI
- Experience working with database administration tools such as SQL and ETL
- Advanced Excel knowledge required (pivot tables formulas automation)
- Handson experience working with relational databases/large datasets to derive insights and make recommendations
- Ability to work crossfunctionally build relationships and excel in team and cross functional environment
- Welldeveloped verbal and written communication skills
Preferred Q ualifications
- Any Graduate can apply.
- Python / SQL / Excel.
data,reporting,analytics,excel,management,python,automation,r,dashboards,datasets