The Role
Design and develop MicroStrategy and Tableau dashboards, integrate and model data (star schemas) from multiple sources, build ETL/scripts, optimize dimensional models for performance, implement security/section access, create complex expressions and visualizations, and support production BI environments in a life sciences pharma context.
Summary Generated by Built In
Company Description
Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.
Job Description:-
- Microstrategy, Tableau Dashboard Design & Development
- Good knowledge of SQL, relational databases and Dimensional Modeling - star schemas
- Advanced scripting and ETL, data modeling (star schema)
- Working with large data sets & Experience with complex data models involving more than 10 tables
- Integrating data from multiple data sources into a Microstrategy, Tableau Data Model.
- Use of complex Microstrategy, Tableau functions and developing most optimal scripts for a given solution
- Optimization of Dimensional data model for performance
- Must have developed enterprise applications for use in production environments, should have experience in Section Access, Security Authentication & Authorization, Dynamic reduction, etc
- Front-end design and Visualization best practices
- Intimate familiarity Set Analysis & all charts and graphs to determine best one to use for a given business situation
- Creating complex expressions for dynamic aggregation
- Actions and triggers, Document Chaining & linking experience
- Publisher and Server knowledge preferred
- Hands-on development mentality, with a willingness to troubleshoot and solve complex problems
- Ability to work in team in diverse/ multiple stakeholder environment
- Strong analytical skills
- Experience and desire to work in a Global delivery environment
- Experience in Life sciences pharma domain
Qualifications
Basic Qualifications :-
- Bachelor’s degree or foreign equivalent required. Will also consider one year of relevant work experience in lieu of every year of education
- At least 4 years of experience with DW/BI & Reporting tools such as Microstrategy, Tableau etc.
- At least 2 years of hands on experience in Design, Development & Build activities in Microstrategy, Tableau Projects - MUST
- At least 4 years of experience in Project life cycle activities on DW/BI development and maintenance projects
Note:-
This is a Full-Time & Permanent job opportunity for you.
Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
No OPT-EAD, H1B & TN candidates please.
Please mention your Visa Status in your email or resume.
Skills Required
- MicroStrategy and Tableau dashboard design and development experience
- Strong SQL and relational database knowledge
- Dimensional modeling and star schema design
- Advanced scripting and ETL experience
- Experience working with large data sets and complex data models (10+ tables)
- Integrating data from multiple data sources into BI data models
- Developing optimal MicroStrategy/Tableau functions and scripts
- Performance optimization of dimensional data models
- Production enterprise application development experience; familiarity with Section Access, security authentication and authorization, dynamic reduction
- Front-end design and visualization best practices
- Familiarity with Set Analysis and chart selection for business use cases
- Ability to create complex expressions for dynamic aggregation
- Experience with actions, triggers, document chaining and linking
- Publisher and Server knowledge
- Hands-on development mentality and troubleshooting skills
- Ability to work in cross-functional teams with multiple stakeholders
- Strong analytical skills
- Experience working in a global delivery environment
- Experience in the life sciences / pharma domain
- Bachelor's degree or equivalent (with possible substitution of relevant experience)
- At least 4 years experience with DW/BI and reporting tools (MicroStrategy, Tableau, etc.)
- At least 2 years hands-on design, development and build experience in MicroStrategy/Tableau projects
- At least 4 years experience in DW/BI project lifecycle activities and maintenance
- Must be US Citizen, Green Card Holder, GC-EAD, H4-EAD or L2-EAD
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.
