Job Description :
This is a 6 month contract to hire for Maricopa County''s Treasurer''s Office. Ideal candidate will have the technical skills below, along with fantastic communication skills, as they will be working on a team of 6 developers, and speaking with internal County customers. POSITION OVERVIEW The purpose of this position is to be a technical leader, responsible for adhering to and enforcing database standards and methodologies, thoroughness, accuracy, and solving complex problems related to the delivery of solutions that improve business capability and efficiency. ESSENTIAL JOB TASKS (This is not an all-inclusive list of all job duties that may be required; employees will be required to perform other related duties as assigned. List in order of importance) • Innovate, design, develop and test Transact SQL queries and stored procedures, follow best practices and standards for a team environment • Demonstrated proficiency developing SSIS packages of high complexity NET) and scope while adhering to documented development standards • Demonstrated proficiency building data analysis solutions (SSAS, data warehouse, data mart, ETL, Reports) • Demonstrated proficiency with SSRS configuration, security, subscriptions and reporting building • Responsible for design of database components (objects, tables, views, functions), providing time estimates, and required documentation • Proficiency managing and analyzing databases with Microsoft SQL Management Studio • Coordinate with other team members to brainstorm and create new processes for data integration and data quality remediation to use in day-to-day operations • Communicate clearly and effectively, verbally and in writing with peers, management and stakeholders Skills Required Specialized training, certifications, and/or other special requirements: Experience using MS SQL Server, T-SQL, Business Intelligence, SQL Integration Studio and SQL Reporting Services Knowledge, skills, and abilities: In-depth knowledge of the complete software development lifecycle using different methodologies and frameworks (e.g. Agile, Waterfall, and SCRUM Strong experience with database diagramming concepts, theory and practices. Ability to convert software requirements and functional specifications into complete working solutions. Ability to develop analysis reports and queries from structured and unstructured sources. Ability to conduct data-driven experiments, to interpret data, and to create innovative data-based products and services. Ability to prioritize and problem-solve complex enterprise applications. Must have strong planning, organizational and analytical skills. Ability to lead database application development projects while communicating well both verbally and in writing. Skills Preferred Preferred training, certifications and/or other special requirements: • Experience with developing database applications end-to-end. • Experience with using SSIS to perform integration and workflows • Experience obtaining and transforming raw data into meaningful and useful information for business analysis purposes • Experience with developing and implementing normalized databases in a relational design. Preferred education and/or experience: • Experience with SQL Server 2008-2016 • Experience with SQL Server Analysis Services (SSAS) • Experience with SQL Server Integration Services (SSIS) • Experience with C# and current .NET Frameworks • Experience with N-tiered architecture • Experience with Microsoft Entity Framework • Experience with Unit testing experience • Experience with Visual Studio 2013/2015, TFS 2013/2015 and SharePoint Experience Required Specialized training, certifications, and/or other special requirements: Experience using MS SQL Server, T-SQL, Business Intelligence, SQL Integration Studio and SQL Reporting Services Knowledge, skills, and abilities: In-depth knowledge of the complete software development lifecycle using different methodologies and frameworks (e.g. Agile, Waterfall, and SCRUM Strong experience with database diagramming concepts, theory and practices. Ability to convert software requirements and functional specifications into complete working solutions. Ability to develop analysis reports and queries from structured and unstructured sources. Ability to conduct data-driven experiments, to interpret data, and to create innovative data-based products and services. Ability to prioritize and problem-solve complex enterprise applications. Must have strong planning, organizational and analytical skills. Ability to lead database application development projects while communicating well both verbally and in writing. Experience Preferred Preferred training, certifications and/or other special requirements: • Experience with developing database applications end-to-end. • Experience with using SSIS to perform integration and workflows • Experience obtaining and transforming raw data into meaningful and useful information for business analysis purposes • Experience with developing and implementing normalized databases in a relational design. Preferred education and/or experience: • Experience with SQL Server 2008-2016 • Experience with SQL Server Analysis Services (SSAS) • Experience with SQL Server Integration Services (SSIS) • Experience with C# and current .NET Frameworks • Experience with N-tiered architecture • Experience with Microsoft Entity Framework • Experience with Unit testing experience • Experience with Visual Studio 2013/2015, TFS 2013/2015 and SharePoint Education Required Bachelor Degree in Computer Science, Information Systems or a related field and five (5) years software development experience in a relational database environment.