Senior Consultant SSAS Cubes Reporting SQL BI Calumo

The Senior Consultant will be responsible for analyzing business requirements in order to model design deploy and maintain data warehouse implementations for different customers across different verticals.

This position reports to the Professional Services Manager and will work closely with a team to communicate with business stakeholders customers end users to create model and deploy data analytics and reporting applications.

Responsibilities

Primary Responsibilities:

• Translate business requirements into data models that lay the foundation for reporting and analytics.
• Assist with implementation planning and delivery.
• Model design and deploy data warehouses fact and dimension.
• Design and deploy Extract Transform Load (ETL) processes using SQL Server Integration Services (SSIS);
• Design and deploy multidimensional cubes for and tabular models.
• Interface with customers to gather technical requirements.
• Understand customers data flows and reporting processes around budgeting and planning processes
• Conducting informationgathering sessions with customer
• Document customer requirements to create maintainable applications following best practice guidelines on application and information design
• Implementone or more of our productsfor new and existing customers 
• Maintain existing customers applications
• Setup configure and test components of customer solutions
• Integrate products with customers ERP systems and other data sources under direction
• Assist system testing and rollout activities
• Assist with execution and reconciliation of data conversion
• Provide acceptance testingand postimplementation support
• Other tasks as requested by leadership
• Record your time weekly in our PSA solution

Achievements/Goals within first 36 months:

• Comprehensive fourweeks onboarding program in report authoring
• Shadowing/Assuming a role of a Senior developer on the first project under guidance of lead architect
• Coming up to a target billable utilization ratio in 5 months
• Be able to conduct meetings with customers in role of finance operations to document business requirements
• Assuming ownership of reporting projects in 3 months
• Ability to execute project implementation plans with or without help from Project Manager
• Regular accurate recording of worked hours and monitoring of project budget

Qualifications :

Qualifications / Requirements

• 5 years of experience with SQL/TSQL
• 3 years of expert understanding of MDX multidimensional cubes or DAX tabular models.
• 3 years of experience with Microsoft SQL Server Management Studio including SSIS and SSAS.
• 3 years of experience designing and deploying Extract Transform Load (ETL) architectures and packages.
• Expert understanding of data management including star schemas snowflake schemas and data modelling techniques.
• Experience working with Azure cloud environments and reporting applications.
• Clear and effective communication skills
• Strong debugging troubleshooting and problemsolving skills

Preferred

• Strong Financial Modelling skills
• Experience with CALUMO TM1 or other similar tools.
• Experience in a customer services role (consulting) within the Finance function of an organization
• Excellent presentation written and oral communication skills
• Ability to multitask and prioritize multiple competing tasks
• Proficient inMicrosoft Office Excel and Corporate Performance Management (ex. Cognos Hyperion SSAS understanding dimensions hierarchies and rollups) 
• Understanding ERP financial software solutions
• Understanding software life cycle

Qualifications

• Bachelors degree in; IT with Accounting Business Analytics orBusiness Systems well regarded 

Additional Information :

Ideal candidate should exhibit the following traits:

• Communication Communicate effectively with customers and internal crossfunctional partners creating promoters at every touchpoint. Clear and articulate language capable of working with a range of client representatives particularly in Finance and IT each possessing varying degrees of technical capability; ability to illustrate concepts and ideas with visual aids. Ability to handle difficult conversations and negotiate 
• Curiosity Desire to continue learning more about the applications and push them to new heights
• Teamwork Work crossfunctionally to achieve team and individual goals
• Enthusiasm Exhibit passion and excitement and embrace a cando attitude
• Perseverance Demonstrate focus and commitment to solving complex issues through to completion
• Drive and Discipline Operate in a fastpaced dynamic environment with a focus on generating highquality results on time and on budget
• Highly organized and with great attention to details

** At this time insightsoftware is not able to offer sponsorship to candidates who are not eligible to work in the country where the position is located. **

insightsoftware About Us: Hear From Our Team InsightSoftware (wistia.com)

Background checks are required for employment with insightsoftware where permitted by country state/province.

At insightsoftware we are committed to equal employment opportunity regardless of race color ethnicity ancestry religion national origin gender sex gender identity or expression sexual orientation age citizenship marital or parental status disability veteran status or other class protected by applicable law. We are proud to be an equal opportunity workplace.