Business Intelligence Developer/Database Administrator
Business Intelligence Developer/Database Administrator
Cube Hub Inc.
Rancho Cordova, CA
See who Cube Hub Inc. has hired for this role
Job Role: Business Intelligence Developer/Database Administrator
Job Location: Rancho Cordova, California
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
Job Location: Rancho Cordova, California
- Virtual with ability to be onsite 2 days per week.
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.
- 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.
-
Seniority level
Mid-Senior level -
Employment type
Contract -
Job function
Information Technology -
Industries
Staffing and Recruiting
Referrals increase your chances of interviewing at Cube Hub Inc. by 2x
See who you knowGet notified about new Business Intelligence Developer jobs in Rancho Cordova, CA.
Sign in to create job alertSimilar jobs
People also viewed
-
Urgent requirement of Power BI Developer / Lead & Architect @ 100% Remote (Full Time Only)
Urgent requirement of Power BI Developer / Lead & Architect @ 100% Remote (Full Time Only)
-
Business Intelligence Developer/Database Administrator
Business Intelligence Developer/Database Administrator
-
Senior Power BI Developer _ Pittsburgh, PA
Senior Power BI Developer _ Pittsburgh, PA
-
BI Developer / Analyst
BI Developer / Analyst
-
Business Intelligence Reporting Analyst/Developer
Business Intelligence Reporting Analyst/Developer
-
Tableau Developer - No C2C candidates
Tableau Developer - No C2C candidates
-
Urgent Role - Sr ETL developer || Boston, MA || USC, GC
Urgent Role - Sr ETL developer || Boston, MA || USC, GC
-
Business Intelligence Developer (Construction Software)
Business Intelligence Developer (Construction Software)
-
Power BI Developer - Remote / Telecommute
Power BI Developer - Remote / Telecommute
-
Power BI Software Developer
Power BI Software Developer
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub