Data Analyst/Report Writer 3
About The Position
A Data Analyst/Report Writer 3 is needed to work with the Public Transportation Division's Transit Grants Enterprise Management System (TGEMS). The Data Analyst will play a pivotal role in supporting complex data migration and analysis initiatives, leveraging a deep understanding of denormalized data structures and advanced data management techniques. This individual will demonstrate the ability to quickly adapt to new systems and schemas, proactively identify dependencies and gaps, and communicate technical needs with clarity and professionalism. The worker’s responsibilities and skills must include: Collaborating with third-party vendors, validating alternative solutions, and maintaining a solutions-oriented mindset. Create transparent dashboards to track progress, provide visibility to stakeholders, and ensure accountability through precise reporting. Strong project management skills are essential, including surfacing risks, proposing mitigations, and delivering timely status updates. Beyond technical expertise, the Data Analyst will foster a collaborative team environment, share knowledge generously, and serve as a mentor-level resource for others. Their involvement will be critical throughout project go-live and hypercare phases, ensuring successful outcomes and continuous improvement.
Requirements
- Minimum 8 years of experience solving complex data problems and delivering actionable insights for business decision-making.
- Minimum 8 years of advanced proficiency in data management, including data cleansing, validation, and stewardship for large enterprise systems.
- Minimum 8 years of proven expertise in cloud data migration, utilizing platforms such as Snowflake and Informatica PowerCenter for both on-premises and cloud environments.
- Minimum 8 years of experience planning and executing migration of data from multiple legacy applications, handling large data volumes and diverse data sources.
- Minimum 8 years of strong background in designing, developing, and automating ETL/ELT pipelines for efficient data integration and transformation.
- Minimum 8 years of ability to create, maintain, and optimize dashboards and reports using visualization tools such as Tableau, Cognos, and Jaspersoft.
- Minimum 8 years of skill in collaborating with cross-functional teams and third-party vendors to resolve data dependencies, gaps, and technical challenges.
- Minimum 8 years of ability to independently perform a variety of complicated tasks, relying on experience and judgment to plan and accomplish goals.
- Minimum 8 years of high degree of creativity and latitude in designing solutions, adapting to new technologies, and implementing innovative approaches.
- Minimum 8 years of experience in data analysis and automation using Python and other relevant programming languages.
- Minimum 8 years of knowledge of industry domains such as construction, asset management, and pharma, with the ability to apply data expertise across sectors.
- Minimum 8 years of commitment to continuous learning and professional development, including certifications in Snowflake Data Engineering and AWS Cloud Practitioner.
- Vendor must ensure Resources retain the authorization to legally work in the United States throughout the term of each engagement based on the length of term period identified in the contract.
- Documentation of such authorizations must be provided prior to engagement.
- Deep understanding of denormalized data structures and advanced data management techniques.
- Ability to quickly adapt to new systems and schemas.
- Proactively identify dependencies and gaps.
- Communicate technical needs with clarity and professionalism.
- Strong project management skills.
Nice To Haves
- 8+ years of experience migrating and analyzing data from TxDOT legacy applications to modern platforms, including cloud-based solutions like Snowflake and Informatica PowerCenter.
- Advanced proficiency in data cleansing, validation, and stewardship for TxDOTCONNECT and related transportation systems, ensuring high data quality and integrity.
- Demonstrated ability to design, develop, and automate ETL/ELT pipelines for TxDOT enterprise data, supporting efficient integration and transformation of large, complex datasets.
- Expertise in creating and maintaining dashboards and reports using Tableau and Jaspersoft, providing actionable insights for TxDOT business decision-making.
- Proven track record of independently planning and executing complicated data analysis tasks for TxDOT projects, relying on experience, judgment, creativity, and a wide degree of latitude to accomplish goals.
- Certifications in Snowflake Data Engineering and AWS Cloud Practitioner.
Responsibilities
- Solving complex data problems and delivering actionable insights for business decision-making.
- Advanced proficiency in data management, including data cleansing, validation, and stewardship for large enterprise systems.
- Proven expertise in cloud data migration, utilizing platforms such as Snowflake and Informatica PowerCenter for both on-premises and cloud environments.
- Experience planning and executing migration of data from multiple legacy applications, handling large data volumes and diverse data sources.
- Strong background in designing, developing, and automating ETL/ELT pipelines for efficient data integration and transformation.
- Ability to create, maintain, and optimize dashboards and reports using visualization tools such as Tableau, Cognos, and Jaspersoft.
- Skilled in collaborating with cross-functional teams and third-party vendors to resolve data dependencies, gaps, and technical challenges.
- Ability to independently perform a variety of complicated tasks, relying on experience and judgment to plan and accomplish goals.
- High degree of creativity and latitude in designing solutions, adapting to new technologies, and implementing innovative approaches.
- Experience in data analysis and automation using Python and other relevant programming languages.
- Knowledge of industry domains such as construction, asset management, and pharma, with the ability to apply data expertise across sectors.
- Commitment to continuous learning and professional development, including certifications in Snowflake Data Engineering and AWS Cloud Practitioner.
- Collaborating with third-party vendors, validating alternative solutions, and maintaining a solutions-oriented mindset.
- Create transparent dashboards to track progress, provide visibility to stakeholders, and ensure accountability through precise reporting.
- Surfacing risks, proposing mitigations, and delivering timely status updates.
- Fostering a collaborative team environment, sharing knowledge generously, and serving as a mentor-level resource for others.
- Ensuring successful outcomes and continuous improvement throughout project go-live and hypercare phases.
Benefits
- Access to a virtual desktop set up (software) will be provided by Lumen’s client, allowing the user access to the required systems and technology.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
No Education Listed
