Job Location: Austin, TX
WHO WE ARE:
The Information Technology (IT) Division lays the foundation for TRS to deliver excellent service experiences across the organization and with our members. We serve with purpose through mentorship and collaboration across a diverse team unified by innovation to create technology and information solutions that have a positive impact on our members’ lives.
We invite you to join one of Austin’s Top Workplaces. TRS offers a best-in-class combination of technology and continuous learning opportunities to equip you to solve problems, expand your knowledge, and create impact for 1 in 20 Texans.
Position Summary
The Senior Data Engineer performs highly complex data integration, data analysis, and reporting work. Partners with internal and external teams to understand, interpret and analyze business operations to develop and implement solutions that support the Agency.
WHAT WILL YOU DO:
Description
Data Integration and Data Analysis
- Interprets complex data requests or business needs and translates into written requirements that allows for a team to design, develop, implement, troubleshoot, and deliver a reusable operational product.
- Defines, captures, qualifies, enriches, explores, documents and preps data to support desired result set that effectively communicates not only the required results but identifies data quality issues that might be impactful
in its utilization.
- Defines, develops, and implements automation of data integration, processes, and interfaces.
- Liaison between IT and Business to facilitate testing and implementation of data solutions.
- Identifies patterns, gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within disparate systems.
- Interprets results to identify significant differences in data.
- May develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality.
- Assists in determining database structural requirements by analyzing business operations and application functional needs; reviews objectives with business, developers and database administrators and evaluates current systems.
- Leverages mature data with variable/algorithm selection, predictive and behavioral analytics to identify emerging risks and issues beyond operational controls.
- Troubleshoots and resolves problems related to systems and applications.
Business Intelligence
- Provides thorough, visible, rigorous and transparent data reports and analysis.
- Tracks trends and provides recommendations for solutions based on findings.
- Interprets and communicates analytical insights to audiences with various analytical backgrounds using different but suitable communication methods for different audiences.
- Develops visually appealing and intuitive dashboards that provide visibility into key performance, risk and control indicators across agency divisions and departments.
- Delivers quality results and presentations under short timelines.
- Applies a broad range of techniques and theories from business intelligence, data analysis and visualization, statistics, predictive analytics, and data modeling to deliver actionable business insights based on large-scale data.
- Understands and maintains existing BI solutions.
Training and Technical Guidance
- Serves as a central resource for reports interpretation and assists with developing specifications for reports.
- Provides training and technical assistance to agency staff on processes, applications, and reporting.
- Participates on agency committees and special projects as assigned.
- Performs quality assurance and serves as a subject matter expert on data integrity, extraction, testing and compilation.
- Performs related work as assigned.
WHAT WILL YOU BRING:
Minimum Required Qualifications
Required Education
- Bachelor’s degree from an accredited four-year college or university.
- High school diploma or equivalent and additional full-time, related experience may substitute for the required education on an equivalent year for year basis.
Required Experience
- Five (5) years of full-time experience in data analytics, SQL, SSIS, business intelligence and visualization tools and MS Office Suite, or related fields.
- Advanced degree in a related field may be substituted for experience on a year for year basis
Required Registration, Certification, or Licensure
- None.
Preferred Qualifications
- Bachelor’s degree from an accredited four-year college or university in Information Technology, Data Analytics, Business or a related field.
- Experience with SQL, SSRS, SSIS, MS Visual Studio.
- Experience working with star-schema data warehouses and relational databases.
- Experience mapping and extracting large amounts of data from structured and unstructured sources.
- Experience with data modeling.
Knowledge, Skills, and Abilities
Knowledge of:
- Strong knowledge of business intelligence tools, databases, SQL and various job associated programming languages to support data analysis and predictive analytics.
- Database modeling and data warehousing principles.
- Extensive knowledge of complex data models is a definite plus.
- Project management and system development life cycle concepts.
Skill in:
- Extensive use of data analysis, data mining, data cleansing and data validation sills.
- Experience with migrating data from legacy systems is a definite plus.
- Using technical and statistical analysis to deliver clear, concise, and visually appealing management metrics and reports to inform decision making and actions.
- Writing queries, views, and stored procedures in a team development environment that meets coding standards and quality assurance.
- Business process analysis and problem solving.
- Completing detailed work with a high degree of accuracy.
- Planning, organizing, and prioritizing work assignments to manage a high-volume workload in a fast-paced and changing environment.
- Effective written and verbal communications, including explaining complex information to others in an understandable manner, and writing clear and precise policies, procedures, and training or other materials.
- Proven track record to work in a team environment and influence a diverse group of stakeholders.
Ability to:
- Operate effectively in a fast-paced environment with competing and shifting priorities.
- Continually learn new concepts and tools to support job needs, and strive for ongoing professional development.
- Establish and maintain harmonious working relationships with co-workers, agency staff, and external contacts.
- Work effectively in a professional team environment.
- Work in an Agile development environment.
- Work in a cross-functional team environment; including utilization of business and technical resources.
Military Occupational Specialty (MOS) Codes:
Veterans, Reservists or Guardsmen with experience in the Military Occupational Specialty ( http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_AdministrativeSupport.pdf ) along with the minimum qualifications listed above may meet the minimum requirements and are highly encouraged to apply. Please contact Talent Acquisition at careers@trs.texas.gov with questions or for additional information.
To view all job vacancies, visit www.trs.texas.gov/careers or www.trs.csod.com/careersite.
For more information, visit www.trs.texas.gov.
Submit CV To All Data Science Job Consultants Across United States For Free
🔍 Explore All Related ITSM Jobs Below! 🚀
✅ Select your preferred “Job Category” in the Job Category Filter 🎯
🔎 Hit “Search” to find matching jobs 🔥
➕ Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link 📝💼
Leave a Reply