At Ancore, we strive to create an environment where our people come first. We call our employees members to reinforce that all who join our team are considered company owners and are empowered to share in the rewards and challenges that come from building a world-class business. As one of the largest independent information technology and business process services firms in the world, we realize our continued success depends on our ability to attract and retain top-quality professionals like you.
• Develop and automate the existing and new reporting requirements, keeping them standardized, but flexible enough to incorporate last-minute changes and adjustments in a fast-moving reporting environment.
• Ability to work with multiple teams to analyze their requirements and provide Power BI reports.
• Developing automated interactive/dynamic Power BI dashboards.
• Efficiently handle large datasets and be able to confidently process them into required formats and execute queries to get the desired result.
• Experience in creating KPI scorecards, customized charts, custom calculations, and effective visualization as per requirements using Power BI desktop.
• Perform data extraction, transformation, data modeling, and representing data in various interactive visuals like tables, matrix, maps, charts, etc.,
• Working on end-to-end Power BI reports and dashboard development.
• Ability to manage priorities and meet tight deadlines.
• Deep understanding of the concepts of Data modeling and creating relationships and building Power BI Reports.
• Strong skills in Power query (M language).
• Extensive experience with M and DAX functions is a must.
• Experience with manipulating/analyzing large volumes of data and performing ETL (Extract, transform, load).
• Experience in drill-through, drill-down and click-through reports.
• Good understanding of SQL, and MySQL.
• Should have command on all the functions of Microsoft Excel.
• Degree in information systems or computer science or any equivalent.
• 3+ years' using Power BI (other leading BI applications will be considered)
• 3+ years' of database design and work with unstructured data in a data lake environment
• Strong knowledge of data collection software and protocol
• Advanced Microsoft Excel proficiency Advanced Formulas, Pivot Tables & Macros
• Ability to structure business discussions and scope solutions.
• Excellent analytical and forecasting ability.
• Understand current data protection and privacy laws.
• Ability to think through problems and provide recommendations to a solution.
• Demonstrated ability to manage multiple complex projects in parallel.
• Proven ability to develop and manage BI solutions using Power BI
• Strong knowledge of T-SQL and DAX to support reports, dashboards, and data models.
We offer great benefits – Competitive Paid Time Off, Medical, Dental and Vision Insurance, 401(k).
We invest in our employees – Every employee is provided with a stipend to invest in certifications, a master’s degree, or even a doctorate. We want you to grow as an expert and a leader and offer flexibility for you to take a course, a certification, or attend a conference. We are committed to supporting your curiosity and sustaining a culture that prioritizes commitment to continuous professional development.
We work hard, we play hard. Ancore is committed to injecting fun into every day. We dedicate funds for activities – virtual and in-person – e.g., we host happy hours, holiday events, fitness events, and annual celebrations. In alignment with our commitment to our communities, we host and attend charity galas/events. We believe in appreciating your commitment and building a positive workspace for you to be creative, innovative, and happy.
Ancore Inc is an Affirmative Action/Equal Opportunity employer. As such, any personnel decisions (hire, promotion, job status, etc.) on applicants and/or employees are based on merit, qualifications, competence and business needs, not on race, color, citizenship status, national origin, ancestry, gender, sexual orientation, gender identity, age, religion, creed, physical or mental disability, pregnancy, childbirth or related medical condition, genetic information of the employee or family member of the employee, marital status, veteran status, political affiliation, or any other factor protected by federal, state or local law.
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable Accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.
