Company Description Insightsoftware is a growing, dynamic software company that helps businesses achieve greater levels of financial intelligence across their organization with our world-class financial reporting solutions. At Insightsoftware, you will learn and grow in a fast-paced, supportive environment that will take your career to the next level. We are looking for future Insighters who can demonstrate teamwork, results orientation, a growth mindset, disciplined execution, and a winning attitude to join our growing team.
Job Description 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, and end users to create, model, and deploy data analytics and reporting applications.
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 and tabular models. Interface with customers to gather technical requirements. Understand customer's data flows and reporting processes around budgeting and planning processes. Conduct information-gathering sessions with customers. 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 applications. Set up, configure, and test components of customer solutions. Integrate products with customers' ERP systems and other data sources under direction. Assist with 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-week onboarding program in report authoring. Shadowing/Assuming a role of a Senior developer on the first project under the guidance of the lead architect. Coming up to a target billable utilization ratio in 5 months. Be able to conduct meetings with customers in the 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 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 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. Additional Information Ideal candidate should exhibit the following traits:
Communication - Communicate effectively with customers and internal cross-functional partners, creating promoters at every touchpoint. 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. 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.
#J-18808-Ljbffr