This job offer is no longer available
About
Location: Rancho Cordova CA
SQL SSIS Python C# VB Script Data Maintenance Plans Supply Chain Fundamentals Building Data Pipelines (ETL) Maintaining & Monitoring SSIS Jobs Building Visualizations Tableau Power BI Data modeling
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
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.