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 multi-dimensional cubes for and tabular models.
- Interface with customers to gather technical requirements.
- Understand customer’s data flows and reporting processes around budgeting and planning processes
- Conducting information-gathering sessions with customer
- Document customer requirements to create maintainable applications following best practice guidelines on application and information design
- Implement one or more of our products for new and existing customers
- Maintain existing customer’s applications
- Set-up, 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 testing and post-implementation support
- Other tasks as requested by leadership
- Record your time weekly in our PSA solution
Achievements/Goals within first 3-6 months:
- Comprehensive four-weeks 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 / Requirements
- 5+ years of experience with SQL/TSQL
- 3+ years of expert understanding of MDX multi-dimensional 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 problem-solving 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 multi-task and prioritize multiple competing tasks
- Proficient in Microsoft Office Excel and Corporate Performance Management (ex. Cognos, Hyperion, SSAS – understanding dimensions, hierarchies and roll-ups),
- Understanding ERP financial software solutions
- Understanding software life cycle
Qualifications
- Bachelor’s degree in; IT with Accounting, Business Analytics or Business Systems well regarded
Ideal candidate should exhibit the following traits:
- Communication - Communicate effectively with customers and internal cross-functional 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 cross-functionally to achieve team and individual goals
- Enthusiasm - Exhibit passion and excitement and embrace a can-do attitude
- Perseverance - Demonstrate focus and commitment to solving complex issues through to completion
- Drive and Discipline - Operate in a fast-paced, dynamic environment with a focus on generating high-quality 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.
