BradentonRecruiter Since 2001
the smart solution for Bradenton jobs

BI Technical Analyst

Company: Arthur J Gallagher & Co.
Location: Bradenton
Posted on: November 14, 2021

Job Description:

Description - External Gallagher is a global leader in insurance, risk management and consulting services. We help businesses grow, communities thrive and people prosper. We live a culture defined by The Gallagher Way, our set of shared values and guiding tenets. A culture driven by our people, over 30,000 strong, serving our clients with customized solutions that will protect them and fuel their futures. Position Summary: The BI Technical Analysts reports to the Application Development Manager of Affinity and will assume responsibility for BI data analysis, technical specifications, and reports within Affinity. The team develops enterprise caliber software applications/integrations on the Microsoft platform. The team is led by managers with software development backgrounds and strives to use modern practices and technologies to develop solutions the right way. There is a dynamic team environment that encourages collaboration among team members to make the whole team better. The technical analyst will be responsible for supporting processes and implementing process improvements, incumbent(s) are tasked with formulating and defining systems scope and objectives through research and fact-finding combined with an understanding of applicable business systems and industry requirements under general supervision. The technical analyst will be responsible for building and delivering reports that meet the business needs. Essential Duties and Responsibilities: * To analyze business problems in order to create accurate business case solutions for the BI team * Conduct requirement sessions with stakeholders regarding business problems * Engage with the business stakeholder to interpret and analyze results, and provide feasible solutions * Monitor and analyze operational data and reports to identify opportunities and improvement suggestions * Data analysis and effective presentation of results to stakeholders * Provide ongoing support where changes to solutions or fault-finding is necessary * To create accurate business requirements definitions * Design data warehouse flows and schemas based off analysis, including staging, fact, dimensions, cubes, and reporting models * To create user and training documentation * To create reports using Microsoft Power BI or other business tools. * To support the Microsoft Power BI technical needs for our business. * Under general direction, formulates and defines system scope and objectives * Works with users to support business applications, and investigate operational problems/system requirements * Devises or modifies procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results * Solves user inquiries that arise during day-to-day operation * Provides administrative and project support to the team * Participation in after-hours system related functions such as production support, conversions, upgrades, and implementations * Develops and maintains relationships with key stakeholders and technology staff, including offshore personnel, to ensure that communication is open and ongoing * Guides and advises less-experienced Business Analysts * Ensures compliance with IT Policy, Sarbanes-Oxley and SOC2 requirements Required: * Bachelor's degree in Computer Science, Information Technology, Engineering, Business, or related field * Enterprise report building and delivery, Microsoft Power BI preferred. * Knowledge of data analytics * Knowledge of BI tools and decision support concepts * 5 or more years related experience, including the following * Microsoft SQL Server 2016 and beyond * Relational database experience, including Microsoft SQL Server * Stored procedures, T-SQL, temp tables, transactions, database performance tuning * Experience with JIRA & Azure DevOps: repository (TFS/GIT), boards (track work), and pipelines (build solutions). * Experience with Microsoft Enterprise BI (SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Power BI) * Data warehouse concepts and design patterns including star schema and snowflake database design, ETL processing * Excellent verbal and written communication skills * Intermediate level proficiency with Microsoft Office Preferred: * Experience with Azure Synapse, Azure Data Explorer, Azure SQL Database, Azure Data Factory, Azure Logic Apps, and Azure Data Lake. * Experience with JSON, XML, YAML, and Datasets * Understanding of systems development and project delivery life cycles * Formal project management training or certification * Understanding of budgeting and financial management processes * Experience with Microsoft Visio and Project * Knowledge of Sarbanes Oxley requirements, SOC2 Work Traits: * Strong applications analysis and issue resolution (trouble shooting) skills * Strong user and client relationship management skills * Strong presentation skills * Excellent written and oral communications with ability to work effectively and provide feedback to senior level managers and vendors * Self-starter with strong work ethic and ability to excel in fast paced, high demand environment * Competent to work at the highest technical level of all phases of applications systems analysis and programming activities * Proven ability to independently manage tasks and priorities, accurately estimate work and meet deadlines * Commitment to quality and excellent customer service to end users * Demonstrated ability to prioritize and manage multiple tasks simultaneous U.S. Eligibility Requirements: * Interested candidates must submit an application and resume/CV online to be considered * Must be 18 years of age or older * Must be willing to submit to a background investigation; any offer of employment is conditioned upon the successful completion of a background investigation * Must have unrestricted work authorization to work in the United States. For U.S. employment opportunities, Gallagher hires U.S. citizens, permanent residents, asylees, refugees, and temporary residents. Temporary residence does not include those with non-immigrant work authorization (F, J, H or L visas), such as students in practical training status. Exceptions to these requirements will be determined based on shortage of qualified candidates with a particular skill. Gallagher will require proof of work authorization * Must be willing to execute Gallagher's Employee Agreement or Confidentiality and Non-Disclosure Agreement, which require, among other things, post-employment obligations relating to non-solicitation, confidentiality and non-disclosure Gallagher offers competitive salaries and benefits, including: medical/dental/vision plans, life and accident insurance, 401(K), employee stock purchase plan, educational expense reimbursement, employee assistance program, flexible work hours (availability varies by office and job function) training programs, matching gift program, and more. Gallagher believes that all persons are entitled to equal employment opportunity and does not discriminate against nor favor any applicant because of race, sex, color, disability, national origin, religion, creed, age, marital status, citizenship, veteran status, gender, gender identity / expression, actual or perceived sexual orientation, or any other protected characteristic. Equal employment opportunity will be extended in all aspects of the employer-employee relationship, including, but not limited to, recruitment, hiring, training, promotion, transfer, demotion, compensation, benefits, layoff, and termination. In addition, Gallagher will make reasonable accommodations to known physical or mental limitations of an otherwise qualified applicant with a disability, unless the accommodation would impose an undue hardship on the operation of our business. #LI-TG2 Additional Information

Keywords: Arthur J Gallagher & Co., Bradenton , BI Technical Analyst, IT / Software / Systems , Bradenton, Florida

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Florida jobs by following @recnetFL on Twitter!

Bradenton RSS job feeds