Vacancy expired!
Description Job Title: Data Management Admin Specialist(Data Scientist) Level 1-4
Deadline: Open Until Filled Salary: Level 1: $67,449.00 - $94,428.60 Level 2: $72,119.00 - $100,966.43 Level 3: $76,088.00 - $106,523.03 Level 4: $82,781.00 - $115,893.75 Hay Points: Level 1: 282 Level 2: 342 Level 3: 393 Level 4: 479 Dept./Div : MTA IT/ Office of IT Information Data Warehouse Agency : MTA Headquarters Location: 2 Broadway Hours: 9.00am - 5:30pm(7.5 hours /day) or as required Reports To: Deputy Chief Info Data Warehouse This position is eligible for telework which is currently two days per week. New hires are eligible to apply 30 days after their effective date of hire.In order to protect our employees and continue to provide safe and reliable service to our communities, as of November 14, 2021 we are requiring all new MTA hires to be fully vaccinated against COVID-19 prior to their start date. MTA will consider exceptions for religious and medical reasons, where appropriate. "Fully vaccinated" means you must have both doses of a 2-dose vaccine and two weeks have elapsed since the second dose, or have received 1 dose of a 1-dose vaccine and two weeks have elapsed since the dose. Proof of your vaccination status in the form of a CDC vaccine card must be submitted prior to your start date.The selected candidate will perform information technology functions related to deep data research and analysis, establishes the workflow and stages that prepare, process and deliver predictions and inferences. Level 1- Work with data engineers to process, cleanse, and verify the integrity of data used for analysis.
- Work with large data sets to conduct exploratory data analysis and visualization, using error metrics to assess the effectiveness and accuracy of data sources and data gathering techniques.
- Maintain and enhance machine learning processes, using performance metrics to evaluate ongoing effectiveness of existing models
- Provide ongoing support and troubleshooting to resolve immediate customer needs, escalating as necessary
- Apply quantitative methods including but not limited to descriptive analysis univariate and multivariate tests, statistical modeling etc., identifying opportunities to optimize and proactively performing data exploration to discover future opportunities.
- Utilize statistical and machine learning techniques and feature engineering to identify optimal methodologies for a given problem. Create, test, and implement custom data models and algorithms to address business objectives and client needs.
- Provide ongoing support and troubleshooting for issues including those escalated from more junior colleagues to resolve immediate customer needs.
- Investigate, evaluate, and test new products and technologies to meet current and future software application requirements.
- Provide counseling and guidance to developers during build and deployment to suggest best approaches for the design of files and systems.
- Produce and maintain documentation to ensure up to date information is available.
- Develop processes and tools to continuously monitor and analyze model performance with respect to resource use as well as accuracy. Implement improvements in existing quantitative solutions based on feedback from these tools.
- Research new technologies/products, prepare preliminary evaluations of technologies/products and associated costs. Develop and present recommendations to support anticipated future business needs.
- Design, engineer, and document solutions and standards to ensure business needs are met.
- Develop analytics workflows, incorporating processes and tools to continuously monitor and analyze model performance and data accuracy for ongoing improvements in quantitative solutions.
- Lead research projects, working with stakeholders throughout the organization to identify opportunities for leveraging data to drive business solutions and recommend solutions to technology and business problems
- Provide technical leadership to project teams, maximizing and sharing learning.
- Provide guidance and technical coaching to less experienced staff to implement and support efficient and effective workflows and develop technical talent
- Assists in configuration, installation, testing, and maintenance of database technologies and resources to ensure that all application and systems availability targets are met.
- Troubleshoots database errors and other problems to resolve immediate customer needs.
- Assist with the development of system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
- Work with system administrators, network administrators, help desk staff and other IT technical resources to coordinate database infrastructure requirements.
- Participate in the evaluation of new database products and technologies, under the direction and guidance of senior colleagues, to meet current and future software application requirements .
- Configures, installs, tests, and maintains database technologies and resources to ensure that all application and systems availability targets are met.
- Provides ongoing support and troubleshooting for database issues including those escalated from more junior colleagues to resolve immediate customer needs.
- Monitors associated software such as version upgrades, patches, and tools and performance tune databases and related servers to ensure consistent database performance.
- Performs database backup on a regularly scheduled basis, and database recovery when required to provide users with minimal interruptions in service.
- Assist with the development of system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
- Assists in project roll-outs by executing data migration activities to ensure solutions meet business needs.
- Investigates, evaluates, and tests new products and technologies to meet current and future software application requirements.
- Design, install, configure, and maintain database technologies and resources to ensure that all application and systems availability targets are met.
- Implements change management/change control processes to improve database performance.
- Provides counseling and guidance to developers during application development to suggest best approach for the design of files and systems.
- Produces and maintains database documentation to ensure up to date information is available.
- Performs capacity analysis and planning for databases on file to ensure sufficient resources are available to hold needed data.
- Develop system backup schedules, verification testing and all related documentation requirements to ensure accurate and timely information on policies and procedures is available.
- Researches new technologies/products, prepares a preliminary evaluation of technologies/products and associated costs, and develops and presents recommendations to support anticipated future business needs.
- Guide junior database staff in the performance of their tasks to develop technical talent.
- Leads the organization's planning for the future of the data model and data architecture to support current and future business needs.
- Provides expertise in enterprise reporting and data management tools to maximize and share learning.
- Develops, documents and maintains logical and physical data models for multi-phase development projects to support complex and critical organizational initiatives.
- Leads the continual redesign of the organization's data model and/or the transition to a common model to improve data efficiency.
- Establishes and documents data policies and standards for the enterprise to ensure information is available and up to date.
- Formulates procedures to ensure that communications of data updates are distributed to all associates and that they are adhered to.
- Consults to the IT community to understand customer data needs and requirements.
- Provides guidance and technical coaching to less experienced staff to support effective workflow and develop technical talent
- Deep knowledge of data analysis, and usage requirements
- Experience with Business Analysis and functional requirements analysis
- Expert in all phases of the data mining pipeline, using information analysis to generate actionable insights
- Strong understanding of data and integration architecture
- Expert level understanding of ETL fundamentals and experience building efficient data ingestion pipelines using Extract Transform Load (ETL) tools
- Advanced data processing and programming skills using SQL-based technologies, as well as other languages like Python.
- Experience working with major database technologies including SQL Server and Oracle as well as NoSQL and file-based data storage.
- Experience with cloud data movement and compute technologies including Azure Data Factory, Logic App, Databricks and storage technologies including Azure Managed instance, Azure Data Lake, Azure synapse analytics
- Competent in information taxonomy creation, information visualization, information modeling, and data warehousing techniques
- Experience with BI tools, particularly Power BI is a plus
- Analytical and problem-solving skills and attention to detail
- Understanding of business context and objectives
- Experience working on a project using Agile delivery, and DevOps practices .
- 5-7 years of experience with distributed data/computing, manipulating large data sets, building statistical models, and developing algorithms.
- Strong problem-solving skills, focusing on drawing conclusions that lead to recommendations for operational improvement.
- A drive to learn new technologies and techniques.
- Excellent communication skills, especially the ability to communicate technical content to general audience and experience visualizing/presenting data for stakeholders.
- Proficiency in the major languages of Data Science (Python, R, SQL, Spark) and working with large datasets on platforms such as Data Bricks, Azure Synapse Analytics, and AWS.
- Knowledge and experience in statistical and data mining techniques as well as machine learning algorithms (simulation, scenario analysis, GLM/regression, trees/random forest, boosting, clustering, neural networks, time series analysis, text mining, social network analysis, etc.)
- Bachelor's Degree in Computer Science or related fields or equivalent experience.
- 1+ years of relevant experience.
- Requires basic knowledge and familiarity with installing, maintaining and troubleshooting database technology.
- Proven ability to troubleshoot and support technical issues using standardized procedures.
- Bachelor's Degree in Computer Science or related fields or equivalent experience.
- 3+ years of relevant experience.
- Requires proven knowledge and familiarity with installing, maintaining and troubleshooting database technology, including ability to explain changes/ modifications/ improvements to applications.
- Bachelor's Degree in Computer Science or related fields or equivalent experience.
- 5+ years of relevant experience.
- Requires strong knowledge and familiarity with installing, maintaining and troubleshooting database technology, including ability to design and engineer solutions and standards and provide routine direction to less senior staff members.
- Bachelor's Degree in Computer Science or related fields or equivalent experience.
- 7+ years of relevant experience.
- Requires advanced knowledge and familiarity with installing, maintaining and troubleshooting database technology, including ability to design and engineer solutions and standards and provide advanced technical direction to less senior staff members.
Vacancy expired!