What are the responsibilities and job description for the MS BI Developer position at V-Soft Consulting Group, Inc.?
Primary Location: Nashville, Tennessee
V-Soft Consulting is currently hiring for a MS BI Developer for our premier client in Nashville, Tennessee.
Education And Experience »
- Bachelor’s degree or equivalent education in computer science, math, or related science field required.
- 5 years proficiency in SQL Server/T-SQL language required.
- 5 years proficiency using Microsoft tools (SSIS, SSAS, BI reporting tools) required.
- 4 years’ experience as an ETL developer.
- 5 years of experience in business intelligence development area building data warehouses & data marts required.
- Work experience in the Fiscal/Finance industry is preferrable.
Knowledge, Skills And Abilities »
- Latest versions of Microsoft BI technologies (SSIS, SSAS, SSRS, PowerBI).
- Data warehousing (star schema, snowflake schema).
- Dimensional modeling.
- ETL processes.
- Data Analysis & troubleshooting.
- Analytical Thinking.
What You’ll Do
Job Responsibilities:
- Create database and schema objects to build the fiscal system from historical files.
- Automate the raw data collection from FTP client server sources (CSV, Excel etc. file).
- Set up FTP tasks for mail notifications and send mail task packages using SSIS.
- Create and automate ETL process using SSIS to load clean data into the system.
- Create and connect error reports (BI reporting tools) for the data submitters from the raw data files.
- Develops, configure and deploy SSIS packages. Implement event handlers and error handling notifications.
- Build OLAP cubes/DataMart for analytical reporting.
- Write complex queries to build joins and data logic for business definitions using T-SQL scripts.
- Build data relationships and create Dimension and Fact tables to maintain a consistent final output through calculated fields.
- Design/develop/optimize stored procedures for data warehouse tables.
- Perform testing, troubleshooting report issues and optimizing query performance.
Interested?
Qualified candidates should send their resumes to sbandi@vsoftconsulting.com
V-Soft Consulting Group is recognized among the top 100 fastest growing staffing companies in North America, V-Soft Consulting Group is headquartered in Louisville, KY with strategic locations in India, Canada and the U.S. V-Soft is known as an agile, innovative technology services company holding several awards and distinctions and has a wide variety of partnerships across diverse technology stacks.
As a valued V-Soft Consultant, you’re eligible for full benefits (Medical, Dental, Vision), a 401(k) plan, competitive compensation and more. V-Soft is partnered with numerous Fortune 500 companies, exceptionally positioned to advance your career growth.
V-Soft Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
For more information or to view all our open jobs, please visit www.vsoftconsulting.com or call (844) 425-8425.
