Company:
Artech LLC
Location: Rancho Cordova
Closing Date: 21/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Description:
*Virtual with ability to be onsite 2 days per week.
Business Intelligence Developer/Database Administrator
We re in search of a BI Developer/Data Base Administrator to technically design and develop business intelligence database solutions supporting Tableau and Power BI analytics dashboards and reports. The individual will gain a strong understanding of business requirements, functional specification write-ups, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation. As a Database Administrator, you should have a demonstrated ability to manage and maintain SQL server databases, monitoring and troubleshooting batch jobs, access role management and support overall server management and patches.
Responsibilities:
" Partner closely with upstream application teams and developers to ensure data sources are accurate, available, and timely.
" Efficiently and accurately develop with complex SQL queries (stored procedures, views, and functions).
" Collaborate with front end business intelligence developers and analysts to test, clean, and standardize data to meet the business requirements.
" Responsible for detailed documentation of database structures, configurations, and procedures is essential for maintaining a well-managed database environment through functional specs and document repository.
" Designing the structure of new databases, including tables, relationships, and data integrity constraints, to ensure optimal performance and efficiency, including 3rd Normal Form i.e. normalization\denormalization as appropriate.
" Proactively monitor server, database, query performance.
" Fine tune query, database, server performance as needed.
" Make sure all access is provisioned through database roles and address instances not compliant.
" Regular database backup maintenance and retention according to backup and retention policy.
" Monitor agent jobs and troubleshoot when issues arise.
" Monitor SSIS package runs and first level of troubleshooting when issues arise in SSIS/SQL.
" Manage access through periodic audits and ensure users have correct access on the server.
" Have the confidence to work cross-functionally with various organizations including business stakeholders and technical partners to exchange ideas to meet business requirements.
" Must have excellent verbal communications skills and documentation skills to maintain work flows and query functionality.
" Adhere to Agile SCRUM methodology and processes.
Qualifications:
" Leverage SQL and SSIS for interacting with SQL server data models included but not limited to an understanding of data connectors and dimensional modeling, tables and queries.
" Experience working with large and complex data sets and able to write complex queries to create stored procedures, views, and functions.
" Empirical understanding of data systems (BI analytics, data blending, data warehousing, data ELT, etc.) on process automation and standardization.
" Experience working on a support team environment by documenting, researching, solving problems through service help desk ticketing system.
" Experience working directly with business analysts or business sponsors to gather and validate functional requirements and provide the design specifications.
" SQL server administration.
" SQL server - management, monitoring and performance tuning.
" Experience managing OLAP and OLTP databases.
" Create, manage and troubleshoot agent jobs.
" SSIS - create, maintain and troubleshoot packages.
" SQL - ability to query system and user databases, analyze query plans, propose and implement performance optimization through schema and query optimization, optimize indexes.
" Ability to work on multiple projects and flexibility to change priorities when needed.
" A 4-year degree in MIS (Management Information Systems), Information Technology or Computer Science.
" 5 years minimum experience as BI SQL Developer and/or a database administrator
*The individual will be 80% supporting BI development and 20% DBA critical activities.
*Virtual with ability to be onsite 2 days per week.
Business Intelligence Developer/Database Administrator
We re in search of a BI Developer/Data Base Administrator to technically design and develop business intelligence database solutions supporting Tableau and Power BI analytics dashboards and reports. The individual will gain a strong understanding of business requirements, functional specification write-ups, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation. As a Database Administrator, you should have a demonstrated ability to manage and maintain SQL server databases, monitoring and troubleshooting batch jobs, access role management and support overall server management and patches.
Responsibilities:
" Partner closely with upstream application teams and developers to ensure data sources are accurate, available, and timely.
" Efficiently and accurately develop with complex SQL queries (stored procedures, views, and functions).
" Collaborate with front end business intelligence developers and analysts to test, clean, and standardize data to meet the business requirements.
" Responsible for detailed documentation of database structures, configurations, and procedures is essential for maintaining a well-managed database environment through functional specs and document repository.
" Designing the structure of new databases, including tables, relationships, and data integrity constraints, to ensure optimal performance and efficiency, including 3rd Normal Form i.e. normalization\denormalization as appropriate.
" Proactively monitor server, database, query performance.
" Fine tune query, database, server performance as needed.
" Make sure all access is provisioned through database roles and address instances not compliant.
" Regular database backup maintenance and retention according to backup and retention policy.
" Monitor agent jobs and troubleshoot when issues arise.
" Monitor SSIS package runs and first level of troubleshooting when issues arise in SSIS/SQL.
" Manage access through periodic audits and ensure users have correct access on the server.
" Have the confidence to work cross-functionally with various organizations including business stakeholders and technical partners to exchange ideas to meet business requirements.
" Must have excellent verbal communications skills and documentation skills to maintain work flows and query functionality.
" Adhere to Agile SCRUM methodology and processes.
Qualifications:
" Leverage SQL and SSIS for interacting with SQL server data models included but not limited to an understanding of data connectors and dimensional modeling, tables and queries.
" Experience working with large and complex data sets and able to write complex queries to create stored procedures, views, and functions.
" Empirical understanding of data systems (BI analytics, data blending, data warehousing, data ELT, etc.) on process automation and standardization.
" Experience working on a support team environment by documenting, researching, solving problems through service help desk ticketing system.
" Experience working directly with business analysts or business sponsors to gather and validate functional requirements and provide the design specifications.
" SQL server administration.
" SQL server - management, monitoring and performance tuning.
" Experience managing OLAP and OLTP databases.
" Create, manage and troubleshoot agent jobs.
" SSIS - create, maintain and troubleshoot packages.
" SQL - ability to query system and user databases, analyze query plans, propose and implement performance optimization through schema and query optimization, optimize indexes.
" Ability to work on multiple projects and flexibility to change priorities when needed.
" A 4-year degree in MIS (Management Information Systems), Information Technology or Computer Science.
" 5 years minimum experience as BI SQL Developer and/or a database administrator
*The individual will be 80% supporting BI development and 20% DBA critical activities.
Share this job
Useful Links