General Purpose
GENERAL PURPOSE: Under minimal supervision, organizes and structures data for analytical or operational uses. Has expertise in building data pipelines to pull together information from different source systems, integrating, consolidating, cleansing data and structuring it for use in individual analytics applications. Has extensive experience in database technologies, cloud based platforms, ability to analyze business needs for data acquisition, data modeling, extract-transfer-load (ETL) processes, data analysis, report creation and implementation. Leverages pragmatic data management practices and principles to ensure the coherent and understandable storage and movement of data for the delivery of information to end users. Work complements the agency business and technical teams on many non-standard and unique business problems and uses creative problem solving to collect, organize and deliver useful reports and data insights.
This job posting may be used to fill multiple positions.
Essential Functions
ESSENTIAL FUNCTIONS:
The following duties ARE NOT intended to serve as a comprehensive list of all duties performed by all employees in this classification, only a representative summary of the primary duties and responsibilities. Incumbent(s) may not be required to perform all duties listed and may be required to perform additional, position-specific duties.
- Analyzes business data requirements and design strategies for the gathering, analyzing and storing of information for end users.
- Owns the design, development, and maintenance of ongoing data marts, metrics, reports, analyses, dashboards, etc. to drive key business decisions.
- Is proficient with writing complex SQL queries, stored procedures, ETL scripts, views, temporary tables, and other objects related to solving questions with data.
- Has expertise in data warehouse lifecycle development, dimensional data modelling, Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) modeling.
- Focuses on efficiency, scalability and performance tuning by partnering with Database Administrators (DBAs) so that applications, ad-hoc queries, reports and dashboards perform well and can be modified with ease.
- Analyzes, creates and maintains scripts to monitor and report on data quality and troubleshoot issues which may compromise the credibility of reports.
- Maintains and administers reporting platforms, including server and client tools, organizing reporting in portals and user security.
- Develops and maintains reports, graphs and visualizations, including a catalog of available reports, allowing users to easily find and understand information.
- Partners with the IT Enterprise Architect and other IT analysts to define and implement a sustainable data management practices.
- Works with business users to understand data and how to use the data to satisfy information needs.
- It is the responsibility of all employees to follow the Agency safety rules, regulations, and procedures pertaining to their assigned duties and responsibilities, which could include systems, operations, and/or other employees.
- It is the responsibility of all employees to integrate sustainability into everyday business practices.
- Other duties as assigned.
Minimum Qualifications
Education and Experience:
Bachelor's Degree in computer science, information technology, business administration, engineering, or closely related field and six years information technology and data analysis experience in a business intelligence environment; OR an equivalent combination of education and experience.
Required Licenses or Certifications:
None.
Required Knowledge Of:
- Principles and practices of computer science and information systems
- Principles and practices of technologies including, but are not limited to, MS Azure, MS SQL-Server, SSIS, SSRS, Crystal Reports, Power BI, Pyramid, Business Objects Enterprise, SharePoint, Excel, and any scripting languages such as PowerShell, Python, Java or C#.
- Data and information domains including those related to Operations, Finance, Enterprise Resource Planning, Asset Management, Transit Rider Technologies, and other subject areas as needed.
- Business intelligence, data management, data warehousing concepts, data modeling, reporting and related activities
- Methods and techniques for evaluating business requirements and developing information systems solutions
- Operational characteristics of a variety of computer and network systems, applications, hardware, software and peripheral equipment, including enterprise business systems
- IT best practices, including ITIL (Incident and Change Management)
- Principles, practices, methods and techniques used in the installation, troubleshooting and maintenance of systems and applications
- Quality Assurance techniques and practices
- Principles and practices of project management.
- English usage, spelling, grammar, and punctuation.
- Principles of business communication and basic report preparation.
- Principles of customer service.
Required Skill In:
- Utilizing personal computer software programs affecting assigned work and in compiling and preparing spreadsheets and reports.
- Experience with SQL, Microsoft Azure, SQL Server, Microsoft Analysis Services and/or Business Objects, Integration Services, Reporting tool (either of Reporting Services, Crystal Reports, Power BI, Pyramid, etc.)
- Logical and physical modeling for both OLTP and OLAP.
- Establishing and maintaining effective working relationships with other department staff, management, vendors, outside agencies, community groups and the general public.
- Experience using SharePoint for delivery of reports and information.
- Experience with large IT implementations, development life cycles, change management and IT processes.
- Working knowledge of Microsoft Office, with advanced skills in Excel as a data source and reporting tool.
- Creating and consuming various raw data formats such as CSV and XML.
- Experience in programming and/or scripting in languages such as PowerShell, PHP, Python, or Java including scripting to APIs or web services for data acquisition.
- Interpreting and administering policies and procedures sufficient to administer, discuss, resolve, and explain them to staff and other constituencies.
- Demonstrating a positive customer service orientation with both internal and external clients.
- Responding to general inquiries and in effective oral and written communication.
- Working cooperatively with other departments, Agency officials, and outside agencies.
Physical Demands/Work Environment
Physical Demands / Work Environment:
- Work is performed in a standard office environment.
- Subject to standing, walking, bending, reaching, stooping, and lifting of objects up to 40 pounds; may occasionally be exposed to dangerous machinery, extreme temperatures, and extreme noise when working in the data center environment or when working in the field.
- The Agency promotes a safe and healthy work environment and provides appropriate safety and equipment training for all personnel as required.
Sound Transit is an equal employment opportunity employer. No person is unlawfully excluded from employment action based on race, color, religion, national origin, sex (including gender identity, sexual orientation and pregnancy), age, genetic information, disability, veteran status or other protected class.