SUMMARY

The Business Data Analyst is responsible for maintaining the integrity, validity, and functionality of the respective data for the assigned business group.

The Data Analyst will lead and perform complex analysis in an evolving data environment. In addition to having very strong technical skills, this position will have outstanding business process analysis and interpersonal skills.

The ability to extract and analyze data, patterns, and related trends is needed, with the ability to summarize the data into useable information by leadership.

ESSENTIAL FUNCTIONS

• Maintains integrity of data in system and develops policies and procedures.
• Oversees the processing of all transactional data entry and the maintenance of all related tables to ensure the accuracy and consistency of all related record changes.
• Serves as a functional Liaison with Information Services in relation to system implementations, conversions, and upgrades.
• Assists in the development of business requirements and evaluation of software capabilities as a user in order to ensure the best design of business system solutions.
• Assists Information Systems as a functional user in the testing of system patches, tables, reports, and software upgrades.
• Extracts and analyzes data from various systems, such as for the Lawson, or other corporate business systems.
• Works with the business group to identify and scope new opportunities for data analysis applications to evaluate business performance and to support business decisions.
• Works internally and with the business group to define, secure and prepare data for modeling.
• Analyzes, identifies and assesses data attributes using statistical software packages and develops recommendations and processes to improve operational performance ensuring adherence to department policies and procedures.
• Performs strategic data and trend analysis and research to support business needs, as necessary.
• Explores data to identify opportunities to improve business results.
• Develops understanding of business processes, goals and strategies in order to provide analysis and interpretation to management.
• Develops and provides training to associates and provides technical assistance and support, as needed.
• Works closely with business stakeholders to identify and answer critical questions.
• Formulates and prepares ad-hoc and project-related business reports to respond to departmental reporting needs.
• Performs other duties as assigned.

DECISION MAKING

The incumbent works under general supervision.

MINIMUM REQUIREMENTS

• Bachelor's degree in Business Administration, Computer Science, Information Systems, or related field from an institution accredited by a nationally recognized accrediting agency.
• Three years' experience developing, analyzing and presenting reports and data.
• Proficient in the use of computer systems such as Excel, Access, PowerPoint, Visio, and Crystal Reports.

JOB DIMENSIONS

Contact with internal and external customers and vendors.

PHYSICAL DEMANDS AND WORKING CONDITIONS

Physical requirements include lifting up to 5 pounds occasionally. Subject to sitting and standing for long periods of time.

Requires visual acuity, speech and hearing. Working conditions are primarily in an office environment and performs occasional field visits.

May be required to work hours other than regular schedule on exception, such as nights, weekends, and holidays.

San Antonio Water System values the contributions of all its employees, providing them the best in compensation and benefits.

The benefits package is designed to attract and retain a workforce of qualified employees who share a responsibility in providing quality water to 1 million consumers.

From an affordable medical and dental plan to life-sustaining retirement and insurance plans, we offer benefits that reward employees for their commitment to a challenging career at SAWS.

Employee benefits include the following :

• Competitive, market-based salaries
• Performance-based incentives
• Medical benefits
• Dental benefits
• Life insurance
• Prescription drug program
• Vision care plan
• Two retirement plans
• Deferred compensation plans ( plan)
• Disability income
• Paid leave (vacation, sick, personal)
• Education assistance program
• Employee assistance program
• Flexible, tax-deferred health and dependent care spending accounts
• Wellness programs
• On-Site Fitness Facilities
• Community service opportunities

Closing Date / Time : 7 / 9 / 11 : 59 PM Central Base Pay 68, Job Address U.S. Hwy. N., San Antonio, Texas United States

Posting Details

Job Details

Description

The Data Analyst 2 is responsible for maintaining databases for the collection, analysis, and dissemination of operational data throughout the company.

This role is also responsible for entry, extraction, and complex ad-hoc reporting from various systems to support business objectives and the needs of the department.

Essential Functions :

