BI Consultant 2 (Multiple Positions)

Ernst & Young LLP Boston , MA 02298

Posted 2 months ago

BI Consultant 2 (Multiple Positions), Ernst & Young U.S. LLP, Boston, MA.

Duties: Provide data analytics services to help clients solve business problems, drive value and insight from information, focusing on the consumption of data.

Help clients realize the full potential of data through effective reporting and analysis and key metrics. Serve as a key member of a team to provide services ranging from discrete projects to full implementations of a reporting and analytics application, transforming data from a cost center into a competitive advantage. Work with reporting solutions for business functional areas, including, management, financial, compliance, operations and risk.

Help clients address issues in the development of reporting and analytics business capabilities, strategy and roadmap. Assist in the facilitation and definition of reporting and analytics business requirements. Support the definition of Business Intelligence technical architectures. Design and implement leading Business Intelligence packages, including Cognos, Business Objects, MicroStrategy, Spotfire, Qlikview, SAS, or related technologies.

Manage and motivate teams of professionals with diverse skills and backgrounds. Consistently deliver quality client services by monitoring progress.

Demonstrate in-depth technical capabilities and professional knowledge. Maintain long-term client relationships and networks. Cultivate business development opportunities.

Full time employment, Monday

  • Friday, 40-45 hours per week, 8:30 am

  • 5:30 pm.


Must have a bachelor's degree in Economics, Engineering, Statistics, Mathematics, Computer Science, Business or a related field and 5 years of progressive, post-baccalaureate work experience solving business problems using SQL. Alternatively, must have a Master's degree in Economics, Engineering, Statistics, Mathematics, Computer Science, Business or a related field and 4 years of work experience solving business problems using SQL.

Must have 4 years of experience in Data Reporting and reporting tools, including Cognos, Business Objects, MicroStrategy, Spotfire, QlikView, SAS, OBIEE, Tableau, SQL, SSRS SQL Server Reporting Services (SSRS), and/or SQL Server Analysis Services (SSAS).

Must have 3 years of experience in the financial services industry.

Must have 1 year of experience in any three of the following next gen tools and technologies: Hadoop, HIVE, Impala, Apache Drill, Pentaho, Paxata, Podium, Databricks, Tamr, Datastax, Datameer, Splunk, Sumologic, Mapreduce, Python, Scala, R, Spark.

Must have 4 years of business intelligence reporting experience.

Must have 3 years of reporting requirements, analysis, design and development experience.

Requires domestic and regional travel up to 80% to serve client needs.

Employer will accept any suitable combination of education, training or experience.

TO APPLY: Please apply on-line at, and click on "Find jobs" (Job Number

  • BOS003SP).

EY provides equal employment opportunities to applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

This particular position at Ernst & Young in the United States requires the qualified candidate to be a "United States worker" as defined by the U.S. Department of Labor regulations at 20 CFR 656.3.

You can review this definition at at the bottom of page 750. Please feel free to apply to other positions that do not require you to be a "U.S. worker".

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
BI Developer

Deloitte & Touche L.L.P.

Posted 1 week ago

VIEW JOBS 3/19/2020 12:00:00 AM 2020-06-17T00:00 BI Developer, Business Intelligence Project Delivery Specialist Are you an experienced, passionate pioneer in technology - a BI Developer, solutions builder, a roll-up-your-sleeves technologist who wants a daily collaborative environment, think-tank feel and share new ideas with your colleagues - without the extensive demands of travel? If so, consider an opportunity with Deloitte's project delivery model. Work you'll do * Analyze & Design: * BI Development, build reports and coordinate with the business and client on developing, maintaining new and existing reports and SSAS. * Write SQL queries to extract data from source applications to answer ad hoc business questions and validate reports. * Conduct JAD sessions with business users and key stakeholders. * Resolve comments and/or seek clarifications from business users on functional design documents across business process area. Facilitate meetings between business units to confirm * Work with data warehouse team and be responsible for reporting and SSAS. The Team Our Sector Packages practice encompasses industry vertical, sector specific solutions that leverage distinct technologies to drive operational change and automate the core of the business. Examples of the type of work we deliver to our clients includes Digital CARE (Epic), Insurance CST (Guidewire), and Digital Banking Solutions. The team brings experience from across Deloitte to leverage common approaches, best practices, and strategic investments to scale these solutions by industry strategy. Professionals will focus on key client issues that are at the core of the business by integrating our industry expertise with deep technical and operational transformation capabilities. Qualifications * Bachelor's Degree or equivalent work experience * 6+ year of Professional work experience * 3+ years' experience in BI development and reporting for large projects * Hands on experience on developing multi-dimensional Cubes on Microsoft SSAS. * Ability to write MDX queries on SSAS. * Ability to analyze & create adhoc reports for business needs using Cube on SSAS. * Knowledge of Data Modelling & Data warehousing concepts * Experience on analyzing & writing SQL queries to analyze the data * Must be willing to relocate to Boston MA. This is not a travel role * Limited immigration sponsorship may be available Preferred * Experience to Redshift Database or any other Postgre SQL DB. * Experience on Tableau - creating reports & dashboards using SSAS Cubes or database source. * Experience on building reports in Asset Management data domain or any Sales tracking systems will be a plus. How you'll grow At Deloitte, our professional development plan focuses on helping people at every level of their career to identify and use their strengths to do their best work every day. From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to help sharpen skills in addition to hands-on experience in the global, fast-changing business world. Benefits At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Deloitte's culture Our positive and supportive culture encourages our people to do their best work every day. We celebrate individuals by recognizing their uniqueness and offering them the flexibility to make daily choices that can help them to be healthy, centered, confident, and aware. We offer well-being programs and are continuously looking for new ways to maintain a culture where our people excel and lead healthy, happy lives. Learn more about Life at Deloitte. Corporate citizenship Deloitte is led by a purpose: to make an impact that matters. This purpose defines who we are and extends to relationships with our clients, our people and our communities. We believe that business has the power to inspire and transform. We focus on education, giving, skill-based volunteerism, and leadership to help drive positive social impact in our communities. Learn more about Deloitte's impact on the world. Recruiter tips We want job seekers exploring opportunities at Deloitte to feel prepared and confident. To help you with your interview, we suggest that you do your research: know some background about the organization and the business area you're applying to. Check out recruiting tips from Deloitte professionals. As used in this posting, "Deloitte" means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. Please see for a detailed description of the legal structure of Deloitte LLP and its subsidiaries. Certain services may not be available to attest clients under the rules and regulations of public accounting. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law. Requisition code: E20MASCACSCT074-TPP * * * * * * Deloitte & Touche L.L.P. Boston MA

BI Consultant 2 (Multiple Positions)

Ernst & Young LLP