SQL BI Developer

Title – SQL BI Developer Location - Sacramento, CA Duration –  12 Months

Job description: AgreeYa is a global Systems Integrator and seeking a SQL BI Developer.

Overview:
At least five (5) years of experience working as a reports developer creating and fine-tuning SQL reports from data stored in various relational databases. This experience must include experience designing robust Logical Data Models and stewarding the data design of the solution and ensuring alignment with the larger roadmap goals.

Minimum Technical Qualifications:

• At least five (5) years of experience working as a reports developer creating and fine-tuning SQL reports from data stored in various relational databases. This experience must include experience designing robust Logical Data Models and stewarding the data design of the solution and ensuring alignment with the larger roadmap goals.
• At least five (5) years of experience designing, developing, debugging, and supporting complex data integration interfaces and processes (including stored procedures, triggers, tables, user defined functions, views, indexes, relational database models) using various tools and technologies including SSIS, SSAS, SSRS, T-SQL and SQL Server technology. This experience must include full time experience in developing ETL scripts and writing code from data model, dataflow diagram and technical design specifications.
• At least five (5) years of experience demonstrating understanding of Software Development Life Cycle (SDLC) methodologies specific to requirements elicitation and analysis, participating in joint application design sessions with the business users to analyze existing or future business processes, preparing business process workflows, business use cases, logical data models, and user interface design for reports and associated functionality.
• At least five (5) years of experience working with Microsoft products/tools such as Power BI, SQL Server versions 2008, 2012 and 2016, SQL Server Reporting Services, etc. This experience should include monitoring the performance of reports and taking corrective action to optimize or improve the performance of the reports when necessary.

Desirable Technical Qualifications:

• Experience developing SQL Reports as part of the data integration solution for a Pension Administration System or a large State of California system.
• Three (3) or more years of experience working with requirement elicitation methodologies, documenting business use cases, business rules, functional and nonfunctional requirements.
• Experience in the field of Data Integration, Data Conversion, and ETL.
• Experience with source code management software, such as Team Foundation Server (TFS).
• Experience producing and assisting in the creation of the following documents: Reports Specification document, data dictionary, reporting tool/platform architecture, test scenarios and test cases for reports testing, etc.
• Three (3) or more years of experience using Test Application Lifecycle Management tools such as Client ALM, or Jama to map functional and non-functional requirements, design specifications to test cases and defects, and provide full traceability for projects.
• Strong understanding of SQL Server Replication Services and experienced in setting up replication between a single source and multiple targets.

About Us: AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,850 staff across offices. AgreeYa works with 500 organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at Agreeya for more information.   AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website to learn about our Career & Culture.