• Models, promotes, reinforces, and rewards the consistent use of HOLT’s Values Based Leadership (VBL) tools, models, and processes to ensure alignment with our Vision, Values, and Mission
• Downloads data from multiple system and reporting databases, develops and disseminates reports to end users
• Responds to data requests from management and performs basic reporting
• Develops and executes complex reports and custom queries
• Prepares technical reports by collecting, analyzing, and summarizing information and trends from various systems
• Maintains databases for the collection, analysis, and dissemination of operational data throughout the company
• Entry, extraction, and ad-hoc reporting from various systems to support business objectives and the needs of the department
• Provides report training to applicable departments / roles
• Creates and provides opportunity and market share reports and analysis using all applicable business reporting databases
• Informs marketing strategy by analyzing marketing campaign effectiveness and ROI, sharing insights about response rates across channels and audiences with Marketing Managers
• Perform analysis and creates insight that inform sales and marketing decisions in operations, sales, marketing, and support groups
• Works safely always and adheres to all applicable safety policies; complies with all company policies, procedures, and standards
• Performs other duties as assigned

Education and Experience :

• High school diploma or equivalent required; BA / BS, Business or Data emphasis preferred
• Minimum of three years of work-related experience required

Knowledge, Skills, and Abilities :

• Strong knowledge of data analytics and applicable reporting tools
• Excellent verbal, written, communication and presentation skills
• Strong analytical and database management skills
• Ability to work on multiple projects and deal effectively with employees and management
• Strong working knowledge and / or experience including but not limited to DBS, Tableau, Alteryx, WMS, Microsoft Word, Excel, PowerPoint, Salesforce, MS Dynamics and Outlook
• Ability to think logically for interpreting and analyzing problems assigned or encountered
• Ability to identify problems and to review related information to develop and evaluate options and implement solutions
• Ability to work independently as well as a part of a diversified team
• Consulting and influencing abilities
• Ability to speak effectively before groups of customers or employees
• Excellent interpersonal and customer service skills
• Creative ability to understand the implications of new information for both current and future problem-solving and decision-making
• Ability to train and motivate others

Supervisory Responsibilities : None

Travel : Up to 15%

Qualifications

Skills

Behaviors

Motivations

Education

Experience

Licenses & Certifications

Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Summary

The Data Analyst plays an important role on the Data Team, reporting and the creation and maintenance of data-driven insights that help our organization make better decisions.

We're looking to add a detail-oriented, methodical, and collaborative team player to our team of driven professionals. This is a telecommuting position requiring a permanent home office.

Job Duties and Responsibilities :

• Managing the Salesforce Portal for any backend issues
• Fixing connectivity issues between apps / programs and Salesforce, as they arise
• Updating or adding custom fields and automation within Salesforce as necessary
• Improving our Salesforce dashboard and reports
• Develop or refine the processes used by different teams within the company to ensure that they're working efficiently and producing high-quality results.
• Writing reports and presentations that present data and findings in a clear and concise manner
• Advocating for business intelligence solutions that will help the organization meet its goals
• Analyzing data to identify patterns or trends that could indicate problems within the business
• Working with senior management to develop goals, objectives, and strategies for improving business performance
• Developing reports that monitor key business metrics such as customer satisfaction levels
• Engage with internal stakeholders / head of departments to ensure reporting needs are met
• Oversee reporting to funders and stakeholders Create, run, and distribute periodic reports
• Use various tools to perform Ad Hoc analysis
• Aggregate, clean, and structure data from various sources
• Take ownership of data quality to ensure validity and reliability of reporting
• Document structures and types of business data

Skills and Qualifications :

Data Analysis : Use data analysis skills to review and interpret data from a variety of sources, including large data sets, to identify useful information for our organization.

Also use data analysis to identify areas where our organization can improve and make data-driven decisions.

Communication : Data Analyst will communicate with a variety of individuals and groups, including other managers, employees, and other stakeholders.

Effective communication is crucial to the success of a business intelligence team, as it allows the team to work together to develop strategies and solutions.

It also allows the Data Analyst to provide feedback and guidance to the team.

• Critical thinking : Critical thinking is the ability to analyze a situation and determine the best course of action. This role will use critical thinking skills to make decisions about the data they collect, the methods they use to collect it and the ways they present the data.
• Problem-solving : This role will work with other managers and executives to identify business challenges and develop solutions.
• Project management : Responsible for overseeing the implementation of a business intelligence project. This can include tasks such as creating a project plan, assigning tasks to team members, monitoring the project's progress, and evaluating its success.
• Salesforce Admin, SQL Server, Excel + VBA, Power BI experience needed
• Expert Excel skills, with a strong understanding of pivot tables, functions, and filters
• Knowledge of relation databases

Required :

