Y & L Consulting Inc.

Title: Business Analyst Location: Austin TX (Hybrid Schedule) Duration: 4months + possible extension As a Technical Business Analyst, the candidate must align information technology systems with business operations by analyzing, recommending, and developing innovative reporting solutions. The candidate will work with Information Technology and Business resources to discover, analyze, and inventory legacy reports including but not limited to SAS(Statistical Analysis System) routines. The position requires the ability to clearly document and communicate processes/requirements to both Business and Technical resources. The Candidate duties include the following: • Coordinate and facilitate business stakeholder meetings to discover, analyze, inventory, document legacy reports including, but not limited, to SAS routines. • Collect and document requirements in organized manner • Assist in the evaluation of technical solutions and make recommendations based on sound...

Position: Data Modeler Contract Duration: 4 Weeks Task:  Assist the client with the build out of operational reports and dashboards. Duties:  Identifies business needs and develops data models that fit those needs Helps in defining databases and the physical, logical and conceptual levels involved Participates in improving business activities by using their knowledge of data flows to present and implement innovative data solutions Maintains the data models they create and defines data modeling and design standards Maintains data maps Identifies data modeling tools, relevant development techniques and standards for an organization Takes responsibility for the evaluation of existing data systems Develops best practices around data coding and standard naming conventions, making sure data models are consistent Evaluates databases and data models for inconsistencies and variances, ensuring data is represented correctly Troubleshoots and optimizes...

Title: Business Analyst Location: Austin TX Duration: 4 months + This position reports to the IT Manager, Outage Management Group under the Enterprise Applications Division. The role of this position is to provide lifecycle management and 24×7x365 support of highly complex, highly available, enterprise-wide applications and customer-facing applications and integrations; to apply expert skills and knowledge of relevant/related technologies and business operations; and to contribute to projects and ongoing operations. Identify problems, and learn specific input and output requirements, such as forms of data input, how data is to be summarized, and formats for reports. Writes detailed description of user needs, program functions, and steps required to develop or modify computer program. Reviews system capabilities, specifications, and scheduling limitations to determine if requested program or program change is possible within existing system WORKER SKILLS...

Job Title .NET Full Stack Developer Location Austin TX ( must be available for some onsite)     Duration 3 + months with the possibility of extension until 2024               The Candidate will perform highly advanced front-end and back-end development work as part of the Administrative Applications’ project team(s) with direction and guidance from Project Manager and Applications Services Management. The primary responsibility of this position is to work with Product Owners and internal/external stakeholders to create and maintain the Microsoft technology-based web applications. The Candidate will direct the back end and front-end design of new applications from conception to completion and work with the cross-functional team members involved with the development project. The Candidate must have strong analytical and problem-solving skills, hands-on technical experience with designing and implementing .NET core...

Job Title: Database Administrator Location: Austin TX Duration: 12months+ The DBA will work closely with different teams comprised of analysts, project managers, architects, and developers to gather Extract, Transform, Load (ETL) needs for the tolling data, and create needed ETLs between the databases. They will follow good practices and project guidelines in all cases including the use of source code control, automated testing and deployment approaches, test-case-based development, and proper documentation practices. The DBA will additionally work closely with the DBA 3 SAP SLT engineer, understanding SLT data flows pulling from SAP, and into SQL server. The DBA responsibilities include but are not limited to: Hands on Microsoft SQL server installation and configuration Development and management of ETL between SQL databases. Monitoring SQL databases storage and utilization Executes the procedures necessary to save, retrieve, and recover databases...

Title: Sr. Data Architect (GIS) Location: Austin TX ( 2 days onsite for locals and 100% remote for non-locals.) Duration: 12 months + The Sr. Data Architect will help build data warehouse strategy and components based on business requirement and in-depth analysis of intelligent roadway data, including intelligent traffic technology, and connected and automated vehicle data. Work with stakeholders to translate business requirements into technical specification, including data streams, integrations, transformations, data warehouses, and data marts. Provides guidelines on creating data models and various standards relating to governed data Assists in performing root cause analyses related to information issues and non-conformance to published data standards based on review of technical metadata of various source systems Lead the effort in managing intelligent roadway data architecture framework, standards, and principles, including modeling, metadata,...

Title: Data Analyst/Report Writer Location: Austin TX Duration: 100% Remote Data reporting analysts transform data into information that can be utilized to make business decisions and actions. Their work involves acquiring data from other sources, creating reports on a regular basis, correcting any code issues, and ensuring that databases remain error-free and organized. Projects include: Validate and transform Accountability System for Educator Preparation data found in Word, PDF, Excel, and PowerBI dashboards to confirm accuracy of historic data set. Write, Review, troubleshoot, and document PowerBI, SAS program code, and compiled reports to explore inconsistencies in data reporting on the Accountability System for Educator Preparation dashboards. Create and organize SharePoint folders, roles, and permissions for storing data and documents. Migrate and document data and other files. Gather, document, and use user requirements to migrate data for a...