Experience: Minimum 5+ years of experience.
Key responsibilities and accountabilities:
- Write optimized queries views triggers for integration & interface design tables, views. Perform SQL database sharing indexing procedure.
- Connecting to data sources, importing data, and transforming data for Business Intelligence.
- MS SQL database design, database security, database management.
- Ongoing development and optimization of our systems
- Design, implementation and maintenance of database software modules.
- Design methodology and project documentation creation.
- Properly understand business requirements and develop data views/models accordingly.
- Understand business requirements to set functional specifications for reporting applications.
Required Qualifications, Skills and Certifications:
- Any University and/or post-University degrees.
- Relevant experience MS SQL Azure.
- Proficiency in SQL & DBMS.
- Exp in database design principles.
- Good at data backup recovery security integrity SQL tuning
- Experience reviewing and documenting Technical & Business Requirements in relation to Business Intelligence, Data Management or software development projects.
- Experience in developing and managing stored procedures.
- Proficiency in Data Modeling and Dimensional Analysis. Liaison effectively between Business Analysts, Developers, Systems Support and Customers/Stakeholders with a reputation for timely resolution of issues and a drive for business results.
- Experience performing Data cleaning and Data Quality control activities.
- Advanced Execution Plan understanding.
- Ability to create relationships between different tables from different data sources.
- Excellent communication, interpersonal, problem solving, and analytical skills.
- Ability to work in groups as well as individually with minimum supervision.
- Excellent verbal and written communication skills is highly preferred for this role.
Good to have:
- Excellent in analytical thinking for translating data into informative visuals and reports.
- Should have knowledge and skills for secondary tools such as Power BI, SQL data warehouse, Visual Studio, etc.
To apply for this job email your details to jobs@mobileaspects.com