• 2 years of hands-on experience with Salesforce
• Bachelor's degree computer science or mathematics
• Project Management experience

Preferred :

• 2 years of experience in reporting
• 2 to 5 years of experience in programming and SQL
• 2 to 5 years of experience in a data analyst or similar role
• Knowledge of advanced statistical methods

About Us :

BALANCE is a nationwide non-profit organization committed to helping individuals and families overcome their financial challenges and meet their goals.

Through local and national education and counseling programs we provide help and hope to families overwhelmed by debt, facing foreclosure, struggling to master their money, caught in a cycle of over-priced fringe financial services, or trying to purchase their first home.

Additional information about us can be found at .

BALANCE offers a fun and collaborative environment with exceptional benefits for our employees which include medical, dental, vision, and life insurance;

403(b) retirement plan, 3 weeks paid time off, plus paid federal holidays, an extensive training program, and more!

BALANCE is an Equal Opportunity Employer. This organization participates in E-Verify. Please no phone-calls.

Position Summary :

The Technology Division has an opening for a Data Analyst. We are currently in the process of introducing more automated and scalable solutions in order to realize new efficiencies and create a better competitive edge.

As a Data Analyst you will work supporting the Business Services’ request for report and data extract using MS-SQL. As well as assist with creating and maintaining automated processes.

You will work for an exciting and fun company with an opportunity for professional growth. We are looking for team players, but also for individuals accountable to finishing out their tasks without constant supervision.

Essential Functions and Responsibilities :

• Establish and maintain automated client data processes
• Create reports for internal teams and / or external clients
• Automate existing query and report generation tasks
• Develop, implement and optimize stored procedures and functions
• Analyze existing SQL queries for performance improvements
• Assist in projects as needed to provide data sources and services
• Review and interpret ongoing business report requirements
• Establish and maintain data integrity best practices company-wide

Position Requirements :

• At least 2+ years demonstrated experience designing and deploying SQL based solutions
• In-depth knowledge of Microsoft SQL Server versions 2008R2 / 2012 / 2014 / 2016
• Strong relational database development and design skills
• Excellent command of T-SQL and joining of complex data sets
• Ability to design, develop, and document complex technical solutions related to data management
• Knowledge of Extract, Transform and Load (ETL) frameworks
• Experience reviewing query performance and optimizing stored procedures
• Demonstrated ability to manage multiple projects at once and ensure actionable outcomes
• Strong attention to detail and self-management skills
• Critical thinker and problem-solving skills
• Strong verbal and written English communication skills
• SQL Server Integration Services (SSIS) experience a major plus
• SQL Server Reporting Services (SSRS) experience a plus, but not required
• Must be highly self-motivated, ambitious, flexible, and high-energy
• Ability to work well in a team, debate ideas and make the case for well thought out opinions while listening and appreciating the opinions of peers

What We Bring To the Table

comprehensive benefit packages

We recognize that talented people are attracted to companies that provide competitive pay, comprehensive benefit packages, and outstanding advancement opportunities.

For this reason, we offer a comprehensive benefits plan which includes the following :

• Competitive overall compensation package
• Career enhancement and growth opportunities
• 401(k) match and company profit sharing plan
• Medical, dental, and vision coverage
• Life / AD&D insurance
• Accident / critical illness insurance
• FSA and HSA accounts
• Competitive paid time off
• Professional development / tuition funds
• Continuing education and career certification
• Employee engagement activities
• Service recognition awards
• Discount fitness memberships
• Work / life resources

Roles & Responsibilities

Job Description :

Main Responsibilities

• Performing a manual review of all invoices in multiple ERPs to locate data information
• Maintaining a detailed and organized tracker to ensure data information is appropriately documented
• Adhering to best data management practices and maintaining a high standard of accuracy and efficiency

Experience Required

Preferred Experience :

Data capture or analysis experience

Skills & Certifications

Knowledge / Skills :

• Exceptional organizational skills, a keen eye for detail, and the ability to spot errors with accuracy and efficiency.
• Good communication skills and the ability to collaborate with staff members.
• Solid time management skills and the ability to prioritize tasks.
• Ability to take ownership, think independently and perform tasks with minimal supervision
• Working knowledge of Microsoft Office - Advanced excel proficiency with a specific focus on Excel formulas, conditional formatting, and data visualization required

Eligibilities & qualifications

Required Education

• High School Diploma or Equivalent