Data Analyst - manila, phBalsamBrands

Job Description Balsam International is looking for a Data Analystwho is knowledgeable and experienced in Microsoft SQL and data analysis. This team member will primarily be responsible for Microsoft SQL related tasks and supporting the TV team in d Job Description Balsam International is looking for a Data Analyst who is knowledgeable and experienced in Microsoft SQL and data analysis. This team member will primarily be responsible for Microsoft SQL related tasks and supporting the TV team in data analysis. Having knowledge in Power BI for Report Development is also a huge plus. Summing these up, we arelooking for someone who is flexible and demonstratesexcellent SQL, Excel, and Analytical skills. What you'll be doing: Data Administration Executes other tasks and duties relating to data administration such as updating and refreshing of data sets. Processes data based on the analytical requirements of the teams we are supporting. Following the agreed schedules and specifications of the reports. Builds and maintains a central database for all the reporting needs. Troubleshoots tracking issues and identifies discrepancies in data collection. Learning and Development Educates junior team members by documenting internal processes in report development and data administration. Develops and creates reporting materials to aid users in automating work. Develops and designs reporting templates utilizing our different tools such as MS Excel, Power BI, and other tools. Report Development Develops new reports, be it on Excel, SQL or Power BI, involving the different data sets such as BR and other internal sources utilized within the company. Develops new reports, be it on Excel or Power BI, with the use of data sets structured by the team. Thoroughly reviews developed reports before being passed on to team members for audit. Report should be consistent and accurate when compared to previous report versions. Documents and updates (as necessary) all the user and technical guides of the reports developed. Utilizes Excel, Power BI or SQL in developing reports. Meets set deadlines for report development and revisions. Business Intelligence Tools Ensures accuracy of the data and reports maintained by the team. Learns and understands the different internal and external tracking tools utilized by the Data Insights team, such as (but not limited to) SSRS and other relevant platforms. Learns and understands the different tracking tools used in our reports. Monitors changes and updates in the different BI tools the team utilizes. Data Analysis and Audit Supports other functions with their data analytics needs. Provides relevant insights relating to the TV performance. Reviews thoroughly the reports before being passed on for publication to the end users. Provides detailed findings on reports being audited. Project Lead Manages incoming requests and consults with the supervisor and/or manager for project assignment. Coordinates with agencies or vendors. Represents the Data Analytics team in cross-functional projects. Other Duties and Responsibilities Performs other duties that may be assigned from time to time. What we're looking for: Education: Bachelor's Degree in Business, Mathematics, or Computer Programming Experience: Minimum of one (1) to two (2) years relevant experience in performing the various functional units of the Data Analytics team covering the areas of Data Administration, Learning and Development, Report Development, Business Intelligence Tools, Data Analysis and Audit and Project Lead. Must be adept in MS SQL or Power BI, with strong skills in Microsoft Excel and Power Query and Business Intelligence tools, with specific experience in MS SQL. Behavioral Competencies: Ownership/ approach to work problems Solves discrete problems under minimal guidance of senior team members. Cross-functional teamwork Participates actively in short- to medium-term projects. May be required to work as lead on project with team members and other functions. Quality and timely delivery of results Delivers high-quality results on projects of medium complexity within established timelines attempts projects of high complexity with guidance. Functional Expertise Expert in role specific tasks and processes. Displays competency in function-specific technologies and tools. Confidently represents function across teams. Effective Communication Clear communicator presents material in logical and efficient manner. Constructive Feedback Curious about self and other team members. When called upon, provides constructive feedback to team members and manager. Open to constructive feedback and developing own potential. Customer Mindset Demonstrates understanding of customer mindset in execution of functional work. Location: The Data Analyst position is a long-term remote working position for Balsam International Unlimited Company Philippine ROHQ in Manila. Team members in the Philippines are located within Metro Manila, Cavite, Rizal, Bulacan or certain parts of Laguna only (Bian, Cabuyao, Calamba, Los Baos, San Pedro, and Santa Rosa). Our must-haves: Must be willing to attend occasional in-person meetings depending on the status of the pandemic. Must have a fast, reliable DSL, Fiber, or Broadband connection (not mobile or broadband stick) as the primary internet connection with a minimum actual speed of 10MBPS . Must have a back-up internet connection of the same speed if primary connection becomes spotty. Note: An online assessment will also be part of the recruitment process. Status: This is a full-time, permanent position with benefits. Hardware Provision: Company-issued Laptop will be provided on first day. At Balsam International, we strive to offer a competitive compensation and benefits package. For permanent, full-time team members, this includes: Government-mandated Benefits (SSS, PAG-IBIG, PhilHealth) 13th Month Pay Paid Leaves. We use time off to rest, go on vacation, or just sleep in! Our paid time off is flexible to our needs. Internet Subsidy. With internet allowance, we are set up for success. Healthcare Coverage (+ 2 dependents). We worry less about rising medical costs with flexible quality healthcare benefits. Maternity, Paternity, and Solo Parent Benefit. Wemake sure parents are supported while they navigate work and family life. Continuous Learning and Professional Development Benefit. Our professional and personal development are fully supported. Whether it be online courses, workshops or books! Mental Health Support. We manage work and life's challenges through Mental Health Day breaks, 24/7 professional counselling, and curated webinars. Company Incentive. An additional cash-based perk for all our Brandits based on company's performance. Meeting & Team Building Allowance. Happy tummies make our meetings more fun and productive! Shutdown Week. We can spend more time on things that matter with an additional one week paid time off on top of paid leaves. Volunteer Time Off. With two paid days off, we are able to volunteer for advocacies we believe in. Bereavement Leave. We get additional paid leaves when a loved one passes to grieve and provide immediate support to our families. At Balsam International, we strive to build a diverse, equitable, and inclusive team to fulfill our purpose to create joy together. Balsam International is proud to be an equal opportunity employer. We encourage people from all backgrounds, ages, abilities, and experiences to apply. We do not discriminate on the basis of race, ethnicity, religion, national origin, citizenship, marital or family status, disability, sexual orientation, gender identity or expression, pregnancy or caregiver status, or any other legally protected status. We will ensure that individuals with disabilities are provided reasonable accommodations to participate in the job application and interview process, to perform essential job functions, and to receive other benefits and privileges of employment.
Monster

Manila City, Metro Manila
Permanent
Full-time