San Diego, CA
|
Software Engineering
|
Contract
|
$52 - $78 (hourly estimate)
{"JobID":309658,"JobType":["Contract"],"EmployerID":null,"Location":{"Latitude":-117.099181818182,"Longitude":33.0466363636364,"Distance":null},"State":"California","Zip":"92127","ReferenceID":"SCS-649320","PostedDate":"\/Date(1694088847000)\/","Description":"Insight Global is looking for a SQL Developer in the San Diego, CA area. This role entails providing technical support and expertise to the users, testing applications, maintaining software, and responding to customers. The mission of this position is to manage and support business critical data management and analytics platforms for their internal stakeholder and building the enterprise data foundation for operational and advanced analytics of their main product.In this position, you will be responsible for maintaining data management and analytics solutions in-line with technology updates, organizational demands, and user specifications. You will support a full range of environments and operational processes, identify areas of improvement, implemented, and release functional and technical updates, support performance optimization efforts, and provide technical support for customers\u0027 needs. You will also be encouraged to understand current trends in data management and analytics solutions and apply those concepts to the platforms and systems you manage.Responsibilities:-Works with business users to understand and translate user stories/requirements into data structures, models and reports-Works with BI team to implement the data management framework that improves the data quality and standards for both database structures and the warehouse repository;-Reviews, understands and documents the current operational processes and data sources to establish support for current and future reporting requirements; -Develops requirements for data mapping and ETL processes; -Assists with the development of the data model(s) for the data warehouse. -Provides recommendations for design and development of data strategies and innovative reporting solutions.-Performs analysis and design mapping data between source systems and the Enterprise Data Warehouse.-Analyzes data in source systems to assess data quality and makes recommendations for addressing within the source systems-45% operations-35% development-10% sprint meetings M/W/F-10% communication with stakeholders","Title":"BIA/SQL Developer","City":"San Diego","ExpirationDate":null,"PriorityOrder":0,"Requirements":"-7-10 years of experience in BI reporting environment-Extensive SQL programming knowledge-Strong knowledge of enhancing and maintaining ETL packages-Demonstrated understanding of system integrations and database structures-Proficient w/ stored procedures and SQL queries along with optimization to improve overall database performance-Proficient in full Microsoft Stack-Ability to analyze trends in data sets to identify new process improvements over time-Strong knowledge of database security best practices-Strong knowledge of complex SQL server replication troubleshooting-Business operations (manufacturing, logistics, service, master data, planning, etc.) experience -On-Prem experience","Skills":"-Visualization tools-SSIS-Familiarity with Power Query, Power BI-Hands on experience with data management and analytical tools like Denodo, SAP Business Objects, Microsoft Power BI, Tibco Spotfire","Industry":"Software Engineering","Country":"US","Division":"AF\u0026E","Office":null,"IsRemoteJob":false,"IsInternalJob":false,"ExtraValues":null,"__RecordIndex":0,"__OrdinalPosition":0,"__Timestamp":0,"Status":null,"ApplicantCount":0,"SubmittalCount":0,"ApplicationToHireRatio":0,"JobDuration":null,"SalaryHigh":78.0000,"SalaryLow":52.0000,"PayRateOvertime":0,"PayRateStraight":0,"Filled":0,"RemainingOpenings":0,"TotalOpenings":0,"Visa":null,"ClearanceType":null,"IsClearanceRequired":false,"IsHealthcare":false,"IsRemote":false,"EndClient":null,"JobCreatedDate":"\/Date(-62135578800000)\/","JobModifiedDate":"\/Date(-62135578800000)\/"}
Insight Global is looking for a SQL Developer in the San Diego, CA area. This role entails providing technical support and expertise to the users, testing applications, maintaining software, and... More responding to customers. The mission of this position is to manage and support business critical data management and analytics platforms for their internal stakeholder and building the enterprise data foundation for operational and advanced analytics of their main product.In this position, you will be responsible for maintaining data management and analytics solutions in-line with technology updates, organizational demands, and user specifications. You will support a full range of environments and operational processes, identify areas of improvement, implemented, and release functional and technical updates, support performance optimization efforts, and provide technical support for customers' needs. You will also be encouraged to understand current trends in data management and analytics solutions and apply those concepts to the platforms and systems you manage.Responsibilities:-Works with business users to understand and translate user stories/requirements into data structures, models and reports-Works with BI team to implement the data management framework that improves the data quality and standards for both database structures and the warehouse repository;-Reviews, understands and documents the current operational processes and data sources to establish support for current and future reporting requirements; -Develops requirements for data mapping and ETL processes; -Assists with the development of the data model(s) for the data warehouse. -Provides recommendations for design and development of data strategies and innovative reporting solutions.-Performs analysis and design mapping data between source systems and the Enterprise Data Warehouse.-Analyzes data in source systems to assess data quality and makes recommendations for addressing within the source systems-45% operations-35% development-10% sprint meetings M/W/F-10% communication with stakeholdersLess