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
