Senior Data Analyst
Location: Austin, TX
Job Type: contract
Company: IDR
Category: Databases
Job Description Apply Now
IDR is seeking a Senior Data Analyst to join one of our top clients in the public sector industry. If you are looking for an opportunity to join a large organization and work within an ever-growing team-oriented culture, please apply today!Position Overview/Responsibilities for the Senior Data Analyst:
The analyst collaborates with product owners, SMEs, DBAs, ETL engineers (SSIS/ADF/Informatica), and reporting teams (Power BI/SSRS) to translate business needs into requirements, specifications, and testable acceptance criteria, ensure accurate and timely extracts/loads, and support audit-ready reporting. Work is performed under limited supervision with considerable latitude for initiative and independent judgment.
This position will be responsible for data analysis and documentation in the implementation of multiple inter-related projects (including implementation of software applications in Software as a Service (SaaS) or Commercial off the Shelf (COTS), migration of data from the mainframe to the new systems and building a Data Warehouse). Assessment of existing Mainframe Transformation business analysis processes, implementation of any necessary improvements to these processes, and monitoring/enforcement of the processes to ensure deliverables and materials are produced and maintained in accordance with newly established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. Make assignments and tracks work of other team members or completes individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.
Responsibilities and Skills include:
• Thorough understanding of the software development lifecycle
• Determines and documents database requirements by analyzing business operations, applications, and programming; reviewing business objectives; and evaluating current systems to create or improve database solutions.
• Based on requirements, develops and implements data models for new projects, and maintains and/or enhances existing data models and data architectures.
• Creates graphics and other flow diagrams (including ERD) to show complex database design and database modeling more simply.
• Develop data structures for transactional systems; and
• Provides guidance for business intelligence systems, as required.
• Implements new database solutions and/or corresponding database changes to support new and modified applications and ensure that new designs conform to data standards and guidelines; are consistent, normalized, and perform as required; and are secure from unauthorized access or update.
• Creation of technical documentation for process and interface documentation
• Follow guidelines on creating data models and various standards relating to governed data. This includes the ability to appropriately classify personally identifiable information.
• Collects, queries, and analyzes data using standard database tools, applications, methods, and techniques for the purposes of creating normalized database solutions.
• Knowledgeable of Change Data Capture (CDC) for bulk data movement
• Ability to promote code from development environments to production
• Familiarity with GitHub or equivalent version control systems
• Experience with:
o Oracle databases
o Snowflake databases
o SQLServer databases
o Database Modeling tools, like DBSchema
o Mainframe IMS hierarchical databases
• Knowledge of o Informatica
o Microsoft SSIS
• Ability to provide status reports and project progress reports to stakeholders and project managers
• Performs related work as assigned
Required Skills for the Senior Data Analyst:
1. Senior Data-Focused Business Analysis 10+ years leading requirements elicitation, data modeling (ERDs, normalization), data flow documentation, and functional/technical specification design for complex software and data integration projects.
2. Advanced Data & ETL Expertise
Strong SQL proficiency (SQL Server/Oracle), hands-on experience with ETL/ELT tools (SSIS, ADF, Informatica), S2T documentation, data validation/reconciliation, and root cause analysis of production/data bridge issues.
3. Technical Documentation & Stakeholder Leadership
Expert technical writing, traceability, use cases, UAT support, client engagement, and cross-functional collaboration; proficient with Visio, SharePoint/Confluence, Azure DevOps, and prototyping tools.
What’s in it for you?
- Competitive compensation package
- Full Benefits; Medical, Vision, Dental, and more!
- Opportunity to get in with an industry leading organization
- Close-knit and team-oriented culture
Why IDR?
- 25+ Years of Proven Industry Experience in 4 major markets
- Employee Stock Ownership Program
- Dedicated Engagement Manager who is committed to you and your success
- Medical, Dental, Vision, and Life Insurance
- ClearlyRated’s Best of Staffing® Client and Talent Award winner 10 years in a row
#LI-remote
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. IDR is subject to certain governmental recordkeeping and reporting requirements for the administration of civil rights laws and regulations. In order to comply with these laws, we invite employees to voluntarily self-identify their race or ethnicity, gender, and veteran status (if applicable). Submission of this information is voluntary and refusal to provide it will not subject you to any adverse treatment. The information obtained will be kept confidential and may only be used in accordance with the provisions of applicable laws, executive orders, and regulations, including those that require the information to be summarized and reported to the federal government for civil rights enforcement. You may access this form here.