Email Alert for
ⓘ There was an unexpected error processing your request.
Please refresh the page and try again.
If the problem persists, please contact us with your issue.
You can always manage your preferences and update your interests to ensure you receive the most relevant opportunities.
Get ready to discover your next great opportunity.
LanceSoft
West Sacramento, CA, United States
BACKGROUND CalSTRS is currently pursuing multiple initiatives and efforts in support of its strategic goal of Digital Transformation. These efforts include the implementation of Business Intelligence and Data Warehouse capabilities. CalSTRS Business Intelligence and Data Warehouse Project needs a Business Intelligence (BI) Developer who has the fun
Job Source: LanceSoftPowerSchool Group
Folsom, CA, United States
Overview As a Business Intelligence Developer , you will play a crucial role in driving data-driven decision-making within our organization. You will be responsible for designing, developing, and maintaining business intelligence solutions that empower stakeholders to extract actionable insights from complex datasets. Your primary focus will be o
Job Source: PowerSchool GroupWest Advanced Technologies
West Sacramento, CA, United States
Position: Business Intelligence Developer Location :West Sacramento, CA Duration: 24 months Mandatory Qualifications: At least 5 years of experience of developing data model and data reports in PowerBI. At least 5 years of experience of creating SQL queries, optimizing SQL query performance, and modifying SQL elements such as procedure, function
Job Source: West Advanced TechnologiesDCI Donor Services
West Sacramento, CA, United States
DCI Donor Services (DCIDS) is looking for a dynamic and enthusiastic team member to join us to save lives!! Our mission at DCIDS is to save lives through organ and tissue donation and we want professionals on our team that will embrace this important work!! We are currently searching for a Business Intelligence Report Developer. This role will crea
Job Source: DCI Donor ServicesState of California
Sacramento, CA, United States
If you have a passion to be a part of a team that works to serve, aid and protect needy and vulnerable children and adults in ways that strengthen and preserve families then is this is the place for you! The Information Systems Division works in collaboration with programs and county agencies, to provide solutions to systems that assist families a
Job Source: State of CaliforniaJobRialto
Rancho Cordova, CA, United States
Description: 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, q
Job Source: JobRialtoAkraya
Rancho Cordova, CA, United States
Primary Skills: SQL, SSIS, Tableau, Power BI, Database Management Contract Type: W2 Duration: 12 Months Location: Rancho Cordova, CA - 95670 (2 Days Hybrid) Pay Range: $60.00 - $65.00 per hour W2 NOTE: Role open to Women Back to Work candidates with a career gap Work for a market leader! JOB RESPONSIBILITIES: We are seeking a versatile Business Int
Job Source: AkrayaAutoZone
Elk Grove, CA, United States
ALLDATA is the industry’s #1 choice for unedited OEM automotive repair and collision information. Founded in 1986, the Elk Grove, California-based company has more than 115,000 subscribers worldwide who rely on us for access to the OEM-accurate information and procedures they need for safe and accurate repairs. More than 400,000 technicians trust A
Job Source: AutoZoneRancho Cordova, CA, United States
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.
So, what's next!
Are you already imagining yourself joining our team? Good, because we can't wait to hear from you.
Connect for more details : [email protected]
Email Alert for Business Intelligence Developer/Database Administrator jobs in Rancho Cordova, CA, United States
ⓘ There was an unexpected error processing your request.
Please refresh the page and try again.
If the problem persists, please contact us with your issue.
You can always manage your preferences and update your interests to ensure you receive the most relevant opportunities.
Get ready to discover your next great opportunity.