Grant Thornton LLP Phoenix , AZ 85002
Grant Thornton is seeking a Senior Associate to join its Technology Strategy & Management service line and take an active role in engagement execution, project management and key business development activities.
Grant Thornton Public Sector helps executives and managers at all levels of government maximize their performance and efficiency in the face of ever tightening budgets and increased demand for services. We give clients creative, cost-effective solutions that enhance their acquisition, financial, human capital, information technology, data analytics, and performance management. For more information, visit grantthornton.com/publicsector.
At Grant Thornton, our professional staff applies traditional, cutting-edge approaches and methods to a variety of analyses. As part of our team, the Senior Associate will utilize various methodologies and models to execute client projects.
Innovate, design, develop and test Transact SQL queries, stored procedures, functions and views, following best practices and standards for a N-Tier high availability environment.
Experience providing SQL Server Operation Support
Experience building SSIS packages
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
Proficiency managing and analyzing databases with Microsoft SQL Management Studio
Provide technical expertise and insight to ensure successful completion of complex projects
Follow industry practices of analysis, design, development, testing, deployment and maintenance/production support of COTS and custom databases and applications
Work independently to develop solutions for complex business and technical problems
Interact effectively and professionally (at all technical levels) in a team setting with co-workers, leadership, stakeholders and business staff.
Communicate clearly and effectively, verbally and in writing, with peers, leadership, stakeholders and vendors
Learn and understand business practices and processes to the extent needed to improve business outcomes through innovative data solutions
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
Complete special projects and other duties as assigned
Experience using MS SQL Server, T-SQL, Business Intelligence, SQL Management Studio, SQL Reporting Services, SQL Integration Services and SQL Analysis Services
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.
Meet or exceed targeted billing hours (utilization).
Assist with business development activities, such as proposals, capture, account teams, whitepapers, conferences, and/or other thought leadership materials.
Developing database applications end-to-end
SSIS to perform integration and workflows
SSRS for reporting and BI
Transforming raw data into meaningful and useful information for business analysis purposes
Normalized databases in a relational design
SQL, SSIS packages
C# and current .NET Frameworks
Microsoft Entity Framework
Visual Studio 2013/2015, TFS 2013/2015
SQL Server 2008-2016
Bachelor's Degree required from an accredited college or university in a related field.
Ability to obtain and maintain certain job-related certifications if no job-related advanced degrees.
U.S. citizenship may be required. Ability to work in the United States indefinitely required.
Travel may be required.
Ability to work overtime required on occasion.
Ability to sit in an office environment for long periods of time.
Ability to obtain and maintain a security clearance.
Ability to communicate clearly in writing and verbally.
Ability to obtain and maintain firm independence and abide by firm ethics requirements.
Meet or exceed continuing professional education (CPE) requirements.
Grant Thornton LLP is the U.S. member firm of Grant Thornton International, one of the six global accounting, tax and business advisory organizations. Grant Thornton's Public Sector, based in Alexandria, VA, is a global management consulting business with the mission of providing responsive and innovative financial, performance management and systems solutions to governments and international organizations. Visit Grant Thornton's Public Sector at www.grantthornton.com/publicsector.
It is Grant Thornton's policy to promote equal employment opportunities. All personnel decisions, including, but not limited to, recruiting, hiring, training, promotion, compensation, benefits and termination, are made without regard to race, creed, color, religion, national origin, sex, age, marital status, sexual orientation, gender identity, citizenship status, veteran status, disability, or any other characteristic protected by applicable federal, state, or local law.